Excel Sales Trend Analysis Model

I need a compact Excel workbook that helps me spot and explain sales trends at a glance. The main goal is to analyse current and past performance rather than produce long-range forecasts. You will have two data sources to work with: detailed customer-demographic fields and our marketing-spend figures for the same periods. There is no historical sales file yet, so the model must extract insight from these two tables alone.

I would like you to keep everything in native Excel, leaning on SUMIFS, LOOKUPs and well-designed PivotTables instead of more advanced statistics. Clear, reusable formulas are important because the sheet will be updated monthly by non-technical staff.

Deliverables
• One Excel file containing:
– Cleaned and well-structured raw-data tabs for the demographic and marketing inputs
– A calculations tab that uses SUMIFS / LOOKUP chains to join the inputs, derive sales KPIs and feed dynamic PivotTables
– At least two PivotTable-driven dashboards that highlight trends by customer segment and by marketing channel, with slicers for quick filtering
• Brief inline documentation (cell notes or a separate sheet) so someone else can extend the model later

Acceptance criteria
• No external add-ins or macros; the workbook must open error-free in standard Excel 365
• All formulas should update correctly when new rows are appended to the source tables
• PivotTables refresh without breaking the slicers or formatting

If this sounds straightforward to you and you can deliver a clean, well-commented file quickly, please let me know your turnaround time.