Breaking News! We FINALLY get the Excel functions we've been Wanting!
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.microsoft.com/t5/excel-blog/announcing-new-text-and-array-functions/ba-p/3186066
Download the File: https://www.xelplus.com/new-excel-functions-vstack-textsplit-tocol/
(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/playlist?list=PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP
🎒 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
Видео Breaking News! We FINALLY get the Excel functions we've been Wanting! канала Leila Gharani
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.microsoft.com/t5/excel-blog/announcing-new-text-and-array-functions/ba-p/3186066
Download the File: https://www.xelplus.com/new-excel-functions-vstack-textsplit-tocol/
(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/playlist?list=PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP
🎒 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
Видео Breaking News! We FINALLY get the Excel functions we've been Wanting! канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
7 Things You're Doing WRONG in ExcelTOO MANY EMAILS? Use THESE Proven Techniques | Outlook tips includedAnswering Your Questions: My Age, Nose, Marriage, Background (1 Million Subscriber Milestone)How to Use OneNote Effectively (Stay organized with little effort!)Excel for Accounting - 10 Excel Functions You NEED to KNOW!How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)6 FREE Add-Ins for Excel to Start Using NowWhen Should you Use the Hash Sign (#) in Excel Formulas?Excel shortcut keys you SHOULD know!NEW! SEARCHABLE Drop Down Lists in Excel with ZERO Effort!SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)Cool PowerPoint Features to up your Productivity | Did you know these?How You Can Actually Use the NEW Excel BYROW & BYCOL FunctionsReturn Multiple Match Results in Excel (2 methods)Properly Use Excel IFS FunctionAdvanced Pivot Table Techniques (to achieve more in Excel)Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)How to Create & Use Excel Macros (Real world example)5 Excel Functions YOU NEED in 2021 & 2022