Completed
31. Add dynamic calculation label to report using LET, ROWS, COLUMNS and SEQUENCE functions
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
