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.

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.

Discover how Microsoft's Excel Copilot simplifies data analysis with natural language queries and boosts productivity. Excel’s AI Copilot ...

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more.

In this case, that’s E4. Click the Data tab. In the Data Tools group, click What-If Analysis and choose Goal Seek (Figure B). In Excel 2003, Goal Seek is on the Tools menu. Figure B ...

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

If you get prompted that the Solver Add-in is not currently installed on your computer, you will be prompted. Click Yes to install it. Now read: How to use Data Visualizer Add-In for Excel.

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