Reference named ranges and named tables in formulas

- [Instructor] When you create an Excel table, … Excel assigns a name to that table … and to each column header in the table … and then when you create a formula and add it to your table, … those names appear automatically … as you enter the formula and select the cell references. … That way, we don't have to manually enter … the cell references. … Let's jump right into our workbook … and take a look at how to use both … named ranges and named tables in our formulas. … First, we'll focus on the invoices worksheet. … This data has been converted into a table … and when that table was created, … Excel created names for the vendor ID, company, … invoices, payments, and balance columns. … So watch what happens when I create a formula … to take the invoice amount … and deduct the payment amount from it, … equals, … as soon as I click in the invoices column, … the title of that column pops in. … I'll do a minus sign and click in Payments. … As I'm creating this formula, … Excel is taking into account all of the data …