From the course: Excel: Productivity Tips

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using named range and table references

Using named range and table references - Microsoft Excel Tutorial

From the course: Excel: Productivity Tips

Start my 1-month free trial

Using named range and table references

“

- [Instructor] Alright, time to talk about simplifying formula references using named ranges and tables. So getting a little bit more complex here, this is a three star productivity tip, a little bit more advanced, a little bit more nuanced than some of the more basic tips that we've covered up to this point. But basically, what we're going to talk about here is how to use either named ranges or tables compared to raw cell ranges, like A1 through A10 to simplify a formula references. So for instance, let's say we're looking at data like this, where you've got a holiday table containing holiday labels for each date, and then some sort of transactional record as well. And we basically want to populate a column like column C here that says given the date, look up the holiday. And if it's a holiday, return the name otherwise return in none. Now, rather than referencing E2 through F16 in our formula, we can format that…

Contents