Title: Writing Powerful Custom Functions with LET and LAMBDA

Session Outline:

Microsoft expert Diarmuid Early will be showing us how to write powerful custom functions using LET and LAMBDA. He’ll start things off with a brief introduction to the basics of writing custom functions with LAMBDA, including how to write, store, and share, as well as some comparison vs VBA user-defined functions. We’ll then move onto writing more complex formulas with LET – and how to do it while maintaining auditability. Then, he’ll show us how to combine LET and LAMBDA to make complex multi-step custom functions.

​Title: Writing Powerful Custom Functions with LET and LAMBDASession Outline:Microsoft expert Diarmuid Early will be showing us how to write powerful custom functions using LET and LAMBDA. He’ll start things off with a brief introduction to the basics of writing custom functions with LAMBDA, including how to write, store, and share, as well as some comparison vs VBA user-defined functions. We’ll then move onto writing more complex formulas with LET – and how to do it while maintaining auditability. Then, he’ll show us how to combine LET and LAMBDA to make complex multi-step custom functions.  Read More

​