Customer Data Cleanup & Reporting

I have a large Excel workbook filled with raw customer data that now needs to be cleaned, reorganised, and turned into clear, informative reports. Typos, blank cells, duplicated rows, and mismatched date / currency formats currently make quick analysis impossible. I want the file streamlined—using solid Excel formulas, functions, or Power Query where helpful—so anyone on my team can filter, sort, and read it without confusion.

Once the data is pristine, I need concise summaries that highlight key customer metrics (totals, averages, breakdowns by region or segment) presented in professional-looking worksheets ready for export to PDF. PivotTables and basic visual elements such as data bars or conditional-format heat maps are welcome if they improve clarity, but the main priority is accuracy and a layout that managers can grasp at a glance.

Deliverables
• Cleaned and de-duplicated customer data table, fully validated
• At least two summary report sheets showing the most relevant customer insights, each laid out for easy printing or PDF sharing
• Short, inline explanation of any advanced formulas or query steps so future updates remain straightforward

I will share the current file when we start; everything stays in Excel, no external tools required. If this sounds straightforward to you, let’s get it done.