Excel Financial MIS Dashboard Creation -- 2
Budget: $10 – $30 USD
I need a polished financial presentation, an MIS-focused slide deck, several supporting MIS reports, and an interactive dashboard—all built exclusively in Microsoft Excel. The finished workbook should highlight key insights through clear charts, graphs, and well-structured data tables; pivot tables are not required unless you feel they add value.
You will receive raw data extracts once we agree on the structure. From there, I want you to:
• Design a concise slide-style summary inside Excel that I can export to PowerPoint when needed.
• Build an intuitive dashboard page with slicers or drop-downs so I can filter the visuals on the fly.
• Produce separate report tabs for underlying data tables that feed each visual, keeping formulas transparent and easy to audit.
• Apply consistent formatting—corporate color palette, readable fonts, and clear label naming—so the whole file is presentation-ready.
I’ll sign off when every chart updates automatically from its source table, all links are error-free, and the dashboard lets me see year-to-date and month-on-month movements at a glance. If you have sample workbooks or templates that demonstrate similar projects, feel free to share them in your bid.
You will receive raw data extracts once we agree on the structure. From there, I want you to:
• Design a concise slide-style summary inside Excel that I can export to PowerPoint when needed.
• Build an intuitive dashboard page with slicers or drop-downs so I can filter the visuals on the fly.
• Produce separate report tabs for underlying data tables that feed each visual, keeping formulas transparent and easy to audit.
• Apply consistent formatting—corporate color palette, readable fonts, and clear label naming—so the whole file is presentation-ready.
I’ll sign off when every chart updates automatically from its source table, all links are error-free, and the dashboard lets me see year-to-date and month-on-month movements at a glance. If you have sample workbooks or templates that demonstrate similar projects, feel free to share them in your bid.
Related categories:
Visual Basic
Data Processing
Excel
Powerpoint
Financial Analysis
Charts
Data Visualization
Data Analysis