Choose your character

It shows in the top bar and on your profile. Change it any time.

Courses / Data and analytics tools

Excel

Practice formulas, lookups and shortcuts in a spreadsheet that works like the real one.

Start lesson 1Practice interviewTake the assessmentPractice the first unit of every course. No account needed.
161lessons
889checked exercises
25projects, cases and exams
Prepares you for Excel assessments, MO-200

Projects, case studies and mock exams

Project · IntermediateMonthly sales report

Turn a raw order list into the monthly report a sales manager asks for, one formula at a time.

8 steps · 25 minProject · IntermediateWeekly timesheet and overtime pay

Work out regular and overtime hours, look up pay rates and total a week of payroll.

8 steps · 20 minCase study · IntermediateCarrier on-time performance

Compare three carriers on on-time rate and lateness, and name the most reliable one.

7 steps · 18 minProject · IntermediateA grade book

Turn a table of quiz and exam scores into averages, letter grades, ranks and a class summary.

7 steps · 18 minProject · IntermediateBudget versus actual

Compare a department's spending with its budget, flag the overspends and name the biggest one.

8 steps · 16 minCase study · IntermediateReturns by marketing channel

Work out the standard marketing metrics for twelve campaigns and find the channel with the best return.

7 steps · 18 minCase study · AdvancedA rental property portfolio

Rank eight rental properties by cap rate and cash flow, and find the one to review first.

8 steps · 25 minCase study · AdvancedClinic no-shows

Find which clinic and which weekday lose the most appointments to no-shows.

7 steps · 20 minCase study · AdvancedStaff turnover

Work out who left, how long people stayed and which department loses the most staff.

7 steps · 20 minProject · AdvancedA stock reorder sheet

Work out which café supplies to reorder, how much, and from whom, with a list that updates itself.

7 steps · 20 minCase study · AdvancedA pricing decision

Compare three contract options for Linden Printworks.

6 steps · 18 minCase study · AdvancedA staffing schedule

Compare fictional training schedules for the Westhaven simulation ward.

6 steps · 18 minCase study · AdvancedWhich store to expand

Compare four fictional locations for Fern Retail.

6 steps · 18 minProject · AdvancedA loan comparison calculator

Build a borrowing comparison for Quarry Workshop.

6 steps · 18 minProject · AdvancedClean an HR export

Prepare a clean staffing list for Solace Field Services.

6 steps · 18 minProject · ExpertA sales dashboard

Build an operational dashboard for North Pier Supplies.

7 steps · 22 minProject · ExpertA dependency schedule

Plan a fictional archive migration for Orchard Studio.

15 steps · 46 minCase study · ExpertSubscriber retention

Compare fictional subscription cohorts for Larch Learning.

6 steps · 18 minMock exam · ExpertCore skills (MO-200 style)

Ten timed tasks in the style of the Excel Associate exam: views, sorting, filtering, names, number formats and formulas.

10 questions · 25 minMock exam · ExpertMO-200 style task set 2

Complete twelve timed original tasks on a fictional support workbook.

12 questions · 30 minMock exam · ExpertAdvanced formulas (MO-201 style)

Eight timed tasks in the style of the Excel Expert exam: XLOOKUP, SUMIFS, IFS, FILTER, SORT and UNIQUE, LET and PMT.

8 questions · 22 minMock exam · ExpertMO-201 style task set 2

Complete twelve timed original tasks on a fictional support workbook.

12 questions · 30 min

Each lesson teaches one skill and gives you three to five exercises in a working spreadsheet with the ribbon, formula bar and shortcuts you'll use at work. The first exercise walks you through the steps; the next ones take the steps away, change the data and end with a task like the ones in job tests and real reports. Any correct formula counts, and a wrong one gets a message about what probably went wrong. You'll start with formulas and SUM, then work through IF, SUMIF and COUNTIF, VLOOKUP, XLOOKUP, INDEX and MATCH, absolute references and the shortcuts that save the most time.

Projects that use Excel

