Generate a dynamic weekly calendar in Excel with this single powerful formula SEQUENCE. Easy and efficient
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
SPILL is a new Excel error that occurs when Excel hasn't had enough space to return the result.
The SORT functions in Excel has been created to sort your data dynamically. Let's see how to use it and improve your dashboard
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
Convert Number to Words is now possible with Excel 365 and the LET function
Create a depending drop down menu in Excel has become easier with the new functions FILTER and UNIQUE of Microsoft 365.
Discover How to Extract Only the Unique Values of a list of data in Excel with the UNIQUE function.