Survey Data Excel Dashboard

I have a raw export of survey questions and responses sitting in Excel. Before I can share it with my stakeholders, the file needs a thorough cleanup—duplicate rows removed, columns correctly typed, stray characters and blank cells handled—and then a clear, interactive dashboard that instantly shows overall customer satisfaction and ratings.

Once the data is tidy, I’d like an at-a-glance view built directly in Excel (Power Query and Pivot Charts are fine) that highlights:

• Average satisfaction score and NPS,
• Distribution of ratings over time,
• Quick filters for date range and survey version.

Please keep everything self-contained in the workbook with no external add-ins. A short walkthrough or commented notes inside the file on how you structured the queries and formulas will help me maintain it later.