Excel lessons online, from beginner to expert
80 practical lessons in a real worksheet: formulas, sorting, filtering, charts and more. Without an account, you can try 3 lessons of your choice. With a free account, you can do the 8 free lessons as often as you like and the first exercises of every other lesson.
Every lesson starts with a short explanation. Then you try it yourself in a worksheet in your browser, with the English function names. If something's not right, you'll see straight away what went wrong. You don't need to install Excel.
- Beginner0 of 36 done
- Advanced0 of 27 done
- Expert0 of 21 done
On the way to your Beginner certificate. See the three certificates
90 results
Basics
Cells, your first formulas, references and the error messages everyone runs into.
- The worksheet: cells, rows and columnsFree
- Getting started with formulasFree
- Order of operations and bracketsFree
- The SUM functionBeginner
- MIN, MAX and AVERAGEBeginner
- Absolute and relative referencesBeginner
- Working with percentagesBeginner
- Understanding error messagesBeginner
- Working with several worksheetsBeginner
Keyboard shortcuts
Practise on your own keyboard until you no longer have to think about it.
Counting and adding with conditions
Count and add up only the rows you need.
Decisions
IF, AND and OR decide for you, and you catch error messages neatly.
Lookups
Let Excel fetch the right value from another table.
Cleaning up text
Turn messy exports into a list you can use.
Numbers
Round correctly, make a top 3 and spot outliers.
Dates
Work with ages, durations, working days and due dates.
Worksheets and formatting
Views, printing, formatting, names and tables: everything around your formulas.
- Freeze Panes and viewsBeginner
- Page setup and printingBeginner
- Formatting cellsBeginner
- Paste Special, inserting and deletingBeginner
- Importing and exporting dataAdvanced
- Cleaning up data with the ribbonAdvanced
- Named rangesAdvanced
- SEQUENCE, RANDBETWEEN and RANDARRAYAdvanced
- Excel tablesBeginner
- Formulas in Excel tablesAdvanced
- SparklinesAdvanced
- Editing chartsAdvanced
Summarising
Summarise long lists without typing a single formula.
Excel 365
Formulas that return a whole list instead of one cell.
Real-world tasks
Combine everything in tasks like the ones you get at work.
Tests per level
Timed and without hints, in a full or shorter version.
The ultimate Excel test
Everything you've learnt, in one test with a 90-minute timer.
Shortcuts test
Press the shortcuts in time, on your own keyboard.
MO-210 and MO-211 practice exams
Practise the parts of Microsoft's exams against the clock: MO-210 (Excel Associate) and MO-211 (Excel Expert).