Completed
24. Example #3: LAMBDA function to create re-usable reporting formula
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Data Analysis with Excel Worksheet Formulas - 4 Comprehensive Examples
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction
- 2 2. 4 scenarios where worksheet formulas are better than other tools.
- 3 3. Example #1: Enter Data In Worksheet & Need Analysis Off To Side.
- 4 4. MOD function for hours worked formula
- 5 5. Line Chart
- 6 6. 7-Day Moving Average formula AVERAGE, IF, NA and ROWS functions
- 7 7. TEXT function for day of the week formula
- 8 8. Dynamic Spilled AVERAGEIFS function to calculate average hours worked per day
- 9 9. Column chart
- 10 10. Create Dynamic Spilled Array Single Cell Reporting Formula. Formula to create report that shows Total Hurs by Project Address
- 11 11. LET function
- 12 12. Array syntax
- 13 13. HSTACK and VSTACK functions to join arrays
- 14 14. Bar chart
- 15 15. Conditional Formatting for Dynamic Spilled Array formulas
- 16 16. Test Dynamic Spilled Array formulas with new data
- 17 17. Example #2: GROUPBY function for single cell reporting. Basics.
- 18 18. GROUPBY with two row conditions and two values columns
- 19 19. Create an array syntax with F9 key
- 20 20. Conditional formatting for GROUPBY with subtotals. Add bold to subtotal row and double-underline for grand total row
- 21 21. GROUPBY with two functions
- 22 22. DROP function
- 23 23. PIVOTBY function
- 24 24. Example #3: LAMBDA function to create re-usable reporting formula
- 25 25. Text LAMBDA function
- 26 26. TAKE function
- 27 27. Load LAMBDA Function into Defined Name: Name Manager
- 28 28. Test re-usable function
- 29 29. Example #4: Build Lambda for Statistical Data Analysis to create a model
- 30 30. Summary
- 31 31. Conclusion
