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.
6 exercises — Beginner · for Human Resources
Divide leavers by average headcount to get a turnover percentage.
Count how many people sit in a single department on a staff list.
COUNTIF
Stamp the current date into a cell as a fixed value.
Subtract leave taken from entitlement to see what each person has left.
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
| # | Exercise | Functions | Difficulty | Time | Status |
|---|---|---|---|---|---|
| 6 | Calculate the annual turnover rateHarbor Supply — annual turnover summary | — | Beginner | 4 min | 10 pts |
| 9 | Count the headcount in one departmentHarbor Supply — staff list by department | COUNTIF | Beginner | 4 min | 10 pts |
| 14 | Type today's date without typing itNo dataset — this one is about your hands | — | Beginner | 3 min | 10 pts |
| 18 | Work out remaining leave daysHarbor Supply — annual leave tracker | — | Beginner | 3 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 |