Excel's Solver is a numerical optimization add-in (an additional file that extends the capabilities of Excel). It can be fast, easy, and accurate. It is not, however, a 100 percent guaranteed silver bullet
Accessing Excel’s Solver
Reviewing the Solver Parameters Dialog Box
Using Excel’s Solver: General Description
Using Excel’s Solver: An Example (Solver.xls)
Two Dangers of Numerical Optimization