Join 300,000+ professionals in our courses: https://www.xelplus.com/courses/

Microsoft Excel team just announced brand new Excel functions (Dynamic array functions) that save us from writing complex Excel formulas. These new Excel functions are for EVERYONE! Excel beginners to advanced to Pro.
We get TEXTSPLIT to split text based on multiple delimiters (such as multiple spaces). We can grab the part of text before a delimiter with TEXTBEFORE and after a delimiter with TEXTAFTER.
We have TOROW and TOCOLS to combine data from multiple ranges into a single row or a single columns. Together with the UNIQUE function you’ll be able to get a unique list of values from multiple columns.
We also get CHOOSECOLS and CHOOSEROWS to select which columns and rows from a range you want returned. A great use-case is to combine CHOOSECOLS with the FILTER function to return columns from different places.
WRAPCOLS and WRAPROWS allows you to take horizontal or vertical data and create multiple columns or multiple rows from it.
TAKE & DROP functions allows you pick which part of a table you want returned. You can keep the first top rows or the last rows. You could combine this with the SORT function to get the top results of your dataset.
Finally the EXPAND function allows you to expand a range to a certain number of columns or rows. This will come in handy to calculations that require multiple ranges to have the same size.

🌍 My Online Excel Courses ► https://www.xelplus.com/courses/

00:00 New Excel Functions in 2022
00:52 TOCOL Excel Function
01:24 TOROW
01:58 TEXTSPLIT Excel Function
02:40 TEXTBEFORE
03:19 TEXTAFTER
03:48 VSTACK Excel Function
04:32 HSTACK
04:56 WRAPROWS Excel Function
05:28 WRAPCOLS
05:44 TAKE Excel Function
06:56 DROP
07:19 CHOOSECOLS Excel Function
08:20 CHOOSEROWS
08:39 EXPAND
10:21 Wrap up

Availability: Current partly in the BETA channel for those in the OFFICE INSIDER program. More info is here available in the Microsoft Excel announcement: https://techcommunity.microsof....t.com/t5/excel-blog/

Download the File: https://www.xelplus.com/new-ex....cel-functions-vstack
(scroll down the post and you'll find the file there) - if you have Office 365 beta, then you can open the file on your version of Excel to see the new function names in your language.

🎬 LINKS to more amazing Office 365 functions: https://www.youtube.com/playli....st?list=PLmHVyfmcRKy

🎒 Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

📚 Excel RESOURCES I Recommend: https://www.xelplus.com/resources/

🎥 GEAR I use: https://www.xelplus.com/resources/#gear

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

🚩Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel #office365