Function

The Excel functions explained

3D Formula in Excel

In Excel, you can build 3D formulas by making a relationship through many worksheets. Let's see how to build a 3D formula.

Extract items that appear only one time

Discover How to Extract Only the Unique Values of a list of data in Excel with the UNIQUE function.

How to return many rows with VLOOKUP

If you want to return many rows, you can't use the VLOOKUP function. But you can do the job with the FILTER function.

The function TODAY will update the result every day

NOW & TODAY

The functions NOW & TODAY are very useful in Excel. It's the only way to build dynamic date to calculate gap between dates.

Dynamic SUM in Excel

There is 2 methods to create a dynamic SUM in Excel. The first one uses the technique with a Table, the second one uses the function INDEX.

Calculate Percentage Increase with Excel

How to calculate the pourcentage of increase (or decrease) between 2 months

Presentation of a depending drop down list

How to create Depending drop down menu in Excel?

Create a depending drop down menu in Excel has become easier with the new functions FILTER and UNIQUE of Microsoft 365.

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.

Convert YYYYMMDD to DD/MM/YYYY

You can easily convert date YYYYMMDD to DD/MM/YYYY in Excel with formulae or with the tool Table to Column in 3 step

The Correct Value for a Week Number

In Excel the way to return the week number is based on the American system. But most of countries use the ISO system. What is the technique to avoid mistakes.

Round to the next decimal range

Discover the technique that will allow you to round up or down to the nearest decimal range.

SORT your data dynamically in Excel

The SORT functions in Excel has been created to sort your data dynamically. Let's see how to use it and improve your dashboard

SUMIF Function in Excel

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

What is the SPILL error?

SPILL is a new Excel error that occurs when Excel hasn't enough space to return the result. There is a lot of situation where you can have this error.