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 position....Read more

Featured Functions

XLOOKUP Function

XLOOKUP is Excel's modern all‑in‑one lookup function. It lets you search a row or column for a value and retrieve the corresponding value from another range, without the frustrating limitations that plagued older functions like VLOOKUP, HLOOKUP, and LOOKUP. It can even return more than one...Read more

Recent Articles

Your website has helped me tremendously to understand how formula and functions works. I purchase books on excel and did not gain the understanding and knowledge that I did from your website. Thank you.
San
I think your website is great! It has helped me so much in learning to how to do things in Excel, please keep up the excellent work.
Stuart
This tip is award winning! Thank you!!
Eileen

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