Financial Data Stats & Charts
Budget: ₹400 – ₹750 INR
I have an Excel workbook filled with raw financial figures and I need a concise, trustworthy snapshot of what the numbers are saying. Specifically, I want you to calculate the mean and median for each relevant column and then translate those insights into clear, well-labeled charts so I can scan trends instantly.
The workbook you return should stay fully dynamic—if I drop in new data next month, the statistics and visuals must update automatically. Use straightforward formulas, keep everything Microsoft 365-compatible, and leave a brief note inside the file describing any data cleaning you performed and how to refresh the results.
Deliverables
• Excel file with dynamic mean & median calculations
• At least two intuitive charts (column, bar, or line) reflecting those figures
• One short in-sheet note outlining the refresh steps and any data checks carried out
Fast turnaround is appreciated; let me know your approach and timeline when you bid.
The workbook you return should stay fully dynamic—if I drop in new data next month, the statistics and visuals must update automatically. Use straightforward formulas, keep everything Microsoft 365-compatible, and leave a brief note inside the file describing any data cleaning you performed and how to refresh the results.
Deliverables
• Excel file with dynamic mean & median calculations
• At least two intuitive charts (column, bar, or line) reflecting those figures
• One short in-sheet note outlining the refresh steps and any data checks carried out
Fast turnaround is appreciated; let me know your approach and timeline when you bid.