Formulas you enter in Excel table columns automatically fill down to create calculated columns.| support.microsoft.com
When you create an Excel table, a table Header Row is automatically added as the first row of the table, but you have to option to turn it off or on.| support.microsoft.com
How to use the Total Row option in Excel to total data in an Excel table.| support.microsoft.com
How to use the SUBTOTAL function in Excel to return a subtotal in a list or database.| support.microsoft.com
How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.| support.microsoft.com
Learn how to add rows and columns to an Excel table.| support.microsoft.com
Format an Excel table by applying different table styles or colors.| support.microsoft.com
How to use AutoFilter in Excel to find and work with a subset of data in a range of cells or table.| support.microsoft.com
Share Excel table data on a SharePoint site by exporting the table.| support.microsoft.com
To ensure that an Excel workbook does not have compatibility issues that cause a significant loss of functionality or a minor loss of fidelity in an earlier version of Excel, you can run the Compatibility Checker. The Compatibility Checker finds any potential compatibility issues and helps you create a report so that you can resolve them. This article details some of the issues that may arise if your workbook contains Excel tables.| support.microsoft.com
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.| support.microsoft.com
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.| support.microsoft.com
Use data validation rules to control the type of data or the values that users enter into a cell. One example of validation is a drop-down list (also called a drop-down box or drop-down menu). Watch more in this video.| support.microsoft.com
Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.| support.microsoft.com