Excel can handle much-sophisticated models than the preceding example. To perform a what-if analysis using Excel, you have three basic options:
- Manual what-if analysis: Plug in new values and observe the effects on formula cells.
- 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.
- 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.
- 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