New Functions Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/new-functions/ Bestselling Excel and Power BI Courses Fri, 10 Mar 2023 23:19:08 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png New Functions Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/new-functions/ 32 32 New Excel Functions in Office 365 (VSTACK, TEXTSPLIT, TOCOL, DROP, WRAPCOLS, CHOOSECOLS, TAKE) https://www.xelplus.com/new-excel-functions-vstack-textsplit-tocol/ Thu, 31 Mar 2022 05:20:00 +0000 https://www.xelplus.com/?p=9390 Excel recently released a set of new functions like VSTACK, TEXTSPLIT and TOCOL that will have you looking forward to working with complex files and data because your life just got more exciting (at least mine did!).

The post New Excel Functions in Office 365 (VSTACK, TEXTSPLIT, TOCOL, DROP, WRAPCOLS, CHOOSECOLS, TAKE) appeared first on Xelplus - Leila Gharani.

]]> Office 2021 – New Functions and Enhancements https://www.xelplus.com/office-2021-new-features/ Thu, 14 Oct 2021 08:10:00 +0000 https://www.xelplus.com/?p=9771 Here's why you should upgrade to Office 2021 if you're on 2019 or 2016 (and for some reason you can't upgrade to 365). You get life-changing Excel functions like XLOOKUP, UNIQUE, FILTER, SORT and a lot more. I cover what you get when you upgrade in this post.

The post Office 2021 – New Functions and Enhancements appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel XLOOKUP, FILTER, SORT, UNIQUE, SORTBY and SEQUENCE Functions https://www.xelplus.com/excel-functions-office-365/ Thu, 07 Jan 2021 10:00:00 +0000 https://www.xelplus.com/?p=10369 This is the list of the most useful Excel Functions you need to know in 2021. There are the new functions available in Excel for Microsoft 365 and also on Excel for the web (available for free).

The post How to Use Excel XLOOKUP, FILTER, SORT, UNIQUE, SORTBY and SEQUENCE Functions appeared first on Xelplus - Leila Gharani.

]]>