Create Dynamic Excel Dashboard in 6 Minutes
☕Buy Me Coffee: buymeacoffee.com/itsmarism
Get the dataset here for free: https://docs.google.com/spreadsheets/...
Build an interactive Excel Dashboard in just 3 steps.
In this video, we will build a dynamic Excel dashboard from scratch in just 3 steps. This will be a Sales Dashboard. First, we will make the dashboard dynamic by using hyperlink to navigate to the different tabs or sheets. Then we will build the overall structure of the dashboard using shapes. Next we will create charts and visualizations which includes dual axis chart - bar chart and line chart, pie chart which shows the success rate %, and stacked column chart of successful and unsuccessful orders per month. We'll also add the KPIs and customize the visuals.
📂 Online store (complete dashboard and templates files - edit and customize as you like!): https://idata-analytics-hub-shop.four...