Excel Solver example and step-by-step explanation

Excel’s Solver tool is an optimization package. It finds the optimal solution to a problem by changing multiple variables. Download the workbook here: 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