Excel Financial Analysis Dashboard
Budget: ₹12,500 – ₹37,500 INR
I need a clean, professional‐looking Excel dashboard dedicated to financial analysis, with the emphasis on budget forecasting. All underlying sheets are ready; what’s missing is an intuitive front-end that lets me monitor how actual spending measures up against projected figures at a glance.
The heart of the job is visual: I want clear, well-labeled graphs and charts that summarise monthly, quarterly and year-to-date performance. Think dynamic column charts for variance, simple line charts for trends and perhaps a waterfall to show cumulative impact—whatever conveys the story best. Everything must update automatically as fresh data is pasted into the source tables.
You are free to use the Excel tools you prefer—PivotTables, named ranges, Power Query, slicers, even a bit of VBA if that streamlines refreshes—so long as the file remains fully editable in the latest Microsoft 365 desktop version. Interactive elements or automated report snippets are welcome bonuses, but polished visuals are the non-negotiable deliverable.
Once complete I will review the workbook for clarity, accuracy of formulas, and ease of updating. If figures, labels or colour choices need minor tweaks, we’ll iterate quickly until the dashboard feels presentation-ready.
The heart of the job is visual: I want clear, well-labeled graphs and charts that summarise monthly, quarterly and year-to-date performance. Think dynamic column charts for variance, simple line charts for trends and perhaps a waterfall to show cumulative impact—whatever conveys the story best. Everything must update automatically as fresh data is pasted into the source tables.
You are free to use the Excel tools you prefer—PivotTables, named ranges, Power Query, slicers, even a bit of VBA if that streamlines refreshes—so long as the file remains fully editable in the latest Microsoft 365 desktop version. Interactive elements or automated report snippets are welcome bonuses, but polished visuals are the non-negotiable deliverable.
Once complete I will review the workbook for clarity, accuracy of formulas, and ease of updating. If figures, labels or colour choices need minor tweaks, we’ll iterate quickly until the dashboard feels presentation-ready.