Sensitivity analysis in Excel 2007

1. Set up your model or calculation in Excel.
2. Identify the variables that you want to analyze.
3. Create a table that lists the possible values for each variable.
4. Create a formula that calculates the outcome of your model or calculation based on the values in your table.
5. Use Excel's built-in Data Table feature to perform the sensitivity analysis.
6. Specify the range of cells that contains your table of variable values and the cell in your formula that references the variable you want to analyze.
7. Excel will automatically calculate the outcome of your formula for each value in your table of variable values.

Performing sensitivity analysis in Excel 2007 is a powerful tool that allows you to explore how changes in certain variables affect the outcome of a particular calculation or model. This could be a financial model, a budget, or any other type of calculation that involves multiple variables. By following these steps, you can easily gain valuable insights into your calculations and models.