Excel tables provide a structure within your workbooks that you can use to store your data.…One major benefit of using Excel tables is that you can refer to table columns…in your formulas using those table and column names, which makes your formulas…easier for you to interpret.…Excel Tables consist of rows and columns of data.…If you want, you can include an entire column of data in a formula by creating…what's called a structured reference to the table column you want to include.…To refer to an Excel table and the column in a formula, you need to first find…out the table's name.…

The way that you do that is by clicking any cell that's part of the Excel table,…and then on the Tables tab of the Ribbon, click Rename.…When you do, the table's name appears in the Name box, here over on the side.…In this case, I've named the table SalesData.…So when I press Escape and scroll back up, I can now create my formula, because…I know the table's name.…So I'll type =, and I want to find the total of all the values in the Sales column,…