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
Advanced Range Names
The Advanced section covers techniques that can be applied to reporting models, dashboards, budgets and forecasts. The Advanced section covers
- Naming conventions – what they are and how to use them to simplify formula creation
- Non-formula uses for range names – create an unbreakable hyperlink
- Linking between files – technique to reduce broken, or corrupted links
- Advanced techniques – creating a sheet name range name and some advanced ways to refer to ranges
- The INDIRECT function and range names
- One Formula to Rule Them All – an amazing technique that can be applied to many situations – a single formula to extract Actuals, Budgets and Forecasts
- Advanced range reference techniques
Level: Intermediate
Duration: 3+ hours with 1+ hours bonus
Price: AU$49