Practice mode · free · unlimited · not certifiable
Workflow Scenarios
Unscored tasks with hints and instant feedback. Practice results never become credentials.
Short lesson
Lookup and summary formulas · 10 min
XLOOKUP(key, lookup_range, return_range) replaces VLOOKUP. SUMIFS/COUNTIFS give pivot-style summaries. Use $A$1 for fixed references.
L3Merge, dedupe, summarisesheet
Two exported customer lists sit side by side (A:C and E:G). Merge them into one list in A:C (no duplicates — same customer and revenue), clear E:G, then in J2:J4 compute revenue by region for EU, US, APAC (labels in I2:I4).
Sign up to practiseL3Send the two-line summarytext
Write the two-line email summary for your manager with the regional totals you just built (EU 1,630 · US 850 · APAC 2,400; total 4,880). It must be sent before the 17:00 deadline.
Sign up to practiseL5Knowledge checkmcq
You receive a CSV, a chat message and a 45-minute deadline. What order gives the most reliable result?
Sign up to practise