Course
Project: sales dashboard
Clean up and analyse a real order list: make the statuses consistent with a drop-down, flag rows with conditional formatting, summarise sales with PivotTables and read a share from one.
Exercise 1 of 7
Add a Status drop-down
The Status column was typed by hand, and the new orders in rows 12 and 13 have none yet. Select E2:E13, open Data Validation, choose List and use the statuses in G2:G4 as the Source, locked with $.
| Order | Region | Rep | Sales ($) | Status | Statuses | |
| 1001 | North | Olivia Reed | 4,200.00 | Delivered | Delivered | |
| 1002 | South | James Carter | 1,850.00 | Delivered | Pending | |
| 1003 | East | Sofia Patel | 3,600.00 | Pending | Cancelled | |
| 1004 | West | Liam Brooks | 2,750.00 | Delivered | ||
| 1005 | North | James Carter | 980.00 | Cancelled | ||
| 1006 | East | Olivia Reed | 5,100.00 | Delivered | ||
| 1007 | South | Sofia Patel | 2,300.00 | Pending | ||
| 1008 | West | Liam Brooks | 6,400.00 | Delivered | ||
| 1009 | North | Sofia Patel | 1,500.00 | Delivered | ||
| 1010 | East | James Carter | 2,900.00 | Cancelled | ||
| 1011 | South | Olivia Reed | 3,300.00 | |||
| 1012 | West | Liam Brooks | 1,200.00 |