Work one company brief through several tools. Your Excel stage reads the tables from the stage before.

Project · Northstar Furnishings · OutlineProfit on paper, cash under pressureExcel → Power BI · 1 hr 40 min
See all projects

Interview practice

Explain what you've learned in a full-screen interview. Speak or type, then review your answers against the rubric for your level.

Interview loops by job

Beginner

FreeNo account or card needed. Every lesson in this unit is yours to practice.

Formula basics

Enter data, write formulas, add up and average ranges, count, and fix totals that come out wrong.

7 lessons
1Cells, data types and editingType numbers, text and dates so Excel reads them correctly, and spot numbers that were stored as text.5 exercises · 6 minFree
2Formulas and cell referencesStart a formula with =, point at cells instead of typing numbers, and let Excel do the math.4 exercises · 6 minFree
3SUM and AutoSumAdd up a range with SUM, or let AutoSum write the formula for you.4 exercises · 6 minFree
4AVERAGE, MIN and MAXFind the average, the smallest and the largest value in a range.5 exercises · 7 minFree
5COUNT, COUNTA and COUNTBLANKCount the numbers, the filled cells or the empty cells in a range.4 exercises · 6 minFree
6Fixing wrong SUM totalsFind why a total is off: numbers stored as text, a range that stops early, a subtotal counted twice.5 exercises · 8 minFree
Practice setSUM, AVERAGE and COUNTTen quick questions about an invoice list, mixing SUM, AVERAGE, MIN, MAX, COUNT, COUNTA and COUNTBLANK.Free

Keyboard essentials

Move, select, copy and paste with the keyboard instead of the mouse.

4 lessons
8Move around with the keyboardJump to the edges of your data, the top of the sheet and the last used cell without scrolling.5 exercises · 6 minWith a plan
9Select with the keyboardSelect cells, columns of data, whole tables and rows without dragging the mouse.5 exercises · 6 minWith a plan
10Cut, copy and pasteCopy formulas so their references follow, paste into a whole range at once, and move cells with cut.5 exercises · 7 minWith a plan
Practice setGetting aroundEight keyboard drills on a new inventory sheet: jump, select, and get back to the top.With a plan

Copying formulas and references

Fill formulas and series, lock references with $, and work across sheets.

7 lessons
12Copy formulas with the fill handleWrite a formula once and copy it down a column or across a row, with references that adjust.4 exercises · 7 minWith a plan
13Fill series: numbers, dates and monthsLet the fill handle continue a pattern: months, weekdays, numbered labels, steps and dates.5 exercises · 6 minWith a plan
14Edit and format fasterEdit a cell in place, fill down, bold, format as currency and use ribbon key tips.5 exercises · 7 minWith a plan
15Absolute references with $ and F4Lock a reference with $ so it stays put when you copy the formula.4 exercises · 9 minWith a plan
16Mixed referencesLock only the row or only the column, so one formula fills a whole table.3 exercises · 8 minWith a plan
17Worksheets and references to other sheetsUse several sheets in one workbook: point at another sheet, add up across sheets and freeze headers.5 exercises · 8 minWith a plan
Practice setReferencesEight formulas on a price quote that only fill correctly with the right $ signs.With a plan

Formatting

Number formats, bold and shaded headers, borders, alignment and wrapped text.

5 lessons
19Number formatsShow numbers as currency, percentages, dates and with the right number of decimals, without changing the values.5 exercises · 7 minWith a plan
20Fonts, fills, borders and alignmentMake a table readable: bold and shaded headers, centered labels, colored text and borders.5 exercises · 7 minWith a plan
21The Format Cells dialog and custom formatsUse Ctrl+1 for exact number formats: negatives in brackets, thousands, multiples like 9.6x, leading zeros and custom dates.5 exercises · 9 minWith a plan
22Merge, wrap text, row height and column widthCenter a title over a table, wrap long headers, set exact row heights and column widths, and hide helper rows.6 exercises · 8 minWith a plan
Practice setFormatting a reportEight steps that turn a raw quarterly report into one you could send: formats, emphasis, borders and wrapping.With a plan

