Microsoft Excel (2019) Advanced Training Course Outline

Microsoft Skills

Microsoft Excel (2019) Advanced

2-Day Course l 100% HRDC Claimable

Course Introduction

The “Microsoft Excel 2019 Advanced” course marks the final stretch toward true spreadsheet mastery, taking participants who already know their way around formulas and filters into far more powerful territory. This two-day, instructor-led program reshapes how learners approach data, teaching them to summarize with Subtotals and Pivot Tables, forecast outcomes through Goal Seek, Solver, and Scenario Analysis, and retrieve information precisely using VLOOKUP, HLOOKUP, and INDEX-MATCH. Participants also learn to consolidate data across workbooks, build richer visual reports with Combo Charts and Pivot Chart Slicers, automate tasks through Macros, and protect their work from unwanted changes. The result is a course that transforms confident Excel users into capable data analysts, ready to model, forecast, and present with real authority.

Learning Objectives

Create Subtotal Using the Subtotal Function
Analyze data Using Pivot Tables
Perform What If Analysis using Goal Seek, Solver, Input Table and Scenarios
Use VLOOKUP function to extract data
Nesting INDEX and MATCH Function
Combining & Consolidating Data
Summarizing & Analyzing with Pivot Table and Pivot Charts
Record and Run a Macro

Training Modules

Module 1: Organize Summary and Details on Your Data

Module 2: Planning, Forecasting & Projection of Your Data

Module 3: Retrieve, Compare or Compiling Data with Functions

Module 4: Present Data with Visual Report

Module 5: Summarizing and Analyzing Data with PivotTable, Slicer and PivotCharts

Module 6: Navigating Large Workbooks

Module 7: Automate Task with Macros

Module 8: Prevent User Changes with Protection

Request for a Quotation
or Chat with us LIVE

Target Audience

Recommended for Clerks, Officers, Executives, Supervisors, Administrators, and, Managers at all levels, as well as staff members who already have a working understanding of Microsoft Excel and are keen to expand their knowledge and practical application of the program.

Training Methodology

This course can be conducted Physically and Online.

Physical Training Methodology
The trainer will provide live guidance and immediate feedback
to strengthen understanding and practical application.

Online Training Methodology
Clear visuals and guided facilitation ensure interactive learning and effective application from any location.

Customization

Duration
Flexible learning options from half a day to a 3-day sessions (and beyond)

Content
100% customizable modules to match your organisation’s exact training needs

Methodology
Delivered in your preferred format, be it physical, online or a blended approach

Request for a Quotation
or Chat with us LIVE

Not exactly what
you're looking for?

No worries, just click on the WhatsApp icon to chat with us immediately or email us at aria@atcen.com

Microsoft Skills