📊 How to Build Excel Interactive Dashboards

[@KevinStratvert]

🥷 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: kevinstratvert.thinkific.com ⏭ Watch more free Excel tutorial videos: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 📊 In-depth Pivot Table tutorial: kzbin.info/www/bejne/hpWtq6xvapuqpZY

[@banda249]

Sir plz put excel sheet to download

[@KevinStratvert]

@@banda249 you’ll find it in the description of the video 👍

[@journeypass5212]

@@KevinStratvert I am not finding the Excel sheet, it says someone has Deleted it....

[@rudiansyahsyah9738]

classroom speak basic simbol in commonecation sortware year 2022 / 2023 sys data com master personal quality utility 🏛🌍🌎🌏

[@anhquanle2261]

@@LimpSociety It s right below the VDO description and downloadable

[@kuuuyajim]

Before sharing the file with team members, I recommend locking all items on the dashboard - only slicers should be interactive. I once created a dashboard and people messed it up. A tutorial on the recommended settings for "Format Cells>Protection", "Review tab>Protect", and object "Size and Properties" would be nice. These are under the hood settings but are important things to learn. Thank you!

[@AbhishekSanyalTGV]

Thanks, sir!

[@questionresearch8721]

Thank you

[@adriaanvantonder3599]

Have the same thing. Want to share it but want only the slicer to be selected. People in my organisation like to click arounf on things they should not and dont want them to change the formats and standards i set. Did you perhaps find a work around since the post?

[@maestro4337]

had the same experience and completely agree

[@allmac7504]

So true!

[@leequist2908]

No way! Not me learning how to do this in 19 minutes. You must be protected at ALL COST. Thanks a million for this and the other tutorial videos.

[@mosheditshoke]

Right!!! This made my day

[@petervanwyk4707]

You have a real talent for communicating loads of information, but making it simple for people to grasp quickly. Not to mention your effortless flow of your videos. Thanks for this video!

[@RamonaHuerta-d2o]

Kevin, I will agree with one comment here, this is one of the most simple, very easy, and well-explained videos. I could build my first dashboard, THANK YOU!!

[@bhartityagi8183]

Always keep in mind that ppl who see his tutorials might be new or their first time. Every movement of curser showing how every options work. So much detail. U r always a saviour. And do ur company really sell in India . I want to place order if it is yes. Thank u once again. Our great professor Kevin .

[@mautasim8798]

This is by FAR the best comprehensive straightforward video about pivot tables and dashboards. Spending the 19 minutes allowed me to understand everything, which was not possible during my 4-hour class !! Now I feel I should pay you for this haha

[@cherrybaby9061]

Thank you Kevin. This is so far the best 19 minutes and 20 seconds of my time! Thank you for helping me learn much in such short time!

[@nephastgweiz1022]

Let's hope your husband doesn't see this comment

[@vals.2721]

It's difficult to believe I managed to do this. You basically saved my presentation. Thank you very much. I have learned so much watching your tutorials. You should have way more subscribers.

[@neilgoodman2885]

I think people think it is too hard and cover their feelings of inadequacy with the word "boredom." Too bad, it is very entertaining. =NHG=

[@simcoe_seadoo3707]

Your ability to convey a concept and transfer the skill set is outstanding!

[@ahavadas4672]

Your steps are as interactive as the dashboard created. Thanks Kevin for creating videos which makes learning supposed complicated parts of Excel super easy.

[@ArchieDuke.]

Of all the multiple channels I subscribe to on KZbin - this has become my favorite channel. My skill levels just improve literally by the day. Many thanks Kevin, and I hope the cookie company business makes you filthy rich.

[@PorshaLaVieBelle]

Kevin, I want you to know that I am so eternally grateful for you! Thank you for all that you do and for sharing your knowledge, you are appreciated.

[@tanglengsreng9530]

I’m literally grateful for this video. My final project requires me to apply what we learned in excel class on that project. This is super helpful.

[@BettyAdamou]

Absolutely AMAZING. I followed step by step and now have something fab to help my team quantify their hard work in a visual and interesting way. Thank you so very much! Subscribed!

[@PaulOlaleru]

This tutorial has further exposed me to the power of Excel. Your training is simple to grasp and easy to follow. Thank you!!!

[@AhmedGamal-mi1ns]

Your voice is so clear. With a few simple steps and beginner tools, we managed to produce a good-looking dashboard. Thanks, Kevin

