Featured Formulas

Date and Time

Sum time

Dates and times are just numbers in Excel, so you can use them in any normal math operation. However, by default, Excel will only display hours and minutes up to 24 hours. This means you might seem to "lose time" if you are adding up time that is more than 1 day.

In this example, the...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Dynamic array

FILTER Function

The FILTER function "filters" data based on one or more conditions, and extracts matching values. The conditions are provided as logical expressions that test the source data and return TRUE or FALSE. The result from FILTER is an array of matching values from the...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Your courses are excellent...Despite all my years of experience, every clip that I have seen so far has been very helpful and a time saver.
Robert
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 think your website is awesome! Thanks so much for all the new things you have taught me. I’m semi-retired but still love finding Excel solutions.
Ann
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