Using What-If Analysis, you can visualize the effects of different variables, making it easier to assess risks and opportunities. In Excel, three primary tools are available for performing What-If ...

Select the entire data table range and go to the Data tab, select What-If Analysis > Data Table. Specify the row and column input cells corresponding to the horizontal and vertical variables. Example: ...

During a What-If Analysis, the worksheet is altered to see how the changes will affect the formulas. Scenarios, Goal Seek, and Data Tables are three types of What-If Analysis tools in Excel. With ...

Stop guessing! Susan Harkins shows you how to use Excel's Goal Seek what-if analysis tool to achieve your goals.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.