Excel LAMBDA, LAMBDA Helper Functions & Eta-LAMBDAs: the Complete Story – Updated 2024: 365 MECS 10

Video Description

Download Excel Start file: https://excelisfun.net/files/10-M365ExcelClassStart2024.xlsx Download pdf notes: https://excelisfun.net/files/10-M365ExcelClass2024.pdf Download Excel Finished file: https://excelisfun.net/files/10-M365ExcelClassFinished2024.xlsx This is a 1:45 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. 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. (01:18) Overview 3. (03:09) Defined Names 4. (13:00) First look at LAMBDA to create a re-usable function 5. (19:25) Advanced Formula Environment 6. (24:08) Summary of LAMBDA 7. (25:50) Rate Of Change Re-usable LAMBDA function 8. (28:33) COGS Re-usable LAMBDA function created in Advanced Formula Environment 9. (30:55) Save LAMBDA to default file 10. (32:44) Show Formula Re-usable LAMBDA function 11. (36:35) LAMBDA Helper Functions 12. (37:24) BYROW and BYCOL functions 13. (39:41) Eta-LAMBDAs 14. (42:16) MAP function 15. (50:46) SCAN function 16. (54:01) REDUCE function, initial look 17. (55:13) Recursion with LAMBDA 18. (01:04:24) REDUCE function, introduction and three examples 19. (01:14:48) MAKEARRAY function 20. (01:16:34) LET function 21. (01:17:46) GROUPBY and PIVOTBY functions 22. (01:22:29) Add calculation label to Single Cell Formula Report: 2 methods 23. (01:24:00) Single Cell Formula Report with two conditions in row area 24. (01:25:53) Conditional Formatting For Dynamic Reports 25. (01:28:25) Add two different calculations to a Single Cell Report 26. (01:31:10) PIVOTBY function 27. (01:33:05) PIVOTBY function to analyze increases and decreases in sales 28. (01:35:02) Goal Seek with the PIVOTBY function 29. (01:36:08) Fully Dynamic PIVOTBY report using formula inputs from cells using the functions: XLOOKUP, CHOOSE and XMATCH. 30. (01:40:15) CHOOSE and XMATCH functions to lookup a function 31. (01:41:53) Add dynamic calculation label to report using LET, ROWS, COLUMNS and SEQUENCE functions 32. (01:45:13) Finance and Statistics LAMBDA re-usable function examples 33. (01:45:52) Homework 34. (01:45:55) Summary and Conclusions 35. (01:46:41) 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/ #excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #groupby #excelformula #excelfunctions #excelfunctions #excelformulasandfunctions #lambda #excellambda #lambdahelper #etalambda