Interview prep
Timed practice on the tasks employers test, plus a mock analyst take-home task.
Lessons
In the order the Roadmap teaches them.
In the full course. Analyst · 25 min
The 10 tasks employers test
Work through ten tasks that come up again and again in spreadsheet tests, from a locked total to a pivot table, and know which lesson to review for each.
See the lessonIn the full course. Analyst · 12 min
Timed test: formulas
Write five everyday formulas against a 10-minute clock, from a copied row formula to SUMIF, COUNTIFS and ROUND.
See the lessonIn the full course. Analyst · 10 min
Timed test: lookups
Do four lookup tasks against an 8-minute clock, with VLOOKUP, XLOOKUP, INDEX and MATCH, and a lookup on two conditions.
See the lessonIn the full course. Analyst · 12 min
Timed test: pivot tables
Build a pivot table, change its fields, filter it, change its summary and fix it after a data change, against a 10-minute clock.
See the lessonIn the full course. Analyst · 12 min
Timed test: cleaning data
Clean a messy sign-up export against a 10-minute clock, with Remove duplicates, TRIM, PROPER, splitting a column and fixing numbers stored as text.
See the lessonIn the full course. Analyst · 15 min
Mock analyst take-home task
Run a take-home task end to end, from checking and cleaning the data to a short summary that answers each question with a number.
See the lessonGet the full course
Every lesson in the Google Sheets course, with new lessons added as they're written.
- All 215 Google Sheets lessons open today, and every new one as it's written.
- The Roadmap, Skills and all seven paths.
- A cheat sheet for every lesson you finish.
- At checkout, add the Excel course for US$49.