Excel exercises at expert level

The functions your colleagues come to you for. Here it's about flexible lookups, bending text and dates to your will, formulas that return whole lists, and real-world tasks.

After Expert you're the person others come to for help.

★Earn your Expert certificate. All 19 Expert lessons, the Expert test and, to finish, the ultimate Excel test. See the certificate

See the module

19 lessons in this module

• INDEX with MATCH23 min · first exercises freeExpert
• 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
• 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
• DATEDIF18 min · first exercises freeExpert
• Working days and due dates19 min · first exercises freeExpert
• Calculating with times and hours21 min · first exercises freeExpert
• 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

Test yourself

• Test: ExpertTimer: 60 min🔒 Expert

BeginnerAdvanced