What If Analysis in Excel – A Step by Step Complete Guide

I am the president of my apartment (don’t think my age is huge (I’m mid-age) or I am over talented 🙂 ). A little apartment of total of 14 flats. If you never maintained a building, you don’t know how painful it is.

You will get no salary at the end of the day, but a good amount of your daily time will be occupied to maintain some silly jobs like water-lifting motor is not working, the guard will go on leave, and a lot like those.

At the end of the day, we have to calculate whether the service charge we are taking from the flat owners is sufficient or not.

Learn Excel Online: Top Excel Courses Online

Sometimes we think: “what if we increase the service charge by 500 BDT?” BDT is the short form of Bangladeshi Taka. You guessed right 🙂 I am from Bangladesh.

Okay! You have got an idea of how what-if analysis fits in your day-to-day life. Some more examples:

  1. What might be our yearly profit if we increase our product price by 5%?
  2. What if the interest rate on the loan I have taken changes to 16% rather than 14%?
  3. What will be our production if the workers do 1 hour overtime?
  4. And a lot of examples I can gather here.

Using Microsoft Excel, you can make complex models and perform those types of what-if analysis. I have made some step-by-step tutorials that will teach you how to build models to perform complex what-if analysis in Microsoft Excel.

  1. A What-If example in Excel.
  2. Types of What-If analysis in Excel.
  3. One Variable Data Table in Excel 2013 [How to Create Guide].
  4. How to create a two-variable data table in Excel 2013.
  5. Excel 2013 Scenario Manager To Do Scenario Analysis.

If you follow the above step-by-step tutorials, you will be able to perform any What-If Analysis in Excel.

Happy Excelling 🙂

Related Article



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

  1. Great example… thanks for laying out so nicely! One correction on the data table steps, the correct range is F3:N13:

    3. Select the range F3: N13 and choose Data ➪ Data Tools ➪ What-If Analysis ➪ Data Table. The Data Table dialog box will appear.

    • Hi there!

      I think the range is correct. Can you tell us why you think it is not? Thanks.

      Md. Shamim Reza (Exceldemy Team)

Leave a reply