Excel exercises for advanced users

You know the basics and want to go further. Here you work with several conditions, look things up with XLOOKUP and HLOOKUP, catch errors and make your data tidy and clear.

After Advanced you combine functions without having to look them up, clean up data and build summaries others understand straight away.

★Earn your Advanced certificate. All 26 Advanced lessons, and passing the Advanced test. See the certificate

See the module

26 lessons in this module

• Counting with COUNTIFS18 min · first exercises freeAdvanced
• Adding up with SUMIFS20 min · first exercises freeAdvanced
• Wildcards: * and ?15 min · first exercises freeAdvanced
• AVERAGEIF and MAXIFS18 min · first exercises freeAdvanced
• Catching errors with IFERROR17 min · first exercises freeAdvanced
• IFS20 min · first exercises freeAdvanced
• AND, OR and NOT19 min · first exercises freeAdvanced
• 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
• LEFT, RIGHT and MID19 min · first exercises freeAdvanced
• LEN and TRIM16 min · first exercises freeAdvanced
• LARGE, SMALL and RANK.EQ17 min · first exercises freeAdvanced
• MEDIAN and MODE16 min · first exercises freeAdvanced
• YEAR, MONTH, DAY and WEEKDAY16 min · first exercises freeAdvanced
• 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
• Formulas in Excel tables17 min · first exercises freeAdvanced
• Sparklines11 min · first exercises freeAdvanced
• Editing charts17 min · first exercises freeAdvanced
• The SUBTOTAL function16 min · first exercises freeAdvanced
• Choosing the right chart13 min · first exercises freeAdvanced
• Conditional formatting16 min · first exercises freeAdvanced
• Drop-down lists with data validation11 min · first exercises freeAdvanced

Test yourself

• Test: AdvancedTimer: 45 min🔒 Advanced

BeginnerExpert