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

Your website is an absolute gem! I recently had to learn Excel after using statistical software. I even recruited my husband to help me find some ADHD-friendly Excel tutorials and all we found was a bunch of fluff. I stumbled on exceljet and after one tutorial was sold; for the first time I didn't feel more annoyed than informed at the end of a tutorial. Everything is logically organized on here and the instructions are thorough without any bull.
Ruby
I am a software engineer with 10+ years of programming experience, but I had to learn advanced Excel material for a new job that used it primarily and I found the official Microsoft documentation a bit vague and uninstructive until I found your website, which helped me implicitly understand a lot about the internal workings of Excel's formulas and matrix treatments through your explanations and examples.
Jay
OMG.....how easy! I will never do anything other than a Pivot Table if needed.
Annie

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