In Excel what if analysis lets you answer questions with data. With what if analysis Excel also lets you experiment with data.
Let's saying you're trying to solve a complicated problem with Excel, like calculating an unknown value. You could try solving it on your own, plugging in different numbers until you find the right answer. However, this method could take a lot of time and effort.
Instead of calculating the answer by yourself, you could use a powerful Excel tool called what-if analysis. This feature makes it easier to experiment with your data. In this lesson, we'll show you how to use what-if analysis to answer different types of questions.