Learn Excel by doing
Short lessons where you type real formulas. A tip at every step, the result straight away, until you write them yourself.
Add two cells. Every formula in Excel starts with =.B2 and B3 are cell references: they point to the values in column B, rows 2 and 3. Add up the January revenue in B4.
learn by doing
No videos to sit through. You type the formula in a real little spreadsheet and see the answer the moment you press Enter.
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | January | $1,200 |
| 3 | February | $950 |
| 4 | March | $1,430 |
| 5 | Total |
a tip at every step
Stuck on what comes next? The tip tells you: the =, the function, the cells to select. The tips fade out as you get better.
excel in your language
Is your Excel in Dutch? Then SUM is SOM and formulas use a semicolon. We teach the names your own Excel uses: English and Dutch now, more on the way.
=SUM(B2:B4)=SOM(B2:B4)=IF(B2>100,"Yes","No")=ALS(B2>100;"Ja";"Nee")=VLOOKUP(E2,A2:C7,3,FALSE)=VERT.ZOEKEN(E2;A2:C7;3;ONWAAR)stay motivated
Short lessons of about ten minutes, your progress saved as you go and a green check for every formula you get right.
Lesson complete!
made for work
Totals, lookups and reports that take an hour by hand take one formula. And many employers test Excel before they hire.
Coming next
- 02Counting
- 03Averages and rounding
- 04Logic
- 05Catching errors
- 06Looking up
- 07INDEX and MATCH
Looking for one function?
No function found. Try another name.
Practise Excel online
Every exercise runs in your browser in a small spreadsheet. You don't need Excel installed, and you can practise on your phone too.
From your first formula to XLOOKUP
The lessons start with adding two cells and build up step by step: SUMIF, IF, VLOOKUP, INDEX and MATCH, text and dates, dynamic arrays and pivot tables.
Clear explanations for every function
Next to the lessons, every Excel function has its own page with the syntax, worked examples, common errors and how to fix them.