Featured Formulas

Sum by quarter

In this example, the goal is to sum the amounts in column C by quarter in column G. Column D is a helper column, and the formula to calculate quarters from the dates in column B is explained below. All data is in an Excel...Read more

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

Recent Articles

For my work as a financial modeller I am using a myriad of dedicated excel sites. I have noticed that your format, language and structure of explanation is just outperforming the others.
Giel
Your website is great and a fantastic resource no matter what your Excel level is. You always make the complex simple. THANK YOU !!
Dominic
I frequently use the resources you provide here on your website, and wanted to thank you for the awesome work you are doing. It is very well done, has great breadth, and lays out complex topics in an understandable way.
Chase

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