Custom Functions and Range Names

Price: $25 incl GST

Duration: 90 minutes

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.

In this session we will cover

  • 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

As always, I will share a few general tips along the way.

Date: 29/04/2025
Time: 1:00 PM AEST
Event: Custom Functions and Range Names (90 min)
Topic: Custom Functions and Range Names
Public: Public
Registration: Click here to register.