Since I use Excel 2013, I will tell you how to get solver on excel 2013. So any excel’s version from 97 and beyond (including Excel 2016) will have this tool. The Solver Add-in is available since the 97-2003 versions of Microsoft Excel. Which Versions of Excel Provide the Solver Add-In?

In short, I will mention all the necessary details to get you up and running with the excel solver add-in. Besides, we will also discuss how you can add solver add-in in excel, which excel versions provide this add-in, how to define your parameters e.t.c. In this article, I will discuss in detail how you can use the Excel Solver Add-In to perform a variable analysis and find the optimal solution. In Excel Solver Add-In, all you have to do is define your data, set objective functions, identify constraints in the scenario manager and then let excel take care of the rest. Once everything is set, use the trial and error method to identify an optimal solution.Ĭhange just one variable and your whole model starts showing a totally different picture. The major reason is that you have to take care and keep track of the numbers of decision variables, identify the constraints, make sure that your resources do not exceed those constraints. If you are familiar with applying different values to a particular scenario in order to figure out the optimum or the closest result depicting the actual results, you must appreciate the complexity this whole process brings. Today, we are going to focus on the Excel solver add-in though. If working with a large data set, some also consider adding the Excel plugin for conjoint analysis to cross-reference data to further optimize their workflow. It helps in simplifying the whole process of identifying the optimal solution to a problem, something that could take considerable time and painstaking effort, to something solved within a few clicks. Microsoft Excel Solver add-in is a great tool to perform complicated “What-If” analysis within no time. Must-Know Terminologies to Use the Excel Solver Add-in.Which Versions of Excel Provide the Solver Add-In?.

Excel solver function two distributions