Solver is a very powerful add-in for solving linear programming problems. To install Solver, complete the following steps:
Step 1. Click the office button, and click the excel options button
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjP_LSxQoDS9r5mJptmwO3HBmzFFBnBkDltxoDucVEUsQXgIg7qqDJ59G7-rj3EfEtXArm-mQHq_oaXaxK1LGCCwzQLfmADlVLefrh51_PiJbqiTBjw8n4G56_6ngFnYJn-uH1ock6Zhmc/s320/excel_options.bmp)
Step 2: Click Add-Ins, and then click "GO" to manage add-ins
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8kuSovFEkdhb37uEpEtiveabfbWefoLYu9svtU4622yVmD3AMYoPenkJHiyzRuRCCscArejuE3Ae-fHANxlt1A_cFu3kdJlk1oaKPnvSKsSLEhp4FbFC_3INXQ2dNaLmldWMjum5jljY/s320/excel_options2.bmp)
Step 3: Now, just click to add the Solver add-in and click OK
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRyzTKJj4GDxKR4wEuEHnvtonPEa3g2bsztK8tYH-6JM9bgmsyOkGgCiudsmKEZEZQWNeoSiCpfbbIU5ZVmWD_WNeNM_ihvSl3moa1rZ2aBJtDnJEZQf1HowK-gxDUki_TiJnNdMKHpmw/s320/excel_options3.bmp)
Step 4: After install you can start using the Solver! Solver is now located on the Data -> Analysis toolbar.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6T2TId6bipnZE7ORQ9-zt0TRNh4nZ4RVvGeQEs90d6u8z0MvLOSkqjZnAZqDGiA6Gs4CAEuCLhqhBj6s3rmTaP8ltUzWd0a7NJlYbSYLMemHgCFQyVeLrDbPadOJ8Qr0wC4mEmveakPg/s320/excel_options4.bmp)
![](file:///C:/DOCUME%7E1/jeastham/LOCALS%7E1/Temp/moz-screenshot-16.jpg)