Exploring LAMBDA for Custom Excel Functions
Derek Henry Overview:
In this course, you’ll learn how to build custom functions in Excel using the LAMBDA function. You’ll learn why LAMBDA functions are so helpful, how to build them using different examples, how LAMBDA custom functions differ from user-defined functions, and some tools to make them easier and quicker to use. You’ll save time, reduce errors, and make Excel easier to use.
Why you should Attend:
Do you work with a lot of Excel formulas, entering the same formulas over and over again? Do you find maintaining them and updating them a little tricky? Are you ready to learn a powerful way to make your formulas more simplified and reusable? It’s easier than you think to make your own custom functions.
Areas Covered in the Session:
- Learn the importance of the LAMBDA function
- Learn from three different LAMBDA examples
- Learn how LAMBDA is different from UDFs
- Learn several different tools for efficiently working with LAMBDA functions
Who Will Benefit:
- Analysts
- Accountants
- Auditors
- Executive Assistants
- Managers
- Directors
Speaker Profile
Derek Henry has an extensive 20+ year background in Accounting and IT, having held roles in public/corporate accounting and technical sales. He helps accounting and finance teams optimize their processes in Excel and beyond with training, tools, consulting projects, and productivity coaching. He is passionate about efficiency and accountability.
Derek is a Certified Public Accountant and a Certified Fraud Examiner. He lives with his family in Arlington, TX. He is actively involved at church, and enjoys disc golf, softball, and having fun with his family.