Dynamic Excel Reporting Dashboard
Budget: ₹750 – ₹1,250 INR
I need an Excel specialist who can turn my raw data into a clean business-reporting workbook. The core of the job is building rock-solid pivot tables, weaving in custom formulas that automate all key metrics, and then tying everything together with clear, refreshable charts.
All calculations must update automatically when I drop in new source data, and the final file should be easy for non-technical colleagues to explore. I’m on Microsoft 365, so you’re welcome to use Power Query or any other native features that improve speed and reliability.
Deliverable: a single .xlsx file containing the finished pivot tables, formulas, and linked charts, plus a brief video or call where you walk me through the logic and show me how to refresh the report. Once I can reproduce the results on my end without errors, we’re done.
All calculations must update automatically when I drop in new source data, and the final file should be easy for non-technical colleagues to explore. I’m on Microsoft 365, so you’re welcome to use Power Query or any other native features that improve speed and reliability.
Deliverable: a single .xlsx file containing the finished pivot tables, formulas, and linked charts, plus a brief video or call where you walk me through the logic and show me how to refresh the report. Once I can reproduce the results on my end without errors, we’re done.