ASK Training

Course Description

Microsoft Excel 2019- Advanced is designed for the participant who wants to leverage on the Advanced functions and features to improve productivity and enhance your spreadsheets to simplify your daily work activities.

This 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 so me 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 Marcos.

 

Course Objectives

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

Use advanced functions such as Financial Logical Lookup and Text functions

Advanced Functions and Formulas

Create and manage conditional formatting rules

Organizing and Analysing DAta

Use the data validation function to control data being accepted for selected cells in your worksheet

Working with Pivot Tables

Create scenarios and use the Goal Seek and Solver functions to achieve desired results in formulated cells

Working with Macros

Use advanced functions such as Financial Logical Lookup and Text functions

Advanced Functions and Formulas

Create and manage conditional formatting rules

Organizing and Analysing DAta

Use the data validation function to control data being accepted for selected cells in your worksheet

Working with Pivot Tables

Create scenarios and use the Goal Seek and Solver functions to achieve desired results in formulated cells

Working with Macros

Course Outline

You will be learning the following:

Advanced Functions and Formulas
  • Displaying and Tracing Formulas
  • Using Logical Functions (NestedIF,AND,OR)
  • Using Lookup Functions (VLOOKUP,HLOOKUP)
  • Using Lookup & Reference Functions (MATCH & INDEX)
  • Using Text Functions (PROPER,CONCATENATE,UPPER, LEFT & etc)
  • Using Date & Time Functions
  • Using Financial Functions (PMT & FV)
  • Creating Scenarios & Report
  • Working with Data Tables
  • Using Goal Seek
  • Using Text to Columns
  • Using Subtotals
  • Consolidating Data by Position or Category
  • Consolidating Data Using Formulas
  • Creating and Specifying PivotTable Data
  • Changing a PivotTable’s Calculation
  • 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
  • Recording a Macro
  • Playing and Deleting a Macro
  • Adding a Macro to the Quick Access Toolbar

Course Fees And Grants

$200 ($216 Inc. 8% GST) per participant
No SDF grant
If you sign up for
Any of the 2 fast track – 10% off
Any of the 3 fast track – 20% off

Absentees will be charged the full course fee.

Course Schedule

CourseCodeVenueDec-22Jan-23Feb-23Mar-23Apr-23May-23Jun-23
Microsoft Excel Advanced - Fast TrackASKEAFJTC Summit11
31
08
27
03
20
12
24
10
26
14
28
ASKEAFMountbatten Square1803
13
10
24
06
19
05
19
07
21
ASKEAFHome Based Learning2829213116

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

$200 ($216 Inc. 8% GST) per participant
No SDF grant
If you sign up for
Any of the 2 fast track – 10% off
Any of the 3 fast track – 20% off

Absentees will be charged the full course fee.

REGISTRATION

For Organisations on HRP Portal, you are strongly encouraged to use this platform for registration.

Browse Courses

Learning Paths

Master Microsoft Office

Master Microsoft Office

Become a Web Designer

Become a Web Designer

Become a Digital Marketer

Become a Digital Marketer

Become a Video Producer

Become a Video Producer