Learn Excel with clear examples and bite-sized videos.
Featured Functions
FILTER Function
The Excel FILTER function is used to extract matching values from data based on one or more conditions. The output from FILTER is dynamic. If source data or criteria change, FILTER will return a new set of results. This makes FILTER a flexible way to isolate and inspect data without altering the …Read more
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
Topics By Category
User Testimonials
I just wanted to say what a fantastic resource ExcelJet is. I never fail to be impressed by the quality of examples and explanations. I have never been let down by this site. This is definitely the go-to place for Excel knowledge.
Dave in NZ
I am an advanced xl user but when I need a clear explanation about a complex issue, I have begun to put "Exceljet Excel [topic]" into google because your work is consistently the best on the internet. Well done. :-)
Iain
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.
