Recent Articles

Combinations and permutations in Excel

Combinations and permutations are two basic ways to count possibilities, used in probability, statistics, games, passwords, and lotteries. This article explains the difference between them, when order and repetition matter, and the Excel functions you can use to calculate each case: FACT, PERMUT, …Read more

Very cool, Dave. Excellent post. Your (always!) clear and straightforward explanations for everything in Excel remain the best. Truly. I do legal work, not data. But I use these more complex Excel skills weekly.
Libby
Exceptional content on Dynamic Arrays. I banged my head on my desk for hours this evening trying to migrate a financial model from traditional reference-based formulas to a much cleaner set of LET() and dynamic arrays function combinations. Your examples on BYROW() are simply stunning. Thank you so much!
JP
I have tried several other Excel training programs, and yours has been the best by far.
Pete

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