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

LAMBDA Function

The LAMBDA function provides a way to create a custom function in Excel. Once defined and named, a LAMBDA function can be used anywhere in a workbook. LAMBDA functions can be very simple or quite complex, stringing together many Excel functions into one formula. A custom LAMBDA function...Read more

Recent Articles

I just wanted to thank you for your excellent website; you are consistently correct and clear!
Steve
I'm an intermediate-level Excel user - I only know as much as I need to get the job done. As I imagine is the case for most people, I learned Excel by asking myself questions like, "I wonder if there's a way to do [X]?" and then Googling the answer. Your site has already taught me so much in the short time I discovered it and, as a Learning & Development professional, I admire your approach. Great work, and thanks for supporting all us Excel geeks!
Will
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