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.