Advanced Excel Financial Dashboard

I have a growing set of cost and expense data that is starting to out-grow simple spreadsheets. What I need is an Excel file that does three things very well:

• Cleans, organises, and merges the raw data I receive each week
• Uses solid formulas (lookups, dynamic arrays, pivot logic, etc.) to calculate totals, variances, and other key results automatically
• Presents the insights in a clear dashboard—interactive charts, summaries, and trend views that management can understand at a glance

Accuracy is critical, so the first step will be building a reliable data model: duplicate removal, consistent naming, and a structure that can accept new imports without breaking anything. From there, I want the calculations and visuals to update themselves the moment fresh figures are dropped in.

Because some of these charts may later be copied into board-level decks, please set them up with clean formatting and colours that will translate well if I decide to paste them into PowerPoint.

Deliverables I expect:
1. A master workbook with automated data-cleaning routines
2. Calculation sheets (clearly labelled) that drive totals, costs, and other KPIs
3. A dashboard tab with interactive charts and slicers
4. A short hand-off note or video so I can maintain or extend the model after delivery

If you have questions about the current data layout or want a sample file before starting, just let me know and I’ll send it across.