Excel practice exercises
Practise the formulas you use at work on real-looking data. Each page has an exercise to try straight away, marked the moment you press Check, and a link into the full lesson.
Core formulas
- Formula basics= + − × ÷, cell references · 4 exercises · free
- SUM, AVERAGE, MAX, MIN, COUNTSummarising a column · 7 exercises
- Absolute references ($)$G$1, $A2, B$1 and the F4 key · 4 exercises
- Percentages and ROUNDROUND, ROUNDUP, whole-group percentages · 6 exercises
- IFMaking a decision on every row · 4 exercises
- Grades with IFS and IFERRORNested IF, IFS, IFERROR · 4 exercises
- COUNTIF and COUNTIFSCounting rows that match · 4 exercises
- SUMIF and AVERAGEIFSUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS · 5 exercises
- VLOOKUPPulling information from another table · 4 exercises
- Bands and approximate matchVLOOKUP with TRUE, XLOOKUP match mode -1 · 4 exercises
- XLOOKUP and INDEX/MATCHModern lookups that can look left · 4 exercises
- Text functions&, LEFT, LOWER, PROPER, TRIM · 6 exercises
- Dates and deadlinesDate arithmetic, NETWORKDAYS, DATEDIF · 6 exercises
- Times and hours workedShift lengths, ×24, breaks, past midnight, [h]:mm · 5 exercises
- Criteria from cells, and wildcards">="&H1, "*"&H1&"*", "<>" · 5 exercises
- AND and ORCombining conditions · 4 exercises
- Ranking and top scoresRANK, LARGE, MAXIFS, finding the top scorer · 4 exercises
More functions
- INDEX and MATCH, one at a timeMATCH position, INDEX by number, two-way INDEX, MATCH bands · 4 exercises
- HLOOKUP: tables that run acrossHLOOKUP, row number, exact and approximate · 5 exercises
- Mean, median and modeMEDIAN, MODE, SMALL, leaving out the extremes · 5 exercises
- Searching text and wildcardsSEARCH, FIND, ISNUMBER(SEARCH()), ?, * in lookups · 5 exercises
- Matching codes with SWITCHSWITCH, a default result, WEEKDAY · 4 exercises
Office and admin
- Invoices and VATVAT to the penny, gross and net, due dates, days overdue · 5 exercises
- Budgets and spend to dateRunning totals, variance, % spent, projections · 5 exercises · free
- Stock and orderingStock value, reorder flags, whole packs, SUMIF, weeks left · 5 exercises
- Rotas and timesheetsWeekly hours, shift counts, overtime, pay, late starts · 5 exercises
Tidy and analyse
Schools and colleges
- Attendance bandsPersistent absence, bands, PA by year group, sessions to recover · 5 exercises
- Mark sheets and grade boundariesTotals, grades from boundaries, % at grade 7+, marks to the next grade · 5 exercises · free
- Target vs actual and residualsResiduals, above or below target, class averages, the PP gap · 5 exercises
- Set lists and rankingPosition in class, sets from ranks, top 3, set averages, moves · 5 exercises
- Trip payments and balancesPaid so far, balances, payment status, subsidies, refunds · 5 exercises
HR and people
- Absence recordsNETWORKDAYS, spells and days per person, Bradford Factor from a log, lost time rate · 5 exercises
- Holiday entitlementStatutory holiday, joiners, pro-rata, holiday left, carry-over · 5 exercises
- Service and key datesEDATE, DATEDIF "YM", anniversaries, notice periods, counting with & · 5 exercises
- Pay gapAVERAGEIF, MEDIAN with FILTER, QUARTILE, COUNTIFS · 5 exercises
- Turnover and headcountCOUNTIFS between dates, headcount on a date, turnover rate, EOMONTH · 5 exercises
- Pay scalesPay points, part-time pay, increments, pay bands, pay rises · 5 exercises
Every lesson is listed on the lessons page. Looking for how a function works first? Read the function guides.