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

I have been using Excel for many, many years. I write a lot of formulas and I write a lot of VBA code. When I'm stuck and I have to Google things, I ALWAYS look for ExcelJet results before I look at just about anything else. Your site has so much great information, it's so easy to read and understand, and it's very easy to adapt your examples to my real-world data. I just wanted to say thank you for all the help and support that you have unknowingly provided me - and by extension the organization where I work - over the years. Your work has saved me many tears and angry fits!
Andrew
You've done immeasurable good in the world by putting together Exceljet and making it freely available online. I go to Exceljet first for every formula question I have. The format is consistent and I know I'll be able to find exactly what I need, a good explanation and a couple ways to do it better in the shortest time possible.
Dan
Just wanted to say you are my go to website for any excel question for good few years and taught me a lot. No other resource can explain the steps better than you do. You made such a difference. It is amazing.
Al

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