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