The COUNTIF function of Excel returns the number of rows within a range according to a criterion. Learn how to use it in this article.
The SUMIF function calculates the sum of specific cells according to a criterion, like a product, country, seller's name, ...
The COUNTIFS function in Excel works like a filter. It returns the number of rows you have in a worksheet based on one or more criteria.
Discover how to use the SUMIFS function in Excel to filter and sum data based on multiple criteria in your worksheets
How to do a calculation or a formula in Excel? It's very simple but you have a few rules to know to avoid mistakes.
Easily identify and remove duplicate data in your Excel spreadsheets with these simple steps. Clean your data and improve accuracy.
Excel can fill series of numbers or dates automatically. Three techniques can be used. Here are the explanations.
Discover a playlist of videos to learn the best Excel shortcuts ever.
How to copy data and reuse them (paste) in other Excel cells? You can copy and paste text, numbers, and formula
In Excel, a cell reference could be relative or absolute (written with dollars). It's important to understand both situations
Discover the tips and tricks to move or copy a worksheet in the same workbook or in a new one. All explanations with animated gif.
SUM is the most used Excel function. There is nothing complex to use this function but there is also tricks behind this function
Discover all the tips and tricks you can do with all the copy-paste special
In Excel, you can audit your formula with the shortcut F9 and analyse which part of your formula returns error. The best trick to know 😉
In Excel, it's possible to make calculation without starting with the symbol equal. Just write your formula and Excel returns the result.