Excel Solver: The add-on can do that

In Excel, you can perform versatile calculations with the add-on solver. In this practical tip, we will show you exactly what the add-on can do.

Excel Solver - that's the add-on

• Thanks to this add-on, math problems can be easily solved in Excel.
• The optimal value is calculated in the so-called target cell - completely automatically.
• You only have to define the limit values ​​and properties and the solver solves this task for you.
• This enables you, for example, to calculate the company revenue if the profit is the target cell and the income and expenditure are defined as limit values ​​or properties.
• Once you have set up the solver, you can change the values ​​to see the difference directly.
• To use the solver, open the "Settings" of Excel and select "Add-Ins".
• Then choose "Manage"> "Excel Add-Ins"> "Go To". You will then see a list of the available add-ins.
• Mark the box next to "Solver" and click "OK".