Move a cell with the mouse in Excel

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

How to Fill a Series Automatically with Excel

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

Function SUMIFS in Excel – Example

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

COUNTIFS – Count rows automatically in Excel

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.

SUMIF Function in Excel

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

Remove Duplicate values in Excel

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

Calculation without equal

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

Function SUM

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

Shortcuts for the pros

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

Absolute Relative Reference – Dollar in Formula

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

Basic calculation with Excel

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

Function COUNTIF

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

Move and Copy worksheets quickly

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

Inspect a Formula with F9

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 😉

Examples of Paste Special (All Options)

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