Build a Logical Test in Excel A logical test Is very important in Excel because it's the starting point for a lot of functions to create dynamic dashboards.
Nested IF in Excel How to write nested IF in Excel? There is 3 situations and 3 functions that can be used. All the case are explained here.
Find Weekends or weekdays in Excel Discover how you can easily find weekends or weekdays with Excel functions. No complex formulas are necessary.
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.
Calculate between two values The VLOOKUP function helps you to return a result between 2 values. Discover how in this article.
Function XOR The function XOR is a logical function to find exclusive OR. That's mean one and only one result (and not TRUE for both)
Create test on String Length 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, ...
Functions AND – OR 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