Featured Formulas

Count

Count birthdays by year

In this example, the goal is to count birthdays by year. The source data is an Excel Table named data in the range C5:C16. The birthdays we want to count are in the Birthday column. In column E, the years of interest have been previously ...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Dynamic array

XLOOKUP Function

XLOOKUP is Excel's modern all‑in‑one lookup function. It lets you search a row or column for a value and retrieve the corresponding value from another range, without the frustrating limitations that plagued older functions like VLOOKUP, HLOOKUP, and LOOKUP. It can even return more than one...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

I want to thank you for your posting of "Split dimensions into three parts" on your web site. You have saved our company many hours of PITA work. Our calculations of cubic inches are a slam dunk now!
Doug
I have used vlookup a lot and read some about index and match, but decided to add extra columns and stay with vlookup, however, your site was so very clear that making the switch (only where necessary) was very easy. For the first time, I understand index and match match. Thank you.
Garth
Your courses are fantastic!! The videos are concise and easily digestible. I will be ordering more.
David
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