Interactive Excel Sales Dashboard

I have a raw sales workbook that needs to become a clear, interactive dashboard directly inside Excel. The file spans several months and already includes product names, regional breakdowns, quantities and revenue; it simply lacks the visual layer that lets decision-makers spot trends at a glance.

Here’s what I need you to do:
• Organise the data so it feeds cleanly into PivotTables (or Power Pivot, if that shortens refresh time).
• Build dynamic charts—bar, line, pie or whichever combination best tells the story of totals, product mix and regional performance.
• Add slicers or drop-down filters so management can drill into any period, product or territory without touching the underlying data.
• Apply consistent, professional formatting and label everything clearly so screenshots drop straight into slide decks.
• Deliver a single, well-commented .xlsx file with instructions on how to update the data source for next month’s numbers.

Acceptance is simple: refresh the file, click a slicer, and every visual updates instantly with no broken links or manual tweaks.