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.

Microsoft Excel’s Data Analysis Toolpak is an invaluable add-in for those who require complex statistical or engineering analyses. This powerful feature allows users to execute a variety of data ...

Discover how Excel’s AI-powered Copilot() function transforms data analysis, automates tasks, and unlocks new productivity ...

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

Select B4:C4, click Data, and then choose Scenario Manager from the What-If Analysis drop-down in the Data Tools group. In the resulting dialog, don’t change anything. You’ve already set it ...

Overview AI Copilot in Excel lets analysts write formulas in plain English instead of complex syntax.Copilot makes Excel more ...

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.

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.