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

Recent Articles

Your website has helped me learn so much about Excel! Was able to setup a 15 stage IF(AND) string and currently have it working perfectly! All thanks to you guys.
Evan
Thank you for all the hard work you put into developing this awesome site. I have been using it for years, the knowledge and skills I gained helped me throughout my professional career; saving me hundreds of hours of extra work, so thank you for sharing your knowledge and support.
Anas
LOVE your emails and free seminars. Since I have joined the mailing list, I have attended everything so far. Please keep them coming!
Cody

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