Excel LAMBDA Function - Every Single Thing You Ever Wanted to Know

This course explains how to use Excel's LAMBDA function to define reusable worksheet functions without VBA. It also covers defined names, LET, LAMBDA helper functions, spilled-array formulas, and dynamic single-cell reports.

Syllabus

1. Introduction
2. Overview
3. Defined Names
4. First look at LAMBDA to create a re-usable function
5. Advanced Formula Environment
6. Summary of LAMBDA
7. Rate Of Change Re-usable LAMBDA function
8. COGS Re-usable LAMBDA function created in Advanced Formula Environment
9. Save LAMBDA to default file
10. Show Formula Re-usable LAMBDA function
11. LAMBDA Helper Functions
12. BYROW and BYCOL functions
13. MAP function
14. SCAN function
15. REDUCE function, initial look
16. Recursion with LAMBDA
17. REDUCE function, introduction and three examples
18. MAKEARRAY function
19. LET function
20. Single Cell Formula Reports
21. Single Cell End Of Month Report
22. Conditional Formatting For Dynamic Reports
23. Single Cell Cross Tabulated Report
24. Single Cell Report that can create four different reports
25. ISOMITTED function
26. Summary and Conclusions
27. Closing and Video Links