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

Take your skills to the next level with advanced range name techniques that can improve your model development. 

The Advanced Course 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

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