Using Excel, learn how to make an ENTIRE Pivot Table using a single formula. This brings automatically updating data Pivot Table-style reports. PLUS: 2 BONUS features!!!
File Download Link:
https://www.bcti.com/wp-content/YT_Downloads/BCTI_GROUPBY_Function.xlsx
File with Conditional Formatting for Artwork:
https://www.bcti.com/wp-content/YT_Downloads/BCTI_GROUPBY_with_CondFmt.xlsx
00:09 Purpose of the GROUPBY Function
01:13 Release Announcement
01:23 Syntax for GROUPBY (Overview)
02:03 Syntax for GROUPBY (Details)
03:53 GROUPBY - Example Objectives
04:45 Single Column Groups without Headings
06:34 Single Column Groups with Headings
07:41 Grouping by Multiple Columns
08:27 Multi-Column Groups with Subtotals
09:39 Multi-Column Groups with Subtotals Sorted
14:06 Multi-Column Groups with Custom Headings
17:48 BONUS: Filtering Groups
18:37 BONUS: Apply Artwork with Conditional Formatting
20:08 Wrapup & Summary
