Short guidance on how to activate ‘Solver’ in MS Excel.
Click on File → Options
Options ----→ Select ‘Excel Add-ins’ from dropdown button ----→Press ‘Go’
Check ‘Solver Add-in’ and press OK
Solver is now available under ‘Data’ ribbon