Tag: How to do a what if analysis in excel

Excel What-if Analysis: Goal Seek

Ever find yourself wondering if Excel could help you answer the question: "What values would I need to get a known result?" The What-if Analysis features, available in Excel 2010 and up, give you the tools to do just that. Unlike functions and formulas that take given values and return…
Read More

Excel What-if Analysis: Scenarios

If you think of Excel as just a database for storing dead data, you will be pleasantly surprised to learn about Excel's What-if analysis tools. Excel offers several features that allow a user to make predictions, or evaluate outcomes based upon variable inputs. In this article, we are going to…
Read More