Featured Formulas

Reverse a list or range

In this example, the goal is to "reverse" the items in the range B5:B14, so that the first item appears last, the second item appears second to last, and so on. When you first encounter a problem like this in Excel, your first instinct might be to sort the values in some way using the...Read more

Featured Functions

SUMIFS Function

The SUMIFS function sums numbers in Excel when they meet one or more specific conditions. SUMIFS is one of Excel's most widely used functions, and you will see it in all kinds of spreadsheets that calculate conditional sums based on dates, text, or numbers. Although a common function, ...Read more

Recent Articles

I cannot understand how you guys make money when you're giving away this amazing product for free, but thank you! Keep it up.
Chris
I continue to love receiving these emails. I’ve never seen this one before. I do think this is useful and I’m sure I’ll find a need for it going forward in my excel usage. Once again, thanks for sharing. You ARE making a difference.
Shane
Just wanted to say thank you both so much for providing this incredibly valuable and thorough resource for free. I've used your website to get me through my classes as a graduate student, and I currently use your website for my work with a State agency conducting data analysis for disease.
Jenn

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