Featured Formulas

XLOOKUP wildcard contains substring

The goal is to look up the Title, Author, and Year in the list of books as shown using a formula based on a partial match and a wildcard. The text string to search for is entered in cell G4. All data is in an Excel Table named data in the range B5:D16. This problem can be easily solved with the...Read more

Featured Functions

Recent Articles

I have been using Excel and Word since version 2 and am considered a local guru in its use. I recently found your site and have learned more in the last few weeks than the previous several years. More importantly, your resources will allow me to seek out particular bits as needed. You have opened my eyes and mind in a wonderful way.
Dennis
Love your website. Your algorithms are clever and innovative. Your examples are easy to follow. And I've never seen a cleaner looking website. It has been extremely helpful to me.
I've never seen a cleaner looking website
Over the last several years, I have gone from a basic Excel user to someone who can write formulas to parse complex data on a system where Excel is my only real tool. Your team writes articles that are clear enough for a beginner and layered enough that I still find myself referencing when I'm stumped on a project. The world is greatly improved by the work you do.
Anonymous

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