Featured Formulas

XLOOKUP binary search

In this example, the goal is to look up amounts for 1000 invoice numbers in a table that contains 1 million invoices. The catch is that not all of the 1000 invoice numbers exist in the source data. In fact, most of the invoice numbers do not appear in column B. This means we need...Read more

Featured Functions

TEXT Function

The TEXT function in Excel is a tool for formatting numbers, dates, and times as text. The purpose of the TEXT function is to convert a number to text using a specified format code. TEXT is most often used to control the formatting of a number embedded into a text string. However, TEXT is also a...Read more

Recent Articles

That worked like a charm! Thank you so much, your website is the best thing I have come across in a while!
Shawna
I'm an intermediate-level Excel user - I only know as much as I need to get the job done. As I imagine is the case for most people, I learned Excel by asking myself questions like, "I wonder if there's a way to do [X]?" and then Googling the answer. Your site has already taught me so much in the short time I discovered it and, as a Learning & Development professional, I admire your approach. Great work, and thanks for supporting all us Excel geeks!
Will
Just like to say, your tutorial “INDEX and MATCH with multiple criteria” completely rocks. A colleague tried to teach me this a while ago and I couldn’t get it; a few years more experienced now, I needed this function today and nailed it on the first go after reading your article.
Shelley

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