Range names are a powerful Excel feature. It is however a topic that splits the Excel community. Some people think they add extra complexity to a file. I believe, when they are used correctly, that they add both structure and flexibility to your models and are a worthwhile addition to your Excel toolbox.
You can make up your own mind when you see all the advantages with using range names
formulas are easier and quicker to create
formulas are easier to read, maintain and modify
reduced use of the $ signs in formulas
you can define specific range and make selecting then a two click process
range work well with macros
create ranges that automatically expand or contract
Range Name Essentials
Learn the basics, plus some powerful techniques to make your range names more dynamic. This session has everything you need to get started with using range names effectively.
Even if you have been using range names this session provides some useful shortcuts and techniques that you may not be aware of. This Essentials section covers
the three ways to create a name (some are much easier than others)
naming rules and suggestions
keyboard shortcuts
name intersections
formula-based names
using names with formatted tables
Versions: M365 (subscription)
Recorded: September 2026
Level: Intermediate
Duration: 1 hour
Price: AU$25
The session materials
a pdf manual which you can print out and make notes in
Excel file to work through during the session
the completed file to review if you need to
Test your new found knowledge with these 10 questions.