Excel Cleanup & Pivot Dashboard

I have an existing Excel workbook that first needs to be put in order, then turned into a concise, pivot-table-driven dashboard.

Here’s the scope:

• Data cleanup
– Remove every duplicate row without losing legitimate repeats
– Correct all data formats (dates, numbers, text) so they behave consistently in formulas and pivots
– Fill or clearly flag missing values to keep the dataset analysis-ready

• Dashboard creation
– Build a refreshable pivot-table dashboard that summarises the cleaned data at a glance
– Include filters or slicers so I can drill down instantly
– Keep the layout simple and presentation-ready on one tab

Deliverables will be a single Excel file that contains:
1. The original raw data (untouched)
2. A cleaned data sheet produced via formulas, Power Query, or VBA—whatever you prefer, as long as it updates easily
3. The finished pivot dashboard with descriptive headings and colour-coded fields

I’ll consider the job complete once the workbook passes a quick duplicate check, all formats respond correctly to SUM/AVERAGE tests, blanks are handled as agreed, and the pivots recalculate without errors when I drop in fresh data.