Using the Solver add-in
In another tutorial we saw how we can find ourselves a better loan for a new car, using Goal Seek . Although Excel’s Goal Seek is a powerful tool, it has one basic limitation. It allows only one variable to be changed to help us achieve our goal.
Excel provides an even more powerful tool that bypasses this limitation. The Solver. The Solver is in the form of an add-in which must be enabled before you can use it.