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.
Read also: Sensitivity analysis in Excel using one or two variables data table