Real situations from working spreadsheets — sales targets, commission tiers, messy exports, aged invoices. Numbered in recommended order: start at 1 and work down, or filter to what you need.
19 exercises — Beginner · for Student
Multiply quantity by unit price to get a line total.
Use LEN to validate that product codes are the right length.
LEN
Divide a unit count by the case size to see how many cases were ordered.
Open a cell for editing without reaching for the mouse or the formula bar.
Copy the cell above into the cells you have selected, without dragging.
Pull the first name out of a single full-name column.
LEFT · FIND
Add up a column of daily sales figures to get the monthly total.
SUM
Pin down what $ changes about a reference, and what it does not.
Read an error code as a diagnosis rather than a failure.
Subtract leave taken from entitlement to see what each person has left.
Combine separate address fields into one line, skipping blanks.
TEXTJOIN
Divide actual sales by target to get an achievement percentage.
Use COUNT to find how many rows contain a numeric value.
COUNT
Calculate the mean value of a set of customer orders.
AVERAGE
Count how many rows meet a numeric condition.
COUNTIF
Identify the extremes in a column of values.
MAX · MIN
Use IF to label each rep as meeting or missing their target.
IF
Mark an order when either of two independent conditions is true.
OR · IF
Add up only the rows matching a text condition.
SUMIF
| # | Exercise | Functions | Difficulty | Time | Status |
|---|---|---|---|---|---|
| 5 | Calculate line totals with multiplicationHarbor Supply — order ORD-1046 lines | — | Beginner | 3 min | 10 pts |
| 7 | Check code length with LENHarbor Supply — product code import | LEN | Beginner | 3 min | 10 pts |
| 8 | Convert loose units into full casesHarbor Supply — pick list, units to cases | — | Beginner | 3 min | 10 pts |
| 10 | Edit the cell you are standing onNo dataset — this one is about your hands | — | Beginner | 2 min | 10 pts |
| 11 | Fill a formula down a columnNo dataset — this one is about your hands | — | Beginner | 3 min | 10 pts |
| 12 | Split a full name with LEFT and FINDHarbor Supply — CRM contact export | LEFT · FIND | Beginner | 7 min | 15 pts |
| 13 | Total a month of sales with SUMHarbor Supply — daily sales, first week of October | SUM | Beginner | 3 min | 10 pts |
| 15 | What does the dollar sign actually do?Conceptual question — no dataset | — | Beginner | 3 min | 15 pts |
| 16 | What is Excel telling you with #N/A?Conceptual question — no dataset | — | Beginner | 3 min | 15 pts |
| 18 | Work out remaining leave daysHarbor Supply — annual leave tracker | — | Beginner | 3 min | 10 pts |
| 20 | Build a mailing address with TEXTJOINHarbor Supply — customer addresses | TEXTJOIN | Beginner | 6 min | 15 pts |
| 21 | Calculate achievement against targetHarbor Supply — Q3 rep performance | — | Beginner | 3 min | 10 pts |
| 22 | Count how many orders shipped with COUNTHarbor Supply — shipment status | COUNT | Beginner | 4 min | 10 pts |
| 23 | Find the average order value with AVERAGEHarbor Supply — October orders | AVERAGE | Beginner | 3 min | 10 pts |
| 27 | Count orders above a threshold with COUNTIFHarbor Supply — October orders | COUNTIF | Beginner | 5 min | 15 pts |
| 28 | Find the largest and smallest orderHarbor Supply — October orders | MAX · MIN | Beginner | 4 min | 10 pts |
| 30 | Flag reps below target with IFHarbor Supply — Q3 rep performance with achievement | IF | Beginner | 5 min | 15 pts |
| 32 | Flag orders needing special handling with ORHarbor Supply — warehouse pick list | OR · IF | Beginner | 5 min | 15 pts |
| 33 | Total sales for one region with SUMIFHarbor Supply — October orders by region | SUMIF | Beginner | 6 min | 15 pts |