Excel is a mission-critical tool for supply chain professionals. This curated playlist explains the most important Excel functions using real inventory, logistics, and operations scenarios.
1. VLOOKUP: Retrieve supplier lead times from vendor master data.
2. HLOOKUP: Extract monthly demand from horizontal planning sheets.
3. SUMIF / SUMIFS: Calculate inventory value by warehouse.
4. COUNTIF / COUNTIFS: Count delayed or incomplete shipments.
5. AVERAGEIF / AVERAGEIFS: Measure average supplier lead time.
6. INDEX / MATCH: Find SKU cost across large datasets.
7. PivotTables: Analyze inventory turnover and stock aging.
8. IF / IFERROR: Flag stock-outs and calculation errors.
9. CONCAT / CONCATENATE: Create unique shipment IDs.
10. TEXT / DATEVALUE: Normalize ERP-exported dates.
11. INDEX-MATCH Combination: Advanced supplier-SKU mapping.
12. Conditional Formatting: Highlight excess inventory.
13. Data Validation: Prevent incorrect material entry.
14. Array Formulas: Calculate safety stock.
15. Solver: Optimize logistics cost.
16. Pivot Charts: Visualize demand vs supply.
17. Goal Seek: Identify order quantities.
18. Advanced Filter: Extract high-risk suppliers.
19. Text Functions: Clean SKU descriptions.
20. Data Tables: Perform what-if analysis.
Tags:
Excel supply chain, inventory analysis, logistics Excel, demand planning, supply chain analytics, operations management