What-If Analysis: Scenarios and Goal Seek in Excel
What-If Analysis in Excel allows you to try out different values (scenarios) for formulas. The following example helps you master what-if analysis quickly and easily. Create Different Scenarios, Scenario Summary and Goal Seek. Navigation: Data Tab → Data Tools Group → What-If Analysis See Examples below: Assume you own a book store and have 100 books in storage. You sell …