Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel LAMBDA function – Every Single Things You Ever Wanted To Know – 365 MECS 10

Posted on by Annie D

Download pdf notes: https://excelisfun.net/files/10-M365ExcelClassStart.xlsx
Download Excel file: https://excelisfun.net/files/10-M365ExcelClassFinished.xlsx
This is a 1 hour 45 min. video about everything that the Excel LAMBDA function can do. This video is also a complete lesson in Defined Names, the LET function and Spilled Single Cell Formula Reports.
Course taught by Excel MVP and Highline College Professor, Mike Girvin. Course is Microsoft 365 Excel Complete Story.
Topics in video:
1. (00:00) Introduction
2. (00:52) Overview
3. (02:42) Defined Names
4. (12:24) First look at LAMBDA to create a re-usable function
5. (19:00) Advanced Formula Environment
6. (23:40) Summary of LAMBDA
7. (25:20) Rate Of Change Re-usable LAMBDA function
8. (28:06) COGS Re-usable LAMBDA function created in Advanced Formula Environment
9. (30:22) Save LAMBDA to default file
10. (32:15) Show Formula Re-usable LAMBDA function
11. (36:06) LAMBDA Helper Functions
12. (36:32) BYROW and BYCOL functions
13. (41:10) MAP function
14. (49:16) SCAN function
15. (54:03) REDUCE function, initial look
16. (55:23) Recursion with LAMBDA
17. (01:04:13) REDUCE function, introduction and three examples
18. (01:15:00) MAKEARRAY function
19. (01:17:04) LET function
20. (01:18:16) Single Cell Formula Reports
21. (01:19:50) Single Cell End Of Month Report
22. (01:29:45) Conditional Formatting For Dynamic Reports
23. (01:31:39) Single Cell Cross Tabulated Report
24. (01:335:01) Single Cell Report that can create four different reports
25. (01:39:00) ISOMITTED function
26. (01:44:07) Summary and Conclusions
27. (01:44:43) Closing and Video Links

Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/ . Artist: http://audionautix.com/

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

ExcelIsFunFri, December 30, 2022 11:39am