Excel practice topics
Each topic guide explains what a family of Excel functions is for, what to watch out for, and lists hands-on exercises in a sensible order. Pick the one that matches what you want to get better at.
Topic guides
Excel IF Function Practice
Practise the Excel IF function with realistic exercises: simple IF, AND and OR conditions, IFS tiers and data checks, with instant feedback.
Excel Lookup Functions Practice: VLOOKUP, XLOOKUP, INDEX MATCH
Practise Excel lookups with realistic exercises: VLOOKUP, XLOOKUP, IFERROR for missing values, INDEX and MATCH, and banded lookups with XMATCH.
Excel SUMIF, COUNTIF and SUMIFS Practice
Practise conditional Excel formulas: SUMIF, COUNTIFS, AVERAGEIF, MAXIFS and SUMIFS with dates, using realistic data and instant feedback.
Excel Text Functions Practice: TRIM, LEFT, TEXT and More
Practise Excel text functions with realistic exercises: clean names with TRIM and PROPER, split codes and emails, format with TEXT, convert with VALUE.
Excel Percentage Formula Practice: Change, Discount and Margin
Practise Excel percentage formulas with realistic exercises: a discounted price, percent change, share of a total, rounding and profit margin.
Excel Data Analysis Practice: RANK, MEDIAN, SUMPRODUCT and More
Practise Excel analysis functions with realistic data: MEDIAN, LARGE and SMALL, RANK, SUMPRODUCT weighted averages, UNIQUE and FILTER.
Or follow a learning path by level
- Beginner: Excel Foundations: Cell references, totals, percentages, counting, rounding and your first IF formulas: everything you need before the harder tools.
- Intermediate: Conditions, Lookups and Text: Conditional sums and counts, lookups, tiers, error handling, text and dates: make a sheet answer questions on its own.
- Advanced: Lookups, Finance and Analysis: Two-way lookups, loans and investments, weighted figures and distinct counts: the formulas behind real business reports.