[@abdikhaliqmohamoud3373]

Great Teacher, Kevin, EVERYTHING IS SIMPLIFIED.

[@Clara-fp5yt]

This is an excellent video! I followed along with you...pausing and going back as needed...and developed my own dashboard. In what would have taken me hours/days trying to figure out first of all how to organize my data and secondly, how to dice and slice it to end up as a bonafide dashboard, took me under an hour from start to finish. I have added a new and valuable skillset to my toolkit thanks to you. Much appreciated!

[@davidjsaul]

Great timing, I've been given a project to manage at work and want to build a dashboard to track progress. My excel skills are decent but this kind of stuff is way out my level so really happy you've done this!

[@jaleesatimberlake5845]

This video was awesome!! I have been struggling for weeks to figure out how to build a dashboard in Excel. With this video, I got it done in 30 minutes!

[@JustBlankNoInfo]

Kevin is showing us lots of Excel and by the way you Excel in Excel! Can we all agree we don't think anything when we see a Kevin video pop up? We click on it. Wow, the cookie in the thumbnail just might have got me more reflex to click it! Awesome video

[@Ryuzaki2100]

Yep. We can agree

[@richardwegrzyn]

Word!!!

[@1AmazedAnne]

Thank you very much, Kevin for this video. I spent hours yesterday and last night watching videos on how to make interactive dashboards, but I got it when I watched and followed along practically. Much appreciation..💃💃

[@dabongmaktong9093]

Honestly this is one of the best excel training I have had in just a few minutes. God bless you sir.

[@MasterSpreadsheets]

Lifesaver - never realized how easy it was to make dashboards with pivot tables

[@brianabadom]

Kevin, thank you for the pace and tone you use in your posts. I can't wait to purchase your products.

[@harunskywalker4942]

You are a good teacher who explains difficult concepts easily. Thanks

[@cjherrera8826]

This video is perfect. I got everything I needed to get started right away. No fluff, no filler. I have upped my excel game thanks to your videos.

[@waynelast1685]

what version excel are you using? I am using the latest 365 version and my appearances are not always the same.

[@gizellawaram1439]

one of the most informative excel tutorials I've watched so far! Simple and straight to the point. Learnt so much, thank you

[@venortancelot9227]

My God, the best lesson i have learnt . Simple - clear and quick

[@HellAtlantic]

This was an amazing video and I basically learned Excel dashboards via pivot tables just by watching this cuz the information was taught perfectly.

[@debbietownsend1673]

You are an excellent teacher, Kevin! You are organized, well-paced and you explain things very well.

[@yvanyombeu2341]

It's awesome. Aftercall the stress i went through in learning how to create dashboards...I finally got the knowledge for free.

[@bonnievillanueva2441]

I always love the intro, hi everyone, Kevin here! ❤️

[@arkzmacaspac7050]

this is better and easy to follow than the one ive watched from another tutorial. I didnt know that you can sort data directly in Pivot. this will surely lessen my time. thank you.

[@mikeywhitby65]

Great work - really makes things much easier to understand and so much easier than trying to read a book. Thanks Kevin

[@BenDieselBasicAutomotive]

I have watched this video a couple of times. Now, I was able to create my own dashboard and my Boss was very glad with my report. Thanks again, Idol.... I'm an avid fan!...

[@Blue_Azure101]

Whose watching this on the day before it’s due at the meeting? 😂🤚🏻

[@VForShort]

😂

[@collinsben9138]

😂

[@dennisombaka2425]

Bless you my wonderful tutor. What some tutors explain in hours, Stratvert does it in less than 20 minutes. Your skill set is superb bro. Keep up the good work.

[@doctored50843]

Wonderful lesson! You make it seem so easy to do! Thanks for the easy to follow step-by-step instructions.

[@mahamad4717]

YOU ARE AMAZING!! i have 30 minutes left to submit my assignment and i know ill be able to do that thanks to you for showing it in such a simple way.

[@suzysasse]

Great content, easy pace, no distracting music…thank you!

[@MarwaMahmoud-zo9zi]

Weirdness Lauderdale

[@yeganelip]

