Completed
10. Create Dynamic Spilled Array Single Cell Reporting Formula. Formula to create report that shows Total Hurs by Project Address
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
