Completed
This is a 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 Spille…
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel LAMBDA, LAMBDA Helper Functions, and Eta-LAMBDAs - The Complete Guide 2024
Automatically move to the next video in the Classroom when playback concludes
- 1 This is a 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 Spille…
- 2 1. Introduction
- 3 2. Overview
- 4 3. Defined Names
- 5 4. First look at LAMBDA to create a re-usable function
- 6 5. Advanced Formula Environment
- 7 6. Summary of LAMBDA
- 8 7. Rate Of Change Re-usable LAMBDA function
- 9 8. COGS Re-usable LAMBDA function created in Advanced Formula Environment
- 10 9. Save LAMBDA to default file
- 11 10. Show Formula Re-usable LAMBDA function
- 12 11. LAMBDA Helper Functions
- 13 12. BYROW and BYCOL functions
- 14 13. Eta-LAMBDAs
- 15 14. MAP function
- 16 15. SCAN function
- 17 16. REDUCE function, initial look
- 18 17. Recursion with LAMBDA
- 19 18. REDUCE function, introduction and three examples
- 20 19. MAKEARRAY function
- 21 20. LET function
- 22 21. GROUPBY and PIVOTBY functions
- 23 22. Add calculation label to Single Cell Formula Report: 2 methods
- 24 23. Single Cell Formula Report with two conditions in row area
- 25 24. Conditional Formatting For Dynamic Reports
- 26 25. Add two different calculations to a Single Cell Report
- 27 26. PIVOTBY function
- 28 27. PIVOTBY function to analyze increases and decreases in sales
- 29 28. Goal Seek with the PIVOTBY function
- 30 29. Fully Dynamic PIVOTBY report using formula inputs from cells using the functions: XLOOKUP, CHOOSE and XMATCH.
- 31 30. CHOOSE and XMATCH functions to lookup a function
- 32 31. Add dynamic calculation label to report using LET, ROWS, COLUMNS and SEQUENCE functions
- 33 32. Finance and Statistics LAMBDA re-usable function examples
- 34 33. Homework
- 35 34. Summary and Conclusions
- 36 35. Closing and Video Links
