Detailed Sales Excel Reports -- 3
Budget: ₹750 – ₹1,250 INR
The task is to build a dynamic, easy-to-refresh Excel workbook that turns raw sales data into clear insights. I need three distinct perspectives captured:
• Monthly sales totals that can be filtered by year
• Product-wise performance, highlighting best-sellers and slow movers
• Region-wise breakdown so I can compare territories at a glance
Please structure the file so new data can be pasted in and all pivots, charts, and formulas update automatically. Native Excel features such as PivotTables, slicers, Power Query, and conditional formatting are welcome as long as the final file remains fully editable (no macros are strictly required, but you may use them if they simplify refresh).
Acceptance criteria:
1. One consolidated workbook delivered in .xlsx format.
2. Separate, clearly labeled tabs for each of the three report views plus a clean data input tab.
3. All calculations must reconcile with a small sample data set I will provide for testing.
4. No external links or hidden connections.
If you can share a short sample layout or screenshot early on, that will help confirm the direction. Once approved, you can complete the full build.
• Monthly sales totals that can be filtered by year
• Product-wise performance, highlighting best-sellers and slow movers
• Region-wise breakdown so I can compare territories at a glance
Please structure the file so new data can be pasted in and all pivots, charts, and formulas update automatically. Native Excel features such as PivotTables, slicers, Power Query, and conditional formatting are welcome as long as the final file remains fully editable (no macros are strictly required, but you may use them if they simplify refresh).
Acceptance criteria:
1. One consolidated workbook delivered in .xlsx format.
2. Separate, clearly labeled tabs for each of the three report views plus a clean data input tab.
3. All calculations must reconcile with a small sample data set I will provide for testing.
4. No external links or hidden connections.
If you can share a short sample layout or screenshot early on, that will help confirm the direction. Once approved, you can complete the full build.