Featured Formulas

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...Read more

Recent Articles

I would like just to thank you for these amazingly clear explanations! Wonderful work!
Paola
Thank you for maintaining such a fabulous tutorial site. It has helped me tremendously, and is my go-to when I'm in a bind...I'd probably be out of a job without your resources.
John
I appreciate you doing this, I constantly return to your site for help and to learn a new function or trick. Very useful and easy to understand the way you break things down.
Gabriel

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