How to make an Interactive & Beautiful Excel Dashboard in 5 Steps
Dashboards are a highly sought after skill in business analytics. In this comprehensive and detailed video, learn how to create a beautiful & functional business KPI (metric) dashboard using Microsoft Excel in less than 30 minutes.
Prior skills needed:
Basic familiarity with Excel (watch this tutorial: https://youtu.be/F7aPazuS8QY )
How to create a pivot table (watch this tutorial: https://youtu.be/aofsdpjvK7w )
How to create slicers (watch this tutorial: https://youtu.be/ZZ-UGMztoqo )
📁 Sample Files:
Please download the blank data & outline file here:
https://chandoo.org/wp/how-to-create-a-dynamic-excel-dashboard-in-5-steps/
💥 Download completed workbook:
The full dashboard is now part of my Excel School Dashboards program. If you join the course, you will unlock this + 50 more Excel workbooks and 32+hours of videos on all things Excel.
Visit https://chandoo.org/wp/excel-school-program/ to sign up.
📈📊 More Videos on Dashboards:
Project Dashboard with Excel - https://youtu.be/FXnyKU6xZeI
Website Metrics Dashboard with Excel - https://youtu.be/QCrVCUkN2XM
Beautiful Sales Dashboard with Excel - https://youtu.be/bG1Qha-Ii7A
HR Dashboard with Excel - https://youtu.be/ui657YnwLV8
Dashboards Playlist - https://www.youtube.com/playlist?list=PLmejDGrsgFyDN-HoP5wlkvq9zKbWM9KtT
~
Video Timestamps:
================
0:00 - Introduction to the Dynamic Business Dashboard
1:07 - The Blank Data File & our data
1:52 - How to design the dashboard?
3:50 - Setting up the Pivot Tables & DAX
7:35 - Preparing the Dashboard
10:40 - Adding the Bar chart with Top 5 Products
15:01 - Adding the trends
19:22 - Sales Person Table Report
23:48 - Adding conditional formats
25:00 - Tidying up the formatting
26:46 - More things you can add
~
#excel #dashboard
Видео How to make an Interactive & Beautiful Excel Dashboard in 5 Steps канала Chandoo
Prior skills needed:
Basic familiarity with Excel (watch this tutorial: https://youtu.be/F7aPazuS8QY )
How to create a pivot table (watch this tutorial: https://youtu.be/aofsdpjvK7w )
How to create slicers (watch this tutorial: https://youtu.be/ZZ-UGMztoqo )
📁 Sample Files:
Please download the blank data & outline file here:
https://chandoo.org/wp/how-to-create-a-dynamic-excel-dashboard-in-5-steps/
💥 Download completed workbook:
The full dashboard is now part of my Excel School Dashboards program. If you join the course, you will unlock this + 50 more Excel workbooks and 32+hours of videos on all things Excel.
Visit https://chandoo.org/wp/excel-school-program/ to sign up.
📈📊 More Videos on Dashboards:
Project Dashboard with Excel - https://youtu.be/FXnyKU6xZeI
Website Metrics Dashboard with Excel - https://youtu.be/QCrVCUkN2XM
Beautiful Sales Dashboard with Excel - https://youtu.be/bG1Qha-Ii7A
HR Dashboard with Excel - https://youtu.be/ui657YnwLV8
Dashboards Playlist - https://www.youtube.com/playlist?list=PLmejDGrsgFyDN-HoP5wlkvq9zKbWM9KtT
~
Video Timestamps:
================
0:00 - Introduction to the Dynamic Business Dashboard
1:07 - The Blank Data File & our data
1:52 - How to design the dashboard?
3:50 - Setting up the Pivot Tables & DAX
7:35 - Preparing the Dashboard
10:40 - Adding the Bar chart with Top 5 Products
15:01 - Adding the trends
19:22 - Sales Person Table Report
23:48 - Adding conditional formats
25:00 - Tidying up the formatting
26:46 - More things you can add
~
#excel #dashboard
Видео How to make an Interactive & Beautiful Excel Dashboard in 5 Steps канала Chandoo
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![4 Essential Excel Skills Every Entrepreneur Needs 💼](https://i.ytimg.com/vi/WCuqPcvmLPo/default.jpg)
![Create One Pivot Table from Many Sheets ~ AWESOME Excel Trick](https://i.ytimg.com/vi/gi-DSWEUC-A/default.jpg)
![TOP 10 XL Functions #excel](https://i.ytimg.com/vi/vQIgNQ6UfFM/default.jpg)
![Example Data Analyst Interview Question - Can you solve this? 🤔](https://i.ytimg.com/vi/cMEvyhvd5Es/default.jpg)
![I don't use PIVOT tables anymore... I use this other thing instead!](https://i.ytimg.com/vi/SPFQX82X03Q/default.jpg)
![Excel Magic Revealed: Unstacking Data Like a Pro! ✨](https://i.ytimg.com/vi/fOokEIZlh8I/default.jpg)
![What is Microsoft Fabric & what can we DO with it?](https://i.ytimg.com/vi/--cK4A2djoA/default.jpg)
![Power BI Q&A - What is Microsoft Fabric? Tableau vs. Power BI, How important is SQL and more...](https://i.ytimg.com/vi/fOyvqXxADvE/default.jpg)
![How to make a Map Chart in Excel - Quick & Simple Tutorial](https://i.ytimg.com/vi/qNNn5uiZxOE/default.jpg)
![ONLY Excel pros use this INDEX MATCH trick 💡](https://i.ytimg.com/vi/v4RnVh2iGgU/default.jpg)
![I got braces in my 40s!](https://i.ytimg.com/vi/3uNjbewTGGw/default.jpg)
![6 *proven* strategies I used to make $100,000+ with my Excel Skills](https://i.ytimg.com/vi/USU2AzGWu_Q/default.jpg)
![Honey, I shrunk the lengthy Excel formula (by 80%😮)](https://i.ytimg.com/vi/HCEIzeIdiD0/default.jpg)
![FREE Power Query Materclass with 5 Advanced Tips to SPEED UP your work 🚀](https://i.ytimg.com/vi/yJum0g4qM2c/default.jpg)
![How to use TEXTSPLIT() in Excel](https://i.ytimg.com/vi/SI2YbN3CY5s/default.jpg)
![Make a beautiful and interactive To-Do List with Excel (Easy Tutorial 👌)](https://i.ytimg.com/vi/mA93MQgKRTc/default.jpg)
![Email Excel Reports with Power Automate & Office Scrips - One Click Automation 🤖](https://i.ytimg.com/vi/eeCqaokSSoQ/default.jpg)
![Power BI got a MAJOR upgrade - This changes everything!](https://i.ytimg.com/vi/5LhYxgtBToQ/default.jpg)
![Learn Tableau in 15 minutes and create your first report (FREE Sample Files)](https://i.ytimg.com/vi/tNLp_JVipoQ/default.jpg)
![DAX Concepts: How to Create Best in Category Calculations with Ease](https://i.ytimg.com/vi/IGIV_V4rcUY/default.jpg)