Featured Formulas

INDEX and MATCH approximate match with multiple criteria

In this example, the goal is to look up the correct shipping cost for an item based on the shipping service selected and the item's weight. At the core, this is an approximate match lookup based on weight. The challenge is that we also need to filter by service. This means we must apply criteria...Read more

Featured Functions

TEXTBEFORE Function

The TEXTBEFORE function extracts text that occurs before a given delimiter. When multiple delimiters appear in the text, TEXTBEFORE can return text before the nth occurrence of a delimiter. TEXTBEFORE can also extract text that occurs before a given delimiter when counting...Read more

Recent Articles

Just wanted to tell you that I very much liked your mail on the EXACT() function! Incidentally, I did not know the trick of the double negative! Keep up the good work!
Peter
Thank you, and thank you so very much for your videos, they are sooooo helpful.
Elizabeth
I’ve been in and out of the courses a lot since I signed up. Your short courses make it SO EASY to take a little break from work and go through one. I then bookmark them to go back through, just to cement the concepts. I so appreciate being able to do that since setting aside an hour or so is just not doable now. This way, I get a nice break, I learn something, it’s so much more retainable because of the brevity. Just a perfect platform.
Peg

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