Exercise catalogue
Choose a category
Pick a topic, then a function. Each exercise opens a real spreadsheet: type the formula, check your answer, and get a hint if you’re stuck.
69 exercises0 completed
Math & trigonometryAdd, round, multiply and calculate: SUM, ROUND, SUMIFS, MOD and more.0/14StatisticalAverages, counts, ranks, spreads and distributions: AVERAGE, COUNTIF, MEDIAN, STDEV.0/30LogicalMake decisions in formulas: IF, IFS, AND, OR, SWITCH, LET and LAMBDA.0/15Lookup & referenceFind and return data: XLOOKUP, VLOOKUP, INDEX/MATCH, FILTER, SORT, UNIQUE.0/10All 521 functionsBrowse every Excel function with syntax, examples and a sheet to try it in.