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