⬇️Download the Excel file here: https://www.myonlinetraininghub.com/new-array-shaping-excel-functions
In this video I cover 9 new array shaping Excel functions including TOCOL, TOROW, WRAPCOLS, WRAPROWS, TAKE, DROP, CHOOSECOLS, CHOOSEROWS and EXPAND. I also use them in some advanced techniques, which is where their real power is realised. See the timestamps below to skip to the function you want to learn.
View my comprehensive courses: https://www.myonlinetraininghub.com/
Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
0:00 New Excel Array Functions
0:23 TOCOL & TOROW functions
2:14 WRAPCOLS & WRAPROWS functions
3:44 TAKE & DROP functions
5:49 CHOOSECOLS & CHOOSEROWS functions
8:08 EXPAND function
9:01 Advanced Examples