Overview
-
Learn how to leverage Solver—a Microsoft Office Excel add-in—to find optimal solutions to problems with multiple constraints.
Syllabus
-
Introduction
- Welcome
- What you should know before watching this course
- Using the exercise files
- Find target values using Goal Seek
- Introduce linear and integer programming
- Install the Solver add-in on Windows
- Organize a worksheet for use in Solver
- Find a solution using Solver
- Introduce the problem
- Organize the worksheet
- Create objective and control formulas
- Create and run the Solver model
- Experiment with different constraints
- Introduce the problem
- Organize the worksheet
- Map store and depot locations
- Create objective and control formulas
- Create and run the Solver model
- Introduce the problem
- Organize the worksheet
- Calculate probability of reaching a node
- Calculate the expected value for the tree
- Extend the decision tree
- Additional resources
