Performing manual what-if analysis in Excel

This article is part of my series: What-If Analysis in Excel – A Step by Step Complete Guide.

A manual what-if analysis doesn’t require too much explanation. In fact, the example we have used in the previous article (A What-If example in Excel) demonstrates how it’s done. Manual what-if analysis is based on the idea that you have one or more input cells that affect one or more key formula cells. You change the value in the input cells and see what happens to the formula cells. You may want to print the results or save each scenario to a new workbook. The term scenario refers to a specific set of values in one or more input cells.

Read more: Sensitivity Analysis in Excel Using One or Two Variables Data Table

Manual what-if analysis is very common. People often use this technique without even realizing that they’re doing a type of what-if analysis. This method of performing what-if analysis certainly has nothing wrong with it, but you should be aware of some other techniques.

If your input cells are not located near the formula cells, you can consider using a Watch Window to monitor the formula results in a movable window.

Read More…

Types of What-If analysis in Excel

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 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/

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo