Lessons

One path, one lesson at a time. Each takes a few minutes and ends with hands-on practice, and the next one opens when you finish.

0 of 22 complete

Progress is kept in this browser. Create a free account to save it everywhere.

Start the course

Cells, values and your first formula

Find your way around the grid, type values, and write a formula that adds them up.

4 min 1/22

Arithmetic and order of operations

Multiply, divide and combine operators, and know which part Excel calculates first.

6 min 2/22

Add it up with SUM and AutoSum

Total a whole column with one function, and let AutoSum write it for you.

5 min 3/22

AVERAGE, MIN and MAX

Summarise a list with its typical, lowest and highest values.

5 min 4/22

Relative and absolute references ($)

Lock a reference with $ so it stays put when you fill a formula down.

7 min 5/22

COUNT, COUNTA and COUNTBLANK

Count how many cells hold numbers, anything at all, or nothing.

5 min 6/22

Keyboard shortcuts that save hours

Bold, format, jump, fill and undo without touching the mouse.

6 min 7/22

Make decisions with IF

Return one result when a condition is true and another when it’s false.

6 min 8/22

Combine conditions with AND and OR

Test several conditions at once inside an IF.

6 min 9/22

Grades with nested IF and IFS

Handle three or more outcomes by chaining conditions.

7 min 10/22

Count what matches with COUNTIF

Count only the cells that meet a condition, such as a status, a threshold or a pattern.

6 min 11/22

Total by category with SUMIF

Add or average only the rows that match. It’s the backbone of every summary table.

7 min 12/22

Several conditions with SUMIFS and COUNTIFS

Filter by region, product and month all at once.

7 min 13/22

Look things up with VLOOKUP

Pull a price, a name or a rate from a reference table by its ID.

8 min 14/22

INDEX and MATCH

The flexible lookup that can look left and survives inserted columns.

8 min 15/22

XLOOKUP, the modern lookup

One function that replaces VLOOKUP and INDEX/MATCH in Excel 2021 and Microsoft 365.

6 min 16/22

Clean up errors with IFERROR

Replace #N/A and #DIV/0! with something a reader understands.

5 min 17/22

Slice text with LEFT, RIGHT, MID and LEN

Pull codes, years and IDs out of longer strings.

7 min 18/22

Clean and join text

Fix messy names with TRIM and PROPER, then combine fields with & and TEXTJOIN.

6 min 19/22

ROUND, ROUNDUP and ROUNDDOWN

Change the actual value, not just how it looks.

5 min 20/22

Build a pivot-style summary

Recreate what a pivot table shows (totals, counts and averages by group) with live formulas.

9 min 21/22

Interview practice: the sales report

A timed, mixed test like the ones used in analyst interviews. Ten minutes on the clock.

10 min 22/22

Final exam

20 questions across every topic. Score 80% or more to unlock your verifiable certificate.

30 min How it works →