Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

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

ExcelIsFun via YouTube

Overview

Dive into a comprehensive 1 hour 45 minute video tutorial exploring every aspect of the Excel LAMBDA function. Learn to create reusable functions, work with the Advanced Formula Environment, and master LAMBDA helper functions like BYROW, BYCOL, MAP, SCAN, and REDUCE. Discover the power of recursion with LAMBDA, explore the MAKEARRAY and LET functions, and create dynamic Single Cell Formula Reports. Gain insights into Defined Names, Conditional Formatting for Dynamic Reports, and the ISOMITTED function. Taught by Excel MVP and Highline College Professor Mike Girvin, this in-depth lesson covers everything from basic concepts to advanced techniques, providing a complete understanding of LAMBDA's capabilities in Microsoft 365 Excel.

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

Reviews

Start your review of Excel LAMBDA Function - Every Single Thing You Ever Wanted to Know

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.