- Key features
- Speaker
- Further information
We’ll cover:
• Structure Data Effectively - Work with Excel Tables, structured references and good spreadsheet design practices to create more reliable models.
• Conditional Formatting - Use colour scales, icons, and rules to automatically highlight KPIs, targets, deadlines, and variances, turning raw data into instantly understandable visuals.
• Work Faster with Everyday Productivity Features – Improve speed with shortcuts, tricks of the trade, and utilise everyday Excel features to handle typical Excel frustrations.
• Link Financial Data with Lookup Techniques – Retrieve and connect information across spreadsheets using XLOOKUP and modern lookup methods for reconciliations, reporting and financial analysis.
• PivotTables in Action - Discover how to quickly summarise and analyse datasets using PivotTables — one of Excel’s most powerful yet accessible reporting tools.
By the end of this session, you'll have the techniques to apply immediately in your work for greater efficiency. It’s time to feel confident in Excel.
Alan Murray
Alan Murray is an Excel trainer, founder of Computergaga.com and author of the Advanced Excel Success and Advanced Excel Formulas books. He has been helping people in Excel for over 23 years. He loves training and the joy he gets from knowing he is making peoples working lives easier. Alan’s Computergaga YouTube channel has over 650 videos and over 50 million views. He also runs the monthly London Excel Meetup Group, where people learn, network, and enjoy each other’s company.
The webinar handout material will be available on the webinar platform when you log in to view the session.
If you wish to view or download handout materials, before starting the webinar, they will also be available through your document library on https://events.accaglobal.com
This event was recorded on 23 Sept 2026
Price
Price (excluding VAT) 110 GBP
Location
United Kingdom
Date & time
On demand
Enquiries
Email enquiries UKCL@accaglobal.com
Course provider