Excel GROUPBY and PIVOTBY: An alternative to Pivot Tables? + How I crashed Excel with PIVOTBY

The GROUPBY and PIVOTBY functions are now available in the Current Channel release of Excel in MS365. Here I talk about how to use their arguments to create advanced analysis formula, and their pros and cons versus pivot tables. 00:00 - Intro 00:34 - The basics of GROUPBY 03:24 - Advanced GROUPBY 14:49 - PIVOTBY 15:57 - How to crash Excel with PIVOTBY 🤣 Intro music: "Pitbull" by Michael Ramir C. https://mixkit.co/ #microsoft #ms365 #msoffice #office #excel #groupby #pivotby #pivottables #dynamicarrays