Excel Predictive Sales Forecasting

I need an experienced analyst to turn my historical sales data into a forward-looking forecast entirely in Excel. Your task is to clean the raw figures, build an accurate predictive model, and present the results in a format that a non-technical stakeholder can understand at a glance.

The dataset arrives as monthly CSV exports. After cleaning, I expect you to apply appropriate time-series or regression techniques available within Excel—think Data Analysis ToolPak, Power Query, Solver, or even VBA if it streamlines the workflow. Please document every transformation step so the model can be refreshed with new data later.

Deliverables
• A well-structured Excel workbook containing:
– The cleaned data sheet
– The predictive model with formulas fully visible
– An interactive dashboard (charts, slicers, key metrics) summarising past performance and future projections
• A short write-up (one page) explaining methodology, assumptions, and how to update the model.

Acceptance criteria
• Forecast error tested on a withheld sample and clearly reported.
• Workbook opens with no broken links or macros disabled warnings.
• All calculations remain inside Excel—no external scripts.

If this matches your skill set, let me know your proposed approach and timeline.