Featured Formulas

Featured Functions

UNIQUE Function

The Excel UNIQUE function extracts a list of unique values from a range or array. The result is a dynamic array of unique values. If this array is the final result (i.e. not handed off to another function), array values will "spill" onto the worksheet into a...Read more

Recent Articles

Thank you for making such a user-friendly and informative website!
Casey
Your pages offer clear writing and simple explanations that I'm sure are immensely helpful to many. Thanks for making the internet a better place.
David
Just wanted to say thank you for this extraordinary resource and awesome examples; the examples you guys give here are some of the clearest and best on the internet. Exceljet and Stackoverflow are really my go-to for any kind of learning.
Weiqi

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