AdvancedComing soon

Advanced Excel

PivotTables, what-if analysis, and the power-user toolkit.

7 modules7 lessonsFree to enrol

Enrolment opens soonTell us you're interested

What you'll learn

PivotTables & PivotCharts

Data validation & form controls

What-if analysis (Data Tables, Goal Seek, Scenario Manager)

Advanced conditional formatting

Consolidating multi-sheet & multi-workbook data

Macro recording, an introduction

Capstone: build a regional sales dashboard

This course includes

7 structured modules

7 lessons

Free to enrol — no credit card

Certificate on completion

Learn at your own pace

Earn a certificate

Complete all lessons to receive a personalised certificate of completion. Download the PDF or share your verification link to show proof of learning.

About this course

For confident formula users ready for Excel's analysis tools — PivotTables and PivotCharts, data validation, scenario tools, and an introduction to macros.

Course content

7 modules · 7 lessonsLocked

This is the planned outline — lessons open when the course launches.

PivotTables & PivotCharts

Ready to start learning?

Create a free account to enrol and track your progress.

Get started free Sign in

Not quite right? Browse all Microsoft Excel courses or tell us what you need →

OpenSigma

Certificate of Completion

This is to certify that

Your Name

has successfully completed

Advanced Excel

Director of Training

Date issued

04 Aug 2026

Certificate ID

XXXX-XXXX-XXXX

Scan to verify