Excel Lessons

Try a step

One click

Every cell has an address: its column letter, then its row number.

Click the cell that holds the rate.

One click. The cells become clickable when JavaScript loads.

Learn Excel by doing it.

Real formulas in a real grid, marked the moment you press Enter.

For work, job interviews and Excel tests.

Start the first lesson
  • Free
  • No account to start
  • 100+ learners

you type. it marks.

Every step is a cell in a real grid. You type the formula and press Enter. The grid marks it on the spot, with a reason when it is wrong.

Correct

Change the hours and the pay changes with them. That is what a formula is for.

one new thing at a time.

A lesson shows you the formula first. Then you predict, apply, vary and build, and the last step shows the mistake everyone makes. How every lesson is built and checked.

  1. 1

    Copy See the formula. Type it.

  2. 2

    Predict Say what a formula returns.

  3. 3

    Apply The same shape on new cells.

  4. 4

    Vary One new argument.

  5. 5

    Build A target and a function name.

  6. 6

    Trap The mistake everyone makes.

18 modules, 105 short lessons, in order. Start on the first without an account.

  1. 1 Spreadsheet Basics
  2. 2 Cell References and Fill
  3. 3 Keyboard Shortcuts
  4. 4 Everyday Math
  5. 5 Logic
  6. 6 Conditional Math
  7. 7 Lookups
  8. 8 Advanced Lookups
  9. 9 Errors and Robust Formulas
  10. 10 Text: Extracting
  11. 11 Text: Building and Cleaning
  12. 12 Text: Splitting
  13. 13 Dates and Time
  14. 14 Dates in Practice
  15. 15 Dynamic Arrays
  16. 16 Summaries and Reports
  17. 17 Pivot Tables
  18. 18 Projects

you can say what you learned.

Every lesson ends with what you can now do, in plain words. The steps have to earn every line.

Lesson complete

VLOOKUP

6 of 6 steps, 900 points

You can now

  • look up a value with VLOOKUP and return any column from its row.
  • search for a code read from a cell or typed into the formula.
  • say what FALSE does, and what leaving it off costs.

typing beats watching.

A video shows you Excel. Here you use it.

Excel Lessons next to a video course
What A video course Excel Lessons
What you do Watch somebody else type. Type every formula yourself, in a real grid.
Feedback You check your own work, if at all. Marked the moment you press Enter, with the reason.
Mistakes You meet them later, on your own. The last step of a lesson is the mistake most people make.
Time Long videos to sit through. Five or six short steps, about five minutes.
Setup Excel open in another window. Nothing to install. It runs in your browser.

Questions people ask first

Is it free?

The first lesson is, with no account. The second is free with one. The rest comes with a subscription, at $3.75 a month paid annually.

Do I need Excel installed?

No. The grid runs in your browser and marks your formulas itself. The lessons need a keyboard, so use a computer.

Which Excel does it match?

English-language Excel formulas, as Microsoft 365 writes them, on Windows, Mac and the web. Most also work in Excel 2021 and Google Sheets. A few of the newest functions need Microsoft 365.

How long is a lesson?

Five or six steps, about five minutes.

How is it scored?

100 points a step, 50 more for a first try, 25 off for a hint. Speed is never scored.

learn Excel by doing it.

The first lesson takes about five minutes and needs no account.

Start the first lesson

For a team? Not on sale yet. Tell us how many seats you would need