Function

The Excel functions explained

Create test on String Length with LEN

The LEN function returns the number of characters is a cell. It's very useful if you have to check the length of names, codes, references

The function DATE is very useful to create your custom dates. This article will explain you how the function works

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

How to split date and the time with Excel? With just to simple formulas, you can extract them in 2 different columns

If you want to calculate the difference between 2 dates in Excel, you have to use a hidding function . It's the function DATEDIF.

The VLOOKUP function helps you to return a specific value inside a table. How to use it? It's not difficult.

The VLOOKUP function helps you to return a result between 2 values. Discover how in this article.

Learn how to use the INDEX function in Excel. Step-by-step guide for beginners and experts to improve your data analysis skills.

Discover all the tricks and mistakes you can have with the IF function

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 functions AND or OR are very useful if you have to create a test on more than 1 criteria. Have a look at the examples in this article

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

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