Feva Works IT Education Centre

Certificate in Microsoft Excel 2019

Enquire Now

Course Information

  • 23 Jun 2021 (Wed) - 30 Jun 2021 (Wed) 7:00 PM - 10:00 PM
Registration period
25 Apr 2021 (Sun) - 22 Jun 2021 (Tue)
HKD 1,500
Course Level
Study Mode
6 Hour(s)
北角英皇道335-341號恆生北角大廈 2 樓

Course Overview





What you'll learn

Module 1 - Microsoft Excel – Core (3 Hrs)
1. Entering Data in Microsoft Excel Worksheets
Entering Text
Using AutoComplete
Entering Numbers and Dates
Using the Fill Handle
Quick Analysis
2. Using Formulas in Microsoft Excel
Math Operators and the Order of Operations
Entering Formulas
AutoSum (and Other Common Auto-Formulas)
Copying Formulas and Functions
Relative and Absolute Cell References
3. Working with Rows and Columns
Inserting Rows and Columns
Deleting Rows and Columns
Setting Row Height and Column Width
Hiding and Un-hiding Rows and Columns
Freezing Panes
4. Data / Time Functions
5. Text Functions
6. Finalizing Microsoft Excel Worksheets
Setting Margins
Setting Page Orientation
Setting the Print Area
Print Scaling (Fit Sheet on One Page)
Headers and Footers

Module 2 - Microsoft Excel - Advanced (3 Hrs)
1. Applying Conditional Formatting
Highlight Cell Rule
Top / Bottom Rule
Data Bar
Color Scale
Icon Sets
2. Using Pivot Tables
Creating Pivot Tables
Preparing Your Data
Inserting a Pivot Table
Inserting Pivot Charts
More Pivot Table Functionality
Automatic Time Grouping
Inserting Slicers
Multi-select Slicer
3. Data Tools
Data Validation
Flash Fill
4. Protecting Worksheets and Workbooks
Password Protecting a Workbook
Password Protecting a Worksheet
Password Protecting Ranges in a Worksheet
Tracking Changes
Accepting or Rejecting Changes
5. Summarize Functions
6. Lookup Functions
7. IF Functions


We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed