Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: What-If Analysis:

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 a certain % for the…