Logic with IF

Comparisons, IF, AND, OR, XOR, NOT, IFS, SWITCH and the IS functions.

8 lessons
24Comparisons: TRUE and FALSECompare two values with =, <>, >, <, >= and <= and get TRUE or FALSE back.4 exercises · 6 minWith a plan
25IF: choose between two resultsTest a condition and show one result when it's true and another when it's false.4 exercises · 8 minWith a plan
26AND and OR inside IFCombine several conditions: all must be true with AND, any can be true with OR.4 exercises · 8 minWith a plan
27XOR and NOTReverse a test with NOT, and check that exactly one of two conditions holds with XOR.4 exercises · 6 minWith a plan
28IFS and nested IFPick from three or more results, such as grade bands or commission tiers.4 exercises · 9 minWith a plan
29SWITCHTurn codes into labels by matching a value against a list, with a default for anything else.4 exercises · 6 minWith a plan
30IS functions: ISBLANK, ISNUMBER, ISTEXT and ISERRORTest what a cell holds: empty, a number, text or an error.4 exercises · 7 minWith a plan
Practice setLogicTen loan-application checks that mix IF, AND, OR, NOT, XOR, IFS, SWITCH and the IS functions.With a plan

Intermediate

Conditional totals, math and statistics

Round, rank and summarize values, then count and total the rows that match.

14 lessons
32ROUND, ROUNDUP and ROUNDDOWNRound the stored value, not only what the cell shows: to cents, to whole numbers, or to the nearest hundred.5 exercises · 7 minWith a plan
33FLOOR, CEILING and MROUNDRound to a multiple: up to the next case of 12, down to a quarter hour, to the nearest $5.4 exercises · 6 minWith a plan
34LARGE, SMALL and RANKFind the 2nd highest or 3rd lowest value, build a top 3, and rank values with ties.4 exercises · 7 minWith a plan
35MEDIAN and MODEFind the middle value, which outliers don't pull around, and the most common value.4 exercises · 6 minWith a plan
36ODD, EVEN and MODRound up to an odd or even number, and use the remainder of a division for every Nth row and leftovers.4 exercises · 6 minWith a plan
37SUMPRODUCTMultiply ranges row by row and add the results: totals of quantity times price, weighted averages and conditional sums.4 exercises · 7 minWith a plan
39COUNTIF: count what matchesCount the cells that meet a condition, like tickets marked Closed or orders over $250.4 exercises · 8 minWith a plan
40SUMIF: add up what matchesTotal only the rows that meet a condition, like the sales for one region.4 exercises · 8 minWith a plan
41Wildcards in SUMIF, COUNTIF and XLOOKUPMatch text that starts with, ends with or contains something, using * and ? in criteria.5 exercises · 8 minWith a plan
42SUMIFS and COUNTIFS: several conditionsAdd up or count the rows that meet two or more conditions at once.4 exercises · 9 minWith a plan
43AVERAGEIF(S), MAXIFS and MINIFSAverage, find the largest or find the smallest value among the rows that meet your conditions.4 exercises · 7 minWith a plan
Practice setMath and statisticsTen questions about a running club's results, mixing rounding, ranking, statistics and SUMPRODUCT.With a plan
Practice setCOUNTIF and friendsEight counts from a support ticket log: text, numbers, not-equal, blanks and two conditions.With a plan
Practice setSUMIF and SUMIFSTen totals from an expense ledger: text, cell, date, not-equal and wildcard criteria, one or several conditions.With a plan

Lookups

Find values in tables with VLOOKUP, HLOOKUP, XLOOKUP, and INDEX with MATCH.

