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.
301 exercises0 completed
Keyboard shortcutsMove, select, find, format and fill without the mouse, with every key press checked in a real sheet.0/46Math & trigonometryAdd, round, multiply and calculate: SUM, ROUND, SUMIFS, MOD and more.0/57StatisticalAverages, counts, ranks, spreads and distributions: AVERAGE, COUNTIF, MEDIAN, STDEV.0/120LogicalMake decisions in formulas: IF, IFS, AND, OR, SWITCH, LET and LAMBDA.0/30Lookup & referenceFind and return data: XLOOKUP, VLOOKUP, INDEX/MATCH, FILTER, SORT, UNIQUE.0/59TextClean, split and join text: LEFT, MID, TRIM, TEXTJOIN, TEXTSPLIT, SUBSTITUTE.0/30Date & timeWork with dates and times: TODAY, EDATE, NETWORKDAYS, DATEDIF, WORKDAY.0/5All 521 functionsBrowse every Excel function with syntax, examples and a sheet to try it in.