This session demonstrates the use of the Advanced Formula Environment to manage and edit LAMBDA formulas in Excel.  It will demonstrate the development of simple introductory LAMBDA formulas in Excel worksheet, then more practical and useful ones, and finally introduce and demonstrate the use of the Advanced Formula Environment to create, edit and manage the LAMBDA formulas in a workbook project.  The participant will gain some very practical and useful functions that they can deploy in their own projects as well as learning how to use the LET and LAMBDA functions and the Advanced Formula Environment to develop solutions to common problems that otherwise require quite complex calculations in models and analyses.

Participants should be familiar with Excel and comfortable working with formulas and functions such as IF, INDEX, MATCH, XLOOKUP and familiarity with the use of the LET function is a distinct advantage.  If unfamiliar, we would recommend that participants complete module T09 first..