Excel Solver is a Excel tool that allows you to find optimal solutions for mathematical optimization problems. It works best for linear and often convex problems. In order to use the tool you must first activate it. The following tutorial uses the English version of Microsoft Office 2007
Start Microsoft Office Excel 2007. The following will display:
Click the Excel Office button, i.e., the large round button in the upper left corner. This brings up the main menu, which once was called the “File Tab”:
From here, click “Excel Options”, this brings up the following:
From the “Excel Options” panel. Select the tab “Add-Ins” on the left and look for “Solver Add-in” in the list of “Inactive Application Add-ins”. It should look something like:
Make sure it says “Excel Add-ins” on the drop down menu next to “Manage”. If you click “Go …” the following window will appear:
Ensure that the “Solver Add-in” is checked and click “OK”. After this you may have to answer the following dialog:
If this pops up simply select “Yes”. A installation window will appear:
This may take a few seconds, and you might be prompted for your Excel DVD. After this you’re done and will find the new button “Solver” under the “Data” tab.
Clicking on the “Solver” button will make the tool’s graphical user interface appear:
In order to actually use the tool, you may take a look at this example from Microsoft a>.