MARJ
Get startedJoin
Digital Productivity & Tools
TL-02L2
VDigital Productivity & Toolschecked 92 days ago18 min read

Spreadsheets, Level Two: XLOOKUP, Pivot Tables, Conditional Formatting

You'll walk away with

An analysis sheet joining two real datasets, with a pivot table and rule-based highlighting

Before thisTL-01 Spreadsheets From Zero: Formula Logic and Your First 15 Functions
If it looks different

⚠️ Version note: XLOOKUP exists in Microsoft 365, Excel 2021+ and Google Sheets. On older Excel you'll need INDEX/MATCH — covered in step 3. Menu paths move between versions; each step says what to look for. Last checked: 24 July 2026.

Members only

Finish the lesson. Make the thing.

Become a member to keep going. Every lesson and game, cancel any time in two clicks.

  1. 01The wall everyone hits
  2. 02Get your data into a shape that works (8 min)
  3. 03XLOOKUP: joining two tables (18 min)
  4. 04Pivot tables: the fastest thing in spreadsheets (18 min)
  5. 05Conditional formatting: make the sheet find things for you (12 min)
  6. 06Sanity-check the sheet (8 min)
  7. 07Six common mistakes
  8. 60′Exercise, with a verifiable output
  9. 09Cheatsheet
  10. ▶The video and audio versions
Yearly$89/yrMonthly$9.99/moWeekly$4.99/wk
Become a member See all plansAlready a member? Sign in
Got the output?

An analysis sheet joining two real datasets, with a pivot table and rule-based highlighting

Mark it when you've got the output in hand.
PATH · SPREADSHEET FLUENT 2/5
VAll Digital Productivity & Tools lessons