Scribd
Upload
12 views

IT Lab-2 Assignment

Uploaded by

Rahul Nayak
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
12 views

IT Lab-2 Assignment

Uploaded by

Rahul Nayak
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 7

What is Excel Solver?

Excel Solver belongs to a special set of commands often referred to as What-if


Analysis Tools. It is primarily purposed for simulation and optimization of various
business and engineering models.

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. Apart from that, it can handle smooth nonlinear and non-smooth
problems.

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. 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.

How to add Solver to Excel

The Solver add-in is included with all versions of Microsoft Excel beginning with 2003,
but it is not enabled by default.

To add Solver to your Excel, perform the following steps:

1. In Excel 2010 - Excel 365, click File > Options.


In Excel 2007, click the Microsoft Office button, and then click Excel Options.
2. In the Excel Options dialog, click Add-Ins on the left sidebar, make sure Excel Add-
ins is selected in the Manage box at the bottom of the window, and click Go.
In the Add-Ins dialog box, check the Solver Add-in box, and click OK:
To get Solver on Excel 2003, go to the Tools menu, and click Add-Ins. In the Add-
Ins available list, check the Solver Add-in box, and click OK.

Note. If Excel displays a message that the Solver Add-in is not currently installed on
your computer, click Yes to install it.

Where is Solver in Excel?


In the modern versions of Excel, the Solver button appears on the Data tab, in
the Analysis group:

Where is Solver in Excel 2003?


After the Solver Add-in is loaded to Excel 2003, its command is added to
the Tools menu:
Now that you know where to find Solver in Excel, open a new worksheet and let's get
started!

Note. The examples discussed in this tutorial use Solver in Excel 2013. If you have
another Excel version, the screenshots may not match your version exactly, although
the Solver functionality is basically the same.

How to use Solver in Excel

You might also like