Featured Formulas

Sum by weekday

In this example, the goal is to sum amounts by weekday. In other words, we want to sum amounts by Monday, Tuesday, Wednesday, and so on. Column B contains valid Excel dates formatted with a custom number format explained below. For convenience, all source data...Read more

Featured Functions

SEQUENCE Function

The SEQUENCE function generates a list of sequential numbers in an array. The array can be one-dimensional, or two-dimensional, controlled by rows and columns arguments. SEQUENCE can be used on its own to create an array of sequential numbers that...Read more

Recent Articles

The best site I ever found on any programming/software topic on the Internet. Period! I can not find words to express my admiration for the clarity, precision and insight with which you put your site together. Thank you.
Mario
I work in the field of data migration and have recently had to work in Excel more than I had previously wanted. Using your site though, I have found that much of what I thought wasn't possible outside SQL is and that I can actually accomplish a lot of the work I need to do using Excel. Your explanations are, as you say, direct and to the point and huge thanks to you for the site.
Nigel
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

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