Assign a descriptive name to a range of cells (a “named range”), that can be used in formulas.| support.microsoft.com
To convert a table into a range, right-click anywhere in a table, point to Table, and then click Convert to Range.| support.microsoft.com
How to use the Total Row option in Excel to total data in an Excel table.| 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
Excel shows the #VALUE! error when your formula includes cells that have different data types (text and numeric values). The #VALUE! error is also shown when a formula references one or more cells that have text instead of numbers, and uses the standard math operators (+, -, *, and /) to add, subtract, multiply, or divide the different data types.| support.microsoft.com
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).| support.microsoft.com
Correct a #REF! error in Excel| support.microsoft.com
Master the art of Excel formulas with our comprehensive guide. Learn how to perform calculations, manipulate cell contents, and test conditions with ease.| support.microsoft.com