Practice Excel with
real, corrected exercises

Simple operations (Q1 revenue)

Build a quarter's activity tracker: revenue, costs and result, formula by formula.

Free

Calculate the revenue

Your first real formula: total revenue, subtotals and grand total for a week of sales.

Free

Invoice with tax

Build a complete invoice from scratch: price before tax, tax rate and total including tax.

Free

Price & tax (absolute reference $)

Master the $ sign: lock a tax rate and copy your formulas without ever breaking them.

Free

Unpaid invoices

Track unpaid invoices in a table and flag every situation automatically.

Free

Fill a series

Let Excel fill your series for you: step of 1, decimals, negatives — one drag of the mouse.

Free

Fill a date series

Build date series, as numbers or as text, using the fill handle.

Free

Logical tests (=, <>, >, <)

Master TRUE and FALSE, the hidden logic behind every IF function.

Free

IF — Temperature (demo)

Write your very first IF: "Hot" or "Cold" is displayed based on the temperature.

Free

IF — Stock below threshold

Build an IF that triggers an alert as soon as stock drops below the limit.

🔒 Paid

IF — Working time and overtime

Spot absences and calculate overtime for 12 employees with a single IF.

🔒 Paid

IF — Membership renewal

Automatically apply the right discount to members based on age and seniority.

🔒 Paid

AND/OR — Combined logical tests

Select customers on several criteria at once by combining AND and OR.

🔒 Paid

AND/OR — Customer records (blank cells)

Detect incomplete customer records and flag missing fields automatically.

🏅 Popular

Nested IF — Expiry dates (discounts)

Apply the right discount based on the expiry date using nested IFs.

🔒 Paid

IF + AND + OR — Shoe selection

Cross type, price and size to pick the right shoes, tier after tier.

🔒 Paid

IF — Tiered commission

Calculate commission for 10 salespeople, from a simple IF to a modern IFS.

🔒 Paid

Nested IF — Customer category A/B/C

Classify customers into categories A, B or C by revenue, then apply the discount.

🔒 Paid

IF — Membership up to date

Track a club's membership dues: up to date, partial or unpaid, calculated automatically.

🔒 Paid

IFERROR — Customer acquisition cost

Tame the #DIV/0! error and protect your calculations with IFERROR.

🔒 Paid

IF — Stock management

Flag reorder points and low-stock alerts across a full inventory table with IF.

🔒 Paid

IF — Price cut based on stock

Automatically discount slow-moving items once stock passes a threshold.

🔒 Paid

COUNTIF discovery — Customer file

Count your customers on any criterion: a word, a number, or even blank cells.

Free

SUMIF discovery — Sales portfolio

Add up revenue by salesperson, region or product in a single formula.

Free

COUNTIF + SUMIF — Market deliveries

Count and total fruit and vegetable deliveries by combining COUNTIF and SUMIF.

🔒 Paid

COUNTIF operators — Customer file

Count with thresholds: greater than, less than, not equal to — every operator.

🔒 Paid

COUNTIF operators — Weather log

Count rainy days, frosts and negative temperatures in a weather log.

🔒 Paid

SUMIF operators — Sales portfolio

Total sales above or below an amount using SUMIF's comparison operators.

🔒 Paid

Summary table — Sales portfolio

Build a real, copyable sales dashboard, locked down with the $ sign.

🔒 Paid

COUNTIFS — Customer file

Cross two criteria at once — status and income — with COUNTIFS.

🔒 Paid

COUNTIFS wildcards — Weather log

Count with wildcards (*) to match partial text in your weather data.

🔒 Paid

SUMIFS — Sales portfolio

Total your sales across 2-3 combined criteria with SUMIFS.

🔒 Paid

SUMIFS — Market deliveries

Add up deliveries by category and date by crossing several criteria.

🔒 Paid

AVERAGEIF — Sales portfolio

Calculate average revenue by salesperson and region with AVERAGEIF.

🔒 Paid

Mixed functions — Stadium laps

The big mix: SUMIF, AVERAGEIF, MIN and MAX with conditions, all in one analysis.

🏅 Popular

Find duplicates — COUNTIF and IF

Spot duplicates in a list at a glance with COUNTIF and IF.

🔒 Paid

Summary — Weather log

The capstone exercise: every .IFS function combined on a full weather log.

🔒 Paid

LEFT — Product code

Extract the code, family and number from a product catalog with LEFT and RIGHT.

Free

CONCAT — First + last name

Combine first names, last names and cities into a single cell with CONCAT.

Free

CLEAN — Remove extra spaces

Strip stray spaces from a customer database with TRIM.

🔒 Paid

PROPER — Fix letter case

Straighten out badly typed names (uppercase, lowercase) with PROPER.

🔒 Paid

SUBSTITUTE — Replace text

Replace a character or word across a whole column in one go with SUBSTITUTE.

🔒 Paid

Combined cleanup

Fully clean a messy database by chaining PROPER and TRIM.

🏅 Popular

MID — Fixed position

Extract exactly the right chunk of text (a year, a number...) with MID.

🔒 Paid

FIND — Character position

Locate any character within a string with FIND.

🔒 Paid

FIND — Email domain

