How to Unstack Data using Excel?
Easily unstack data in Excel with this simple guide. Learn how to quickly rearrange your data for better analysis and visualization.
Dynamic function
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 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.
How to use the MATCH function in Excel
The MATCH function returns the position of an item in a list. This function is very useful to create DYNAMIC dashboard and formulas
Dynamic VLOOKUP research
You can replace the third argument of your VLOOKUP function with a MATCH function to create a dynamic formula to research your data
