Browse and take tests to sharpen your skills
INDEX and MATCH, XLOOKUP search modes, dynamic arrays, SUMPRODUCT and date conditions, data validation and cleanup, Power Query, and reports that survive new data.
Lookups with VLOOKUP and XLOOKUP, SUMIFS and COUNTIF, text and dates, conditional formatting, Excel tables, and pivot tables.
Formulas and cell references, copying formulas, common errors, sorting and filters, basic counting functions, and picking a chart.
Tell us which topic or difficulty level you need — no account required.