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

Have you ever found yourself wrestling with Excel’s XLOOKUP function, wishing it could just do a little more? Maybe you’ve been frustrated by its single-column ...

Stop guessing! Susan Harkins shows you how to use Excel's Goal Seek what-if analysis tool to achieve your goals. If you ask me, Excel’s what-if analysis tools are under-used. I often respond to ...

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. Everyone knows Microsoft Excel as a ...