Featured Formulas

Count cells equal to this or that

In this example, the goal is to count cells in the range D5:D15 that contain "red" or "blue". For convenience, the D5:D15 is named color. Counting cells equal to this OR that is more complicated than it first appears because there is no built-...Read more

Featured Functions

EOMONTH Function

The EOMONTH function returns the last day of the month, a given number of months in the past or future. You can use EOMONTH to calculate expiration dates, due dates, and other dates that must land on the last day of a month. EOMONTH returns a serial...Read more

Recent Articles

I just wanted to say thanks for the great site. I'm impressed by the level of quality in both the clear layout and useful examples. It's a testament to the effort that you two must have put into it. I greatly appreciate it!
Simon
Dave this is amazing. I wish I got this message a year ago, so glad I signed up for your tips!! Thank you!
Mary
I have tried several other Excel training programs, and yours has been the best by far.
Pete

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