3-day Virtual Seminar

Custom Functions and Range Names

Overview

This session covers recent developments in Excel that allow you to create custom functions without VBA (macros). You will need the subscription version of Excel to follow along with this session.

The technique uses the new LAMBDA function and range names. A few other new functions are also covered.

Why you should Attend

Do you have long complex formulas? You might be able to convert them into simple, short custom functions that require just a few arguments. Do you have standard formulas you use frequently? Maybe custom functions can make entering it fast and easy.  

Areas Covered in the Session

• The advantages of custom functions
  
• The LET function (it works well with LAMBDA)
  
• How to create a LAMBDA and test it
  
• How to create a custom function using range names and LAMBDA
  
• How to document a custom function
  
• A new more flexible range reference syntax
  
• How to solve an issue with dynamic arrays and summing
  
• Free resources to assist with custom functions
  
• A macro to better document your custom functions
  

Who Will Benefit

• Accountants and Finance Staff