Function

The Excel functions explained

Select the 5 top-bottom values in Excel

With the new Excel CHOOSEROWS function, it's easy to extract the top / bottom rows of your data. Let's discover how to build it.

Warning when the dates are close to the deadline

Highlight the Date outside the deadline in Excel

How to highlight the dates outside the deadline in Excel? You must use the conditional formatting and create your own rule.

How to display hours over 24

Discover how you can display time over 24 hours in your worksheets. You just have to customize the number format of your cells.

The most useful Statistics Excel functions

Excel offers many statistical functions that are easy to use. This article will show you how to use them to analyze your data.

How to Extract numbers from an Excel cell?

How to extract only the numbers of your cells. The technique needs the new function of Excel 365

Percentage increase and decrease with conditional formatting

Percentage formula (increase or decrease)

What is the formula to calculate the percentage of increase or decrease between 2 cells is very simple in Excel.

How to build your dynamic dates in Excel

With Excel, you can build your dynamic date very easily. Discover how to build a dynamic date in this article.

How to do a VLOOKUP on 2 columns

There is two techniques to build a research based on 2 columns. One is with VLOOKUP and the other, the easiest, with XLOOKUP

Formulas for calculating the days of the week

In this article, you will find all the formulas that allow you to calculate the days of the week; like the next Monday, Tuesday, Wednesday, …. Formula to calculate the First Monday of the month The following formula returns the first Monday of the current month based on today's date. =TODAY()-DAY(TODAY())+8-WEEKDAY(TODAY()-DAY(TODAY())+7-1) Formula to calculate the last Monday […]