8 lessons
46VLOOKUP: exact matchFind a value in the first column of a table and return something from the same row.4 exercises · 9 minWith a plan
47VLOOKUP approximate match: tiers and bandsLook up a rate, grade or price band for a value that falls between the thresholds in a table.4 exercises · 8 minWith a plan
48HLOOKUPLook up a value in the top row of a table and return a value from a row below it.4 exercises · 6 minWith a plan
49XLOOKUPLook up a value in one column and return the match from another, in any direction.4 exercises · 9 minWith a plan
50XLOOKUP: match modes, last match and not foundUse XLOOKUP's optional arguments: search from the end for the latest entry, find the next size up, and set what shows when nothing matches.4 exercises · 8 minWith a plan
51INDEX and MATCHFind a position with MATCH and fetch the value at that position with INDEX.4 exercises · 10 minWith a plan
52IFERROR, IFNA and fixing lookups that failReplace #N/A with a clear message, and fix the usual causes: extra spaces and numbers stored as text.4 exercises · 8 minWith a plan
Practice setLookupsTwelve lookups on an order sheet: exact and approximate matches, looking left, two-way, last match and not found.With a plan

Text

Take text apart, tidy it and put it back together: LEFT, MID, FIND, SUBSTITUTE, TRIM, TEXTJOIN and TEXT.

9 lessons
54LEN, LEFT and RIGHTCount characters and take a fixed number of them from the start or end of a text.5 exercises · 7 minWith a plan
55MIDTake characters from the middle of a text, by start position and length.4 exercises · 6 minWith a plan
56FIND and SEARCHFind where a character or word sits in a text, and use that position to cut text at the right place.5 exercises · 8 minWith a plan
57SUBSTITUTE and REPLACESwap one piece of text for another: by what it says with SUBSTITUTE, or by position with REPLACE.4 exercises · 6 minWith a plan
58TRIM, CLEAN, UPPER, LOWER and PROPERTidy text from exports: remove extra spaces and hidden characters, and fix capitalization.5 exercises · 7 minWith a plan
59Joining text: &, CONCAT and TEXTJOINCombine text from several cells into one, with spaces, commas or any separator.4 exercises · 7 minWith a plan
60TEXTBEFORE, TEXTAFTER and TEXTSPLITCut text at a delimiter without counting positions, and split it into columns.4 exercises · 7 minWith a plan
61TEXT: numbers and dates as textTurn numbers and dates into text with a format: month names, percentages, currency and padded IDs.4 exercises · 6 minWith a plan
Practice setText functionsTen clean-up and extraction tasks on a messy contact list.With a plan

Dates

Build, take apart and calculate with dates: days, working days, months, weekdays and today.

7 lessons
63Dates as numbers: DATE, YEAR, MONTH and DAYBuild dates from parts, take them apart, and do arithmetic with them.5 exercises · 8 minWith a plan
64TODAY and NOWWork with today's date: days until a deadline, overdue flags and ages that stay current.4 exercises · 6 minWith a plan
65DAYS and DATEDIFCount days, whole months and whole years between two dates.4 exercises · 8 minWith a plan
66EOMONTH and EDATEJump a number of months forward or back, or to the last day of a month.4 exercises · 6 minWith a plan
67NETWORKDAYS and WORKDAYCount working days between dates and find the date a number of working days away, skipping weekends and holidays.4 exercises · 7 minWith a plan
68WEEKDAY, WEEKNUM and day namesFind the day of the week and the week number of a date, and show day names with TEXT.4 exercises · 6 minWith a plan
Practice setDatesTen questions about a project plan: durations, working days, months, weekdays, deadlines and slippage.With a plan

Lists and Excel tables

Sort, filter, validate and clean lists, then build expanding tables with structured references.

7 lessons
70Sort dataSort a table by one column or several, A to Z or largest first, without breaking its rows apart.5 exercises · 7 minWith a plan
71Filter rowsShow only the rows you need with the filter arrows, and total what's visible with SUBTOTAL.5 exercises · 8 minWith a plan
72Remove duplicatesDelete repeated rows from a list, matching on every column or only the ones that identify a row.4 exercises · 6 minWith a plan
73Data validation: drop-downs and limitsStop wrong entries before they happen: drop-down lists, number and date limits, and your own error messages.5 exercises · 8 minWith a plan
74Excel tablesCreate tables, name their columns, and keep totals linked to the data.5 exercises · 9 minWith a plan
75Table and data shortcutsChoose the data range quickly and build reports without reaching for every ribbon tab.4 exercises · 7 minWith a plan
Practice setTablesBuild and adjust named tables on fresh purchasing records.With a plan

