Microsoft Excel: Using Solver for Decision Analysis
Offered By: LinkedIn Learning
Course Description
Overview
Discover how to use Excel Solver to find optimal solutions to problems that range from simple to complex.
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
Linear and Discrete OptimizationÉcole Polytechnique Fédérale de Lausanne via Coursera Linear and Integer Programming
University of Colorado Boulder via Coursera Graph Partitioning and Expanders
Stanford University via NovoEd Discrete Inference and Learning in Artificial Vision
École Centrale Paris via Coursera Convex Optimization
Stanford University via edX