Learn Excel by writing the formulas yourself.

Short tasks on an Excel-style sheet. When your formula is wrong, you see exactly why.

Start with 120 challenges. The full course is $29, one time.

The practice sheet

Challenge 1 of 120: = + - * / (Starter)

Your first formula

You did a job for a client and the invoice needs its numbers. In B8, work out the fee: hours times the hourly rate. In B9, the total with travel. In B10, what's still to pay once the deposit is taken off. In B11, the amount of each of the monthly payments left.

A formula starts with =. Then click a cell, type an operator, click the next cell: + adds, - subtracts, * multiplies and / divides. =B2*B3 is B2 times B3. Click the cells rather than typing their numbers, so the answer follows when a number changes.

invoice.xlsx
Ready

Write in the green cells. Enter checks your answer. Click a cell while typing to insert it, drag to select a range, F4 adds $, Esc cancels.

Write in the green cells. Enter checks your answer. Tap a cell while writing a formula to insert it, or slide across cells for a range. The strip above the keyboard has = ( ) : , $.

How it works

  1. One move per challenge

    Each challenge teaches one move: adding a column, locking a reference, a first IF. It takes about 3 minutes.

  2. Wrong answers come with a reason

    Every check names the cell, the value and the fix. Any formula that gets the right answer passes. Typed-in numbers don't, because they stop being right the moment the data changes.

  3. You type every formula

    Typing =VLOOKUP( yourself teaches more than reading about it ten times. The keyboard shortcuts work like the real thing.

All challenges

All 120 challenges are free to practise. In the course they come in order, and each formula lesson ends with the same task on new data. The first 10 course lessons are free; Pro opens the rest.

  1. 01Starter, 3 min Your first formula= + - * /
  2. 02Starter, 3 min Add it upSUM
  3. 03Starter, 3 min AutoSum in one keystrokeAutoSum
  4. 04Starter, 3 min Find the averageAVERAGE
  5. 05Starter, 3 min Smallest and largestMIN, MAX
  6. 06Starter, 3 min Brackets change the answerOrder of operations
  7. 07Starter, 3 min Count what's thereCOUNT, COUNTA, COUNTBLANK
  8. 08Starter, 3 min Write once, fill downRelative references
  9. 09Starter, 3 min Fill rightCtrl + R
  10. 10Core, 3 min Lock it with $Absolute references
  11. 11Starter, 3 min Percent of a totalPercentages
  12. 12Starter, 3 min Make the numbers readableNumber formats
  13. 13Starter, 3 min Bold, italic, underlineCtrl + B, I, U
  14. 14Core, 3 min Up or down by how much?Percent change
  15. 15Core, 3 min What you see vs what's storedROUND
  16. 16Core, 3 min The typical valueMEDIAN
  17. 17Core, 3 min The most common valueMODE
  18. 18Core, 3 min Top 3 and bottom 3LARGE, SMALL
  19. 19Core, 3 min Always round up (or down)ROUNDUP, ROUNDDOWN
  20. 20Core, 3 min Round to the nearest 5, 15, 0.25CEILING, FLOOR, MROUND
  21. 21Core, 3 min Round to odd or evenEVEN, ODD
  22. 22Starter, 3 min How many days are left?TODAY
  23. 23Core, 3 min Select to the end in one moveCtrl + Shift + arrow
  24. 24Starter, 3 min Every cell has an addressCell addresses
  25. 25Starter, 3 min Select a rangeDrag, Shift + click
  26. 26Starter, 3 min Move without the mouseArrow keys, Enter, Tab
  27. 27Starter, 3 min Jump to the edge of the dataCtrl + arrow
  28. 28Starter, 3 min Whole rows and columnsShift + Space, Ctrl + Space
  29. 29Starter, 3 min Select everythingCtrl + A
  30. 30Starter, 3 min Let the status bar do the mathStatus bar: Sum, Count, Average
  31. 31Starter, 3 min Sort without breaking rowsSort
  32. 32Core, 3 min Sort by two columnsMulti-level sort
  33. 33Starter, 3 min Filter to what mattersFilter
  34. 34Core, 3 min Insert and delete rows fastInsert and delete rows
  35. 35Starter, 3 min Copy and paste a formulaCtrl+C, Ctrl+V
  36. 36Core, 3 min Paste values onlyPaste Special → Values
  37. 37Core, 3 min Highlight what's over targetConditional formatting
  38. 38Core, 3 min Spot the duplicatesDuplicate Values rule
  39. 39Starter, 3 min TRUE or FALSE?Comparisons
  40. 40Starter, 3 min Work across sheetsSheet tabs
  41. 41Core, 3 min Pass or fail?IF
  42. 42Core, 3 min Both or either?AND, OR
  43. 43Core, 3 min Exactly one of the twoXOR
  44. 44Core, 3 min Grade bands with nested IFNested IF
  45. 45Core, 3 min Many conditions, no nestingIFS
  46. 46Core, 3 min Match a code with SWITCHSWITCH
  47. 47Core, 3 min IF with AND and ORIF + AND, OR
  48. 48Core, 3 min What's in this cell?ISNUMBER, ISTEXT, ISBLANK
  49. 49Core, 3 min Count the ones that matchCOUNTIF
  50. 50Core, 3 min Add up the ones that matchSUMIF
  51. 51Core, 3 min Use a cell as the conditionCriteria in a cell
  52. 52Core, 3 min Partial matches with * and ?SUMIF, COUNTIF with wildcards
  53. 53Core, 3 min Count with two conditionsCOUNTIFS
  54. 54Core, 3 min Add up with two conditionsSUMIFS
  55. 55Core, 3 min Average with conditionsAVERAGEIF, AVERAGEIFS
  56. 56Core, 3 min Count the blanksCOUNTBLANK, COUNTA
  57. 57Core, 3 min Look it upVLOOKUP
  58. 58Core, 3 min Find the right bracketVLOOKUP approximate match
  59. 59Core, 3 min Fill a lookup downVLOOKUP + $
  60. 60Core, 3 min Look across a rowHLOOKUP
  61. 61Core, 3 min XLOOKUP, the modern wayXLOOKUP
  62. 62Starter, 3 min Fix #NAME?#NAME?
  63. 63Core, 3 min Where is it in the list?MATCH
  64. 64Core, 3 min Give me the nth oneINDEX
  65. 65Starter, 3 min Fix the capitalsUPPER, LOWER, PROPER
  66. 66Starter, 3 min First and last charactersLEFT, RIGHT
  67. 67Advanced, 3 min INDEX and MATCH togetherINDEX + MATCH
  68. 68Advanced, 3 min XLOOKUP with wildcardsXLOOKUP match_mode
  69. 69Advanced, 3 min Row and column lookupINDEX + MATCH + MATCH
  70. 70Advanced, 3 min Lock just the row or the columnMixed references
  71. 71Core, 3 min Mistake hunt: the totals don't add upFixing SUM
  72. 72Advanced, 3 min Growth per year (CAGR)CAGR with ^
  73. 73Advanced, 3 min Whole parts and leftoversINT, MOD
  74. 74Core, 3 min Use a rate from another sheetReferences to other sheets
  75. 75Advanced, 3 min Custom number formatsCustom formats
  76. 76Core, 3 min Catch the error, not the bugIFERROR
  77. 77Core, 3 min Mistake hunt: the commission sheetFixing IF
  78. 78Core, 3 min Which invoices are missing?Compare two lists
  79. 79Core, 3 min Mistake hunt: the regional reportFixing SUMIF
  80. 80Core, 3 min Reconcile the ledger with the bankXLOOKUP or VLOOKUP + IFNA
  81. 81Core, 3 min Join text together&, CONCAT, PROPER
  82. 82Core, 3 min Join a list with commasTEXTJOIN
  83. 83Core, 3 min Pull from the middleMID
  84. 84Core, 3 min FIND or SEARCH?FIND, SEARCH
  85. 85Core, 3 min Split first and last namesLEFT, MID + FIND
  86. 86Core, 3 min Stray spaces that break a countTRIM
  87. 87Core, 3 min Flag the bad entriesTRIM, LEN, EXACT
  88. 88Advanced, 3 min Clean a bank descriptionTEXTBEFORE, TEXTAFTER, PROPER
  89. 89Core, 3 min Swap one word for anotherSUBSTITUTE
  90. 90Core, 3 min Mistake hunt: #N/A everywhereFixing #N/A
  91. 91Core, 3 min Mistake hunt: hard-coded numbersReferences instead of typed numbers
  92. 92Core, 3 min Mistake hunt: numbers stored as textNumbers stored as text
  93. 93Core, 3 min Fix #DIV/0!#DIV/0!
  94. 94Core, 3 min Fix #VALUE!#VALUE!
  95. 95Core, 3 min Fix #REF!#REF!
  96. 96Core, 3 min Fix a circular referenceCircular references
  97. 97Core, 3 min One of each, then the totalsUNIQUE
  98. 98Advanced, 3 min Rows that matchFILTER
  99. 99Advanced, 3 min Sorted, unique list in one formulaSORT + UNIQUE
  100. 100Core, 3 min Your first pivot tablePivot tables
  101. 101Advanced, 3 min Slice the pivotPivot table filters
  102. 102Advanced, 3 min Which category went up most?SUMIFS, change, lookup
  103. 103Core, 3 min How many days late?Date arithmetic
  104. 104Core, 3 min Turn text into real datesDATEVALUE
  105. 105Core, 3 min Build a date from partsDATE, YEAR, MONTH
  106. 106Advanced, 3 min Month ends and working daysEOMONTH, NETWORKDAYS
  107. 107Core, 3 min Renewal datesEDATE
  108. 108Advanced, 3 min Totals between two datesSUMIFS with dates
  109. 109Core, 3 min Days overdue and aging bandsDate difference, aging bands
  110. 110Core, 3 min Age and years of serviceDATEDIF
  111. 111Core, 3 min How many late orders?Pick the tool
  112. 112Core, 3 min Sales per repPick the tool
  113. 113Core, 3 min Whose part is it?Pick the tool
  114. 114Core, 3 min Who gets the bonus?Pick the tool
  115. 115Core, 3 min Each region's sharePick the tool
  116. 116Advanced, 3 min Case: the supplier reportCase, five steps
  117. 117Advanced, 3 min Case: the monthly budgetCase, five steps
  118. 118Advanced, 3 min Case: the reorder listCase, five steps
  119. 119Advanced, 3 min Case: timesheet and overtimeCase, five steps
  120. 120Advanced, 3 min Case: the messy customer listCase, five steps

How to learn Excel: what to learn first, how to practise, and what tests ask

Written for adults who need Excel at work. Each skill below links to a challenge you can try in a few minutes.

1. Learn Excel in this order

It's easy to learn Excel from whatever the last video showed, a chart one week and a macro the next, and never get solid on the few moves most spreadsheet work runs on. This order starts with those moves. Each step uses the one before it, so a skipped step usually shows up later as a formula you can't fix.

  1. A1

    Move and select without the mouse

    Arrow keys, Ctrl + arrow to jump to the end of a column, Ctrl + Shift + arrow to select it. Small as it sounds, it is what makes someone look at home in a spreadsheet. Select to the end, then the shortcut drills.

  2. A2

    First formulas that point at cells

    SUM, AVERAGE, MIN, MAX, COUNT. Point at cells instead of typing the numbers in, so the answer changes when the data does. SUM, AVERAGE, COUNT vs COUNTA.

  3. A3

    Copy a formula, not a number

    Fill down, then learn what the $ does. Relative and absolute references are where most beginners stall, and they explain why a formula that is right in row 2 is wrong in row 12. Fill down, Lock it with $, Percent of a total.

  4. A4

    Make decisions with IF

    IF, then AND and OR, then a nested IF for grade bands or price tiers. Watch the edges: is the pass mark > 50 or >= 50? IF, AND, OR, Nested IF.

  5. A5

    Count and add up with conditions

    COUNTIF and SUMIF, then COUNTIFS and SUMIFS. A lot of questions at work come down to one of these: how many orders from the North, how much did one customer spend in March. COUNTIF, SUMIF, SUMIFS.

  6. A6

    Look values up in another table

    VLOOKUP first, because you will meet it in old files. Then XLOOKUP, which is simpler, and INDEX with MATCH for versions without it. VLOOKUP, XLOOKUP, INDEX and MATCH.

  7. A7

    Clean up and check

    Real data is messy: names in one cell, stray spaces, numbers stored as text, #N/A down a whole column. A lot of real work time goes here, and tests like to check it. Split names, Fix #N/A, Numbers stored as text.

  8. A8

    Summarise: pivot tables and charts

    A pivot table does in a few clicks what SUMIFS does by hand. Learn it after SUMIFS and you will know what it is adding up, which helps when the total looks wrong. Pivot challenges are on the course path.

Macros, VBA and Power Query can wait until a job asks for them. The 120 free challenges here cover steps one to seven and take about 360 minutes in all. The course page shows the whole path, module by module.

Read the full guide

2. Why practice beats watching a video

Videos are good for seeing something done once, like where a button is. The trouble starts when you use them to build a skill, because watching someone write a formula feels like learning. You follow every step, it all makes sense, and the next morning the empty cell gives you nothing back.

Researchers have measured that gap. In a 2019 physics study, Louis Deslauriers and colleagues found that students in hands-on classes learned more than students in a polished lecture, yet felt they had learned less.

Recalling something also sticks better than reading it again. In a 2006 study by Henry Roediger and Jeffrey Karpicke, students either reread a text or practised recalling it. Five minutes later the rereaders were ahead. A week later the order had flipped, and the rereaders had expected to do best. This is the testing effect, and other studies have found it many times since.

People also remember an answer they worked out better than one they were shown (Slamecka and Graf, 1978, the generation effect). Typing =SUMIF( and picking each argument yourself is that kind of work. And practice spread over several days is remembered better than the same time in one sitting: Cepeda and colleagues reviewed hundreds of studies of this spacing effect in 2006.

Watching a video compared with practising in a sheet
Watching a videoPractising in a sheet
Who writes the formulaThe presenterYou
Where you startHalfway through someone else's workAn empty cell
When a mistake shows upLater, at workStraight away, with the reason
PaceThe video'sYours

So use a video to see something once. Then close it and write the formula yourself. That is how this site works: every challenge starts from an empty cell, any formula that gets the right answer passes, and when yours is wrong you are told why, in terms of your own sheet.

3. How to practise so it sticks

  • Type every formula yourself. Even slowly. Typing is how the argument order sticks, and pasting from a forum skips that step.
  • Use small tables. Ten or twelve rows are enough. You can check the answer by eye, so you know whether the formula is right before you trust it on ten thousand rows.
  • Change the data and watch. Edit one number. If your total doesn't move, somewhere you typed a number where a cell reference belongs. The checker here does this to every answer, which is why typed-in results don't pass.
  • Redo yesterday's challenge first. From an empty cell, without looking. It takes a couple of minutes and gives you recall and spacing at once.
  • Learn the three errors. #N/A means a lookup found nothing. #VALUE! usually means text where a number should be. #REF! means a cell the formula pointed at is gone. Knowing which is which tells you where to look.
  • Short and often. A few short sessions in a week do more than one long Sunday. Each challenge here is sized for a short session.

4. What Excel tests and interviews check

Many admin, analyst, finance and operations jobs check Excel before an offer. There is no single standard test; each employer writes or buys its own. They tend to come in three shapes: a take-home workbook you send back, a timed test in the browser with a mix of multiple choice and small sheet tasks, or a live task where you share your screen and explain what you are doing. Some run in a simulated Excel that accepts only one way of doing each task, and some are set in an older version without XLOOKUP. That is why VLOOKUP and INDEX MATCH still come up.

The skills they check overlap a lot:

  • Totals and counts with conditionsSUMIFS, COUNTIFS, AVERAGEIFS
  • LookupsVLOOKUP, XLOOKUP, INDEX + MATCH, and what to show when nothing is found
  • References that survive fill-down$A$1, $A1, A$1
  • LogicIF, nested IF or IFS for bands, AND, OR
  • Percentagesshare of a total, change from last month
  • Text cleanupsplitting names, TRIM, numbers stored as text
  • Summariessorting, filtering, pivot tables, a simple chart

Whoever marks the test can usually click a cell and see how you got the number. A correct total typed in by hand usually counts as wrong, and so does a lookup range that slides off the table when filled down. The hard-coded numbers and mixed reference challenges practise both. The formats, the skills and free timed practice tests are on Excel tests for job interviews, with a page each for data analyst, finance, accounting and admin jobs.

5. Common Excel interview questions

Interviewers may ask about Excel out loud, before a sheet task or instead of one: the difference between a relative and an absolute reference, COUNT and COUNTA, which lookup you use and why a VLOOKUP returns #N/A, SUMIF or SUMIFS, and when IFERROR hides a real mistake. Keep the answers short and concrete: what it does, one example, the mistake to avoid. Short answers to these and more, by level and by role, each linked to a challenge, are on Excel interview questions and answers.

6. FAQ

Can I learn Excel online for free here?
Yes. All 120 challenges are free, and you don't need an account for them: progress is saved in your browser, or on your account if you sign in. Pro costs $29 once and opens the full course, every lesson in order with a second round on new data, the full reports of the interview practice tests and a certificate when you pass one.
Do I need Excel installed?
No. The practice sheet runs in your browser, with a formula bar, fill-down and the usual keyboard shortcuts. A laptop or desktop is the most comfortable way to use it.
Does it work on a Mac?
Yes. Shortcuts are shown with ⌘ on a Mac and Ctrl on Windows, the way Excel itself works on each.
Will this help with Google Sheets?
Mostly, yes. SUM, IF, COUNTIF, SUMIFS, VLOOKUP, XLOOKUP, INDEX and MATCH are written the same way in Google Sheets. Menus and a few shortcuts differ.
Which version of Excel does it match?
Excel 365, the current version. XLOOKUP needs Excel 2021 or 365; the INDEX and MATCH challenge covers older versions.
How long does it take to learn Excel?
It depends on what the job needs. The 120 challenges here take about 360 minutes in all. Doing each one again a few days later, from an empty cell, helps it stay.
Is Excel still worth learning now that AI can write formulas?
An AI tool can draft a formula. You still have to tell whether it is right: whether the range covers every row, whether a $ is missing, whether the lookup is on the right column. That checking is what the challenges here practise.

The whole course, in order.

The challenges teach one move each. The course puts them in order and makes you do each one twice, the second time on data you haven't seen.

$29 One time. No subscription. Early-access price. Get Pro for $29

Secure checkout on Stripe.

  • CourseAll 120 ready lessons in order, plus every one we add. The first 10 are free. Each formula lesson ends with a second round on new data, no hints.
  • TestsYour score on the interview practice tests is free. Pro adds the full report: what went wrong on each task, and the lesson for it.
  • CertificatePass a timed test with 8 of 10 tasks right and get a certificate with its own page to verify it, and an Add to LinkedIn button. How it works
  • 14 daysNot what you hoped for? Full refund within 14 days, no questions. Refunds

Sign in or create an account

No password. Your solved challenges then follow you to any device.

Signing in sets one cookie that keeps you signed in. Privacy