Data & AI · Paid

Advanced Excel for Analysts

Power Query, pivots and models that scale.

4.6 (221)5,890 learners6h9 lessonsAdvanced

Grace Whitman · InstructorPublicCertificate

$79

On-demand6h
Lessons9
CertificateOn completion
LevelAdvanced

Guest checkout — instant access
30-day money-back guarantee

This course includes

6h of on-demand content
3 modules · 9 lessons
Full lifetime access
Certificate of completion

30-day money-back guarantee — no questions asked.

Outcomes

What you'll learn

Automate data prep with Power Query

Build advanced PivotTables and dashboards

Use dynamic arrays and modern functions

Create models others can trust and reuse

Debug and audit complex spreadsheets

About

About this course

Push Excel far beyond formulas. Master Power Query, advanced PivotTables, dynamic arrays and dashboard techniques to build models analysts can trust and reuse.

Curriculum

Course content

3 sections · 9 lessons · 6h

Power Query: load & clean — AvailableVideo12 min
Merging & appending queries — Locked. Buy this course to unlockVideo14 min
Interactive lab: transform data — Locked. Buy this course to unlockSCORM22 min

Instructor

Your instructor

Grace Whitman

Analytics Trainer

Grace has spent a decade making spreadsheets do extraordinary things and teaching others to do the same.

Reviews

What learners say

4.6221 reviews

5★50%
4★50%
3★0%
2★0%
1★0%

Victor S.
Power Query finally makes sense. The lab was brilliant.
Mei C.
Advanced and worth it. Dynamic arrays section is excellent.

Get started

Get certified in Advanced Excel for Analysts.

Start in seconds — instant access, and a verifiable certificate on completion.

Buy & start now