Microsoft Excel - Solver Example
Solver is a preinstalled add-in that just needs to be activated in Excel. Solver functions in a similar manner to goal seek except that you can change your set cell to a maximum, minimum, or set value as well as have multiple changing cells. On top of the added functionality you can set constraints for your changing cells. This video covers a basic example of where you might be able to use Solver.