How to Create a Stunning Interactive Dashboard in Excel! Sales Excel Dashboard

How to Create a Stunning Interactive Dashboard in Excel! Sales Excel Dashboard - Crash Course

Рет қаралды 65,428

3 жыл бұрын

✅ Download the free course files to follow along
➡️ www.simonsezit.com/excel-dash...
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 ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Excel beginners 👉 • Microsoft Excel Beginn...
✅ Excel 2021 Tutorials for Intermediate Users here 👉 • Excel 2021 Tutorials f...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Microsoft Office 2021 and Office 365 Training here 👉 • Microsoft Office 2021 ...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
kzfaq.info...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

Пікірлер: 40

@SimonSezIT 2 жыл бұрын

✅ Download the free course files to follow along ➡www.simonsezit.com/excel-dashboards-instructor-files/ 🔥Check out our FREE 300+ hour training course playlist here 👉kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀Level up your Excel skill set with this free playlist 👉kzfaq.info/sun/PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z

@ghadeeromari4707 2 жыл бұрын

I can’t download the excel materials!

@Lyriks_ 2 жыл бұрын

Good instructor are able to explain difficult topics, Great instructor are able to make difficult topics easy to understand, Best intructor are able to make the whole process enjoyable, and I really enjoyed this one !

@SimonSezIT 2 жыл бұрын

Thank you very much!

@AjaySharma-oc8hz 2 жыл бұрын

This is Awesome !

@rocketmannsingh3742 7 ай бұрын

Had to write this review. Guys you are amazing seriously never ever seen someone explaining this way. I literally understood it. Greate work! I mean who goes this much extra miles to make us understand these things on youtube 😅.

@SimonSezIT 7 ай бұрын

Whoa, thanks a ton for the awesome review! We're glad that our explanation hit the mark for you. It's our mission to make sure our videos are as clear and helpful as possible. Keep watching, and we'll keep delivering the goods! Cheers! 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!

@beyobeya 3 жыл бұрын

Superb! Thanks a lot!

@SimonSezIT 3 жыл бұрын

Thanks for watching Mark!

@alexxgalindo8557 2 жыл бұрын

Thanks for this amazing content btw

@SimonSezIT 2 жыл бұрын

Thanks for watching!

@allison447 2 жыл бұрын

Myndi Tracy?? - great work, like the new functions to save a ton of time troubleshooting. one tip: all those chart references and year drop down can be a named range so no need to go back to the data to click and collect it.

@kebincui 2 жыл бұрын

Super 👍👍👍👍🌹🌹

@tlc1795 3 жыл бұрын

Excellent!

@SimonSezIT 3 жыл бұрын

Glad you liked it!

@SimonSezIT 3 жыл бұрын

Thanks Tasha! I appreciate you commenting and delighted to hear you’ve enjoyed the course!

@nguyentranhoang3617 3 жыл бұрын

Thanks for a good video

@SimonSezIT 3 жыл бұрын

You are welcome

@SimonSezIT 3 жыл бұрын

Thanks for watching!

@tauhidanwar3512 2 жыл бұрын

Thanks for the awesome tutorial. I have one question. I am using excel 2016 and not able to use unique function. Any alternative options will be highly appreciated. Thanks again

@keerthikumar7126 3 жыл бұрын

Can you create a similar dashboard for customer satisfaction survey dashboard which can be used in service desks also we have KPI and SLA dashboards those can be great examples due to the complex nature.

@KenyaCosmetics 3 жыл бұрын

kindy do a video of procurement dashboard

@preetisalgaonkar5915 3 жыл бұрын

Kindly help. When i start adding columns to the sales table - Calcs, the data gets deleted and shows Name? in the product and country column. So can not proceed further. Please note I am using office 19.

@alexxgalindo8557 2 жыл бұрын

I have the latest update of excel 2019 and I don't have that formula. any advice

@xlwatcher8885 Жыл бұрын

The link provided does not give a downloaded file. It opens up another screen which says "Get my files," but no downloaded file??? Can you send a link? Thank you very much!

@michelelomonaco5118 2 жыл бұрын

Hello, I can't download the Excel materials, despite sending the email address. Thank you.

@kroyle5328 3 жыл бұрын

Download files does not work

@edjk6278 Жыл бұрын

are the files still available? I am receiving the email correspondence.

@SimonSezIT Жыл бұрын

Hi! Make sure click on the confirmation link to confirm. If you've already done that, please check your spam/junk folders.

@jenquinlan193 Жыл бұрын

I took one of the free courses and downloaded the applicable spreadsheets after confirming my email address. Now, when trying to sign up for another free course, it brings me to the request for my email address but nothing is ever sent to me. It seems that once you have my email, it no longer works to trigger the auto send of any other materials. :(

@SimonSezIT Жыл бұрын

Sorry about that Jen. Please check out spam/junk folder. If it's not there, contact our support team via email, letting them know what video you need the files for.

@alicenexon1381 Жыл бұрын

wish tNice tutorials could be

@frontiermedia8772 3 жыл бұрын

Hi I would like to ask where is the previous vedios

@SimonSezIT 3 жыл бұрын

Hi Reyzu, this video is part of our longer Dashboards in Excel course. You can access them all by becoming a Simon Sez IT member: www.simonsezit.com/signup/

@preetisalgaonkar5915 3 жыл бұрын

please guide.