To make managing and analyzing a group of related data easier, you can turn a range of cells into an Excel table (previously known as an Excel list).

Learn about the many ways to create a table in an Excel worksheet, and how to clear data, formatting, or table functionality from a table in Excel. Discover more in this video.

When you create an Excel table, Excel assigns a name to the table, and to each column header in the table. When you add formulas to an Excel table, those names can appear automatically as you enter …

When you use Format as Table, Excel automatically converts your data range to a table. If you don't want to work with your data in a table, you can convert the table back to a regular range while …

How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.

Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

Calculated columns in Excel tables are a fantastic tool for entering formulas efficiently. They allow you to enter a single formula in one cell, and then that formula will automatically expand to the rest of the …

After you create an Excel table in your worksheet, you can easily add or remove table rows and columns. You can use the Resize command in Excel to add rows and columns to a table:

To find the top or bottom values in a range of cells or table, such as the top 10 grades or the bottom 5 sales amounts, use AutoFilter or conditional formatting.

Rename an Excel table to make it easier to find and refer to in formulas and references.

In Excel, a data table is a range of cells that shows how changing one or two variables in your formulas affects the results of those formulas.