What-If Analysis: in Excel

Excel Data Analysis is a powerful tool that is used to visualize and gain insights of records in a spreadsheet.

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… read more »