Conditional formatting
Make the cells that matter stand out: thresholds, whole rows, duplicates and due dates.
Lessons
In the order the Roadmap teaches them.
In the full course. Confident · 8 min
Highlight cells above a value
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 lessonIn the full course. Confident · 9 min
Color scales and data bars
Color a grid of numbers from lowest to highest, so the strong and weak spots stand out at a glance.
See the lessonIn the full course. Confident · 9 min
Highlight the whole row
Color an entire row when one of its cells meets a condition, with a formula rule that locks the column it checks.
See the lessonIn the full course. Confident · 9 min
Highlight duplicates
Color every value that appears more than once in a column, so repeated invoices, emails or IDs stand out before they cause trouble.
See the lessonIn the full course. Confident · 11 min
Highlight overdue and due-this-week dates
Color overdue dates red and dates due within the next week yellow, with formula rules that compare each date to today.
See the lessonIn the full course. Confident · 10 min
Traffic-light status column
Color a status column green, yellow and red with one rule per status. Then you can see problems right away when a status changes.
See the lessonIn the full course. Confident · 9 min
Manage and remove rules
Find, change, extend and remove conditional formatting rules, and know which rule wins when two apply to the same cell.
See the lessonIn the full course. Confident · 10 min
Icon sets
Show a small icon in each cell, such as a green, yellow or red circle, and choose the numbers where the icon changes.
See the lessonIn the full course. Advanced · 12 min
Rules with custom formulas
Write formula rules that compare cells in the same row, combine conditions with AND and OR, and handle empty cells.
See the lessonPaths with these lessons
A path is a short list of lessons from the course, picked for one goal.
Excel test prep
For an Excel test or skills check for an office, admin or analyst job.
15 lessons · about 2 h 30 min · 4 free · Beginner to Confident
See the pathExcel for small business
For quotes, stock and money kept in a spreadsheet.
12 lessons · about 2 h 15 min · 3 free · 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 Excel course, with new lessons added as they're written.
- All 217 Excel lessons open today, and every new one as it's written.
- The Roadmap, Skills and all eight paths.
- A cheat sheet for every lesson you finish.
- At checkout, add the Google Sheets course for US$49.