Mastering Named Ranges

Thursday 26th June 6:30pm Perth (UTC 10:30am)

👀 Session is ONLINE only 👀

Session Outline:
Join Excel expert Neale Blackwood for a practical, hands-on session focused on making the most of named ranges in Excel. Learn how to create and manage names efficiently, use dynamic and flexible range techniques like TRIMRANGE, and apply real-world examples that enhance clarity and productivity.

• Best-practice naming conventions
• Dynamic named ranges
• Integration with Excel Tables
• Clever techniques like the hyperlink hack

Whether you're just starting out or ready to take your skills further, this session will give you immediately usable tools to improve your Excel workbooks.
Attendees will receive a comprehensive manual and workbook.

About Neale
Neale Blackwood is a Microsoft Excel expert with over 40 years’ experience as an Accountant and consultant. He has over 30 years’ experience using and writing about Excel. Neale has written over 250 articles for the CPA Australia INTHEBLACK magazine since May 2002.
In December 2022 Neale was awarded the CPA Australia, WA Division President’s Award for Excellence – Distinguished Service.
He has written and presented numerous Excel sessions at CPA events around Australia. He has recorded 50 Excel podcasts for the CPA Australia Excel Tips podcast series.
His first book, Advanced Excel Reporting for Management Accountants, was published in 2014 by Wiley.
He has presented over 450 live webinars on Excel since 2012 and written over 700 Excel blog posts.