Excel Relative Named Ranges - A Secret of Excel Pro Users

Relative named ranges are a super useful Excel tool, but they can catch out the unsuspecting user. In this video I uncover the reason the name manager sometimes returns kooky results and how to leverage this feature to create dynamic named ranges.

🔻 DOWNLOAD EXCEL FILE HERE: https://www.myonlinetraininghub.com/r...

🎓 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

💬 Please leave me a COMMENT. I read them all!

🧟‍♀️ CONNECT with Mynda on LinkedIn:   / myndatreacy  

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...

⏲ TIMESTAMPS
0:00 Introduction
0:31 What is a Relative Range
1:30 What is a Relative Named Range
2:47 Scope of Relative Named Ranges
3:19 Dynamic Sheet References
4:23 Key to Creating Relative Named Ranges
6:04 Relative Dynamic Named Ranges
11:21 File Download