Featured Formulas

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

Featured Functions

Recent Articles

Thanks for having the most informative examples of Excel queries. I use your site constantly and it's a wealth of knowledge that has saved me so much time and helped me teach colleagues to streamline their tasks also. I appreciate that you have shared your knowledge and made this available to everyone.
Patrick
I am so grateful to have found your site. I am a basic Excel person that fell into a job that does a ton of reporting, so wow....I am glad to have this site. I have it book marked and am trying to practice getting better! I'm sure it's hard to reach all audiences from basic people to stars in Excel, so I appreciate you looking out for us beginners too!
Brenda
I don't think you understand how much your training has changed my life in terms of work efficiency and effectiveness not to mention minimizing my stress, anxiety and enabling me to shine in front of employers.
Veronika

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