Referring to Excel table data in formulas


show more Referring to Excel table data in formulas provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Referring to Excel table data in formulas

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

Referring to Excel table data in formulas
Video duration: 2m 3s 6h 32m Beginner

Viewers:

Referring to Excel table data in formulas provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...