This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

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.

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.

However, that data can then be represented on a graph, with axes corresponding to the different variables in the table. A horizontal axis on a graph corresponds to one variable from a data table.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool.

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...

Prevent duplicates before they happen by combining a simple function with data validation.