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.

Learn essential Excel techniques to build robust financial models, forecast accurately, and impress stakeholders with your ...

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

Using Goal Seek in Excel for various financial tasks such as ratio analysis, budgeting, loan repayments, and retirement planning.

Next, have Excel run the regression on the two columns of return data you generated. Under the Data menu, the Data Analysis button allows you to select Regression.