Excel Sales Analysis Dashboard

I have raw sales data coming in regularly and I want a single Excel file that turns those numbers into insight without any manual number-crunching from me. The sheet should focus exclusively on analysis:

• Highlight sales trends over time so I can see seasonal spikes or dips at a glance.
• Compare product performance side-by-side to reveal my best- and worst-selling items.
• Uncover customer purchasing patterns that might inform promotions or loyalty offers.

I’d like this insight presented visually. Please build clear, well-labeled charts and an interactive dashboard inside the workbook so I can filter by date range, product line, or customer segment and have everything update automatically. I don’t need invoice generation or basic sales tracking features—just a polished analytical tool.

Deliverable: a finished Excel file with any supporting formulas or macros already in place, ready for me to drop in new data and start exploring results immediately.