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 …

Learn about the many ways to create a table in an Excel worksheet, and how to clear data, formatting, or table functionality from a …

Have you ever used VLOOKUP to bring a column from one table into another table? Excel also includes a built-in Data Model that …

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

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 …

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 …

For a larger table or to customize a table, select Insert > Table > Choose row and column. Enter the number of columns and number …

In Microsoft Word, you can adjust a table's size and column and row dimensions, either manually or automatically. You can also …

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 …

If the pivot_table argument is a range that includes two or more PivotTables, data will be retrieved from whichever PivotTable was …