Google Sheets Skills
The same 215 lessons as the Roadmap, grouped by what they do. Pick a skill, or search for what you need in everyday words.
Skills
Getting started15 lessons
Find your way around Google Sheets: select, enter and edit, autofill, move rows and columns, and work with tabs.
about 2 h 10 min
Formatting10 lessons
Make numbers, dates and tables readable: currency, percent, borders, wrapping and custom number formats.
about 1 h 40 min
Formula basics10 lessons
Write formulas that update by themselves, copy them without breaking, and pull numbers from other sheets.
about 1 h 25 min · 1 free
Math and statistics14 lessons
Totals, counts, averages and rounding, then conditional totals with SUMIF, SUMIFS, AVERAGEIFS and MAXIFS.
about 2 h 20 min
Logic7 lessons
Let a cell decide with IF, AND, OR and IFS, and handle errors cleanly.
about 1 h 10 min
Text13 lessons
Join, split, trim and change the case of text: names, product codes and email addresses.
about 2 h
Dates and times11 lessons
Do math with dates and times: days between, month-ends, working days, ages and hours worked.
about 1 h 45 min
Lookups12 lessons
Bring values over from another table with VLOOKUP, XLOOKUP and INDEX/MATCH, and fix #N/A.
about 2 h · 1 free
Dynamic arrays12 lessons
Formulas that return whole lists: FILTER, SORT, UNIQUE, SEQUENCE and ARRAYFORMULA, then LET and LAMBDA.
about 2 h
Sorting and filtering6 lessons
Put lists in the right order and show only the rows you need, including filter views your team can share.
52 min
Data cleaning10 lessons
Fix duplicates, extra spaces, numbers and dates stored as text, joined columns and blank cells in imported data.
about 1 h 45 min · 1 free
Pivot tables13 lessons
Summarize a long list by region, month or rep, then group, sort and refresh.
about 2 h 5 min · 1 free
Charts14 lessons
Pick the right chart and make it clear: columns, lines, pies, combos, scatter plots and more.
about 2 h 10 min
Conditional formatting8 lessons
Make the cells that matter stand out: thresholds, whole rows, duplicates and due dates.
about 1 h 15 min
Dropdowns and validation7 lessons
Stop typos at the source with dropdowns, checkboxes and rules for what a cell accepts.
about 1 h 10 min · 1 free
Tables and named ranges4 lessons
Ranges that grow with your data and formulas you can read at a glance.
31 min
Errors and debugging4 lessons
Read every error value, find out why a total is wrong, and fix it.
39 min
Keyboard shortcuts6 lessons
The Google Sheets shortcuts for moving, selecting, formatting and writing formulas.
56 min
Sharing, printing and protecting6 lessons
Print on one page, add comments, and protect cells and formulas.
50 min
Business math8 lessons
Margin vs markup, percentage changes, interest, loan payments and break-even.
about 1 h 25 min
Real-world projects19 lessons
Build files you'll reuse: a budget, an invoice, a timesheet, trackers, a dashboard and more.
about 4 h 15 min
Interview prep6 lessons
Timed practice on the tasks employers test, plus a mock analyst take-home task.
about 1 h 25 min
Get 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.