Overview

See how to use naming conventions to add structure and flexibility to your files. Create an unbreakable hyperlink with a range name. Discover some advanced ways ranges interact. Create a dynamic chart and see how to apply factor to existing formulas. 

Why you should Attend

See how to solve common Excel problems with range names
Broken hyperlinks? Range names can fix them
Trying to combine actuals, budgets and forecasts into a single report?  Range names can do it
Need a dynamic auto-updating chart? Range names to the rescue
Need to apply a factor to lots of different formulas? Range name can do it in four simple steps - no editing required

Areas Covered in the Session

• Naming conventions - what they are and how to use them to simplify formula creation
  
• Non-formula uses for range names - create an unbreakable hyperlink
  
• The INDIRECT function and range names
  
• 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
  
• Dynamic charts
  
• Applying Factors
  

Who Will Benefit

• Accountants and Finance Staff