Discover how to use Excel Solver to find optimal solutions to problems that range from simple to complex.
Overview
Syllabus
Introduction
- Optimize your analysis in Excel
- What you should know before starting
- Find target values using Goal Seek
- Introduce linear, nonlinear, and evolutionary programming
- Install the Solver add-in on Windows
- Organize a worksheet for use in Solver
- Find a solution using Solver
- Challenge: Create a Solver model
- Solution: Create a Solver model
- Introduce the problem
- Organize the worksheet
- Create objective and control formulas
- Create and run the Solver model
- Experiment with different constraints
- Challenge: Tune an investment portfolio
- Solution: Tune an investment portfolio
- Introduce the problem
- Organize the worksheet
- Map store and depot locations
- Create objective and control formulas
- Create and run the Solver model
- Extend the model by adding population density
- Challenge: Optimize resource placement
- Solution: Optimize resource placement
- Introduce the problem
- Organize the worksheet
- Calculate the probability of reaching a node
- Calculate the expected value for the tree
- Challenge: Define a decision tree
- Solution: Define a decision tree
- Additional resources
Taught by
Curt Frye
Related Courses
-
Master Decision making with " Excel What-If Analysis"!
-
Introduction to Spreadsheets and Models
4.2 -
Advanced Models for Decision Making
-
Microsoft Excel Pro Tips: Excel from Beginner to Advanced
-
Microsoft Excel - Excel Data Analysis Expert (Accredited)
-
Business Analytics with Excel: Elementary to Advanced
5.0
