Two-Variable Data Table Setting Up a Two-Variable Data Table: List one set of values horizontally and the other set vertically. Enter the formula above the vertical list of values.

In Excel, three primary tools are available for performing What-If Analysis: Scenarios, Goal Seek, and Data Table. To recap the last couple of months, here are brief definitions of Scenarios and Goal ...

While many charts only involve one variable, you can create charts that have multiple variables. To do this, you need only to create a table with multiple columns.

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.

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques.

You can use the RAND () function to establish probability and create a random variable with normal distribution.

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.