How to get solver in Excel
You can watch a video tutorial here.
Solver is a program in Excel that is used for what-if analysis. This comes with Excel as an add-in program and is not installed by default. If you cannot find the Solver program under Data > Analyze, then you need to load it.
Step 1 – Open the Excel options window
– Go to File > Options
Step 2 – Manage the Add-ins
– Go to Add-ins
– Select Excel Add-ins from the Manage drop-down
– Click Go
Step 3 – Load the Solver add-in
– Select Solver add-in
– Click OK
Step 4 – Check that the Solver has been added
– Go to Data > Analyze
– Check that the Solver has been added