Featured Formulas

Dynamic array

List upcoming birthdays

In this example, the goal is to list the next n upcoming birthdays from a larger set of 25 birthdays based on the current date. The set of birthdays are in an Excel Table named data in the range B5:C29. In the example shown, we are using 7 for...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Math

SUMIFS Function

The SUMIFS function sums the cells in a range that meet multiple conditions, referred to as criteria. Each condition is provided with a separate range and criteria. To define criteria, SUMIFS supports various logical operators...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

By the way I think your site is an awesome reference tool for excel, especially the section with formula examples. I have found that to be incredibly helpful.
Brett
It was a pleasure to read your explanations and samples - I am rather a novice, but managed with the great help of your explanation. Thanks a lot, you are a treasure.
Doron
I wanted to say how much I love your website. I never used excel before my current position, which I started in 3 years ago, and I have since had to heavily rely on Excel for many, many things. I've looked at many different websites throughout my time in my current position, and by far I love yours the most. Your explanations are simple, straight forward, and have brought me to a point I feel extremely confident with my skills in excel.
Daniel
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