Featured Formulas

Grouping

Categorize text with keywords

In this example, the goal is to categorize various expenses using the categories shown in column F and the keywords shown in column E. This is a case where it seems like we should perform a lookup operation of some kind, but the problem is that the keywords appear embedded in the text and the...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Date and time

EDATE Function

The EDATE function returns a date on the same day of the month, n months before or after a start date. You can use EDATE to generate expiration dates, contract dates, due dates, anniversary dates, retirement dates, and other dates that derive from a start date. EDATE returns a...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Thanks so much for the emails you send throughout the year. I really enjoy them.
Steve
I have learned more from you than any class I’ve taken. You have made me look like a hero more than once.
Kate
Just wanted to thank you for the amazing content. I've been using Excel for quite some time now, and I've scoured dozens of sources that gave useless advice you'd have to squint to properly see and understand. I've hit two of your pages in two google searches in the past five minutes and am kinda cross with myself for not finding it sooner. I'm here to stay, guys. Thank you from the bottom of my heart.
Said
More Testimonials

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