Google Sheets lessons
Every reading is free to read here. Practice happens in a live sheet in the app: Level 1 is free, and Levels 2 and 3 come with the Certificate Pass.
Level 1Free
Google Sheets Basics
35 lessons in 8 sections
Welcome
Spreadsheet Fundamentals
Formulas & References
Core Functions
Summarizing Data
Formatting, Validation & Charts
Analyst Habits
Preview: Sheets Superpowers
Level 2Readings free, practice with the Certificate Pass
Intermediate Google Sheets
45 lessons in 11 sections
Lookups
Logic
Multi-Condition Math
Working Across Tabs
Text
Text, Part 2
Dates
Dates, Part 2
Clean Inputs
Pivot Tables & Formatting
Level 3Readings free, practice with the Certificate Pass
Sheets Superpowers
50 lessons in 10 sections
Formulas That Spill
Shaping Arrays
LET and LAMBDA
- ARRAYFORMULA: one formula per columnReading4 min
- ARRAYFORMULA for rows yet to comePractice3 min
- LET: formulas you can readReading4 min
- LET: name the piecesPractice3 min
- LAMBDA and MAP: your own logic on every rowReading5 min
- MAP with your own LAMBDAPractice3 min
- BYROW: the best month per campaignPractice3 min
- SCAN, REDUCE, BYCOL and MAKEARRAYReading5 min
- SCAN: a running cash balancePractice3 min
- REDUCE: compound a year of growthPractice3 min
- Named functions: your team's own formulasReading4 min
REGEX
QUERY
- QUERY: SQL inside a cellReading6 min
- QUERY: revenue by channelPractice3 min
- QUERY: where, and order byPractice3 min
- QUERY: top channels with labelsPractice4 min
- A channel report from one QUERYProject8 min
- QUERY, advanced: conditions, dates, pivot and other tabsReading6 min
- QUERY another tab, with or and parenthesesPractice4 min
- QUERY: one quarter, pivoted by monthPractice4 min