An curved arrow pointing right. Don't waste time testing different values individually in Excel. Use a data table to show the results for many different possible scenarios at once. Follow BI Video ...

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

What Is The Use Of What If Analysis In Excel How It Can Be Useful In Business Operation? With Excel’s What-If Analysis tools, you can explore all the possible outcomes by putting different values into ...

Using a scenario, Excel could automatically substitute specific values for cells on a worksheet based on a set of saved values. The What-If Analysis tool can be found on the Data tab, in the Data ...

Understanding the right and wrong ways to use what-if analysis not only saves time and money, it also can lead to actionable results.

1. Make A Budget Once you enter your financial information into a blank spreadsheet, you can tell Excel to perform calculations and analysis using formulas.

Susan Harkins continues her review of Excel's analysis tools with Scenario Manager.