Learn about the SORTBY function, which sorts the contents of a range or array based on the values in a corresponding range or array. SORTBY is in a class of functions called dynamic arrays.| support.microsoft.com
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
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
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
Learn about the RANDARRAY function for creating arrays of random numbers between 0 and 1. RANDARRAY is in a class of functions called dynamic arrays.| support.microsoft.com
How to correct a #SPILL error in Excel (when a formula returns multiple results and cannot return them to the grid).| support.microsoft.com
Learn about how Excel's dynamic, and spilled array formulas behave.| support.microsoft.com
Learn about the UNIQUE function, which returns a list of unique values in a list or range. UNIQUE is in a class of functions called dynamic arrays.| support.microsoft.com
Learn about the SORT function, which sorts the contents of a range or array. SORT is in a class of functions called dynamic arrays.| support.microsoft.com
How to use the FILTER function in Excel to filter a range of data based on criteria you define.| support.microsoft.com