Excel What If Analysis Data Table Tutorial

In this chapter you will understand the possible situations where you can use the whatif analysis tools.

Excel what if analysis data table tutorial. For details on usage of these tools refer to the later chapters in this tutorial. To use the data table feature we will need some data. Select the scenario manager and give a scenario name and select the cell which contains the scenario value. However what if analysis enables you to easily compare the results of different scenarios.

Scenarios goal seek and data tables. By this we can enter multiple scenarios. Click the cell interestrate which is c2. First we need to copy the.

For example you might want to know how much loan you can afford for a home by analyzing different loan amounts and interest rates. Both are available under the data tab what if analysis. Go to the data menu tab and click on the what if analysis option under the forecast section. Now from the goal seek option from what if analysis select the value we want to compare.

You need both input and dependent cells to do. Before we start using the data table we need to do some changes to our data. A data table is a range of cells in which you can change values in some of the cells and come up with different answers to a problem. Three kinds of what if analysis tools come with excel.

Scenarios and data tables take sets of input values and determine possible results. The what if analysis with data table the dataset. On the data tab in the forecast group click what if analysis. Do the analysis with the what if analysis data table tool click the icon in the column input cell box.

Heres a table with 2 inputs book price and quantity.