Excel Video Lesson: Naming Ranges and Cells

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!

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *