Getting started
Find your way around Google Sheets: select, enter and edit, autofill, move rows and columns, and work with tabs.
Lessons
In the order the Roadmap teaches them.
In the full course. Beginner · 8 min
Find your way around the screen
Name the parts of the screen, find any cell by its address, and read a quick total without a formula.
See the lessonIn the full course. Beginner · 9 min
Select cells, ranges, rows and columns fast
Select any block of cells without dragging past it, plus whole rows, whole columns and the whole list.
See the lessonIn the full course. Beginner · 8 min
Enter and edit data
Type data fast with Enter and Tab, keep numbers as numbers, and fix a cell without retyping it.
See the lessonIn the full course. Beginner · 9 min
Autofill: numbers, dates and patterns
Fill numbers, dates, days, months and quarters by dragging, instead of typing each one.
See the lessonIn the full course. Beginner · 8 min
Undo, redo and fixing mistakes
Take back a change with Undo, one step at a time, bring it back with Redo, and undo a sort that no other sort can fix.
See the lessonIn the full course. Beginner · 10 min
Insert, delete and move rows and columns
Insert, delete and move whole rows or columns, and see how the totals and formulas around them keep up.
See the lessonIn the full course. Beginner · 8 min
Resize columns and rows to fit
Fix #### and cut-off text by fitting columns and rows to their contents, or set an exact width.
See the lessonIn the full course. Beginner · 8 min
Freeze the top row and first column
Keep the headers and the first column in view while you scroll a long, wide sheet.
See the lessonIn the full course. Beginner · 10 min
Work with multiple sheets (tabs)
Add, rename, move, color, copy and delete sheet tabs, and know what happens to formulas that read them.
See the lessonIn the full course. Beginner · 11 min
Copy, cut, paste and Paste Special
Copy, cut and paste cells, and use Paste Special to paste only the numbers, only the look, or a copy turned on its side.
See the lessonIn the full course. Beginner · 9 min
Find and replace
Change a name or word in every cell at once. Use Match entire cell contents so it only changes cells that match exactly.
See the lessonIn the full course. Beginner · 8 min
Hide and unhide rows, columns and sheets
Hide rows, columns and whole sheets you don't need on screen, bring them back, and know why hiding is not deleting.
See the lessonIn the full course. Beginner · 8 min
Group rows and columns
Group detail rows or columns under their totals, collapse them out of sight with one click, and expand them again.
See the lessonIn the full course. Beginner · 7 min
Zoom, gridlines and view options
Zoom a sheet in and out to read it or see more of it, and turn gridlines off on the sheets you show to others.
See the lessonIn the full course. Beginner · 8 min
Save, download and file formats
Save or download a copy as .xlsx or .csv, and know what each file format keeps.
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.