Excel’s latest version comes with some exciting new features and enhancements.
In this blog, we’ll get to know six new Excel formulas that will help you save time in Excel, along with some useful resources to master them. From XLOOKUP to the brand-new text and array formulas, this page will give you the tools to improve your everyday life in Excel.
Excel formula #1: TEXTSPLIT
TEXTJOIN has been around for a little while as a text-combining formula… but have you met TEXTJOIN’s new counterpart: TEXTSPLIT?
TEXTSPLIT allows you to split text into multiple columns/rows. Like TEXTJOIN, this new Excel feature uses a given delimiter (i.e. space or comma) to separate the text over the desired cells.
Get familiar with TEXTSPLIT with this helpful content:
- In this blog from Ablebits, Alexander Frolov gives an in-depth tutorial on TEXTSPLIT: TEXTSPLIT function in Excel.
- This blog by Excel Campus compares the merits of TEXTSPLIT to TEXTBEFORE and TEXTAFTER: Best Way to Split Text in Excel.
Excel formula #2: TEXTBEFORE and TEXTAFTER
TEXTBEFORE and TEXTAFTER are great tools if you want to extract text from the start or end of a cell. TEXTBEFORE pulls out all text that comes before a given delimiter, while TEXTAFTER does the same with text after that delimiter.
Learn how to leverage these new Excel formulas with these short blogs below:
- This Excel-Exercise blog shows you how to use TEXTBEFORE and TEXTAFTER in just two minutes: TEXTBEFORE and TEXTAFTER.
- Another useful article by Alexander Frolov on how to use TEXTBEFORE: Excel TEXTBEFORE function.
Excel formula #3: TAKE and DROP
These new Excel features allow you to keep (TAKE) or remove (DROP) a given number of columns/rows from the start or end of an array.
- These tips from Microsoft Support will help you master them in minutes: TAKE function and DROP function.
Excel formula #4: CHOOSECOLS and CHOOSEROWS
These brand new Excel formulas are an easy way of extracting specific columns (CHOOSECOLS) or rows (CHOOSEROWS) from a range of datasets, whether they’re non-contiguous or right next to each other.
Check out these links to get to grips with CHOOSECOLS and CHOOSEROWS:
- This blog from Get Digital Help gives a quick overview of CHOOSECOLS: How to use the CHOOSECOLS function.
- These Microsoft Support pages are also good for mastering the basics: CHOOSECOLS and CHOOSEROWS.
Excel formula #5: VSTACK and HSTACK
VSTACK and HSTACK allow you to combine two or more sets of arrays vertically (VSTACK) or horizontally (HSTACK). Better yet, these new Excel functions even work with dynamic arrays and ranges with large source sizes!
- For a quick tutorial, these guides from ExtendOffice both go into a lot of detail on each new function: Excel VSTACK function and Excel HSTACK function.
Excel formula #6: XLOOKUP
If you’re an Excel aficionado, you must know the XLOOKUP formula. It’s been available in Office365 and Excel for web since 2020, but we still can’t get enough of this feature in 2022! XLOOKUP is a powerful look-up function that can go far beyond the limitations of VLOOKUP and the INDEX and MATCH functions.
Interested in learning more? Check out these articles below:
- This helpful blog by Inferogroup covers exactly why XLOOKUP is a more efficient function than VLOOKUP: XLOOKUP – The New Improved VLOOKUP.
- This guide from ExcelKid covers 5 common problems with XLOOKUP and how to solve them: 5 Reasons why XLOOKUP is Not Working.
- If you want to go further, you can also watch this video tutorial on XLOOKUP by LinkedIn Learning: Using the XLOOKUP function.
BONUS: Top Excel formulas videos 2022
If you prefer a video tutorial, we’ve also attached our favourite guide to new Excel formulas in 2022 here:
This video is an informative and concise overview of the functions we’ve just covered. Thanks to Mike Tholfsen, you can get to grips with these new Excel functions in just 5 minutes.
Thanks for sharing such a useful information. Having some training in Excel is a MUST nowadays.As a professional in your field, you already know the benefits of using Microsoft Excel. By using Excel, you’ll save a ton of time at your job and/or in your personal life, and it’s guaranteed to be more accurate than something you could’ve done by hand. Get the Best Microsoft Advanced Excel classes in pune only on urbanpro platform.
Thank you Vanessa! Nice to meet another Excel enthusiast truly convinced by its utility 🙂
We suggest you discover Power Query and Power BI with our sister company https://www.finance3point1.com/en/ , expert in data modeling.
Thanks Bro, I gain Much More KNowledge in this post such a Great Job Related Post
excel is a good kind of software for professionals. it saves time and human efforts. it sorts out many kinds of complex problems in few seconds. preparing work report is very import for saving and managing data. i always use excel for managing data.
I am so grateful for your blog.i Really looking forward to read more! Really Great.
Thank you so much for sharing this blog! I just want to mention I am just new to blogging and really enjoyed you’re web blog. Most likely I’m want to bookmark your blog post . You certainly have awesome articles.
Thank you so much for sharing this blog! I just want to mention I am just new to blogging and really enjoyed you’re web blog. Most likely I’m want to bookmark your blog post .
Regards,
Thank you for excellent article. You made an article that is interesting.
Excellent post with valuable content. It is very helpful for me and a good post.
Cool!
Thanks for the great article. The fact is that for the new functions to work, we had to change the way Excel works. Before the advent of Dynamic Array Functions (DAF), the user essentially could not reference a range of cells in one cell. Rather, he could have referred, but, let’s say, such links worked in very limited cases. However, in fairness, it should be noted that everything started with array formulas, it just evolved in DAF, which can be indirectly judged from Microsoft’s messages that array formulas will be left in Excel for compatibility. By the way, you can… Read more »
The content is amazing, i really liked it
thankyou
Best article ever read like this till now, Thankyou, the article is very good and i learned many things
please post more like this thankyou
There is so many software but excel is one of the best. One needs to know the right command. When used excel can do a lot of tasks. Thanks for sharing
Thanks for the roundup!
We are very grateful to you for this information and we hope that you will continue to give us such information.
Thank you, for this information
The blog is very informative. looking forward to reading more from you thank you
nice article
All I can say is wow keep up the great work .Your effort is deeply, deeply appreciated.nice ideas
There is so many software but excel is one of the best. One needs to know the right command. When used excel can do a lot of tasks. Thanks for sharing
import from the web is a great formula in excel also the formula you have explained are awesome these formulas make our work easy. thanks for sharing
Thanks for sharing. Nice blog.