Excel exercises online

No files to download and no answer sheet to check your work against. You work in your browser, and every attempt is checked and explained straight away.

Choose your module

All 80 practice lessons

You can try 3 lessons straight away, without an account. With a free account, you can do the 8 free lessons as often as you like and the first exercises of the other 72; the full lessons are in the modules.

• The worksheet: cells, rows and columnsBeginner, 13 minFree
• Getting started with formulasBeginner, 14 minFree
• Order of operations and bracketsBeginner, 14 minFree
• Cut, copy, paste and undoBeginner, 6 minFree
• COUNT and COUNTABeginner, 15 minFree
• Comparing: TRUE or FALSEBeginner, 15 minFree
• Sorting dataBeginner, 13 minFree
• Filtering dataBeginner, 14 minFree
• The SUM function14 min · first exercises freeBeginner
• MIN, MAX and AVERAGE14 min · first exercises freeBeginner
• Absolute and relative references19 min · first exercises freeBeginner
• Working with percentages18 min · first exercises freeBeginner
• Understanding error messages16 min · first exercises freeBeginner
• Working with several worksheets16 min · first exercises freeBeginner
• Moving around quickly with the keyboard8 min · first exercises freeBeginner
• Formatting with shortcuts7 min · first exercises freeBeginner
• Selecting with the keyboard8 min · first exercises freeBeginner
• Shortcuts for formulas8 min · first exercises freeBeginner
• Counting with COUNTIF17 min · first exercises freeBeginner
• Counting with COUNTIFS18 min · first exercises freeAdvanced
• Adding up with SUMIF19 min · first exercises freeBeginner
• Adding up with SUMIFS20 min · first exercises freeAdvanced
• Wildcards: * and ?15 min · first exercises freeAdvanced
• AVERAGEIF and MAXIFS18 min · first exercises freeAdvanced
• The IF function20 min · first exercises freeBeginner
• Catching errors with IFERROR17 min · first exercises freeAdvanced
• IFS20 min · first exercises freeAdvanced
• AND, OR and NOT19 min · first exercises freeAdvanced
• Looking up with VLOOKUP22 min · first exercises freeBeginner
• VLOOKUP with an approximate match18 min · first exercises freeAdvanced
• Looking up in a row with HLOOKUP17 min · first exercises freeAdvanced
• Looking up with XLOOKUP19 min · first exercises freeAdvanced
• INDEX with MATCH23 min · first exercises freeExpert
• UPPER, LOWER and PROPER16 min · first exercises freeBeginner
• LEFT, RIGHT and MID19 min · first exercises freeAdvanced
• LEN and TRIM16 min · first exercises freeAdvanced
• Joining text16 min · first exercises freeBeginner
• SEARCH and FIND18 min · first exercises freeExpert
• SUBSTITUTE and REPLACE17 min · first exercises freeExpert
• TEXTBEFORE and TEXTAFTER16 min · first exercises freeExpert
• The TEXT function17 min · first exercises freeExpert
• ROUND, ROUNDUP and ROUNDDOWN18 min · first exercises freeBeginner
• LARGE, SMALL and RANK.EQ17 min · first exercises freeAdvanced
• MEDIAN and MODE16 min · first exercises freeAdvanced
• Rounding to a multiple17 min · first exercises freeExpert
• MOD and INT16 min · first exercises freeExpert
• Borrowing and saving with PMT, PV, FV and NPER19 min · first exercises freeExpert
• Calculating with dates14 min · first exercises freeBeginner
• TODAY and DATE16 min · first exercises freeBeginner
• YEAR, MONTH, DAY and WEEKDAY16 min · first exercises freeAdvanced
• DATEDIF18 min · first exercises freeExpert
• Working days and due dates19 min · first exercises freeExpert
• Calculating with times and hours21 min · first exercises freeExpert
• Freeze Panes and views14 min · first exercises freeBeginner
• Page setup and printing15 min · first exercises freeBeginner
• Formatting cells15 min · first exercises freeBeginner
• Paste Special, inserting and deleting13 min · first exercises freeBeginner
• Importing and exporting data17 min · first exercises freeAdvanced
• Cleaning up data with the ribbon15 min · first exercises freeAdvanced
• Named ranges17 min · first exercises freeAdvanced
• SEQUENCE, RANDBETWEEN and RANDARRAY16 min · first exercises freeAdvanced
• Excel tables17 min · first exercises freeBeginner
• Formulas in Excel tables17 min · first exercises freeAdvanced
• Sparklines11 min · first exercises freeAdvanced
• Editing charts17 min · first exercises freeAdvanced
• Creating a chart12 min · first exercises freeBeginner
• Sorting by several columns12 min · first exercises freeBeginner
• The SUBTOTAL function16 min · first exercises freeAdvanced
• Choosing the right chart13 min · first exercises freeAdvanced
• PivotTables17 min · first exercises freeBeginner
• Conditional formatting16 min · first exercises freeAdvanced
• Drop-down lists with data validation11 min · first exercises freeAdvanced
• The UNIQUE function15 min · first exercises freeExpert
• The SORT function17 min · first exercises freeExpert
• The FILTER function18 min · first exercises freeExpert
• The SUMPRODUCT function18 min · first exercises freeExpert
• Excel 365 for advanced users25 min · first exercises freeExpert
• In practice: a summary per group22 min · first exercises freeExpert
• In practice: an order form22 min · first exercises freeExpert
• In practice: cleaning up data22 min · first exercises freeExpert