Excel · मराठी आवृत्ती
13. Excel Dashboard — शिकलेलं एकत्र वापरूया
Tables, formulas, PivotTables, charts आणि slicers वापरून काल्पनिक Maharashtra sales dashboard बनवू. आधी definitions, मग data आणि layout.
March 2026चे teaching headline figures
| KPI | Value (March 2026) | How it is calculated |
|---|---|---|
| Net Sales | ₹49,50,000 | Sum of Amount for Delivered orders |
| Total Orders | 14,000 | Count of Order ID (all statuses) |
| Delivered Orders | 13,200 | Count where Status = Delivered |
| AOV (average order value) | ₹375 | Net Sales ÷ Delivered Orders |
| Cancellation Rate | 4.0% | 560 cancelled ÷ 14,000 |
| Avg Delivery Time | 11.6 min | Average of Delivery Mins for Delivered orders |
हे fictional example totals आहेत. Source order-line levelवर असेल तर Count of Order ID हा rowsचा count होतो; वरच्या order figuresसाठी distinct order IDs किंवा validated order-level table वापरा. Delivery timeही प्रत्येक orderला एकदाच weight द्या. 13,200 Delivered +560 Cancelled =13,760; बाकी240 ordersचा Status sourceमध्ये स्पष्ट असला पाहिजे, गृहीत धरू नका.
City sales: Pune ₹18,42,500; Nagpur ₹9,86,300; Nashik ₹7,12,400; Sambhaji Nagar ₹6,05,900; Kolhapur ₹4,38,700; Solapur ₹3,64,200. बेरीज ₹49,50,000.