Module · Beginner · 1h 15m
Module 2: Lookups, pivots and checks
Pulling data across tables, summarising with pivots, and the checks that catch mistakes before someone else does.
- spreadsheets
- module
Inside this module
- Use XLOOKUP and SUMIFS
- Build a pivot table
- Add validation and reconciliation checks
The full module opens with a membership that covers Excel Skills.
Sign in if you already subscribe.
Sign inLessons
- 01Lookups and conditional sums
Lesson · 25 min · XLOOKUP for fetching one value, SUMIFS and COUNTIFS for totals by condition.
- 02Pivot tables
Lesson · 25 min · Summarising a table in seconds, and the layout habits that keep pivots readable.
- 03Checks that catch mistakes
Lesson · 25 min · Data validation on inputs and reconciliation formulas that prove the sheet still adds up.
