Tag Archives: Data

Using the Solver add-in

Kornilios Ampatzis/ April 4, 2019/ Tutorials

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.

How to use Goal seek in Excel

Kornilios Ampatzis/ April 1, 2019/ Tutorials

Some of the most useful features in Excel, are hidden under the data ribbon button, What-If analysis. In this tutorial, we will try to explain and use the Goal Seek feature.