How to move a cell with the mouse in Excel? It's very easy and much more efficient than doing a cut and paste.


Excel helps you to fill a series of numbers automatically. Three techniques can be used. Here are the explanations.


Discover how to use the SUMIFS function in Excel to filter and sum data based on multiple criteria in your worksheets


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.


The SUMIF function calculates the sum of specific cells according to a criterion, like a product, country, seller's name, ...


Discover how to remove duplicate values in Excel from one column or many columns from the ribbon or by formula


In Excel, it's possible to make calculation without starting with the symbol equal. Just write your formula and Excel returns the result.


SUM is the most used Excel function. There is nothing complex to use this function but there is also tricks behind this function


Discover a playlist of videos to learn the best Excel shortcuts ever.


In Excel, a cell reference could be relative or absolute (written with dollars). It's important to understand both situations

With a funny example, discover how you can use basic calculation, like sum, subtraction, multiplication and division in Excel

The COUNTIF function returns the number of rows within a range according to a criteria. Many situations are possible.

Discover all the tips and tricks to move or copy a worksheet in the same workbook or in a new one.

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 😉

Discover all the tips and tricks you can do with all the copy-paste special