What-If Analysis
Excel Tips and Tricks

What-If Analysis (Goal Seek, Scenario Manager and Data Table) in Excel

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-

  1. Scenario Manager
  2. Goal Seek
  3. Data Table

What-If Analysis is available in “Data” tab of Excel Ribbon-

What-If Analysis

Watch the step by step video tutorial:

Click here to download the practice files.

My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.