Featured Formulas

Filter on dates expiring soon

In this example, the goal is to filter data to show rows where dates have expired or will be expiring soon. In the table to the left, we have equipment that needs to be replaced every x months, where x appears in the "Months" column. The "Replaced" column shows the date equipment was...Read more

Featured Functions

SUMPRODUCT Function

The SUMPRODUCT function multiplies arrays together and returns the sum of products. If only one array is supplied, SUMPRODUCT will simply sum the items in the array. Up to 30 ranges or arrays can be supplied.

When you first encounter SUMPRODUCT, it may...Read more

Recent Articles

You are so much committed and obsessed with teaching Excel, hats off to both of you. We extensively refer to your material when we are stuck with some problem in excel and each time your material has provided a solution.
Ramesh
Thank you for all your articles and hard work in putting all this information together. It has really given me insight into how Excel works and how to use many of functions in Excel.
Ron
Finally. Someone helping me see how to use Excel the way I want! I'm a long time C programmer, now learning Excel to create some medium complex budget planning for a non-profit organization. While I'm making progress beginning to "think Excel", your tutorials on complex references using INDIRECT are wonderful! The syntax makes my eyes water, but I see what they're doing and how I can use 'em. Aha! Thanks tons for helping me bridge the gap between how I think and Excel's tools.
Deborah

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