Excel Sales Dashboard & Analysis

My monthly sales spreadsheets need to be transformed into clear, insightful visuals and a concise analytical report within the next four weeks. The core of the job is building interactive charts and dashboards in Excel—think PivotTables, PivotCharts, slicers, and well-structured formulas—followed by a narrative summary that highlights key trends, variances, and actionable insights.

Deliverables
• Dynamic Excel dashboard that updates cleanly when new sales data are dropped in
• Written analysis (PDF or Word) that explains findings, metrics, and any business implications
• A brief walkthrough or annotated sheet so I can trace every formula and logic step

Acceptance criteria
• All visuals auto-refresh from a single data source without broken links
• No hard-coded numbers where a formula should sit
• Formatting is consistent and ready for client presentation (colour palette, fonts, and spacing)
• Explanations are plain-English and easy for a non-analyst to follow

While sales data is the immediate focus, light help with quick video snippets or social-media post prep would be a nice bonus later on, though not required for this milestone. Accuracy, organisation, and clarity are critical; if the numbers reconcile and the story makes sense, we’re good.