| 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. |
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.