Optimization and the Excel Solver

Optimization and the Excel Solver

$199.00 / year

Course Overview:

This course covers the Excel Solver. Excel solver is used to find the optimal solution to problems.

Key Topics:

  • How to setup a Solver model by using objective cells, variable cells, and constraints
  • How to use Solver to find the profit maximizing product mix
  • How Solver can be used to schedule a workforce
  • Capital budgeting with solver
  • Estimating demand and sensitivities with solver
  • How to build a simple inventory model
  • How to calculate the cheapest diet with various nutritional constraints
  • Setting up transportation and network flow models.
  • Using Solver to set point spreads!

Who Will Benefit?

Any professional that has intermediate to advanced knowledge of Microsoft Excel.