Hi - Dave here.
Happy Friday!
For a very long time, Excel introduced new functions at a leisurely pace. Every few years, a handful of new functions would appear, most aimed at technical and edge-case problems. Most users greeted these new functions with a yawn, if they noticed at all.
All that changed in 2019 when Microsoft's Excel team kicked things into high gear and suddenly began introducing brand-new functions at a furious pace. You might not know it, but Excel now has nearly 50 new functions!
This is not your Dad's Excel anymore. The new upgraded engine and new functions are a massive change that will ripple through business and personal spreadsheets for years to come. Many complicated formulas will become obsolete, replaced by compact and elegant alternatives. If you use Excel frequently, this is a change you should understand. To help you get started, I've put together a list of new functions here:
[
New Excel Functions]
The page above contains a summary and example of each new function, plus links to more detailed information.
Excel formulas
We maintain a list of over 500 working formulas
here.
If you need more structure, we also offer
video training.
Have a great weekend!
Dave
PS - There are now actually at least 50 new functions. I'm a little behind in documenting them and will update the page above soon.
The Exceljet newsletter is free and sent weekly on Fridays. Each week, I take a detailed look at one useful Excel formula. You can sign up on our home page.