Named Ranges in Excel
This video tutorial explains how you can name ranges or cells for use within functions & formulas. It is a great follow-up to the last video lesson on Absolute & Relative cell referencing.
I’ve found it incredibly useful throughout Excel. It helps to alleviate the concern that you’re pulling information from the wrong area, and makes formulas more easy to follow.
If you found this Named Ranges video interesting, you may want to check out the Five Powerful Excel Tips video which goes over Dynamic Named Ranges (which allow for the named ranges to change as more data is added to them). It’s the first tip in the lesson!
Thanks again
Well done, Excel master!
I love your site! I am analyzing huge amounts of data that I import weekly from a database and utilize the named data ranges in formulas to pick up information. Sometimes it will grow or shrink in the number of rows (but never in the # of columns) when I sell something new. Is it possible to name a range of data that will automatically grow with the newly imported data?
Hey Ang,
Thanks for the positive feedback! What you’re referring to is ‘Dynamic Named Ranges’ which I go over first in my Five Powerful Excel Tips video: http://excelexposure.com/2012/10/02/excel-video-lesson-five-powerful-tips/
Let me know if you have any questions.
Very helpful video. I’ve known about named ranges for a while, but have always been afraid of not using them correctly. This finally gives me some confidence to start.
Great video. I can’t believe I’ve gone this long without naming!
Pingback: A Complete Introduction to Excel | MBAx.me
Amazing!
Thanks a million!!! This is the best video tutorial that i’ve found on the web… I’l be waiting for your next video on this subject. Thanks again
Very good for someone who is trying to learn @home .looking for some practice exercises
Really Fantastic Jobb!
For some of us this goes too quick, but still very helpful. It is good to know you can go online and learn these applications. The MUSIC has got to go!
Another fantastic lesson! Will need to watch this a couple of times, as it is so packed with useful information!
I agree. You’re approach is not complicated. Thank you so much for you’re efforts. I’m enjoying every lesson.
You’re very good at teaching! And it’s easy to follow!
Thank you!
I didn’t know about the Name Manager, that’ll come in handy.