Skip to main content
Webinar banner
Excel Advanced Range Names
Paid Live Webinar $25 (includes live event, pdf manual and Excel file plus the recording) - a tax invoice will be sent.

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

Nov 20, 2018 10:00 AM in Perth

Webinar is over, you can not register now. If you have any questions, please contact Webinar host: Neale Blackwood.