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

This course includes recordings from two separate live range name webinars plus some bonus range name content. As an added bonus I have included a recording of a live webinar I ran on Formatted Tables. Formatted Tables work brilliantly with range names.

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

Version: All
Recorded: Aug 2022
Level: Intermediate
Duration: 1 hour
Price: AU$25