Optimizing values in an Excel spreadsheet to meet a given objective can be an arduous process. Microsoft offers Solver, a numerical optimization add-in to assist in this task. While it can’t solve every problem, It can be a very useful “what-if” tool. Here is how to use it effectively.