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…


<< Go Back to What-If Analysis in Excel | Learn Excel

What is ExcelDemy?

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

Kawser Ahmed is a Microsoft Excel Expert, Udemy Course Instructor, Data Analyst, Finance professional, and Chief Editor of ExcelDemy. He is the founder and CEO of SOFTEKO (a software and content marketing company). He has a B.Sc in Electrical and Electronics Engineering. As a Udemy instructor, he offers 8 acclaimed Excel courses, one selected for Udemy Business. A devoted MS Excel enthusiast, Kawser has contributed over 200 articles and reviewed thousands more. His expertise extends to Data Analysis,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo