Excel’s New GROUPBY Function (w/ Bonus Features)

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: File with Conditional Formatting for Artwork: 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