Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Introduction to Supply Chain Analytics using Microsoft Excel
Bestseller
Rating: 4.5 out of 5(2,662 ratings)
10,059 students

Introduction to Supply Chain Analytics using Microsoft Excel

Learn supply chain analytics with Excel: forecasting, optimization, and data-driven decisions without complex math
Last updated 5/2026
English

What you'll learn

  • Fundamental tools of descriptive, predictive and descriptive analytics
  • How to answer the questions, "What happened?", "What will happen?", and "What should we do?"
  • Analytical tools for assessing demand forecasts, production outputs and product mix strategies
  • Introductory time series analysis tools
  • Baseline, Trend, Seasonality and Error
  • Linear programming using Excel Solver
  • Statistical tools in Excel like quartiles, the data analysis tool kit, Norminv, linear regression, mathematical programming, and more!
  • How to use the Economic Order Quantity (EOQ)
  • "Launch points" for further study in analytics

Course content

4 sections63 lectures5h 52m total length
  • Introduction4:17
  • What is a Supply Chain?4:35
  • What is Supply Chain Management?5:50
  • What is Analytics?9:44
  • Glossary of Terminology2:26

Requirements

  • Basic Microsoft Excel skills
  • Basic understanding of manufacturing or logistics
  • Basic business acumen
  • Some supply chain or operations experience would be helpful.

Description

Learn the analytical tools that drive better decisions in supply chain and operations—without needing advanced math or specialized software. This practical, Excel-based course has helped over 9.800 students build real-world skills in analytics.

4.7 stars average rating
1,500+ five-star reviews
Designed for professionals in supply chain, inventory, or operations roles
Practice with Excel-based downloadable exercises

Why Take This Course?

Analytics and supply chain management are two of the most in-demand skills in today’s job market. This course helps you build capability in three key areas:

Descriptive Analytics – What happened?

  • Parametric and nonparametric statistics

  • Measures of central tendency and dispersion

  • Process capability using the normal distribution

  • Calculating process yield

  • Combining normal random variables

  • Practical applications in manufacturing and inventory

Predictive Analytics – What will happen?

  • Time series basics

  • Building linear regression models in Excel

  • Seasonality and trend analysis

  • Forecasting techniques using real data

  • Excel Data Analysis Add-in walkthroughs

Prescriptive Analytics – What should we do?

  • Introduction to optimization and mathematical programming

  • Excel’s Solver Add-in step-by-step

  • Objective functions, constraints, and real-world modeling

  • Economic Order Quantity (EOQ)

  • Policy-driven models and product mix problems

What You’ll Get:

  • 5+ hours of instructor-led content

  • Step-by-step walkthroughs in Microsoft Excel

  • Downloadable exercises for each major topic

  • A 110+ term glossary to reinforce your learning and support continued study

  • Lifetime access to the course and all future updates

What Students Are Saying:

Very great course if you are starting out in the Supply Chain field. Found it very informative and engaging.” – Isabel B.

“I’ve learned things about inventory I never heard of before. Outstanding course.”Jerry O.

“Easy to understand, recommended for beginners. One of the better courses on Udemy.”Clifford C.

“Great tools for the Supply Chain professional! Engaging and very knowledgeable of the overall subject.”Stephanie M.


Build Skills That Advance Your Career

Whether you're new to analytics or want to sharpen your decision-making tools, this course will help you:

  • Understand the numbers behind your supply chain

  • Use Excel to perform real-world analyses

  • Communicate more confidently with data

Introduction to Supply Chain Analytics using Microsoft Excel will serve as the starting point to your career in supply chain analytics and management. No intimidating math. No complicated jargon. Just practical analytics for real professionals.

Who this course is for:

  • Supply Chain Analysts, Supply Chain Managers, Inventory Analysts, Demand Planners
  • Procurement Analysts, Materials Planners, Production Planners, Logistics Analysts
  • Business Analysts, Manufacturing Analysts, Data Analysts, Forecasting Analysts
  • Supply Chain Coordinators, Operations Analysts, Operations Research Analysts, Continuous Improvement Professionals
  • Planning Managers, Logistics Managers, Inventory Control Managers, Procurement Managers
  • Industrial Engineers, Quality Engineers, Quality Managers, Six Sigma Black Belts