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