Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Discover the latest and greatest Excel functions recently released! In this tutorial, we unveil a set of powerful new tools that make data management and analysis even more intuitive. Perfect for everyday Excel users, these functions are as user-friendly as UNIQUE, SORT, FILTER, and XLOOKUP.
⬇️ Download the File: pages.xelplus.com/new-functio...
🔍 What You'll Learn:
▪️ New Function Showcase: Get an overview of the newly introduced functions like TEXTSPLIT, TOCOL, TOROW, and more.
▪️ Practical Examples: See these functions in action with real-world examples, making it easier to understand and apply them.
▪️ Dynamic Data Management: Learn how to create dynamic lists, split text into multiple cells, and efficiently manage data in rows and columns.
If you have Office 365, then you can open the file on your version of Excel to see the new function names in your language.
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.
00:00 New Excel Functions
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: techcommunity.microsoft.com/t...
🎬 LINKS to more amazing Office 365 functions: • Excel for Office 365 &...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
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
22 май 2024
