How To Use Excel What If Analysis

For this we must have data of such kind where for a single parameter we would have 2 or more values for comparison.

How to use excel what if analysis. Business owners use what if analysis for analyzing different scenarios in excel. 9 322 which 18 equals exactly to rs. 19 786 is the outgoing amount. The emi calculated rs. With a data table in excel you can easily vary one or two inputs and perform what if analysis.

By using what if analysis tools in excel you can use several different sets of values in one or more formulas to explore all the various results. Scenarios data tables and goal seek. Click on the what if analysis button and choose scenario manager from the list of options. What if analysis scenario manager can give a summary with input numbers and current values together. Go to the data menu tab and click on the what if analysis option under the forecast section.

What if you want to know how many books you need to sell for the highest price to obtain a total profit of exactly 4700. Excel will reverse calculate and immediately give you the value rs. For example you can do what if analysis to build two budgets that each assumes a certain level of revenue. To use excel s what if analysis tool begin by clicking on the data tab on the ribbon and locating the what if analysis tool button under the data tools section. What if analysis is one of the most powerful excel features and one of the least understood.

On the data tab in the forecast group click what if analysis. That s how easy what if analysis in excel can be. However excel s what if analysis function was designed for just such an occasion. There are three different tools available in excel to perform what if analysis. What if analysis goal seek takes a few seconds to perform calculations.

What if analysis is one of the most common processes that data analysts managers or excel users tend to use these days for advanced business analysis. You can use what if analysis to estimate your monthly savings that meet your retirement goals find the return rate of an investment plan your budget and so on. What if analysis in excel is used to test more than one value for a different formula on the basis of multiple scenarios. Refer to our article on what if analysis two variable data table. In most general terms what if analysis allows you to test out various scenarios and determine a range of possible.