Excel Descriptive Data Analysis & Charts -- 2

I need an experienced Excel pro to turn a raw dataset into clear, descriptive insights. The workbook contains operational figures from the past year; it just needs cleaning, smart summarisation, and eye-catching visuals that update automatically.

Your focus will be descriptive statistics—averages, counts, distributions, and other summary measures that reveal what’s really happening in the numbers. From there, craft pivot tables and charts that make the story obvious at a glance. Everything must stay within Excel; no external BI platforms.

Deliverables
• Cleaned and structured workbook with clearly labeled sheets
• Descriptive-stat tables (using formulas, PivotTables, or a mix)
• Dynamic charts or a compact dashboard tied to those tables
• Short write-up explaining key formulas and steps taken

The file is ready to share right away, and I’d love to see a first draft within a week. If you can wrap it up faster—or suggest ways to make the visuals even more compelling—tell me in your proposal.