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 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, 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 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 over time?
  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. Performing manual what-if analysis in Excel.
  4. One Variable Data Table in Excel 2013 [How to Create Guide].
  5. How to create a two-variable data table in Excel 2013.
  6. 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 🙂

Read More:

Solver Excel – A Step by Step Complete How-to-use Guide

How to calculate Average, Median, & Mode 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!

1 Comment
  1. Reply
    Mallory Stevens February 8, 2017 at 2:41 AM

    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.

    Leave a reply