In contrast, Excel has no functions that return a table, but some functions can work with arrays. The ability to easily reference complete tables and columns is a new feature in Power Pivot.

Learn what PivotTable and PivotCharts are, how you can use them to summarize and analyze your data in Excel, and become familiar with the PivotTable- and PivotChart-specific elements and terms.

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 …

This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get the same result.

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.

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

Use different ways to calculate values in calculated fields in a PivotTable report in Excel.

Where possible, we’ve included examples with some of the dynamic array functions, as well as existing array formulas entered as both dynamic and legacy arrays.

Tips: Consider one of the newer lookup functions, depending on which version you are using. Use VLOOKUP to search one row or column, or to search multiple rows and columns (like a table).

Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.