Excel Advanced Range Names

 Price: $25 incl GST

Duration: 1 hour

This session covers many advanced techniques. These techniques can be applied to reporting models, dashboards, budgets and forecasts.

The session 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

As always, I will share a few general tips along the way.

Date: 23/09/2021
Time: 1:00 PM AEST
Event: Excel Advanced Range Names
Topic: Excel Advanced Range Names
Public: Public
Registration: Click here to register.