learningxlsx
Score0

Arrow keys move between cells. Type a value or a formula, then press Enter. Escape cancels typing; with nothing typed, it moves to the lesson card. F6 moves between the grid, the lesson card, the sheet tabs and the buttons at the top. F1 says the step again; on a step with a hint, press it twice to show the hint.

Learn Excel by typing it

learningxlsx is ten Excel lessons played on a real spreadsheet grid, right here in the browser. You type the formula, press Enter, and the sheet answers; every lesson can be played again with new numbers in a new setting.

Free. No account. Progress stays in this browser.

The ten lessons

  1. 1
    Totals: SUM formulaAdd up a column, then find the average, the highest, the lowest and the count.
  2. 2
    Copying: absolute referenceCopy a formula down a column, then lock one cell with $ so it stays put.
  3. 3
    Percentages: percentage formulaWork out percentage change, then plan next year with a growth rate.
  4. 4
    Keyboard: Excel shortcutsWrite, copy and total a sheet without touching the mouse. Needs a keyboard.
  5. 5
    Decisions: IF functionLet the sheet decide: IF for one condition, AND when both must hold.
  6. 6
    Conditions: SUMIF and COUNTIFTotals and counts that only include the rows you ask for.
  7. 7
    Lookups: VLOOKUPFind a code in a table and bring back its row, with VLOOKUP and XLOOKUP.
  8. 8
    Text: text functionsJoin first and last names, clean up stray spaces and capitals, split an email.
  9. 9
    Lists: remove duplicatesKeep each value once with UNIQUE, then filter and sort, all with formulas.
  10. 10
    Month end: month-end reportThe final sheet: a real report asked in plain words, no formulas shown.

Each one takes a few minutes. Every answer is worked out by the same formula engine that checks yours, so the numbers on the page and on the sheet always agree.

Daily and Rush

Daily is one sheet a day, the same for everyone. You solve it from memory, or with the formulas shown if the lesson it comes from is new to you, and you can share the result without giving the answers away.

Rush gives you single steps from the lessons you have cleared, one after another, for three minutes, and ends early after three misses.