Featured Formulas

Count

Count cells that contain errors

In this example, the goal is to count errors in the range B5:B15, which is named data for convenience. The article below explains several different approaches, depending on your needs. For background, this article: ...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Date and time

WORKDAY Function

The WORKDAY function calculates a date that is a given number of working days from a specified start date, automatically excluding weekends and, optionally, holidays. You can use the WORKDAY function to calculate project start dates, delivery dates, due dates, and other dates that must...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

I just want to say that your website is probably the best website providing Excel tricks. The part that I appreciate the most is that there are tutorials about some complicated cases of combining several excel formula together to use, such as https://exceljet.net/formula/categorize-text-with-keywords. These tutorials work perfectly and the steps are clearly presented with explanation for each step and screenshot of excel.
Yannes
I just wanted to say your site is excellent and a life saver. Clear explanations with worked examples.
Simon
This is the best learning resource I have stumbled upon in many years during the process of my Excel learning.
Anchery
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