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