In Excel 2007, click the Microsoft Office button, and then click Excel Options. In Excel 2010 - Excel 365, click File > Options.To add Solver to your Excel, perform the following steps: The Solver add-in is included with all versions of Microsoft Excel beginning with 2003, but it is not enabled by default.
For example, it can help you maximize the return of investment, choose the optimal budget for your advertising campaign, make the best work schedule for your employees, minimize the delivery costs, and so on. While Solver can't crack every possible problem, it is really helpful when dealing with all kinds of optimization problems where you need to make the best decision. Please see Excel Solver algorithms for more details. Apart from that, it can handle smooth nonlinear and non-smooth problems. The Excel Solver add-in is especially useful for solving linear programming problems, aka linear optimization problems, and therefore is sometimes called a linear programming solver.
It is primarily purposed for simulation and optimization of various business and engineering models. Excel Solver belongs to a special set of commands often referred to as What-if Analysis Tools.
