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 …

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.

Have you ever used VLOOKUP to bring a column from one table into another table? Excel also includes a built-in Data Model that lets you create relationships between tables, which can be an alternative to …

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

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.

How to use the INDEX function in Excel to return a value or reference to a value within a table or range.

Format your data as an Excel table (select anywhere in your data, and then select Insert > Table from the ribbon). If you have complicated or nested data, use Power Query to transform it (for example, to …

For a larger table or to customize a table, select Insert > Table > Choose row and column. Enter the number of columns and number of rows in the dialog box, and then click OK to insert the table.

In Microsoft Word, you can adjust a table's size and column and row dimensions, either manually or automatically. You can also change the size of multiple columns or rows and modify the space …

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.

If the pivot_table argument is a range that includes two or more PivotTables, data will be retrieved from whichever PivotTable was created most recently. If the field and item arguments describe a single …