How to make an Excel Dashboard in 5 Easy Steps (Interactive + Free File)

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