Featured Formulas

Get last match

In the example shown, we have a set of order data that includes Date, Product, Name, and Amount. The data is sorted by date in ascending order. The goal is to look up the latest order for a given person by Name. In other words, we want the last match by name. The challenge is that Excel...Read more

Featured Functions

LET Function

The LET function lets you define named variables in a formula. There are two primary reasons you might want to do this: (1) to improve performance by eliminating redundant calculations and (2) to make more complex formulas easier to read and write. Once a variable is named, it can be...Read more

Recent Articles

Yes, that is exactly what I mean, thank you! You guys are great - who would’ve thought that Excel could be fun :)
Alex
Just a note to say your site is fantastic! I've learnt more on here in 3 hours than I have in nearly 3 decades of using Excel. Keep up the great work!
Mark
I work in IT support for a big law firm. Since I started with your lessons, the amount of Excel requests in my daily work increased tremendously. I get so much positive feedback and my colleague asked me the other day not to go on vacation simultaneously with the head of the Excel-Team again.... Thank you very much for your excellent work!
Carolin

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