Tools & Techniques:
Combines beginner and intermediate level Microsoft Excel training with
real-world inventory management techniques. Attendees acquire Excel
tools and techniques specifically designed to solve a variety of
inventory management challenges:
- ABC Inventory Classification
- Economic Order Quantity calculation
- Demand pattern analysis (statistical variability)
- Safety stock calculation
- Order point, average inventory, overstock calculations
- Kanban parameter setting
- Supply chain opportunities
Excel features & functions covered by this training include:
- Properly formatting data to avoid common pitfalls
- Building formulas and functions
- Sorting, filtering and summarizing worksheets
- Importing data from other sources
- Joining worksheets through common data elements
Training combines PowerPoint presentations with hands-on, instructor-led,
exercises. All attendees are provided a "Tools and Techniques" quick
reference guide to maximize their ability to apply lessons learned
on-the-job for immediate payback of your training investment.
-Back to the top-