Guided project · 6 steps Cellwise Plus
Weekly tips and income log in Excel
Log a week of tips, work out tip % and tips per client, and find your best day.
You will use: SUM, ROUND, MAX, MATCH, INDEX
Starting data
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Day | Clients | Services | Card tips | Cash tips | Total tips | Tip % | Tips per client | ||
| 2 | Tue | 6 | 410 | 62 | 20 | Best tip day | ||||
| 3 | Wed | 7 | 465 | 71 | 15 | |||||
| 4 | Thu | 8 | 590 | 88 | 30 | |||||
| 5 | Fri | 9 | 640 | 104 | 25 | |||||
| 6 | Sat | 11 | 820 | 118 | 52 | |||||
| 7 | Sun | 4 | 260 | 41 | 10 | |||||
| 8 | Week |
Build it step by step
Step 1
Add card and cash tips for each day. Write it in F2 and fill to F7.
Step 2
Tip % is total tips divided by service sales. Write it in G2 and fill to G7.
Step 3
Total the week in row 8. Write the SUM for clients in B8, then fill it across to F8.
Step 4
Tip % for the week in G8: total tips over total services. Do not average the daily percentages.
Step 5
Tips per client in K1, rounded to cents.
Step 6
Which day brought in the most tips? Return the day name in K2.