Introduction to Range Names
August
06
2025
(Wednesday)
Time
08:00 AM PDT | 11:00 AM EDT
Duration: 60 Minutes
23 Days Left To REGISTER
Duration: 60 Minutes
23 Days Left To REGISTER
Instructor
Neale Blackwood
Neale Blackwood
Overview
Learn the basics, plus some powerful techniques to make your range names more dynamic. This session has everything you need to get started with using range names effectively.
Even if you have been using range names this session provides some useful shortcuts and techniques that you may not be aware of.
Why you should Attend
Build better formulas with range names. Speed up formula creation and make it easier to maintain and update your formulas. Avoid using dollar signs in your formulas. Add structure to your files and make them more flexible.
Areas Covered in the Session
- The three ways to create a name (some are much easier than others)
- Naming rules and suggestions
- Keyboard shortcuts
- Name intersections
- Formula-based names
- Using names with formatted tables
- Names and emojis
- Names and textboxes
Who Will Benefit
- Accountants and Finance Staff
Speaker Profile
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 Excel articles for the CPA Australia INTHEBLACK magazine since May 2002.
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.
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.
Access Recorded Version
One Attendee / Group Attendees
Unlimited Viewing Recorded Version for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)