Excel Supply Chain Analysis: Solving Transportation Problems Course
This course teaches practical transport modelling in Excel, focusing on designing error-resistant workbooks, structuring cost and flow matrices, converting freight quotes to unit costs, using Solver for optimization, troubleshooting issues, running scenarios, and presenting professional results for real-world distribution decisions.

from 4 to 360h flexible workload
certificate valid in your country
What will I learn?
Master practical transport modelling in Excel with this focused, high-impact course. Learn to design clean, error-resistant workbooks, structure cost and flow matrices, and convert real freight quotes into consistent unit costs. You will set up and troubleshoot Solver, interpret optimal shipment plans, run scenarios, and document clear, professional results you can apply immediately to real distribution decisions.
Elevify advantages
Develop skills
- Build clean Excel transport models: tables, named ranges, clear layouts.
- Optimise freight flows in Excel Solver to cut logistics costs fast.
- Convert US freight quotes into usable per-unit transport cost inputs.
- Diagnose Solver issues quickly: infeasible, unbounded, or degenerate models.
- Present transport results clearly: key costs, flows, and assumptions.
Suggested summary
Before starting, you can change the chapters and workload. Choose which chapter to start with. Add or remove chapters. Increase or decrease the course workload.What our students say
FAQs
Who is Elevify? How does it work?
Do the courses have certificates?
Are the courses free?
What is the course workload?
What are the courses like?
How do the courses work?
What is the duration of the courses?
What is the cost or price of the courses?
What is an EAD or online course and how does it work?
PDF Course