In this article, we you will learn about What-If Analysis in Microsoft Excel. You can use several different sets of values in one or more formulas to explore all the various results using What-If Analysis.
There 3 types of What-If Analysis tool in Excel-
- Scenario Manager
- Goal Seek
- Data Table
What-If Analysis is available in “Data” tab of Excel Ribbon-