GROUPBY Excel Function: Creating Single Cell Reports - 11 Examples

GROUPBY Excel Function: Creating Single Cell Reports - 11 Examples

ExcelIsFun via YouTube Direct link

14. F5 Go To Trick to find Conditional Formatting in Report.

14 of 22

14 of 22

14. F5 Go To Trick to find Conditional Formatting in Report.

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.