Download Start Excel file: https://excelisfun.net/files/10-M365ExcelClassStart.xlsx
pdf download: https://excelisfun.net/files/10-M365ExcelClass.pdf
Download Finished 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.

This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW

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:35: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/

#MikeGirvin
#excelisfun
#MikeexcelisfunGirvin
#Microsoft365Excel
#MECS10
#Microsoft365ExcelCompleteStory
#ExcelLAMBDAfunction
#DefinedNames
#LETfunction
#SingleCellFormulaReports
#SingleCellFormulaReports
#DynamicSpilledArrayFormulas
#LAMBDAHelperFunctions
#SCANfunction
#BYROWfunction
#BYCOLfunction
#MAPfunction
#REDUCEfunction
#RecursionwithLAMBDA
#ISOMITTEDfunction
#MAKEARRAYfunction
#FreeClass
#FreePowerBIClass
#lambdaexpression
#LAMBDA
#EXCELLAMBDA
#SINGLECELLREPORTS
#dynamicarrayformulas
#dynamisspilledarrayformulas
#excelarrayformulas
#exceldynamicarrayformulas
#exceldynamisspilledarrayformulas
#excelformulas
#excelFunctions
#dataanalysis
#dataanalytics