Download Excel File: https://excelisfun.net/files/EMT1844.xlsx
Learn about how to use the GROUPBY function to make single cell formula reports that can update instantly when source data changes.
Topics:
1. (00:00) Introduction to GROUPBY, PIVOTBY and the new Lambda Replacement Functions
2. (00:58) Compare arguments in GROUPBY and PIVOTBY functions.
3. (01:58) GROUPBY and the 7 arguments.
4. (01:58) 16 New Lambda Replacement Functions.
5. (05:43) New Lambda Replacement Functions as replacement for LAMBDA.
6. (06:17) PERCENTAGE of in GROUPBY Function.
7. (07:04) Why use formulas rather than PivotTables.
8. (07:17) Two Fields in Row Area of Report.
9. (08:05) Problem: No Label for Calculation Column. Look at field_header argument.
10. (08:21) Two Columns of calculations in report.
11. (08:55) Add Custom Header Labels to Report with VSTCK Function and Array Constant.
12. (10:26) Subtotals
13. (11:00) Conditional Formatting for dynamic Report.
14. (13:25) F5 Go To Trick to find Conditional Formatting in Report.
15. (14:44) How to create multiple columns with different calculations with GROUPBY, LET, DROP and TAKE Functions.
16. (18:04) Filter GROUPBY Report with Contains Criteria.
17. (19:17) Filter GROUPBY Report with Criteria from a list.
18. (21:18) Using LAMBDA in the GROUPBY Function: two examples.
19. (23:25) Creating Array Calculation in values argument of GROUPBY Function.
20. (24:06) Create Fully Dynamic GROUPBY Report with Formulas Inputs from Worksheet Cells.
21. (26:55) Summary
22. (28:12) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #conditionalformat #conditionalformatting #subtotal #groupby #excelformula #excelfunctions #excelfunctions #excelformulasandfunctions #lambda