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 Objective

At the end of this course, you should be able to:

Enhance your work environment and generate new ideas

Advanced Functions and Formulas

Clarify the roles and responsibilities of your supervisory role and adjust to the new role with confidence

Organizing and Analysing Data

Learn how to listen effectively so that you can understand and manage others

Working with PivotTables

Work effectively on the computer desktop using icons

Working with Macros

Enhance your work environment and generate new ideas

Advanced Functions and Formulas

Clarify the roles and responsibilities of your supervisory role and adjust to the new role with confidence

Organizing and Analysing Data

Learn how to listen effectively so that you can understand and manage others

Working with PivotTables

Work effectively on the computer desktop using icons

Working with Macros

Course Outline

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

  • Creating Scenarios & Report

  • Working with Data Tables

  • Using Goal Seek

  • Using Text to Columns

  • Consolidating Data by Position or Category

  • Consolidating Data Using Formulas

  • Recording a Macro

  • Playing and Deleting a Macro

  • Adding a Macro to the Quick Access Toolbar

  • 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

Course Fees And Grants

Course Fee:
$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.

Course Schedule

CourseCodeVenueJan-23Feb-23Mar-23Apr-23May-23Jun-23Jul-23
Microsoft Excel Advanced - Fast TrackASKEAFJTC Summit11
31
08
27
03
20
12
24
10
26
14
28
07
19
ASKEAFMountbatten Square1803
13
10
24
06
19
05
19
07
21
05
28
ASKEAFHome Based Learning-282921311614
ASKEAFJTC Summit (Weekend)-1804150610

Registration

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Our Corporate Partners

What Our Students Say

COURSE FEES AND GRANTS

Course Fee:
$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.

REGISTRATION

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

ASK Training