The Solver add-in to Excel expands your analytical toolkit by optimising your model output to fit your goals, such as minimising or maximising profits, costs, portfolio returns or units produced.
It’s like a powered up version of goal-seek. Dr. Kevin Kelly shows how to put Solver on your toolbar, set the model objective, set up your model, establish operational constraints, and let it run.