you`re one of the best people which I've ever seen for teaching. thanks for your great videos!

[@rickblunt1780]

Awesome presentation, well spoken, thoughtful and easy to understand. I have been using Excel and VBA for years, I knew that I needed to learn pivot tables/charts but I was always afraid to tackle it. This video is making me a lot less hesitant to try it - thank you

[@conordunne4862]

This video saved me in my MBA Business analytics course. One of the best videos I have ever seen on youtube and you are so good at teaching!

[@chinyerenwosu9169]

Quite insightful. Now I can comfortably build my excel dashboard.

[@POPOOLAQAZEEM]

Did you have the spreadsheet..can you pls share?

[@thebesttechnical3608]

This dude literally knows everything.

[@swastikszn1781]

"Hi everyone Kevin here" Love the intro And also Good work Kevin!

[@Tahuti418]

Nice to get a video that gets right to the point!! No intro, no logo, and exactly what I was looking to get. Thanks.

[@pushkalvashist3637]

“Hi everyone Kevin here” ahhhhhh never gets old

[@travelwell6049]

What about “ turr day”

[@blessedandbeautiful8365]

Yes 😁 and when he says Kevin Cookie Company…golden lol 😆

[@travelwell6049]

@@blessedandbeautiful8365 you have to do a shot

[@priyadarshirajan]

Yup I kinda like it.

[@coffeebean4951]

To-dddaaaayyyyyyyyy

[@dflick799]

THANK YOU KEVIN! You make learning Excel so easy and for that I am very thankful. As I have tried to learn form other Excel teachers/demonstrators and only became more confused and very frustrated. I now only watch your tutorials video's.

[@msgreen]

By far best demo I've seen for a beginner. Clear, concise and meaningful presentation. Good job Kevin!

[@NasserMGH]

You instruct students in the use of Excel and other software. You deserve a like and a follow-up because I watched the whole video. I went to all of your social media sites and read the descriptions... I really enjoyed it, and I'm eager to learn from you and power BI. I'm overjoyed to have located a resource for data analysis and charting software. Your explanation is lovely, but what I find most lovely is how straightforwardly you presented the information. Accept my greetings, please. From the Kingdom of Saudi Arabia, Nasser.

[@kofiAnkraAsareAttrams]

I’ve been looking for a way to do this for awhile. Love the simplicity. Thanks man.

[@grace_upon_linda]

Thank you so much for this . I am on a journey of becoming a data analyst. I am glad to have built a dashboard! Woop woop!🎆

[@abiodunoshinowo2702]

Kevin is a Microsoft wizard... I am super glad I come across your channel... Kindly keep up the good works. God bless!

[@cbalian]

I am such an Excel geek at

[@collinsk.langat6230]

please help with something. The profit calculations are wrong on my pivot table

[@paulogumisiriza6624]

Kevin you're such a blessed teacher

[@edhorn5640]

Great video. Your delivery is nice, smooth, and to the point. Thank you for not being one of those "teachers" that rambles on forever about absolutely nothing. One thing that would be amazing in your dashboards is a single command button that would clear all the slicers/timeline filters in the dashboard with a single click. Do you think that is possible? Also, I do agree with Jimcarl S. that certain elements of the dashboard should be locked.

[@ros_na]

YOU ARE THE BEST KEVIN!!! SIMPLE, CLEAR AND HELPFUL .

[@rahulrustagi6119]

Best tutorial for dashboard. Wish i got my cookie also.

[@tajakicaterrell9487]

This is absolutely FANTASTIC! Very user friendly and not too long of a video.

[@millionandbell7779]

Is Kevin Stratvert an AI that Microsoft is testing, because his videos are perfection

[@orthodoxsophia]

lol...I thought so too.

[@ameraizat4810]

Thank you so much sir. I've learnt a lot just by watching this video alone. Cant wait to watch them all! Thank you so much!!😊😊

[@phucnguyenxuan5227]

Great video, i went through quite some of your videos, as the content was great! Thanks a lot for sharing your knowledge and put it into a great educational sequence Always something new to learn!

[@RadarblokeAnna]

Thanks Kevin! May you’ll be blessed more for sharing your knowledge.

[@guillaumecourtens9594]

Hello, one issue I have is that sheets won’t look exactly the same on various screens. For example you craft a very nice cell, you set width manually to look good on your computer, but when it’s opened on another computer, the text does not fit the cell anymore. Any tips on how to keep things looking good ?

[@TechTeacherTT]

Isnt there something like autofit?

[@ishtiaqahmed7666]

Hi Kevin, I am watching your video from Pakistan 🇵🇰. I loved all your tutorials mainly for one reason and that is your "way of delivery". It's awesome👍. A big fan of your from 🇵🇰

[@SavageGothamChess]

Hey Kevin I just wanted to know whether you are on any social media platform where you reply to direct messages?

[@gajabathiarjuntg2390]

I think in Twitter

[@stephaniehill9097]

Thank you SOOO much! You told me more in 19 minutes than a professor in an hour!!

[@BunderChowed]

“Your thEOry of a DOonut shaped YOUknee-verse is inTREEging. I may have to steeeel it.”

[@qaziusman85]

I used to learn new things everyday after watching your videos❤🎉

[@focusalibi6807]

wow, This is the best tutorial i have seen on Dashboard on YT so far. I love it. Thank you!

[@justinabosco2763]

@kevin you are a superstar. I send weekly report to my GM, but this week I added this dashboard. She is so happy. 😍

[@mafejayme350]

An excellent guide for learning excel dashboards comprehensively with ease.

[@abhijitd80]

This is a great example of how to make an illustrative video. Thank you!

[@feridad1928]

You've helped millions with your videos. I hope one day a lot of the good you did comes your way. Thank you!

[@ramaxow]

Thanks Kev. You are an amazing tutor. I have made my Dashboard after watching the video just twice.

[@tapiwahlomayi7145]

Ooooohhhh Kevin you are amazing. I am still referring to this in 2023 !!!!!!

[@arpro3038]

OMG, This is the best Dashboard video on KZbin. Thank you for creating it.

[@necof3762]

I have been voluntold to create a dashboard by 3/28/24. Your tutorial will help me, I will revisit this several times!! Thank you so much for the easy information, I hope it is this easy once I begin the work!!

[@adriandiazkeith1761]

Absolutely my favorite tutorial by Kevin Stratvert! Can't wait to test it out for with my Team. Mahalo

[@petchompoopotiwong8561]

One of the best tutorial so far! Thank you Kevin for saving my corporate life.

[@HudhayfSuleimanYear10-gp5lm]

thank you I have an ICT GCSE coursework to do this really helped me i appreciate it .Have a good life sir .Your saving lives.!!!!

[@aleksanderguga603]

Great guy ..... You have explained everything in 20 minutes

[@unemployedgraduatesassocia3824]

Thanks, Kevin for impacting me with your knowledge of creating Excel Dashboard

[@Shady_Emnm]

I just found your channel and I just want to say awesome job. You explain and show everything in a very clear way and have helped me improve my excel skills. You don't rush or just flash up a formula. This is great I can't wait to see what I can accomplish with your guides!

[@AlexOsborne10]

this is EXACTLY what im looking for for my business analyst job role im applying for. confidence boost for my interview next week! FYI im from Malaysia , your cookies are amazing!

[@AnaMaria-om8qw]

Thank You!! This is one of the best videos that I have ever watch!!

[@ngesangngetleh425]

Thank you very much Kevin, my Excel skills have been upgraded thanks to your easy to follow videos. The sample excel worksheets you share are super helpful, thank you for being very generous with your knowledge and skills. God bless you

[@SimonUjah]

Hi, Kelvin, you deserve any amount of thanks. You have my admirations

[@WK6mm]

Just simply wow, even I am just a newbie, I understood it well the way you illustrated and taught it. Thanks alot

[@olemissjch]

Fantastic job Kevin! I built my own Dashboard of my data while watching this tutorial. Thank-you!

[@KevinStratvert]

Nice work!

[@aitrends8901]

I already knew power of excel but your video and presentation is simply Fantastic !!!

[@koleriley28]

I very rarely comment but just wanted to say thanks for this video. This video was super helpful for me to fill the gaps in my excel knowledge to complete a dashboard project I had.

[@DewanaStrauder]

Wonderful tutorial!!!! This was just what I needed to dress up Excel from those boring tables!!! Two thumbs up!!!!

[@talknow2859]

I learnt more in these 19 mins than I have with most other videos. Thank you 🎉🎉🎉

[@Minttyr6551]

I was Kevin!!!🤩 Much appreciated, I'll be back for more of your guided insights! Great Stuff!!!!!!!!!!!!!!

[@FugieMax]

This is very helpful especially for those who are still learning the pivot table just like me. Thank you so much!!!!

[@adekunlebadejo82]

THANK YOU, THANK YOU, THANK YOU! Easy flow. I was able to build another dashboard entirely following this video.