Featured Formulas

Generate quarter dates

In this example, the goal is to generate a list of quarter start and quarter end dates. This can be done by combining the SEQUENCE function with the EDATE and EOMONTH functions, as explained below.

The SEQUENCE function

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

Recent Articles

I LOVE your site. It helps me frequently as I have no formal training but I'm very logic oriented and this site is put together so very well and has assisted me so very much! You've improved the quality of my life.
Mike
I came across your website couple years back and I am still impressed with your clear way of explaining things rather than just showing how to accomplish certain task. -Dominik
Dominik
You certainly provide the clearest explanations of how to use Excel that I have ever seen! Thanks very much for sharing!
Mike

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