Advanced Excel 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
  • 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
  • Dynamic charts
  • Applying Factors

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

Date: 17/04/2025
Time: 1:00 PM AEST
Event: Advanced Excel Range Names
Topic: Advanced Range Names
Public: Public
Registration: Click here to register.