0–6 points
Start at the beginning — and that is a normal place to be
Introduction to Excel develops workbook navigation, data entry, Autofill, basic formulas, formatting and printing. Compare these tasks with the work you already do before choosing this starting point.
If most of your low answers were about lookups and pivot tables specifically, and the rest felt easy, Excel Intermediate 1 may be a better fit.
7–13 points
Excel Intermediate 1
Intermediate 1 builds a budget worksheet using tables, sorting, filtering, absolute and relative references, Flash Fill and workbook views. It is a useful next step when basic data entry and formatting are familiar.
Introduction to Excel if the referencing question was a guess; Intermediate 2 if you are already confident with tables and filters.
14–19 points
Excel Intermediate 2
Intermediate 2 develops charts, table functions and slicers, named ranges, functions with multiple arguments, conditional formatting and nested functions. It builds on the tables and references practised in Intermediate 1.
For PivotTables, compare Advanced Data Management after checking its starting skills. For deeper formula work, compare Advanced Functions. Power Query and Power Pivot belong to Expert Data Management.
20–25 points
Excel Advanced Functions, or Advanced Data Management
Choose by the task you want to improve. Advanced Functions covers conditional logic, data summaries, time calculations, text functions and formulas using tables and named ranges. Advanced Data Management covers validation, duplicates, PivotTables, PivotCharts and slicers.
Expert Data Management covers Power Query and Power Pivot. If you are new to PivotTables, compare Advanced Data Management first.
26–29 points
One of the Expert courses — pick by what you are building
Compare a specialist path with the work you need to do: Expert Functions for dynamic arrays and advanced formulas; Expert Data Management for Power Query and Power Pivot; Expert Dashboard for interactive reports; or Expert Macros and Forms for macros, minor VBA edits and form controls.
Check each published prerequisite. Expert Functions requires Advanced Functions or equivalent experience, and Expert Data Management requires Advanced Data Management or equivalent experience. A high overall score can still hide a gap in one of those subjects.