Featured Formulas

Sum by quarter

In this example, the goal is to sum the amounts in column C by quarter in column G. Column D is a helper column, and the formula to calculate quarters from the dates in column B is explained below. All data is in an Excel...Read more

Featured Functions

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

Recent Articles

I absolutely love getting your emails and insights.
SB
I find your site invaluable and a fantastic resource whenever I need to give Excel a spin and accomplish a challenging task.
Steve
I've been through a lot of websites to learn Excel functions. I have to say, yours is by far the best! So clear, so intelligent. Wonderful job.
Geoff

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