Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Excel Relative Named Ranges - A Secret of Excel Pro Users. That video is uploaded by MyOnlineTrainingHub at 2020-02-26T15:00:06-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [gCo0zL3-OtE]
| Name | Excel Relative Named Ranges - A Secret of Excel Pro Users |
| Video Uploader | Video From MyOnlineTrainingHub |
| Upload Date | This Video Uploaded At 26-02-2020 23:00:06 |
| Video Discription | 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/relative-named-ranges 🎓 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: https://www.linkedin.com/in/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/excel-forum ⏲ 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 gCo0zL3-OtE |
| Category | Science & Technology |
| Tags | excel named ranges | excel relative named ranges | excel named range |
