Featured Formulas

Get address of named range or table

The goal is to return the full address of a range or named range as text. The purpose of this formula is informational, not functional. It provides a way to inspect the current range for a named range, an Excel Table, or even the result of a formula. The core...Read more

Featured Functions

REGEXEXTRACT Function

The REGEXEXTRACT function extracts text matching a specific regex pattern from a given text string. For the advanced Excel user, this function is a major upgrade. Instead of working out complex formulas based on functions like LEFT, RIGHT, FIND, MID, etc., REGEXEXTRACT can target...Read more

Recent Articles

I have used Excel for nearly 30 years in financial services and I consider myself quite a good user. As my professional context changed quite a bit over the years (derivatives trading/pricing, audit, risk reporting, compliance, risk controlling), the focus changed, too, and so there are formulas that I haven’t used for a while but in principle I know they exist. Up to now, it was a more or less time consuming search in order to freshen up my memory but your page in general and this list in specific is sheer genius.
Kerstin
Thank you very much for this resource. I've been visiting your site here-and-there for over a year now and I want to thank you for all of the valuable knowledge that you and your team have shared.
Neil
I've been an avid reader of your weekly emails since 2018, and have learned far more than I ever thought possible! I HAD thought of myself, pre-Exceljet, as a moderately-advanced Excel user, but this has been updated over and over again to a somewhat more humble evaluation of my powers.
Laurie

Get Training

We offer free resources and paid training.

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.

View Paid Training & Bundles

Just show me the free stuff

Excel 101 and Core Pivot Packages