Microsoft Excel Advanced – Fast Track
Course Description
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.
Course Outline
Advanced Functions and Formulas
- 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
Organising and Analysing Data
- Creating Scenarios & Report
- Working with Data Tables
- Using Goal Seek
- Using Text to Columns
- Consolidating Data by Position or Category)
- Consolidating Data Using Formulas
Working with Macros
- Recording a Macro
- Playing and Deleting a Macro
- Adding a Macro to the Quick Access Toolbar
Working with PivotTables
- 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
Related Courses
Microsoft Excel Basic – Fast Track
This 1 day workshop, participants will acquire fundamental skills in formatting cells, values, worksheets, and workbooks, gain confidence in using basic formulas for calculations, and receive guidance on setting up pages for printing in this essential learning module.
Course Duration:
1 Day (9.00am – 5.00pm)
View course details here
Microsoft Excel Intermediate – Fast Track
This 1 day workshop course is suitable for you, if you are looking beyond using basic features of Excel. You’ll learn the popular features such as conditional formatting, sorting, filtering, data validation, formulas, and charts.
Course Duration:
1 Day (9.00am – 5.00pm)
View course details here
Microsoft Excel Advanced – Fast Track
Course Duration:
1 Day (9.00am – 5.00pm)
Course Fee Details:
1 Fast Track Course: $218.00 (incl. of 9% GST)
2 Fast Track Courses: $392.40 (incl. of 9% GST)
3 Fast Track Courses: $523.20 (incl. of 9% GST)
This course is not eligible for SDF Grant.
Course Schedule
| Course Name | Course Code | Venue | April 2024 | May 2024 | June 2024 | July 2024 | August 2024 | September 2024 |
|---|---|---|---|---|---|---|---|---|
| Microsoft Excel Advanced - Fast Track | ASKEAF | JTC Summit | - | 31 | - | 31 | - | 27 |
| ASKEAF | Mountbatten Square | 05 | - | 20 | - | 28 | - |
Nett Course Fee
$218.00