Create a weekly calendar with just one formula
How to create a weekly calendar with just one formula. The SEQUENCE formula does the job and it's not complex
Dynamic arrays
How to use the FILTER function in Excel?
The FILTER function of Excel returns all the rows corresponding to a specific criteria. It's possible because of the Dynamic Arrays of Microsoft 365
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 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.
Convert Number to Words in Excel
Convert Number to Words is now possible with Excel 365 and the LET function
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
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
