Advanced Range Names

 Price: $35 incl GST

Duration: 1.5 hours

This is one topic that can add both structure and flexibility to your Excel models. These techniques can be applied to most Excel files including reporting models, budgets and financial models. Range names have many advantages. Range names can

  • make formulas faster to create and easier to read, understand and maintain
  • reduce the need for absolute and mixed references (fewer $ signs in formulas)
  • define input areas
  • allow you to easily navigate in a large workbook
  • make working with macros more reliable
  • create dynamic ranges that expand and contract as data is added or removed
  • create robust linking between files

This is a longer than normal session (1.5 hours) and covers many advanced techniques. These techniques can be applied to reporting models, dashboards, budgets and forecasts.

The session will cover

  • 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
  • Functions – that work well with range names, especially the INDIRECT function
  • 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
  • Controls – using range names with controls

As always, I will share other tips and tricks along the way.

 

Date: April 27, 2017
Time: 1:00 PM AEST
Event: Webinar - Advanced Range Names (1.5 hours)
Topic: Range Names
Public: Public
Registration: Click here to register.