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.

Enable the Data Analysis Toolpak add-in for advanced statistical analysis. This tool provides access to functions like Regression, ANOVA, and Descriptive Statistics.

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

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

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

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

To read a histogram in Excel, first install the Analysis ToolPak Excel add-on, then input your data and generate a histogram, with optional chart and cumulative percentage numbers.

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.