Logic

Let a cell decide with IF, AND, OR and IFS, and handle errors cleanly.

7 lessons · about 1 h 10 min · Beginner to Confident

Get the full course The same skill in Google Sheets

Lessons

In the order the Roadmap teaches them.

In the full course. Beginner · 11 min

IF: make a decision in a cell

Write an IF that shows one result or another depending on a test, with text, numbers or an empty cell as the result.

See the lesson

In the full course. Confident · 10 min

IF with AND and OR

Make IF check two or more conditions at once, with AND when all must be true and OR when one is enough.

See the lesson

In the full course. Confident · 10 min

Nested IF vs IFS

Choose between three or more outcomes with a nested IF or IFS, and put the tests in the right order.

See the lesson

In the full course. Confident · 9 min

SWITCH

Turn codes into names with SWITCH, and show a clear message for a code that isn't in your list.

See the lesson

In the full course. Confident · 11 min

Hide errors with IFERROR and IFNA

Replace expected errors such as #DIV/0! with a clear value using IFERROR, and use IFNA for lookups so real mistakes still show.

See the lesson

In the full course. Confident · 11 min

Pass/fail and grading scales

Mark scores Pass or Fail against a pass mark kept in one cell, and turn scores into letter grades with a grading scale table.

See the lesson

In the full course. Confident · 10 min

Flag overdue items

Add a column that says Overdue next to every late, unfinished item and stays empty for the rest.

See the lesson

Paths 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 path

Excel 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 path

Lookups 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 path

Reports 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 path

Get 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.

US$149

Tax included · Lifetime access

Get the full course

30-day money-back guarantee if you've opened fewer than 10 paid lessons.

No account needed to pay. Payments are handled by Link, Stripe's checkout. Your card statement shows LINK.COM.