Microsoft Excel 2019 – Advanced is designed for the participants who wants to leverage on the Advanced functions and features to improve productivity and enhance your spreadsheets to simplify your daily work activities.
The course focuses on practical examples that will help users easily transit to using these formulas and functions in real-world scenarios.
Participants will be shown some of the most challenging formulas and functions in Excel and how to put them to their best use.
In this 1 day workshop, you will be guided to use Lookup Formulas, Match and Index Formulas, Text & Date Formulas and Financial Formulas. Besides that, you will learn to analyse data and appreciate the powerful feature in using Pivot Tables. You will have the opportunity to learn simple Macros.
At the end of this course, you should be able to:
You will be learning the following:
Displaying and Tracing Formulas
Using Financial Functions (PMT & FV)
Using Lookup Functions (VLOOKUP, HLOOKUP)
Using Lookup & Reference Functions (MATCH & INDEX)
Using Text Functions (PROPER, CONCATENATE, UPPER, LEFT & etc)
Using Date & Time Function
Filtering and Sorting a PivotTable
Working with PivotTable Layout
Grouping PivotTable Items
Updating a PivotTable
Formatting a PivotTable
Creating a PivotChart
Creating a Standalone PivotChart
Use Slicers to Share Slicers Between PivotTables
$200 ($216 Inc. 8% GST) per participant
No SDF grant
Any of the 2 fast track – 10% offer
$360 ($388.80 Inc. 8% GST)
Any of the 3 fast track – 20% offer
$480 ($518.40 Inc. 8% GST)
No SDF grant.
Absentees will be charged the full course fee.
For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.