Completed
1. Introduction
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel LAMBDA Function - Every Single Thing You Ever Wanted to Know
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction
- 2 2. Overview
- 3 3. Defined Names
- 4 4. First look at LAMBDA to create a re-usable function
- 5 5. Advanced Formula Environment
- 6 6. Summary of LAMBDA
- 7 7. Rate Of Change Re-usable LAMBDA function
- 8 8. COGS Re-usable LAMBDA function created in Advanced Formula Environment
- 9 9. Save LAMBDA to default file
- 10 10. Show Formula Re-usable LAMBDA function
- 11 11. LAMBDA Helper Functions
- 12 12. BYROW and BYCOL functions
- 13 13. MAP function
- 14 14. SCAN function
- 15 15. REDUCE function, initial look
- 16 16. Recursion with LAMBDA
- 17 17. REDUCE function, introduction and three examples
- 18 18. MAKEARRAY function
- 19 19. LET function
- 20 20. Single Cell Formula Reports
- 21 21. Single Cell End Of Month Report
- 22 22. Conditional Formatting For Dynamic Reports
- 23 23. Single Cell Cross Tabulated Report
- 24 24. Single Cell Report that can create four different reports
- 25 25. ISOMITTED function
- 26 26. Summary and Conclusions
- 27 27. Closing and Video Links
