Using Excel Solver to Optimize Your Business | StraightLinePerform

Using Excel Solver to Optimize Your Business | StraightLinePerform

Excel’s Solver tool is an optimization package. It finds the optimal solution to a problem by changing multiple variables.

It can solve for more complex “what-if-analysis” which Goal Seek can’t. Goal seek is restricted to changing one variable, whereas with solver you can have many variables.

Calling Solver an “advanced goal seek” doesn’t do it any justice. Solver can handle complex data models and solve for the optimal solution. But; it can also easily solve for the more simpler problems that we might face at work.