For tracking tasks, requests or projects in a shared sheet.
Team trackers in Google Sheets
Build a shared tracker with status dropdowns, color-coded rows, due-date warnings, counts by status, filters and sorting, ending with a full project tracker.
The first lesson is free and needs no sign-up.
Do this path on your computer.
Its lessons run in your browser on a laptop or desktop, and every step is checked as you go. Send yourself the link. Nothing is saved until you sign in.
The lessons, in order
Each one takes about 10 minutes. One is free; the rest are in the full course.
- 1
Make a dropdown list
Free · Confident · 7 min
Give a column a dropdown of fixed choices, pick from it, and stop anything else from being typed.
Start the lesson - 2
Dropdown from a range
In the full course. Confident · 11 min
Build a dropdown whose choices come from a list of cells on another sheet, and stretch it when the list grows.
See the lesson - 3
Highlight cells above a value
In the full course. Confident · 8 min
Color every amount above a limit automatically, so the cells that need attention stand out and keep standing out when the numbers change.
See the lesson - 4
Highlight the whole row
In the full course. Confident · 9 min
Color an entire row when one of its cells meets a condition, with a formula rule that locks the column it checks.
See the lesson - 5
Days between two dates
In the full course. Beginner · 9 min
Count the days between two dates by subtracting them, show the result as a number, and add 1 when both end days count.
See the lesson - 6
Highlight overdue and due-this-week dates
In the full course. Confident · 11 min
Color overdue dates red and dates due within the next week yellow, with formula rules that compare each date to today.
See the lesson - 7
SUMIF and COUNTIF
In the full course. Confident · 12 min
Total and count only the rows that match a condition, and copy the formula down without breaking its ranges.
See the lesson - 8
Filter a list
In the full course. Beginner · 9 min
Show only the rows you need by picking values or setting a condition, and know that the hidden rows still count in your totals.
See the lesson - 9
Sort by several columns
In the full course. Confident · 9 min
Sort a list by two or three columns in the right order, and never break your rows by sorting one column alone.
See the lesson - 10
Project tracker with status and due dates
In the full course. Confident · 14 min
Build a project tracker with a status dropdown, red overdue dates that clear when a task is done, and counts by status and owner.
See the lesson
Other paths in the Google Sheets course
Google Sheets basics in a weekend
For starting from zero, or only typing numbers into cells today.
14 lessons · about 2 h · 4 free · Beginner to Confident
See the pathLookups without the #N/A
For matching lists by hand today: prices, product names, staff details, commission tiers.
9 lessons · about 1 h 30 min · 2 free · Beginner to Advanced
See the pathReports 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 pathGoogle Sheets for small business
For quotes, stock and money kept in a spreadsheet.
12 lessons · about 2 h 15 min · 3 free · Confident
See the pathPivot tables by Monday
For summarizing a sales or expense list for a meeting.
7 lessons · about 1 h 5 min · 1 free · 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.