Price and Quantity are input ranges in the data table in our example. It’s calculated by multiplying the price with the quantity of product sold. Total sales are the output cell in the data table.
In the example below, we want to find out how the Total Sales change if price and/or quantity of the product sold changes.
Two Way Data TableĪ two-variable data table is used when you want to see how the final result changes when two of the input variables change simultaneously. Instead of creating different scenarios, you can create a data table to quickly try out different values for formulas. Data TableĪ 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. It is very beneficial because with this tool one can easily adjust values in the formula. Goal Seek is another tool of What-if analysis feature, which helps to adjust a value used in a formula to achieve a specific goal. In that case, you don’t have to do it manually. If you change the value of two variables it will automatically make the rest of the changes. If you want to change two variables in your data then you can use this tool to do so. Scenario Manager is one of the tools of What-if feature and it helps you in comparing multiple sets of data. Then you can push S / G / T for Scenario Manager / Goal Seek / Data Table respectively.
The feature is very beneficial as it saves your time and makes your work easier.Īlt A W is the Excel shortcut that helps to get to What-If analysis quickly. The What-if analysis feature of MS Excel helps in swapping multiple sets of data and comparing them side by side.
0 kommentar(er)
