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.

Many Excel users have hit these roadblocks and wondered if there’s a more powerful tool out there. Enter SuperXLOOKUP—a fantastic option that promises to transform your data analysis experience.

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

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

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.