Excel Functions for Accountants Part 05 (What if Analysis)

What-If Analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet. Three kinds of What-If Analysis tools come with Excel: Scenarios, Goal Seek, and Data Tables. Scenarios and Data tables take sets of input values and determine possible results.

Excel Functions for Accountants Part 06 (What-If Analysis?)