Featured Formulas

GROUPBY with monthly totals

In this example, the goal is to generate monthly totals using the GROUPBY function. This is a tricky problem in Excel because typically, source data contains a regular date field and not a separate field with month names. In addition, the GROUPBY...Read more

Featured Functions

TEXTJOIN Function

The TEXTJOIN function concatenates multiple values together with or without a delimiter. TEXTJOIN can concatenate values provided as cell references,  ranges, or constants, and can optionally ignore empty cells.

The TEXTJOIN function...Read more

Recent Articles

My Lord where have you been all my life?...I've learned more awesome tricks/functions in one afternoon from you than in the last 10 years.
Robert
I've been using your site for reference as I learn more advanced functions/features of Excel. Your materials are very well written and informative.
Michael
Just wanted to drop a quick note to thank you for putting together this site...The instruction and context you provide is the most clear/concise that I've been able to find and has made me a much better user of Excel.
Harry

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