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 More…

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Kawser Ahmed
Kawser Ahmed

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