Visual reporting

Apply conditional formatting and build linked charts, sparklines and Gantt views.

11 lessons
77Highlight cells rulesColor cells automatically when they pass a test: greater than, between, text that contains, duplicates.5 exercises · 8 minWith a plan
78Data bars and color scalesShow the size of every number at a glance with in-cell bars and graded colors.4 exercises · 6 minWith a plan
79Rules with formulasHighlight whole rows, or cells that pass a test on another column, with a formula rule.4 exercises · 9 minWith a plan
81Column and bar chartsCompare categories with clustered bars and show composition with stacked bars.5 exercises · 10 minWith a plan
82Line charts and scatter plotsPlot ordered trends, show individual observations, and distinguish numeric scatter axes.4 exercises · 9 minWith a plan
83Pie, doughnut and combo chartsShow parts of one whole and plot measurements with different units on separate axes.5 exercises · 12 minWith a plan
84Chart titles, axes, labels and dataMake a chart readable and repair the data ranges behind it.5 exercises · 11 minWith a plan
85SparklinesAdd small row-level trends without taking space from the worksheet.4 exercises · 9 minWith a plan
86A Gantt chart from a task listBuild a schedule with a stacked bar chart and a hidden start-offset series.4 exercises · 11 minWith a plan
Practice setConditional formattingEight rules on a store report: thresholds, text, top items, bars, scales and formulas.With a plan
Practice setChartsChoose and finish charts for fresh comparisons, trends, rates, and schedules.With a plan

Projects: everyday reports

Build complete reports from raw lists, one step at a time: sales, payroll, deliveries, grades, budgets and campaigns.

7 lessons
ProjectMonthly sales reportTurn a raw order list into the monthly report a sales manager asks for, one formula at a time.With a plan
ProjectWeekly timesheet and overtime payWork out regular and overtime hours, look up pay rates and total a week of payroll.With a plan
Case studyCarrier on-time performanceCompare three carriers on on-time rate and lateness, and name the most reliable one.With a plan
ProjectA grade bookTurn a table of quiz and exam scores into averages, letter grades, ranks and a class summary.With a plan
ProjectBudget versus actualCompare a department's spending with its budget, flag the overspends and name the biggest one.With a plan
Case studyReturns by marketing channelWork out the standard marketing metrics for twelve campaigns and find the channel with the best return.With a plan
Practice setEveryday reportsReview counts, totals, exact matches and report decisions on a fresh support export.With a plan

PivotTables

Summarize lists, change value calculations, group and filter fields, and build calculated fields.

5 lessons
95PivotTable basicsTurn rows of sales records into grouped reports with Rows, Columns and Values.5 exercises · 10 minWith a plan
96PivotTable value calculationsChoose summary functions, percentages, running totals and ranks.6 exercises · 12 minWith a plan
97Group and filter PivotTablesGroup dates or numbers and select the records that belong in a report.6 exercises · 12 minWith a plan
98Calculated fields and report layoutAdd calculated measures, choose a report layout and retrieve results with GETPIVOTDATA.5 exercises · 11 minWith a plan
Practice setPivotTablesBuild sales summaries, filter the report and choose calculations on fresh records.With a plan

Advanced

Dynamic arrays and named formulas

Build spilling results, name ranges and calculations, and write reusable functions.

