Objective
Create a complete sales tracking and analysis system.
Worksheets
- Sales_Data
- Product_Master
- Employee_Master
- Customer_Data
- Sales_Analysis
- Sales_Dashboard
Data Fields
- Order ID
- Date
- Customer
- Salesperson
- Product
- Category
- Region
- Quantity
- Sales
- Discount
- Net Sales
Formula
Net Sales
=Sales-Discount
Sales Amount
=Quantity*Unit_Price
Analysis
Use:
- SUMIFS
- COUNTIFS
- XLOOKUP
- PivotTables
- PivotCharts
- Slicers
- Conditional Formatting
Practice
Build a dashboard showing:
- Total Sales
- Total Orders
- Total Quantity
- Top Product
- Top Salesperson
- Region-wise Sales
- Monthly Sales