Isolate the domain of an email address by combining FIND and MID.

🔒 Paid

TEXTBEFORE — Modern text functions

Split text without counting positions using TEXTBEFORE and TEXTAFTER.

🔒 Paid

TEXTSPLIT — Split text

Explode a single cell into several dynamic columns with TEXTSPLIT.

🔒 Paid

IF + prefix — Category

Classify products and customers by their prefix, combining IF and text functions.

🔒 Paid

LEN — Validate length

Check that a code or phone number has the right number of characters with LEN.

🔒 Paid

FIND — Test for presence

Check whether an address contains @ or .com with IFERROR and ISERROR.

🔒 Paid

Build an ID

Build a full customer ID from a name, city and code.

🔒 Paid

Clean a broken CSV import

Fix a broken CSV import: spaces, case, numbers and dates stored as text become usable again.

🔒 Paid

MATCH — Days and months

Find the position of a day or month in a list with MATCH.

Free

VLOOKUP exact match — Catalog

Find the price or category of a product from its reference.

Free

INDEX — Distances between cities

Read a two-way table: find the distance between two cities with INDEX.

🏅 Popular

VLOOKUP approximate — Grades

Assign grades with a scale and discover why sorting is required.

🔒 Paid

Compare 2 lists — Inventory

Cross stock and orders, and replace #N/A with a clear message using IFERROR.

🔒 Paid

Fix #N/A errors

Play detective: repair broken VLOOKUP formulas, one by one.

🔒 Paid

VLOOKUP exact + approximate

The capstone exercise: switch between exact and approximate lookups.

🔒 Paid

INDEX + MATCH — Sales team

Level up: cross rows and columns with the INDEX + MATCH combo.

🏅 Popular

XLOOKUP basics — Catalog

Adopt XLOOKUP, the modern function that replaces VLOOKUP with a simpler syntax.

🔒 Paid

XLOOKUP reverse search — Wedding quote

Price a full wedding quote with two price scales searched in reverse order.

🔒 Paid

XLOOKUP multi-criteria — Exchange rates

Find an exchange rate crossing date and currency with a multi-criteria XLOOKUP.

🔒 Paid

FILTER basics — Customer base

Show customers from a region or city with a single FILTER formula.

🔒 Paid

FILTER AND/OR — Customer base

Filter on several combined criteria with AND (*) and OR (+).

🔒 Paid

TODAY — Invoice due dates

Spot overdue invoices at a glance with TODAY() and an IF test.

Free

Subtraction — Difference between dates

Calculate in days or weeks the time separating two dates.

Free

YEAR/MONTH/DAY — Break down a date

Break any date into year, month and day, then rebuild it.

🔒 Paid

DATEDIF — Age and seniority

Calculate the exact age and seniority of your employees with DATEDIF.

🔒 Paid

EOMONTH — End of month and ISO week

Find the end of month, ISO week number and weekday of a date.

🔒 Paid

NETWORKDAYS — Scheduling

Count actual working days, excluding weekends and public holidays.

🔒 Paid

Summary — Project schedule

The capstone exercise: build a real project schedule with every date function.

🏅 Popular

HOUR/MINUTE — Break down a timestamp

Break down an employee time-clock entry into hours and minutes.

🔒 Paid

TIME — Decimal conversion

Switch between hh:mm format and decimal hours (and back) without mistakes.

🔒 Paid

Time — Subtraction and negative times

Calculate durations, subtract breaks and handle night shifts (negative times).

🔒 Paid

SUMIF — Total hours worked

Total hours by employee or by day in [h]:mm format with SUMIF.

🔒 Paid

Payroll — Calculate hours

Build a real payslip: durations, breaks, overtime and hourly cost.

🔒 Paid

Speed — Distance and travel time

Calculate distance, speed and duration of a trip with D = S x T.

🔒 Paid

Summary — Weekly timesheet

The capstone exercise: a complete weekly timesheet, start to finish.

🔒 Paid

COUNT / COUNTA / COUNTBLANK — Attendance list

Diagnose an attendance list by counting values, text and blank cells.

Free

Percentages — Sales breakdown

Calculate each department's share of total sales and simulate increases and drops.

Free

MIN/MAX/AVERAGE

Discover the three essential summary functions on a real dataset.

Free

Variation rate — Quarterly growth

Measure your revenue growth from one quarter to the next, in % and in plain terms.

🔒 Paid

Moving average — Sales trend

Smooth out a jagged sales curve with a moving average.

🔒 Paid

STDEV — Production consistency

Measure how consistent your production is with the standard deviation (STDEV).

🔒 Paid

MEDIAN + MODE — Store footfall

Average, median, mode: three ways to read a store's footfall data.

🔒 Paid

Running total — Monthly revenue

Track your revenue climbing month after month with a running total locked to $.

🔒 Paid

RANK + QUARTILE — Sales challenge

Rank 10 salespeople, build the podium and calculate quartiles.

🏅 Popular

LARGE / SMALL — Top sales

Pull out your best and worst sales with LARGE and SMALL.

🔒 Paid

MOD + IF — Multiple tests

Detect multiples of 12 or 24 months with MOD and an IF diagnostic.

🔒 Paid