This course covers everything related to the Excel LAMBDA function, including Defined Names, the LET function, and Spilled Single Cell Formula Reports. By the end of the course, learners will be able to create re-usable functions using LAMBDA, understand advanced formula environments, and utilize various helper functions like BYROW, BYCOL, MAP, SCAN, and REDUCE. The teaching method involves a comprehensive video lesson led by an Excel MVP and Highline College Professor. This course is intended for individuals familiar with Microsoft 365 Excel who want to enhance their skills in utilizing the LAMBDA function and related features.
Overview
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
Taught by
ExcelIsFun
Related Courses
-
CHOOSE Function - Beginner to Advanced Examples
-
Comprehensive Excel Dynamic Array Formula Lesson - The Power of Array Formulas
-
Aging Accounts Receivable Reports on Multiple Sheets With Array Formula
-
Excel Worksheet Formulas & Models – Everything You Ever Wanted to Know
-
Power Query - Excel.CurrentWorkbook Function to Append All Excel Tables in Excel Workbook
-
Conditional Calculations with Excel Formulas - Comprehensive Lessons
