Excel Sales Trend Analysis
Budget: ₹400 – ₹750 INR
I have a set of e-commerce sales records that needs to be turned into clear, actionable insights. Your task is to take the raw spreadsheet I provide, clean or re-structure it if required, and then use Excel’s Pivot Tables, Pivot Charts, and well-chosen formulas to spotlight meaningful sales trends.
The end result should let me quickly see how revenue and unit volumes are shifting over time, which products or categories are gaining traction, and any seasonality worth noting. Interactive pivots that I can refresh with new data are essential, and every formula should be transparent so I can trace how figures are derived.
Deliverables
• An Excel file containing:
- Dynamic Pivot Tables that slice the sales data from multiple angles (date, product, region, etc.).
- Pivot Charts linked to those tables for visual snapshots.
- Supporting formulas (e.g., growth %, moving averages) clearly labeled and easy to modify.
• A brief summary sheet highlighting the key trends you uncovered and any recommendations you see fit.
I’ll supply the raw data as soon as we start. If anything about time intervals or additional dimensions needs clarification, flag it early so we keep the analysis on point.
The end result should let me quickly see how revenue and unit volumes are shifting over time, which products or categories are gaining traction, and any seasonality worth noting. Interactive pivots that I can refresh with new data are essential, and every formula should be transparent so I can trace how figures are derived.
Deliverables
• An Excel file containing:
- Dynamic Pivot Tables that slice the sales data from multiple angles (date, product, region, etc.).
- Pivot Charts linked to those tables for visual snapshots.
- Supporting formulas (e.g., growth %, moving averages) clearly labeled and easy to modify.
• A brief summary sheet highlighting the key trends you uncovered and any recommendations you see fit.
I’ll supply the raw data as soon as we start. If anything about time intervals or additional dimensions needs clarification, flag it early so we keep the analysis on point.