91 exercises available
Practice Excel with
real, corrected exercises
A real spreadsheet, right in your browser. Every exercise is corrected and explained step by step. No download, no install.
91exercises
20free
7topics
How do you access the exercises?Free — open access, just click and go.Paid — one pass unlocks every exercise, from $9.99 for 30 days.
Right in your browser
Automatic grading
Real-world scenarios
20 free
Explore the 91 exercises
Click a topic. Green exercises are free.
Free — open access
Everything else — included in the pass
Core ExercisesBasic operations, invoices, absolute references, series7 free 7 exercises
Core Exercises
Basic operations, invoices, absolute references, series
Simple operations (Q1 revenue)
Build a quarter's activity tracker: revenue, costs and result, formula by formula.
Calculate the revenue
Your first real formula: total revenue, subtotals and grand total for a week of sales.
Invoice with tax
Build a complete invoice from scratch: price before tax, tax rate and total including tax.
Price & tax (absolute reference $)
Master the $ sign: lock a tax rate and copy your formulas without ever breaking them.
Unpaid invoices
Track unpaid invoices in a table and flag every situation automatically.
Fill a series
Let Excel fill your series for you: step of 1, decimals, negatives — one drag of the mouse.
Fill a date series
Build date series, as numbers or as text, using the fill handle.
IF & logical testsIF, nested IF, AND, OR, IFERROR, IFS2 free 15 exercises
IF & logical tests
IF, nested IF, AND, OR, IFERROR, IFS
Logical tests (=, <>, >, <)
Master TRUE and FALSE, the hidden logic behind every IF function.
IF — Temperature (demo)
Write your very first IF: "Hot" or "Cold" is displayed based on the temperature.
IF — Stock below threshold
Build an IF that triggers an alert as soon as stock drops below the limit.
IF — Working time and overtime
Spot absences and calculate overtime for 12 employees with a single IF.
IF — Membership renewal
Automatically apply the right discount to members based on age and seniority.
AND/OR — Combined logical tests
Select customers on several criteria at once by combining AND and OR.
AND/OR — Customer records (blank cells)
Detect incomplete customer records and flag missing fields automatically.
Nested IF — Expiry dates (discounts)
Apply the right discount based on the expiry date using nested IFs.
IF + AND + OR — Shoe selection
Cross type, price and size to pick the right shoes, tier after tier.
IF — Tiered commission
Calculate commission for 10 salespeople, from a simple IF to a modern IFS.
Nested IF — Customer category A/B/C
Classify customers into categories A, B or C by revenue, then apply the discount.
IF — Membership up to date
Track a club's membership dues: up to date, partial or unpaid, calculated automatically.
IFERROR — Customer acquisition cost
Tame the #DIV/0! error and protect your calculations with IFERROR.
IF — Stock management
Flag reorder points and low-stock alerts across a full inventory table with IF.
IF — Price cut based on stock
Automatically discount slow-moving items once stock passes a threshold.
COUNTIF / SUMIFCOUNTIF, SUMIF, COUNTIFS, SUMIFS, AVERAGEIF2 free 15 exercises
COUNTIF / SUMIF
COUNTIF, SUMIF, COUNTIFS, SUMIFS, AVERAGEIF
COUNTIF discovery — Customer file
Count your customers on any criterion: a word, a number, or even blank cells.
SUMIF discovery — Sales portfolio
Add up revenue by salesperson, region or product in a single formula.
COUNTIF + SUMIF — Market deliveries
Count and total fruit and vegetable deliveries by combining COUNTIF and SUMIF.
COUNTIF operators — Customer file
Count with thresholds: greater than, less than, not equal to — every operator.
COUNTIF operators — Weather log
Count rainy days, frosts and negative temperatures in a weather log.
SUMIF operators — Sales portfolio
Total sales above or below an amount using SUMIF's comparison operators.
Summary table — Sales portfolio
Build a real, copyable sales dashboard, locked down with the $ sign.
COUNTIFS — Customer file
Cross two criteria at once — status and income — with COUNTIFS.
COUNTIFS wildcards — Weather log
Count with wildcards (*) to match partial text in your weather data.
SUMIFS — Sales portfolio
Total your sales across 2-3 combined criteria with SUMIFS.
SUMIFS — Market deliveries
Add up deliveries by category and date by crossing several criteria.
AVERAGEIF — Sales portfolio
Calculate average revenue by salesperson and region with AVERAGEIF.
Mixed functions — Stadium laps
The big mix: SUMIF, AVERAGEIF, MIN and MAX with conditions, all in one analysis.
Find duplicates — COUNTIF and IF
Spot duplicates in a list at a glance with COUNTIF and IF.
Summary — Weather log
The capstone exercise: every .IFS function combined on a full weather log.
Text functionsLEFT, RIGHT, CONCAT, SUBSTITUTE, MID, FIND, LEN2 free 16 exercises
Text functions
LEFT, RIGHT, CONCAT, SUBSTITUTE, MID, FIND, LEN
LEFT — Product code
Extract the code, family and number from a product catalog with LEFT and RIGHT.
CONCAT — First + last name
Combine first names, last names and cities into a single cell with CONCAT.
CLEAN — Remove extra spaces
Strip stray spaces from a customer database with TRIM.
PROPER — Fix letter case
Straighten out badly typed names (uppercase, lowercase) with PROPER.
SUBSTITUTE — Replace text
Replace a character or word across a whole column in one go with SUBSTITUTE.
Combined cleanup
Fully clean a messy database by chaining PROPER and TRIM.
MID — Fixed position
Extract exactly the right chunk of text (a year, a number...) with MID.
FIND — Character position
Locate any character within a string with FIND.
FIND — Email domain
Isolate the domain of an email address by combining FIND and MID.
TEXTBEFORE — Modern text functions
Split text without counting positions using TEXTBEFORE and TEXTAFTER.
TEXTSPLIT — Split text
Explode a single cell into several dynamic columns with TEXTSPLIT.
IF + prefix — Category
Classify products and customers by their prefix, combining IF and text functions.
LEN — Validate length
Check that a code or phone number has the right number of characters with LEN.
FIND — Test for presence
Check whether an address contains @ or .com with IFERROR and ISERROR.
Build an ID
Build a full customer ID from a name, city and code.
Clean a broken CSV import
Fix a broken CSV import: spaces, case, numbers and dates stored as text become usable again.
Lookup functionsVLOOKUP, XLOOKUP, INDEX, MATCH, FILTER2 free 13 exercises
Lookup functions
VLOOKUP, XLOOKUP, INDEX, MATCH, FILTER
MATCH — Days and months
Find the position of a day or month in a list with MATCH.
VLOOKUP exact match — Catalog
Find the price or category of a product from its reference.
INDEX — Distances between cities
Read a two-way table: find the distance between two cities with INDEX.
VLOOKUP approximate — Grades
Assign grades with a scale and discover why sorting is required.
Compare 2 lists — Inventory
Cross stock and orders, and replace #N/A with a clear message using IFERROR.
Fix #N/A errors
Play detective: repair broken VLOOKUP formulas, one by one.
VLOOKUP exact + approximate
The capstone exercise: switch between exact and approximate lookups.
INDEX + MATCH — Sales team
Level up: cross rows and columns with the INDEX + MATCH combo.
XLOOKUP basics — Catalog
Adopt XLOOKUP, the modern function that replaces VLOOKUP with a simpler syntax.
XLOOKUP reverse search — Wedding quote
Price a full wedding quote with two price scales searched in reverse order.
XLOOKUP multi-criteria — Exchange rates
Find an exchange rate crossing date and currency with a multi-criteria XLOOKUP.
FILTER basics — Customer base
Show customers from a region or city with a single FILTER formula.
FILTER AND/OR — Customer base
Filter on several combined criteria with AND (*) and OR (+).
Dates & timeTODAY, DATEDIF, EOMONTH, HOUR, TIME, NETWORKDAYS2 free 14 exercises
Dates & time
TODAY, DATEDIF, EOMONTH, HOUR, TIME, NETWORKDAYS
TODAY — Invoice due dates
Spot overdue invoices at a glance with TODAY() and an IF test.
Subtraction — Difference between dates
Calculate in days or weeks the time separating two dates.
YEAR/MONTH/DAY — Break down a date
Break any date into year, month and day, then rebuild it.
DATEDIF — Age and seniority
Calculate the exact age and seniority of your employees with DATEDIF.
EOMONTH — End of month and ISO week
Find the end of month, ISO week number and weekday of a date.
NETWORKDAYS — Scheduling
Count actual working days, excluding weekends and public holidays.
Summary — Project schedule
The capstone exercise: build a real project schedule with every date function.
HOUR/MINUTE — Break down a timestamp
Break down an employee time-clock entry into hours and minutes.
TIME — Decimal conversion
Switch between hh:mm format and decimal hours (and back) without mistakes.
Time — Subtraction and negative times
Calculate durations, subtract breaks and handle night shifts (negative times).
SUMIF — Total hours worked
Total hours by employee or by day in [h]:mm format with SUMIF.
Payroll — Calculate hours
Build a real payslip: durations, breaks, overtime and hourly cost.
Speed — Distance and travel time
Calculate distance, speed and duration of a trip with D = S x T.
Summary — Weekly timesheet
The capstone exercise: a complete weekly timesheet, start to finish.
Statistical functionsCOUNT, AVERAGE, STDEV, MEDIAN, RANK, QUARTILE3 free 11 exercises
Statistical functions
COUNT, AVERAGE, STDEV, MEDIAN, RANK, QUARTILE
COUNT / COUNTA / COUNTBLANK — Attendance list
Diagnose an attendance list by counting values, text and blank cells.
Percentages — Sales breakdown
Calculate each department's share of total sales and simulate increases and drops.
MIN/MAX/AVERAGE
Discover the three essential summary functions on a real dataset.
Variation rate — Quarterly growth
Measure your revenue growth from one quarter to the next, in % and in plain terms.
Moving average — Sales trend
Smooth out a jagged sales curve with a moving average.
STDEV — Production consistency
Measure how consistent your production is with the standard deviation (STDEV).
MEDIAN + MODE — Store footfall
Average, median, mode: three ways to read a store's footfall data.
Running total — Monthly revenue
Track your revenue climbing month after month with a running total locked to $.
RANK + QUARTILE — Sales challenge
Rank 10 salespeople, build the podium and calculate quartiles.
LARGE / SMALL — Top sales
Pull out your best and worst sales with LARGE and SMALL.
MOD + IF — Multiple tests
Detect multiples of 12 or 24 months with MOD and an IF diagnostic.
Unlock everything with one pass
One offer, the whole library. You only choose how long you keep it.
1 Month Access
The whole catalogue for 30 days — every topic, every level.
$9.99
one payment, nothing renews
- 91 corrected exercises
- IF, COUNTIF, SUMIF, text functions
- VLOOKUP, XLOOKUP, INDEX / MATCH, FILTER
- Dates, times and statistics
⭐ Best value
1 Year Access
The same catalogue, for a full year.
$99.99
one payment, nothing renews
- Everything in the 1 month pass
- 365 days instead of 30
- Every new exercise of the year included
- About the price of 10 months