Featured Formulas

Average last n rows

In the worksheet shown, we have a list of values in column C. The goal is to dynamically average the last n values using the numbers in cell E5 for n. Since the list may grow over time, the key requirement is to average amounts by ...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

I just want to say thanks for these emails. I’m not sure if people let you know or not but I love getting these and find them useful. You are making a difference in people’s lives.
Shane
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 just want to tell you that your site is awesome! You have all those formulas and you explain them so well. Whenever I get stuck on something, yours is the first place I check. Thank you for saving me time and time again!
Ruth

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