Click on the Add-ins option and then click on Go.

This will open up an Excel options window.

Note: If you have Excel 2007, you need to click on the Microsoft Office button → Options.

If you have Excel versions: - 2010, 2013, 2016, or 2019 you have to first go to the File tab → OPTIONS, as shown.

Now let’s take a look into how to add this tool. But first, let's look at how to enable Solver in Excel.Ī solver is an add-in tool available in Excel. This topic might be a little challenging for beginners, but the step-by-step tutorial covered in this article will give you an insight into how the Solver tool can be used for decision making. They also determine how each scenario affects the outcome on the worksheet. This Solver belongs to the set of ‘what-if’ analysis tools, that help us test various scenarios in Excel.

Solver in Excel is a tool that helps us solve decision problems by arriving at relevant optimal solutions.

This article gives you a simple introduction to Solver in Excel that enables you to perform linear programming and arrive at the best possible outcomes. Thus, helping us solve business problems in the most efficient way. These decisions require accountants' knowledge to determine what actions need to be taken to maximize the outcome.

When it comes to making important decisions such as budgeting, outsourcing, and adding or dropping a line of products, we need to consider the total costs. Microsoft Excel is a popular data analytics tool that improves the user's productivity while working on data.

Excel solver function doesnt display