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_Downloads/BCTI_GROUPBY_Multiple_Aggs.zip Link to video on Excel's GROUPBY Function: https://youtu.be/z9sjA8NaSDI 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