Types of What-If analysis in Excel

This article is part of my series: What-If Analysis in Excel – A Step by Step Complete Guide.

Excel can handle much-sophisticated models than the preceding example. To perform a what-if analysis using Excel, you have three basic options:

  1. Manual what-if analysis: Plug in new values and observe the effects on formula cells.
  2. Data tables: Create a special type of table that displays the results of selected formula cells as you systematically change one or two input cells.
  3. Scenario Manager: Create named scenarios and generate reports that use outlines or pivot tables.

We’ve discussed each of these types of what-if analysis in the rest of this categories.

Read also: Sensitivity analysis in Excel using one or two variables data table

Read More…

Performing manual what-if analysis in Excel


Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share here. Not only how to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned!

We will be happy to hear your thoughts

      Leave a reply