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.

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

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

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

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.

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

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.