Description
Fundamentals of Inventory Management Using Microsoft Excel is a course on the essential principles, analytical techniques, and Excel-based tools needed to effectively manage inventory, published by Udemy Online Academy. Suitable for inventory analysts, production planners, supply chain professionals, manufacturing professionals, procurement teams, and Excel users, this course covers inventory types, inventory levels, inventory accounting, financial metrics, demand forecasting, total inventory costs, and inventory control policies, and bases each concept on tools that most professionals already have access to. Learners begin by understanding the costs and benefits of holding inventory and develop an intuition about why businesses hold inventory in the first place and what tradeoffs are involved in over- or under-holding. The course then covers the different types of inventory, followed by a focused review of cycle stock, pipeline stock, and safety stock, explaining what distinct roles each type plays in keeping operations running smoothly without unnecessary excess. By establishing these basic categories, the course gets down to practical Excel work and teaches learners how to create data visualizations that are truly useful for inventory management and analysis, not generic charts.
Learners also study inventory accounting and related financial metrics, connecting inventory decisions to their broader impact on a business’s financial picture. Demand forecasting is considered a core skill, and learners perform forecasting and time series analysis directly in Excel to predict future inventory needs based on historical patterns. The course then looks at total inventory costs, teaching learners how to evaluate ordering and holding costs together, rather than optimizing one at the expense of the other. The course concludes with inventory control policies, including a practical application of the Economic Order Quantity (EOQ) model, and provides learners with a specific, calculable method for determining optimal order sizes. By the end of the course, learners will be able to apply solid inventory management principles using the Excel tools they already have.
What you will learn in Fundamentals of Inventory Management Using Microsoft Excel:
- The costs and benefits of inventory
- Types of inventory
- Overview of cycle stock, pipeline stock, and safety stock
- Data visualizations useful to inventory management and analytics
- and …
Course specifications
Publisher: Udemy
Instructors: Ray Harkins, The Manufacturing Academy
Language: English
Level: Introductory to Advanced
Number of Lessons: 66
Duration: 6h 45m
Course topics on 2026/8
Fundamentals of Inventory Management Using Microsoft Excel Prerequisites
Basic knowledge of manufacturing
Basic knowledge of Microsoft Excel
Pictures
Fundamentals of Inventory Management Using Microsoft Excel introduction video
Installation guide
After Extract, watch with your favorite Player.
English subtitle
Quality: 720p
Downloadly link
Rapidgator link
File password (s): www.downloadly.ir
Size
3.1 GB