What if Analysis in Excel

In Excel, What-if analysis is a process of changing cells’ values to see how those changes will affect the worksheet’s outcome. You can use several different sets of values to explore all the different results in one or more formulas. What-if Excel is used by almost every data analyst and especially middle to higher management professionals to make better, faster and more accurate decisions based on data. What-if analysis is useful in many situations, such as: o You can propose different budgets based on revenue. o You can predict the future values based on the given historical values. o If you expect a certain value due to a formula, you can find different sets of input values that produce the desired result. To enable the what-if analysis tool go to the Data menu tab and click on the What-If Analysis option under the Forecast section.