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.

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

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

Unlock the power of GROUPBY in Excel! Combine tables, create dynamic fields, and perform scalable data analysis with this comprehensive guide ...

On Monday, the company announced that its Copilot AI is now available as an Excel function for Microsoft 365 insiders. That means you can add COPILOT to a formula and then use natural language in a ...