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