Microsoft Excel Advanced – Fast Track

Nett Course Fee

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 NameCourse CodeVenueJuly 2024August 2024September 2024October 2024November 2024December 2024
Microsoft Excel Advanced - Fast TrackASKEAFJTC Summit31-27-06-
ASKEAFMountbatten Square-28-30-18