Errors and debugging
Read every error value, find out why a total is wrong, and fix it.
Lessons
In the order the Roadmap teaches them.
In the full course. Confident · 11 min
#N/A, #VALUE!, #REF!, #DIV/0! and #NAME? explained
Read the five common error values, find what causes each one and fix the cause instead of hiding it.
See the lessonIn the full course. Confident · 10 min
Why your SUM is wrong
Find why a SUM total doesn't match: numbers stored as text, a range that stops short, hidden rows or a total typed by hand, and fix each one.
See the lessonIn the full course. Confident · 8 min
Circular references
Find a formula that depends on its own cell, directly or through other cells, and fix it so it can finish.
See the lessonIn the full course. Advanced · 10 min
#SPILL! errors
Find what blocks a list formula, including cells that only look empty, clear it, and lay out lists so they have room to grow.
See the lessonPaths with these lessons
A path is a short list of lessons from the course, picked for one goal.
Reports that don't break
For a weekly or monthly report other people rely on.
11 lessons · about 1 h 45 min · 2 free · Beginner to Confident
See the pathClean up messy data
For exports, CSVs and form responses that need tidying before anyone can use them.
10 lessons · about 1 h 30 min · 1 free · Beginner to Confident
See the pathGet 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.