3D Formula in Excel In Excel, you can build 3D formulas by making a relationship through many worksheets. Let's see how to build a 3D formula.
Extract items that appear only one time Discover How to Extract Only the Unique Values of a list of data in Excel with the UNIQUE function.
How to return many rows with VLOOKUP If you want to return many rows, you can't use the VLOOKUP function. But you can do the job with the FILTER function.
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.
Dynamic SUM in Excel There is 2 methods to create a dynamic SUM in Excel. The first one uses the technique with a Table, the second one uses the function INDEX.
Calculate Percentage Increase with Excel How to calculate the pourcentage of increase (or decrease) between 2 months
How to create Depending drop down menu in Excel? Create a depending drop down menu in Excel has become easier with the new functions FILTER and UNIQUE of Microsoft 365.
COUNTIFS – Count rows automatically in Excel 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.
Convert YYYYMMDD to DD/MM/YYYY You can easily convert date YYYYMMDD to DD/MM/YYYY in Excel with formulae or with the tool Table to Column in 3 step
The Correct Value for a Week Number In Excel the way to return the week number is based on the American system. But most of countries use the ISO system. What is the technique to avoid mistakes.
Round to the next decimal range Discover the technique that will allow you to round up or down to the nearest decimal range.
SORT your data dynamically in Excel The SORT functions in Excel has been created to sort your data dynamically. Let's see how to use it and improve your dashboard
SUMIF Function in Excel The SUMIF function calculates the sum of specific cells according to a criterion, like a product, country, seller's name, ...
What is the SPILL error? SPILL is a new Excel error that occurs when Excel hasn't enough space to return the result. There is a lot of situation where you can have this error.
UNIQUE Function – Remove duplicates with formulas 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