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 to an Excel table, those names can appear automatically as you enter …

Formulas you enter in Excel table columns automatically fill down to create calculated columns.

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.

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.

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). Note: Excel tables should not be confused with the …

If you are writing a dynamic array formula to act on a list of data, it can be useful to place it in an Excel table, then use structured references to refer to the data.

You can quickly total data in an Excel table by enabling the Total Row option, and then use one of several functions that are provided in a drop-down list for each table column.

Spilled array formulas aren't supported in Excel tables. Try moving your formula out of the table, or converting the table to a range (select Table Design > Tools > Convert to range).

You can perform calculations and logical comparisons in a table by using formulas. The Formula command is found on the Table Layout tab, in the Data group. A formula in Word automatically …

Learn about the calculation methods that are available, how calculations are affected by the type of source data, and how to use formulas in PivotTables and PivotCharts.