Learn · Practice notebook

Learn Excel by doing

Free Excel exercises in short lessons, with a spreadsheet in your browser. Every answer is checked instantly, and when it's wrong you see exactly why.

TOPIC 01 14 of 14 ready

Start here: Excel basics

Never used Excel? Start with cells, your first formula and adding things up.

TOPIC 02 5 of 5 ready

Keyboard and navigation

Move, select and fill without the mouse.

TOPIC 03 6 of 6 ready

Logic

Make formulas decide: pass or fail, bonus or not.

TOPIC 04 10 of 10 ready

Counting and totals

Count and add up only the rows that match.

TOPIC 05 7 of 7 ready

Statistics and rounding

Middle values, top 3s, and rounding the way you need.

TOPIC 06 9 of 9 ready

Text

Clean, split and join text so it is ready to use.

TOPIC 07 16 of 16 ready

Lookups

Find a value in one table and bring back the matching details.

TOPIC 08 5 of 5 ready

Dynamic arrays

One formula that fills a whole range: filter, sort and reshape.

TOPIC 09 6 of 6 ready

Dates

Work out ages, deadlines and month ends.

TOPIC 10 2 of 2 ready

Formatting

Make numbers readable and let colour point out what matters.

TOPIC 11 4 of 4 ready

Tables, sorting and PivotTables

Organise a list, then summarise it in a few clicks.

TOPIC 12 2 of 2 ready

Charts and controls

Turn a table into a chart, and give a sheet dropdowns and tick boxes.

Know someone fighting with a spreadsheet? Send them this page.