Learn How To Master Named Ranges In Excel In Just 35 Minutes [Full Course]

In this week’s training, I will show you how to do Ultimate Named Range.

⬇𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗜𝗦 𝗪𝗘𝗘𝗞'𝗦 𝗪𝗢𝗥𝗞𝗕𝗢𝗢𝗞 𝗧𝗘𝗠𝗣𝗟𝗔𝗧𝗘 𝗛𝗘𝗥𝗘:

EXCEL COURSES:

EXCEL PRODUCTS:


TIMESTAMPS:
0:00 – Introduction
0:39 – Overview
3:44 – Named Ranges Detail
22:09 – New Named Range Workbook Scope
23:26 – Hidden Workbook Scope
24:15 – Show All Named Ranges
25:24 – List All Named Ranges
27:18 – Show Hidden Named Ranges
28:55 – Delete Named Ranges
29:20 – Delete Hidden Named Ranges
31:16 – Find Value Using Named Ranges

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!

Thank you very much for your continued support,
Randy Austin

#exceltraining #ultimatenamedranges #namedrange #excelvba

[rabihbadr]

This is most probably the best Excel channel on youtube.

[osoriomatucurane]

Awesome tutorial, concise and crystal clear! Thank you Sir!
You really master the art of teaching by all standards. I never knew why with the dynamic named range offset formula we included the headers, then subtract one. Just to find out that the formula is being tweaked so to prevent it from breaking down.

[emile]

Very complete, thanks, learned about hidden names
The only thing I could see lacking in that video, is making a name from a column of a Table, and because the Table expands itself, so does the name (a sort of dynamic name without formula)

[BRASSBELL]

A lots of love from INDIA... thanks a lot for your teaching us....

[josemanuelherediagonzalez]

Amazing video! I finally understand how to use name references. Thank you so much!

[SyedMuzammilMahasanShahi]

Thanks Randy for this beautiful video.

[rolandnormiljacques]

As usual a brilliant and informative video. thanks!

[Lamouettekamikaze]

Your UI (as usual) is so freaking cool !

[Thukai-Operater]

Sir can i also make the same thing on ms excel 2007 and how did you maoe the first sheet matter❤

[anupyadav]

Your video is very good and very interested very interested

[tuanoananh]

thanks for useful video. Easy to understand ^^
13:42

[macman]

Another great lesson! I decided to watch this as I am procrastinating on fixing my SMS sender. I completed it but have an error so I may breakdown and download the file for comparison or post a question on the facebook forum if that doesn't work. Learned more great stuff as usual including the Paste List which I was unaware of.

[VenemAcademy]

Thnx Randy, this clear things up :-) great! Marry X-mas 2all

[alfredreloj]

This is very educational.. Trying to merge 3 workbooks into 1. (Customer Manager, Invoice Payments and create invoice) .. I'm an absolute beginner so this really helps. Thanks Randy!

[garyevans]

As usual a brilliant and informative video.
I think there is one more feature that would be worth adding to the video.

In VBA a named cell can be referenced by putting the name in square brackets.

For example in the macro Sub

The line Sheet1.Range("B8").Value = FoundInvRange.Row

Can be replaced by [ReferenceName].Value = FoundInvRange.Row

If we name the cell B8 in sheet1 as ReferenceName



Hope that's helpful.

[LarsIngeHolen]

I like this 👍 Do you have something like this about data mapping?

[mumbaitiger]

Super Video.
Merry Xmas to you.
Will this work in Excel 2007

[hoangphamanh]

This is great. How can i download it, i think the link is broken. It did not send me anything after i fill in the information.

[moesadr]

Awesome training video, thank you. Does anyone knows how to ensure that the cells in each Name Ranges will stay sorted ( alphabetically, small to large if numbers, etc). If it helps, for example if later I add more company names to the existing list, how I can sure that the list will be sorted properly on the Drop Down list? Can we modify the formula instead of writing a macro or VBA and or doing it manually each time? Thank you

[TsiriniainaRakotonirina]

Hello Randy,
Where can I purchase those 120Workbooks please? I'm very interested to purchase that to support you and learn at the same time as well. Thank you so much for your training, I'm so grateful to you as I learned so much already