Tables and named ranges
Ranges that grow with your data and formulas you can read at a glance.
Lessons
In the order the Roadmap teaches them.
In the full course. Confident · 7 min
Turn a range into a table
Make a list a table with a name, so it keeps its filter buttons and banding and grows when you add a row.
See the lessonIn the full course. Confident · 8 min
Totals row and table styles
Add a total row to a table whose totals follow a filter, and change the table's colors without touching the data.
See the lessonIn the full course. Advanced · 8 min
Structured references
Write formulas with a table's names, like Orders[Revenue], so they read clearly and follow the table.
See the lessonIn the full course. Advanced · 8 min
Ranges that grow automatically
Write totals that name a table's column, so they keep up when you add rows.
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.