Excel Data Cleaning & Insights

I have a raw customer-survey workbook that needs professional attention so I can truly understand who my customers are and how their age, location, and other background details shape their behavior.
The file contains duplicate rows, inconsistent formats, and unstructured columns, so the first step is a thorough clean-up. Once the data are reliable, I’d like them reorganised into clearly named sheets, followed by a concise analysis driven mainly by Pivot Tables and visual summaries.

Key deliverables
• A cleaned, de-duplicated data sheet with consistent headers and formats
• An organised workbook (e.g., Raw, Clean, Analysis) ready for future updates
• Pivot Tables that slice the data by age and location, spotlighting meaningful patterns
• Charts/graphs derived from those pivots for a quick visual read
• A short written summary (1-2 pages) highlighting the most relevant insights about customer groups by age and geography, plus any other background attributes that stand out

Acceptance criteria
The workbook must open without errors, all duplicates must be removed, numeric fields correctly typed, and Pivot Tables must refresh in one click. Charts should be clearly labelled and the narrative summary ought to reference the visuals so I can share everything with stakeholders.

Skills that will be useful include Microsoft Excel, data entry, data cleaning, Pivot Tables, and basic data analysis/visualisation. If this sounds like a straightforward project you can wrap up efficiently, I’m eager to get started and review your approach.