✅ Download the free course files to follow along
➡️ https://www.simonsezit.com/excel-dashboards-instructor-files/
In this mega video tutorial, we talk you through step by step how to create an interactive dashboard for a sales team from scratch.
We start by looking at an overview of a sales analysis dashboard, combining step-by-step how we create and present data in an outstanding Dashboard. We then move you through Data setup, Wireframe, Headline Stats, sales table calculations, and so much more. Finally, we move on to Dynamic Filled Map Charts and Sparklines and finish with the completed assembly of the Dashboard.
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
0:00:23 - Dashboard Overview
0:05:15 - Data Setup
0:08:39 - Wireframe Design
0:12:20 - Combo Box Setup
0:17:13 - Headline Stats - SUMIFS, MAX, LARGE, and INDEX and MATCH
0:30:03 - Sales Tables Calculations - IF, SUMIFS and COUNTIFS
0:42:24 - Map Chart - Dynamic Filled Map
0:50:42 - Discount Charts - Setup
0:59:43 - Stacked Column Chart - Dynamic with Totals
1:09:36 - Donut Chart - Dynamic with Icon
1:14:21 - Sparklines
1:22:05 - Conditional Formatting
1:33:01 - Dynamic Titles
1:36:17 - Assemble Dashboard - Part 1
1:47:29 - Assemble Dashboard - Part 2
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
✅ Check out our free video playlist for Excel beginners 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z
✅ Excel 2021 Tutorials for Intermediate Users here 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3
✅ Microsoft Excel Tips and Tricks 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
💬Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT
🔔 Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)