Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Microsoft Excel: Using Solver for Decision Analysis

Video Introducing this tutorial

Introduction

Welcome
What you should know before watching this course
Using the exercise files

1. Working with Solver

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

2. Tuning Investment Portfolios

Introduce the problem
Organize the worksheet
Create objective and control formulas
Create and run the Solver model
Experiment with different constraints

3. Optimizing Resource Placement

Introduce the problem
Organize the worksheet
Map store and depot locations
Create objective and control formulas
Create and run the Solver model

4. Defining Decision Trees

Introduce the problem
Organize the worksheet
Calculate probability of reaching a node
Calculate the expected value for the tree
Extend the decision tree

Conclusion

Additional resources