There are 3 important steps to create dynamic excel. First of all data cleaning, bring the data in a proper format after cleaning it. The second important step is importing. Third and last is creating a visual.
How to develop a dynamic excel dashboard