Solver

What is the Excel Add-in, Solver?

Solver is a “What-If” analysis tool you can safely add to Excel. Using an “Objective cell” (a cell containing a formula) that is subject to constraints. (This is the tricky part – determining the constraints you are working under) The constraints / limits the values of other formula cells in a workbook. Using a group of cells called “Decision Variables” that are used in computing a formula in the objective or constraint cells. Solver will adjust the values in the decision variable cells to satisfy the limits on constraint cells and provide a result you’ve requested based on the constraints you’re working under.

Solver can determine the maximum or minimum value of one cell by changing other cells in a formula

You can use this add-in to determine capital budgets, expenditures, optimal production – all based on existing constraints.

Solver is available in Western Training Solutions, Excel Level 3. Ask your IT department if you are allowed to download this Excel add-in to your software. If you are, and you’d like to learn more -contact sales@westernts.ca or call or text to get more information on this exciting data tool that can make your life so much easier!