Sales

Sales Dashboard

You run sales operations for a six-person team. The VP wants a half-year dashboard from 150 orders: total revenue, revenue per month, a rep leaderboard and a regional breakdown, all driven by formulas so it updates when new orders arrive.

Deliverable: A Revenue column and named range, a KPI block, monthly revenue with a line chart, a ranked rep leaderboard with the top two highlighted, and a PivotTable by region.

1. 1Revenue per order15 pts
2. 2Name the Revenue column15 pts
3. 3Orders and average order10 pts
4. 4Revenue by month20 pts
5. 5Rep leaderboard20 pts
6. 6Who is on top?10 pts
7. 7Highlight the top two10 pts
8. 8Revenue by region15 pts
9. 9Chart the trend10 pts