Learn Excel by doing

Short lessons where you type real formulas. A tip shows you every step and you see the result straight away, until you write them yourself.

Start lesson 1 Look up a function

Step 1 of 5Type = to start a formula

Step 2 of 5Type SUM( to open the function

Step 3 of 5Drag across B2:B4 to select the months

Step 4 of 5Type ) to close the function

Step 5 of 5Press Enter to see the result

Correct!

	A	B
1	Month	Sales
2	January	$1,200
3	February	$950
4	March	$1,430
5	Total

try it yourself

No videos to sit through. Type the formula in the little spreadsheet and press Enter: the tip shows you every step.

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.

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.

Illustration: a person at a desk, a spreadsheet flying off their screen, a clock showing time saved

01 Start with lesson 1Adding up+, SUM, SUMIF, SUMIFS 8 exercises Start lesson 1

Coming next

02Counting
03Averages and rounding
04Logic
05Catching errors
06Looking up
07INDEX and MATCH

See all lessons →

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.

learn Excel with Excel CSE

Start lesson 1

Illustration: our mascot cheering, with coins, a green check and a trophy around it