Excel Sales Dashboard & Cleanup

I’m working with a single workbook that captures two years of sales activity. While most of the data is usable, I still run into the odd duplicate, a handful of blanks, and the occasional product or customer name that’s been typed two different ways. Once those issues are fixed, I want to see everything come to life in an easy-to-refresh dashboard.

The dashboard must give me a clear view of:
• Sales by product, customer, and region
• Sales targets lined up against the actual figures so gaps jump off the page

Feel free to lean on Power Query for the cleanup, PivotTables and slicers for drill-downs, and standard Excel charts or conditional formatting for appealing visuals—whatever combination keeps refreshes quick and the file size reasonable.

I’ll provide the current workbook plus a short data key. I expect back:
1. A cleaned dataset (no duplicates, consistent names, missing values handled)
2. The interactive dashboard on its own sheet
3. A quick set of refresh instructions so I can keep everything up to date on my own

Fast turnaround and a concise overview of your approach will help me choose the right person.

---
來源：Freelancer.com | 出價次數：19 | 剩餘時間：6 日 | 專案類型：固定預算