Completed
2. Compare arguments in GROUPBY and PIVOTBY functions.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
GROUPBY Excel Function: Creating Single Cell Reports - 11 Examples
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction to GROUPBY, PIVOTBY and the new Lambda Replacement Functions
- 2 2. Compare arguments in GROUPBY and PIVOTBY functions.
- 3 3. GROUPBY and the 7 arguments.
- 4 4. 16 New Lambda Replacement Functions.
- 5 5. New Lambda Replacement Functions as replacement for LAMBDA.
- 6 6. PERCENTAGE of in GROUPBY Function.
- 7 7. Why use formulas rather than PivotTables.
- 8 8. Two Fields in Row Area of Report.
- 9 9. Problem: No Label for Calculation Column. Look at field_header argument.
- 10 10. Two Columns of calculations in report.
- 11 11. Add Custom Header Labels to Report with VSTCK Function and Array Constant.
- 12 12. Subtotals
- 13 13. Conditional Formatting for dynamic Report.
- 14 14. F5 Go To Trick to find Conditional Formatting in Report.
- 15 15. How to create multiple columns with different calculations with GROUPBY, LET, DROP and TAKE Functions.
- 16 16. Filter GROUPBY Report with Contains Criteria.
- 17 17. Filter GROUPBY Report with Criteria from a list.
- 18 18. Using LAMBDA in the GROUPBY Function: two examples.
- 19 19. Creating Array Calculation in values argument of GROUPBY Function.
- 20 20. Create Fully Dynamic GROUPBY Report with Formulas Inputs from Worksheet Cells.
- 21 21. Summary
- 22 22. Closing, Video Links
