Hi - Dave here.
Happy Friday!
About two years ago, I sent out a list of nearly 50 new Excel functions. At the end of that email, I added a PS promising to update the list "soon", since Microsoft had already released a few more. Well, "soon" took a little longer than planned 🙂 But the update is finally done, and it's pretty big. The list now covers 53 new functions, each with a short summary, an example, and a link to more detailed information:
[
See the updated list of new Excel functions]
What's changed? Quite a lot:
- Every function is now sorted by release status, including a new Excel 2024 section with 23 functions. If you use a desktop version of Excel, you can see at a glance which functions you have.
- The regular expression functions (REGEXEXTRACT, REGEXREPLACE, and REGEXTEST) have graduated from the Beta channel and are now generally available in Excel 365.
- Three newer functions have joined the list: TRANSLATE and DETECTLANGUAGE, which let you translate text with a formula (really!), and TRIMRANGE, a clever function for creating dynamic ranges.
Finally, the list now includes two brand-new functions: IMPORTTEXT and IMPORTCSV. These functions import data from a text or CSV file directly with a formula. No Power Query, no copy and paste, no wizard. Just point the function at a file (or even a URL) and the data spills onto the worksheet. Plus, if the file changes, you can refresh the data at Data > Refresh All.
Note: both functions are currently available only in the Insiders Beta channel, which you have to opt into specifically. There are many ways to get data into Excel, and I'm curious to see what people think of these new functions. I'll revisit this topic in a future email when they are generally released.
In the meantime, the updated list is a good way to check what you might be missing.
Excel formulas
We maintain a list of over 1000 working formulas
here.
If you need more structure, we also offer
video training.
Have a great weekend!
Dave
The Exceljet newsletter is free and sent weekly on Fridays. Each week, I take a detailed look at a specific Excel formula or function. Sign up on our home page.