Excel lessons

Formulas, pivot tables, Power Query and the modern dynamic-array functions. 12 lessons across 6 tracks, each ending with a short self-check.

12lessons

100mtotal

6tracks

24checks

Formulas & functions

References, logic, and the functions you use every day.

2 · 15m

Cell references and the $ signRelative, absolute and mixed references — the thing that breaks copied formulas.beginner7m IF, IFS and logical testsConditional logic without nesting yourself into a corner.beginner8m

Lookup & reference

From VLOOKUP to XLOOKUP, and dynamic arrays.

2 · 19m

XLOOKUP, VLOOKUP and INDEX/MATCHThe three generations of lookup, and why XLOOKUP wins.intermediate10m Dynamic arrays and spillingFILTER, SORT, UNIQUE and SEQUENCE — one formula, many results.intermediate9m

Data analysis

Pivot tables, tables, and summarising large sheets.

1 · 10m

Pivot tablesSummarising thousands of rows in seconds, and the settings worth changing.beginner10m

Power Query & Power Pivot

The modern data stack inside Excel.

2 · 18m

Power Query in ExcelRepeatable data cleanup that survives next month, replacing manual copy-paste.intermediate9m Power Pivot and the Data ModelRelationships and DAX measures inside Excel, past the million-row limit.advanced9m

Charts & presentation

Charts, conditional formatting, and readable workbooks.

2 · 14m

Conditional formattingRules that highlight what matters, including formula-driven ones.beginner7m Charts that communicateChoosing and cleaning charts so the point is visible.beginner7m

Automation & quality

VBA basics, validation, and workbooks that do not break.

3 · 24m

Validation and workbook qualityStopping bad input before it happens, and auditing formulas that already broke.intermediate8m VBA and macrosRecording, editing and writing simple automation — and when not to.advanced9m Preparing for an Excel interview or testWhat gets tested, and the drills that actually prepare you.intermediate7m