Excel LAMBDA, LAMBDA Helper Functions, and Eta-LAMBDAs - The Complete Guide 2024

Overview

Dive into a comprehensive 1 hour 47 minute video tutorial exploring the full capabilities of Excel's LAMBDA function, LAMBDA Helper Functions, and Eta-LAMBDAs. Learn to create reusable functions, master the Advanced Formula Environment, and develop sophisticated Single Cell Formula Reports. Gain expertise in Defined Names, the LET function, and various Excel functions including BYROW, BYCOL, MAP, SCAN, REDUCE, MAKEARRAY, GROUPBY, and PIVOTBY. Discover techniques for dynamic reporting, conditional formatting, and advanced formula applications in finance and statistics. Access downloadable Excel files and PDF notes to enhance your learning experience. Taught by Excel MVP and Highline College Professor Mike Girvin, this tutorial covers Microsoft 365 Excel's most powerful features for data analysis and reporting.

Syllabus

This is a hour video about everything that the Excel LAMBDA function, LAMBDA Helper Functions & Eta-LAMBDAs can do. This video is also a complete lesson in Defined Names, the LET function and Spilled Single Cell Formula Reports.
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. Eta-LAMBDAs
14. MAP function
15. SCAN function
16. REDUCE function, initial look
17. Recursion with LAMBDA
18. REDUCE function, introduction and three examples
19. MAKEARRAY function
20. LET function
21. GROUPBY and PIVOTBY functions
22. Add calculation label to Single Cell Formula Report: 2 methods
23. Single Cell Formula Report with two conditions in row area
24. Conditional Formatting For Dynamic Reports
25. Add two different calculations to a Single Cell Report
26. PIVOTBY function
27. PIVOTBY function to analyze increases and decreases in sales
28. Goal Seek with the PIVOTBY function
29. Fully Dynamic PIVOTBY report using formula inputs from cells using the functions: XLOOKUP, CHOOSE and XMATCH.
30. CHOOSE and XMATCH functions to lookup a function
31. Add dynamic calculation label to report using LET, ROWS, COLUMNS and SEQUENCE functions
32. Finance and Statistics LAMBDA re-usable function examples
33. Homework
34. Summary and Conclusions
35. Closing and Video Links