Advanced Excel Cleanup & Analysis

I have several raw workbooks that mix financial, sales and customer figures, and I need them transformed into reliable, presentation-ready outputs. The first step is a thorough data clean-up: removing duplicates, repairing missing or partial entries, and giving every column consistent, professional formatting. Once the data is solid, I want dynamic pivot tables and charts that highlight the key trends I’ll be discussing with stakeholders. Finally, I need a clear profit-and-loss statement prepared from the cleaned data that I can drop straight into a report.

Deliverables:
• A cleaned, fully formatted Excel sheet (no duplicates, no blank anomalies)
• Interactive pivot tables and matching pivot charts for quick drill-downs
• A profit-and-loss statement pulling from those same tables so the numbers always stay in sync

If you are comfortable with advanced Excel functions—Power Query, pivot table design, conditional formulas—this should be straightforward work. I’ll provide the source files immediately and am happy to clarify any edge cases before you begin.