Excel Report & Chart Automation
Budget / Salary₹600–1,500
TypeFreelance project
LocationRemote
Posted1 hour ago
I have a workbook that should generate management-ready reports and visual dashboards automatically instead of relying on manual copying, filtering, and chart updates. The workflow I have in mind is simple for the end user: drop raw data into a sheet or connect to an external source, press a single button, and watch the entire report pack refresh—tables updated, charts rebuilt, and everything formatted consistently for printing or PDF export.
To succeed here, the solution will need to cover:
• Building Excel dashboards and charts that stay linked to the underlying data
• Automating report creation with formulas, VBA macros, or Power Query—whatever is most reliable and maintainable
• Handling large data files, including any cleanup, deduplication, or re-structuring required before the analysis layer runs
Deliverables I expect:
1. A fully automated routine (macro, query, or both) that imports/refreshes data, performs necessary transformations, and updates all report sheets and charts.
2. At least one consolidated “Summary” sheet with dynamic tables and visualisations ready for management review.
3. Well-commented code or a short how-to note so I can adapt the solution as new data fields appear.
When you reply, show relevant experience achieving similar Excel automation—especially examples where dashboards or periodic reports now regenerate with a single click. No lengthy proposals needed; a concise summary of past wins in this exact space will help me gauge fit quickly.
To succeed here, the solution will need to cover:
• Building Excel dashboards and charts that stay linked to the underlying data
• Automating report creation with formulas, VBA macros, or Power Query—whatever is most reliable and maintainable
• Handling large data files, including any cleanup, deduplication, or re-structuring required before the analysis layer runs
Deliverables I expect:
1. A fully automated routine (macro, query, or both) that imports/refreshes data, performs necessary transformations, and updates all report sheets and charts.
2. At least one consolidated “Summary” sheet with dynamic tables and visualisations ready for management review.
3. Well-commented code or a short how-to note so I can adapt the solution as new data fields appear.
When you reply, show relevant experience achieving similar Excel automation—especially examples where dashboards or periodic reports now regenerate with a single click. No lengthy proposals needed; a concise summary of past wins in this exact space will help me gauge fit quickly.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.