FILTER with optional criteria
To filter data with multiple criteria that are all optional, you can use the FILTER function with the LET function. In the example shown, the formula in B5 is: …Read more
Learn Excel with clear examples and bite-sized videos.
Featured Functions
GROUPBY Function
The Excel GROUPBY function is designed to summarize data by grouping rows and aggregating values. The result is a summary table created with a single formula.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
This is an Excel Knowledge Gateway made simple, where every step of a formula is included and well-explained in a proper order.
Emmanuel
I am an experienced Excel developer. That means I am the person that people come to with questions, or for complex implementations. However, there are plenty of techniques that get used once a year or less. Your site is always my first stop for refreshing my memory or looking for new ways to use common functions. This is also where I refer people who are trying to increase their knowledge or find out how to solve a problem.
Joe
I just want to say that your website is probably the best website providing Excel tricks. The part that I appreciate the most is that there are tutorials about some complicated cases of combining several excel formula together to use, such as https://exceljet.net/formula/categorize-text-with-keywords. These tutorials work perfectly and the steps are clearly presented with explanation for each step and screenshot of excel.
Yannes
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.