9 lessons
100UNIQUEList each value once, count distinct values, and find the ones that appear only once.5 exercises · 7 minWith a plan
101FILTERReturn the rows that meet one or more conditions, and say what to show when none do.5 exercises · 8 minWith a plan
102SORT and SORTBYSort with a formula that stays sorted, by any column, including one you don't return.4 exercises · 7 minWith a plan
103SEQUENCE and spill references (#)Generate number lists and grids, and point other formulas at a whole spilled range with #.4 exercises · 7 minWith a plan
104Named rangesGive a cell or range a name in the Name Box and use the name in formulas instead of an address.5 exercises · 7 minWith a plan
105LETName the parts of a long formula inside it, so it reads clearly and calculates each part once.4 exercises · 7 minWith a plan
106LAMBDA and named functionsWrite your own function with LAMBDA, try it in a cell, and use one that has been saved under a name.4 exercises · 7 minWith a plan
107MAP, BYROW, REDUCE and SCANApply a LAMBDA to every value, every row, or as a running total, with one spilling formula.4 exercises · 8 minWith a plan
Practice setDynamic arraysEight one-cell reports on an order list: lists, filters, rankings and totals that spill.With a plan

Financial models and What-If analysis

Calculate loans and returns, then compare scenarios and test changing inputs.

10 lessons
109PMT: loan paymentsWork out the regular payment on a loan or the deposit for a savings goal, with the rate and periods in step.5 exercises · 8 minWith a plan
110FV, PV, NPER and RATESolve for the missing piece: what savings grow to, what you can borrow, how long it takes, and the rate.5 exercises · 8 minWith a plan
111NPV and IRRDiscount a project's cash flows to their present value, find its rate of return, and avoid NPV's year-0 trap.5 exercises · 8 minWith a plan
112XNPV and XIRRValue cash flows that arrive on specific, uneven dates.4 exercises · 6 minWith a plan
113Amortization schedule with IPMT and PPMTSplit each loan payment into interest and principal, track the balance, and total the interest.4 exercises · 9 minWith a plan
114Scenario switches with CHOOSE and INDEXFlip a whole model between low, base and high cases from one input cell.4 exercises · 7 minWith a plan
115Goal SeekWork backwards from the answer you need: the price that hits a margin, the loan that fits a payment.4 exercises · 7 minWith a plan
116Data tables for sensitivity analysisSubstitute one or two assumptions into a model and compare the calculated results.4 exercises · 10 minWith a plan
117A sensitivity grid with mixed referencesShow how a result changes across two inputs at once, with one formula and mixed references.4 exercises · 7 minWith a plan
Practice setFinancial functionsEight questions about buying a delivery van: the loan, the alternatives and whether the contract pays.With a plan

Data preparation, cases and auditing

Prepare repeatable imports, build decision models, inspect formulas and protect workbooks.

19 lessons
119Flash Fill from examplesExtract names, change case and build labels from examples.4 exercises · 9 minWith a plan
120Text to ColumnsSplit delimited imports without losing empty fields or the original data.4 exercises · 9 minWith a plan
121Fix numbers and dates stored as textTurn imported text like "$1,240.50", "2026-03-02" and "120-" into numbers and dates Excel can calculate with.5 exercises · 8 minWith a plan
122Clean data with Power QueryImport a file, set data types, clean text and load the resulting table into the workbook.4 exercises · 12 minWith a plan
123Merge and append queriesMatch lookup rows with a merge, expand the needed fields and append compatible batches.4 exercises · 13 minWith a plan
133Trace formula relationshipsFollow formula inputs and outputs with auditing arrows and locate worksheet errors.4 exercises · 9 minWith a plan
134Evaluate formulas step by stepReplace references with their values and inspect a calculation before accepting its result.4 exercises · 8 minWith a plan
135Protect sheets and workbook structureLeave input cells editable while protecting formulas and worksheet structure.4 exercises · 10 minWith a plan
136Find and resolve circular referencesRemove accidental circular formulas and configure iteration only for deliberate feedback models.4 exercises · 9 minWith a plan
Case studyA rental property portfolioRank eight rental properties by cap rate and cash flow, and find the one to review first.With a plan
Case studyClinic no-showsFind which clinic and which weekday lose the most appointments to no-shows.With a plan
Case studyStaff turnoverWork out who left, how long people stayed and which department loses the most staff.With a plan
ProjectA stock reorder sheetWork out which café supplies to reorder, how much, and from whom, with a list that updates itself.With a plan
Case studyA pricing decisionCompare three contract options for Linden Printworks.With a plan
Case studyA staffing scheduleCompare fictional training schedules for the Westhaven simulation ward.With a plan
Case studyWhich store to expandCompare four fictional locations for Fern Retail.With a plan
ProjectA loan comparison calculatorBuild a borrowing comparison for Quarry Workshop.With a plan
ProjectClean an HR exportPrepare a clean staffing list for Solace Field Services.With a plan
Practice setData preparation and auditClean and load a query, inspect formulas, protect inputs and check a business result.With a plan

Expert

Automation and workbook delivery

Record, read and fix macros, write worksheet functions, and prepare printed reports.

7 lessons
138Record and replay a macroRecord worksheet entries, inspect the generated VBA and replay the macro.4 exercises · 10 minWith a plan
139Read VBA proceduresFollow assignments, variables, loops and conditions before running a worksheet macro.4 exercises · 12 minWith a plan
140Fix common VBA mistakesRepair loop bounds, row and column arguments, missing increments and wrong range addresses.4 exercises · 12 minWith a plan
141Write a worksheet Function in VBAReturn a value from a VBA Function and call it from a worksheet formula.4 exercises · 12 minWith a plan
142Set up a worksheet for printingChoose orientation, margins, scaling and a print area that produces a readable report.4 exercises · 8 minWith a plan
143Repeat headings on printed pagesRepeat header rows and identifying columns so every printed page can be read independently.4 exercises · 8 minWith a plan
Practice setAutomation and printingRun macros, use a worksheet function, and prepare a report for printing.With a plan

Expert models, dashboards and planning

Build changing ranges, tied rankings, linked dashboards and schedules.

9 lessons
145Two-way lookupsFind the intersection of a row label and a column heading.4 exercises · 9 minWith a plan
146Dynamic rangesBuild totals and lists that follow the occupied rows.4 exercises · 9 minWith a plan
147Array formulas and conditional mathCalculate across corresponding rows without helper columns.4 exercises · 9 minWith a plan
148Running totals and moving averagesTrack cumulative work, year-to-date totals and recent averages.4 exercises · 9 minWith a plan
149Deduplication, ranking and top groupsBuild distinct lists and rank results while preserving ties.4 exercises · 9 minWith a plan
ProjectA sales dashboardBuild an operational dashboard for North Pier Supplies.With a plan
ProjectA dependency schedulePlan a fictional archive migration for Orchard Studio.With a plan
Case studySubscriber retentionCompare fictional subscription cohorts for Larch Learning.With a plan
Practice setExpert modelsReview lookups, expanding ranges, array logic, tied ranks and a changing dashboard.With a plan

Interview and exam practice

Classic interview tasks and timed mock exams, followed by an untimed review.

8 lessons
Interview setEssential spreadsheet tasksAnswer eight practical questions from a fictional support export.With a plan
Interview setExcel interview questionsEight classic interview tasks on one employee table: lookups, conditional totals, dates and errors.With a plan
Interview setAdvanced spreadsheet reasoningHandle overlapping criteria, tied results and changing spill ranges.With a plan
Mock examCore skills (MO-200 style)Ten timed tasks in the style of the Excel Associate exam: views, sorting, filtering, names, number formats and formulas.With a plan
Mock examMO-200 style task set 2Complete twelve timed original tasks on a fictional support workbook.With a plan
Mock examAdvanced formulas (MO-201 style)Eight timed tasks in the style of the Excel Expert exam: XLOOKUP, SUMIFS, IFS, FILTER, SORT and UNIQUE, LET and PMT.With a plan
Mock examMO-201 style task set 2Complete twelve timed original tasks on a fictional support workbook.With a plan
Practice setAssessment reviewRevisit advanced assessment mistakes without a timer.With a plan

Your Work Gym account

Save your progress and pick up on another device. Your browser's progress comes with you.

We'll email you a link. It works once and expires in 15 minutes.

You can keep practicing without an account.