Types of What-If analysis in Excel

Excel can handle much-sophisticated models than the preceding example. To perform a what-if analysis using Excel, you have three basic options:

1. Manual what-if analysis: Plug in new values and observe the effects on formula cells.
2. Data tables: Create a special type of table that displays the results of selected formula cells as you systematically change one or two input cells.
3. Scenario Manager: Create named scenarios and generate reports that use outlines or pivot tables.

We’ve discussed each of these types of what-if analysis in the rest of these categories.

Read More…

• What-If Analysis in Excel with Example
• What If Analysis Data Table Not Working
• How to Delete What If Analysis in Excel
• How to Do Sensitivity Analysis in Excel
• How to Get Sensitivity Report from Solver in Excel
• How to Perform Sensitivity Analysis for Capital Budgeting in Excel
• Sensitivity Analysis for NPV in Excel
• How to Build a Sensitivity Analysis Table in Excel
• How to Do IRR Sensitivity Analysis in Excel

<< Go Back to What-If Analysis in Excel | Learn Excel