Microsoft Excel - GroupBy with Multiple Aggregations (plus, Dynamic User Selection)
Learn how to create multiple aggregations using a single GROUPBY function. Also, learn to make a user-driven formula to calculate by different categories and sort directions. All this with automatic color formatting.
File Download Link:
https://www.bcti.com//wp-content/YT_D...
Link to video on Excel's GROUPBY Function:
• Excel's New GROUPBY Function (w/ Bonus Fea...
01:19 Starting with a default GROUPBY function
02:27 Declaring the default settings (i.e., explicit arguments)
03:43 Building Additional Aggregations
05:42 Building Dynamic User Selections
06:40 Building a Dynamic Heading
07:01 Building Dynamic Grouping
09:03 Building Dynamic Sorting Logic
10:54 Making the Output Pretty