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.