Learn how to create a dynamic and modern Excel Dashboard
In this video we are creating a dynamic Excel Dashboards from the ground up, by using best practices and main principles. You will learn how a dashboard should be structured, in order to make it dynamic and as easy to update and to use as possible.
The following visualization instruments are going to be used:
-
Actual vs. Budget Bar Charts
-
Progress Charts
-
Doughnut Charts
-
List Box Form Control
-
Pivot Chart
​
All with dynamic conditional formatting.
Pivot Chart slicers and Form Controls will helps us navigate through the data to display the exact information required.
​
You are welcome to follow along! No Macros/VBA or Add-Ins are going to be needed, just Microsoft Excel 2010 or newer.
If you found this video useful, make sure to like it, share it and subscribe to our YouTube Channel! There, you'll find more free video tutorials.
​
Also, make sure to check out our Excel add-in Pine BI, which allows users to create advanced charts in seconds and help create dynamic Dashboards.
​
You can also review our Premium Templates, which are already set up and ready to use - all you need to do is just add your data!
We're happy to provide the file used in the video above for free. To see the download link, just fill the subscription form below. This way you'll also be up to date with all our updates!
Dashboard Tutorials
Chart Tutorials
Check out our Premium Templates
