Featured Formulas

Due date by category

In this example, the goal is to create a due date based on category, where each category has a different number of days allocated to complete a given task, issue, project, etc. The amount of time available to resolve each category is shown in column H, and categories is the...Read more

Featured Functions

IFS Function

The IFs function evaluates multiple expressions and returns a result that corresponds to the first TRUE result. You can use the IFS function when you want a self-contained formula to test multiple conditions at the same time without nesting...Read more

Recent Articles

I am a highly advanced Excel user. I just wanted to mention to you that I spent some time yesterday and today looking through your website, and I believe it's the best I've ever seen for breaking down the topic of Excel into simple, easy to digest pieces.
Seth
Hello, just wanted to say thanks for your great website. It's helped me many times with excel formulas when I was stumped, so really appreciate it as a resource. It's well designed and effectively communicated.
JC
I find your email tips extremely helpful for excel!
Jill

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