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
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.
Instructor
Neale Blackwood