When the dialogue box appears, make sure the box is ticked, as shown below. To do this, go to File -> Options -> Add-Ins -> Manage Excel Add-Ins. The first step is to make sure you have Solver installed in your Excel file. Step 1: Ensure the Solver Add-In is Installed Put another way, we want to figure out how many salespeople we should hire to get the maximum amount of profit. There is a diminishing return on salespeople, so we want to figure out what the optimal number of people to hire is. The best example of how to use Excel solver is by graphing a situation where there is a non-linear relationship between, for example, the number of salespeople in a company and the profit that they generate. Learn with video instruction in CFI’s Advanced Excel Course.

It is a type of what-if analysis and is particularly useful when trying to determine the “best” outcome, given a set of more than two assumptions. Excel Solver is an optimization tool that can be used to determine how the desired outcome can be achieved by changing the assumptions in a model.

Excel qm add in 2016