Load Solver Add In
The Solver add in is not automatically visible in Excel. You need to load the solver add in to be able to use it.
In order to do this you need to follow these steps.
Go to the file button and click on options
Go to Add-Ins and click on the Go Button
Choose the Solver Add-in and click OK (if you click OK and it asks for disks you need to speak to your IT department)
You will see the Solver button in the Data Ribbon, right at the end