exceltestpracticeStart free
Practice testsLearnFunctionsShortcutsPricingStart free

Learn Excel by level

Pick the path that matches what you can already do. Each lesson is a few short exercises in a working grid, checked the moment you press Enter. Not sure where you fit? Take the five-question check.

  1. Beginner Track 0

    Excel from Zero

    You have never used a spreadsheet, or you open one and stay on the cells you already know.

    Start Excel from Zero

    After this path you can

    • Enter, select, copy and format data in a grid without hunting for buttons.
    • Write a formula with cell references, and use $ to lock the one that must not move.
    • Total, average and count a column, then sort and filter a list.

    38 lessons in 6 of 6 modules, 38 planned. All 38 lessons are free.

  2. Intermediate Track 1

    Everyday Excel

    You can write a SUM and format a table, and you want the functions that turn a list into answers.

    Start Everyday Excel

    After this path you can

    • Make a formula decide with IF, AND and OR.
    • Total or count only the rows that match a condition with SUMIFS and COUNTIFS.
    • Pull a value from another table with VLOOKUP or XLOOKUP, and tidy text with TRIM and TEXTJOIN.

    41 lessons in 6 of 9 modules, 57 planned. The first two lessons of every module are free: 12 of 41 published lessons.

  3. Advanced Track 2

    Analyst

    You already use lookups and conditional sums, and you want to model, audit and summarize larger data.

    Start Analyst

    After this path you can

    • Look up on two criteria with INDEX and MATCH.
    • Find the cause of every error value, and handle it with IFERROR and IFNA.
    • Write FILTER, SORT and UNIQUE formulas that spill, and price a loan with PMT.

    34 lessons in 6 of 8 modules, 46 planned. The first two lessons of every module are free: 12 of 34 published lessons.

Which path is right for me?

Five questions about real Excel tasks. Answer yes only if you could do it right now without looking anything up.

  1. A column of sales sits in B2:B9. Could you total it with a formula you typed yourself, starting with the equals sign?

  2. You copy a formula down a column and one reference must stay on the same cell, like a tax rate in F1. Do you know to write $F$1, and why?

  3. Could you write a formula that totals sales for one region only, or for one region in one month?

  4. Given a product ID, could you pull its price from a separate price list with VLOOKUP or XLOOKUP, using exact match?

  5. Could you look up a value by both its row heading and its column heading with INDEX and MATCH, and say what a #N/A in the result means?

How to score yourself

Read down the list and stop at the first question you could not answer with a confident yes. "Not sure" counts as no. Where you stopped is your starting path: questions 1 and 2 is Beginner; questions 3 and 4 is Intermediate; question 5 is Advanced. Yes to all five also lands on Advanced.

Coming later

  • ExpertExpert, not published yet

    Modeling and case work: the long, multi-step tasks some interviews hand you.

The Advanced and Expert paths arrive module by module; each page lists what is live.