Excel Data Analysis Sheet
Budget: $10 – $30 AUD
I need a clean, well-structured Excel workbook that lets me import raw data quickly and draw insights without extra manual work. The file should handle typical analysis tasks—sorting, filtering, automatic summaries, visual dashboards, and clear formulas that can be extended when new rows are added. Pivot Tables or Power Query are welcome if they simplify the workflow, and I’m open to lightweight VBA snippets for repetitive steps, but keep everything transparent so I can trace the logic later.
You’ll start from a CSV dump I provide, organise it into tables, add any helper columns required, and create at least one analysis tab showing key metrics and charts. Please name ranges and label everything clearly so a non-technical user can follow along.
Deliverable: a single Excel workbook, ready for me to drop in fresh data and refresh the results.
You’ll start from a CSV dump I provide, organise it into tables, add any helper columns required, and create at least one analysis tab showing key metrics and charts. Please name ranges and label everything clearly so a non-technical user can follow along.
Deliverable: a single Excel workbook, ready for me to drop in fresh data and refresh the results.