This guide will walk you through the three primary what-if analysis tools in Excel: Scenarios, Goal Seek, and Data Tables, along with additional tools like the Solver add-in.

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. Produced by ...

Learn how to use Excel’s What-If Analysis tools, including Goal Seek and Scenario Manager, to explore different scenarios and outcomes based on variable data inputs.

Use Data Table for what-if analysis. Old-school Excel came with a forecasting ability that looked at historical data and made forecasts with a high-low numeric range, but it was fairly linear ...

Learn how Power Pivot transforms Excel into a powerful tool for managing complex datasets, advanced calculations, and data integration.

How to Make a Regression Table in Excel. Microsoft Excel 2010 comes with an expansion pack called the Analysis ToolPak that includes a number of analylitical tools, like the ability to create a ...

You’ll find it under the Formulas tab, in the Formula Auditing group. Once you open it, just hit Add Watch and select the cells you want to monitor. The pop-up will show you the sheet name, cell ...

This 3-day hands-on workshop will show you how to use Microsoft® Excel for making sense of data. You will enhance your data analysis skills and learn how to interpret Excel output.