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

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

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

Microsoft Excel has hundreds of tools that you can use to make your spreadsheets tick. However, if you're looking to level up your expertise, get to know these six essential features today.

The trick involves using Excel’s Go To Special, Blanks tool to repeat account numbers and descriptions on each row to make your data pivot-ready. This enhanced format helps to unleash Excel’s full set ...

Success in business and science means making smart decisions. And those require the kind of information you can only get from sophisticated data analysis. It’s a growing field with huge opportunities.

When discussing Excel-based reports or data analysis in meetings, I can take notes directly in OneNote and link them to the relevant Excel files.