Optimization with Excel Solver

is a Microsoft Excel add-in program you can use for optimization in what-if analysis.

According to O’Brien and Marakas, optimization analysis is a more complex extension of goal- seeking analysis. Instead of setting a specific target value for a variable, the goal is to find the optimum value for one or more target variables, under certain constraints. Then, one or more other variables are changed repeatedly, subject to the specified constraints, until you discover the best values for the target variables.

Get new e-books by email:

More on digital marketing in our blog

See all posts