Excel Project Tracking Dashboard
Budget: ₹600 – ₹1,500 INR
I have two days to brief senior stakeholders on where our project stands, so I need a clean, presentation-ready Excel workbook that focuses purely on tracking progress and status updates.
Here’s what I expect:
• A dedicated data-entry sheet where I can paste or update raw progress figures.
• An automatically refreshing dashboard that converts those figures into clear line graphs, showing trends over time at a glance.
• Consistent, corporate-friendly formatting—legible labels, logical colour use, and no clutter—so I can drop the file straight into a meeting without extra tweaks.
• All formulas, chart ranges and named ranges unlocked and documented in-cell or via brief comments, so the team can maintain it after hand-off.
Please deliver the finished .xlsx file within 48 hours. I’ll provide the current raw data as soon as we start, then review once for minor tweaks before sign-off.
Here’s what I expect:
• A dedicated data-entry sheet where I can paste or update raw progress figures.
• An automatically refreshing dashboard that converts those figures into clear line graphs, showing trends over time at a glance.
• Consistent, corporate-friendly formatting—legible labels, logical colour use, and no clutter—so I can drop the file straight into a meeting without extra tweaks.
• All formulas, chart ranges and named ranges unlocked and documented in-cell or via brief comments, so the team can maintain it after hand-off.
Please deliver the finished .xlsx file within 48 hours. I’ll provide the current raw data as soon as we start, then review once for minor tweaks before sign-off.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Excel VBA
Excel Macros
Data Visualization
Data Analysis