Types of What-If analysis in Excel

Get FREE Advanced Excel Exercises with Solutions!

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 these categories.

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

Read More…

Performing manual what-if analysis in Excel

Khan Muhammad Kawser

Khan Muhammad Kawser

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 them here. Not only a how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can check out my courses at Udemy: udemy.com/user/exceldemy/

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF