How to use Solver in Excel

A quick walkthrough of how to use the Solver add-in in Excel for linear problems, yes / no (binary) problems, and arrangement problems.

Linear problem example from Exceldemy:

Binary problem from FMWC 2022 round 8:

Arrangement problem from FMWC 2021 round 4:

Sections
00:00 Linear problem
04:45 Binary decisions
08:35 Arrangement problem

[BhavyaGupta]

That's an awesome video on Solver 👏 Incredible that you explained different solver options in just under 13 mins. Waiting for the video on Actuarial problem.

[ExcelWizard]

Wow! You explained the 3 solver methods comprehensively in just 12 minutes.

[TheExcelLady_Ireland]

This was really helpful - particularly to see the binary options and to get an explanation of the three models. Thank you

[recalcordie]

Superb explanations! - and also interesting examples. Thank you Diarmuid!
Minute 1:50 = 😅

[steve_yu]

One of the reasons I loathe non-linear optimization questions, is that you have no way of knowing whether your solution is the absolute optimal one. For example, on FMWC 2022 08-A, my version of Excel calculated that watching these videos will bring you to exactly 13 hours 58 minutes (no time wasted) 😅:

Microsoft Excel World Championship 2022: Finals
Excel Esports Speedrun: Laurence Lau vs. Excel Wizard
Excel Esports: Women's Battle
Excel Esports: All-Star Battle
Excel Esports Continent Battles - Asia & Pacific
FMWC Open - Finals
Battle of 16 - Finals
XLOOKUP Function Explained by Andrew Ngai
Data Modeling in Excel - Square of Fortune Game Walkthrough