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.

Learn how to use Excel’s What-If Analysis tools, including Goal Seek and Scenario Manager, to explore different scenarios and outcomes based on variable data inputs.

An curved arrow pointing right. Don't waste time testing different values individually in Excel. Use a data table to show the results for many different possible scenarios at once. Produced by ...

What is a pivot table, and why should you create one? Before we dive into pivot tables in Excel, letâ s have a quick word about it. A pivot table is a powerful tool in Excel to summarize and ...

During a What-If Analysis, the worksheet is altered to see how the changes will affect the formulas. Scenarios, Goal Seek, and Data Tables are three types of What-If Analysis tools in Excel. With ...

Goal Seek is a What-if Analysis feature in Excel. Learn how to use it to calculate the changing value in cell, and more!

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

Microsoft Excel’s Data Analysis Toolpak is an invaluable add-in for those who require complex statistical or engineering analyses. This powerful feature allows users to execute a variety of data ...

Just as Excel can perform basic data analysis functions, it has a surprising number of data visualization tools under the hood.

Excel's Data Model feature allows you to build relationships between data sets for easier reporting. Here's how to use it to make data analysis easier.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.