Function

The Excel functions explained

What is the Most Common Value in your Excel document.

You can easily return the most common number in a range of cells with the function MODE or MODE.SNGL

Generate a dynamic weekly calendar in Excel with this single powerful formula SEQUENCE. Easy and efficient

A running total is a very useful mathematical operation which is very simply to build in Excel.

When a test in Excel returns TRUE or FALSE, you can convert it to 1 or 0 with 2 different techniques. Discover these techniques in this article

The MATCH function returns the position of an item in a list. This function is very useful to create DYNAMIC dashboard and formulas

How to use the XLOOKUP function of Excel? It's a combination of the VLOOKUP and INDEX functions. Look at this article.

UNIQUE is a new Excel function to remove automatically the duplicates in a list of data. It's amazing how simple is it to use this function

SPILL is a new Excel error that occurs when Excel hasn't had enough space to return the result.

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

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 FILTER function of Excel returns all the rows corresponding to a specific criteria. It's possible because of the Dynamic Arrays of Microsoft 365

How to round up or down for decimals, like for instance, 10 cents, 25 cents, 50 cents? The different formulae explain in this article

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

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

How to convert a list of data to a double-entry table? Only one function is needed to do the job. See the technique in this article