📊 How to Build Excel Interactive Dashboards

Рет қаралды 2,393,497

Күн бұрын

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
In this step-by-step tutorial, learn how to create dynamic and interactive Excel dashboards. With a dashboard, you can showcase the most important information and key performance indicators (KPIs) that your organization cares about. All you need is Microsoft Excel -- there's no need for any VBA or add-ons. When you receive new data, you can easily update your dashboard to reflect the latest. You can adjust the look and feel using various themes and you can even customize the dashboard to match your organization's color scheme. Once you finish, you can share out your dashboard easily for others to consume. If you'd like to follow along, you'll find the sample sheet that I used below.
📚 RESOURCES
- Sample spreadsheet to follow along: 1drv.ms/x/s!AmxrofZZlZ-whMgx8...
- Introduction to Pivot Tables video: • Pivot Table Excel Tuto...
- Advanced Pivot Tables video: • 🧙‍♂️ Pivot Table Excel...
⌚ TIMESTAMPS
00:00 Introduction
00:52 Background on dashboard
01:25 Overview of data
02:15 Create table
02:55 Insert pivot tables
04:10 Pivot table 1
08:43 Pivot table 2
10:00 Pivot table 3
11:57 Align objects
12:31 Set chart height and width
12:50 Add timeline & slicers
14:42 Connect slicers to all pivot charts
15:47 Using slicers to filter
16:02 Add new data & refresh dashboard
17:13 Adjust view to look less like Excel
17:58 Customize theme
18:28 Share dashboard
18:54 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: • ❎ How to use Excel
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official website: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | shopify.pxf.io/XY9rPa
✅ 📋 Notion | affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | try.elevenlabs.io/taqepq60mptr
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON KZfaq
kzfaq.info?...
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz
⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.
#stratvert

Пікірлер: 1 400

@KevinStratvert 2 жыл бұрын

🥷 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: kzfaq.info/sun/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 📊 In-depth Pivot Table tutorial: kzfaq.info/get/bejne/hsp6rdxqmpzbn2g.html

@banda249 2 жыл бұрын

Sir plz put excel sheet to download

@KevinStratvert 2 жыл бұрын

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

@journeypass5212 2 жыл бұрын

@@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 3 жыл бұрын

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 2 жыл бұрын

Thanks, sir!

@questionresearch8721 2 жыл бұрын

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

@playeroflife Жыл бұрын

Ty for that tip.

@tanglengsreng9530 3 жыл бұрын

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.

@simcoe_seadoo3707 2 жыл бұрын

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

@cherrybaby9061 2 жыл бұрын

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 4 ай бұрын

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

@ArchieDuke. 3 жыл бұрын

Of all the multiple channels I subscribe to on KZfaq - 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.

@davidjsaul 2 жыл бұрын

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!

@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.

@PaulOlaleru 2 жыл бұрын

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

@abdikhaliqmohamoud3373 3 жыл бұрын

Great Teacher, Kevin, EVERYTHING IS SIMPLIFIED.

@bhartityagi8183 3 жыл бұрын

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 .

@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=

@gizellawaram1439 2 жыл бұрын

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

@mikeywhitby65 2 жыл бұрын

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

@doctored50843 3 жыл бұрын

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

@irinamicov 2 жыл бұрын

Amazing video! I found it in an Excel playlist from another KZfaqr/Data analyst and decided to check it out since I have been wondering how dashboarding works in this tool. I was able to easily follow along and replicate everything from scratch. Thank you for this quick and easy lesson on Excel.

@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.

@petervanwyk4707 2 жыл бұрын

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!

@rickblunt1780 2 жыл бұрын

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

@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

@Shady_Emnm 10 ай бұрын

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!

@HellAtlantic 2 жыл бұрын

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

@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.

@user-jv3hk3dn5z 4 ай бұрын

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!!

@dabongmaktong9093 13 күн бұрын

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

@edhorn5640 2 жыл бұрын

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.

@mustiaden6409 Жыл бұрын

I found this as extremely helpful! I have just assumed a position that involves data management and I already feel empowered to do smart job! Thanks!

@forumsempronium3084 Жыл бұрын

Thanks Kevin! Simply great! I got everything I needed to know about making dashboard for analyzing in my case: all possibile public financing and grants programs for innovation projects in my region. Every detail of your presentation is just perfect (clarity & structuring of content, duration of presentation .......... everything!!!)

@brianabadom 2 жыл бұрын

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

@cbalian 3 жыл бұрын

I am such an Excel geek at

@collinsk.langat6230 2 жыл бұрын

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

@ktrice11 2 жыл бұрын

Mannnnn, you knocked this one out of the park. I tried watching others and they were too informational and boring. I was very receptive to this video and the way you explained it. You did a great job and I subscribed. Thanks man!

@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!

@kofiAnkraAsareAttrams 2 жыл бұрын

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

@suzysasse 2 жыл бұрын

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

@MarwaMahmoud-zo9zi 10 ай бұрын

Weirdness Lauderdale

@1AmazedAnne 4 ай бұрын

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..💃💃

@missaltay718 Жыл бұрын

You Rock Star you!! This will be the first project I will be publishing. I have done several but this is the prettiest and the easiest project I've completed so far, and it looks like I may know what I'm doing, (I don't!). Thanks a million for this one Kevin🤓🍪

@phucnguyenxuan5227 2 жыл бұрын

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!

@strategy_gal 3 жыл бұрын

This is a really great tutorial, Kevin! It was very clear and simple. Keep it up!

@harunskywalker4942 Жыл бұрын

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

@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

@debbietownsend1673 10 ай бұрын

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

@gracemark5995 3 жыл бұрын

these dashboards really helped me a lot , thanks for this awesome video kevin

@PuddingMaaan Жыл бұрын

Amazing video. Straight to the point and very simple yet powerful explanation of how to use dashboards and pivot tables. Thank you

@emmanuelmalumedzha5052 2 жыл бұрын

Great content. I always pick up simplified methods to get things done quicker. Thank you Kevin.

@msgreen 10 ай бұрын

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

@DarkDudesAI 3 жыл бұрын

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 3 жыл бұрын

Yep. We can agree

@richardwegrzyn 3 жыл бұрын

Word!!!

@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.

@cece82gemini27 11 ай бұрын

Great video! Easy to follow, quick and to the point and I'd probably rewatch for additional knowledge purposes and note taking. Thank you! 😊

@swastikszn1781 3 жыл бұрын

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

@CheezerSuper 3 жыл бұрын

This is brilliant!! Always learn something new :)

@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.

@conordunne4862 10 ай бұрын

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!

@bonnievillanueva2441 3 жыл бұрын

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

@rahulrustagi6119 3 жыл бұрын

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

@dimaeljanoudi3178 Жыл бұрын

This was awesome. i followed along and I actually created a dashboard that I'm proud of! Thanks Kevin for the simple explanations

@stuartduncan2772 2 жыл бұрын

Good video. Just in time for me. I've been tasked with sorting out a team performance board that has been cobbled together by no techs and it is a shambles. This has really helped. Thank you.

@pushkalvashist3637 3 жыл бұрын

“Hi everyone Kevin here” ahhhhhh never gets old

@travelwell6049 3 жыл бұрын

What about “ turr day”

@blessedandbeautiful8365 3 жыл бұрын

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

@travelwell6049 3 жыл бұрын

@@blessedandbeautiful8365 you have to do a shot

@priyadarshirajan 3 жыл бұрын

Yup I kinda like it.

@coffeebean4951 2 жыл бұрын

To-dddaaaayyyyyyyyy

@stuartbrown3859 3 жыл бұрын

I learnt a ton with this one. Love the background music at the end

@minhcvu1293 2 жыл бұрын

This is a really great training session. I've enjoyed it very much and have learned so much. Thank you!

@Videolover777 2 жыл бұрын

Good job Kevin. You covered a lot of detail in an easy-to-follow video. Thanks!

@millionandbell7779 2 жыл бұрын

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

@orthodoxsophia 2 жыл бұрын

lol...I thought so too.

@guillaumecourtens9594 3 жыл бұрын

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 2 жыл бұрын

Isnt there something like autofit?

@grilledcheesekid7370 2 жыл бұрын

I came for a refresher on dashboards and left with an answer to a frustrating sorting problem! Wow. Just awesome.

@d0zxe 9 ай бұрын

wow this was so easy to understand, I like how you were straight to the point and didn't bore us with unnecessary details. Thank you!

@SavageGothamChess 3 жыл бұрын

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

@gajabathiarjuntg2390 3 жыл бұрын

I think in Twitter

@BunderChowed 3 жыл бұрын

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

@rachelbenton4609 Жыл бұрын

This is so helpful. I didn't even know where to start, but now I feel like I can confidently create a dashboard.

@venortancelot9227 Жыл бұрын

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

@danieliskander9680 Жыл бұрын

Hello Kelvin. You are a magician. Thank you for this wonderful presentation. Your work is clean and simple and I am going to make this video my go-to video every time I have to work on tables and charts. Thank you big time.

@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!...

@efronnjobvu545 2 жыл бұрын

Simplified straight to the point. You are a life saver man

@leequist2908 2 жыл бұрын

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.

@ceciliachan2775 2 жыл бұрын

Kevin, your videos are really excellent!!! Easy to follow and very informative and inspiring!! Can you please also share when we should use Excel dashboard and when to use Power BI? Thank you!

@Tahuti418 6 ай бұрын

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

@feridad1928 Жыл бұрын

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

@RadarblokeAnna Жыл бұрын

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

@ramaxow Жыл бұрын

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

@Shan3rdI Жыл бұрын

I've really been enjoying and learning a lot from your videos. I love your presentation style and step by step instructions. Most grateful.

@yvanyombeu2341 Жыл бұрын

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

@adriaanvantonder3599 Жыл бұрын

Thank you for the education kind sir.. this video has placed me at a whole new level in my office. My commanding officers are still baffled by the new way i present my data. I graciously soak up the knowledge you share.

@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.

@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.

@jesusbvasquezq6597 Жыл бұрын

Excellent tutorial, well passed and direct to the point, many thanks Kevin for sharing this!

@AldrieCutamora Жыл бұрын

Very informative and precise explanation. Thank you so much!

@lookingforwardto Жыл бұрын

Great excel teacher I have ever see in youtube. Nice presentation & material. Thanks

@stephaniehill9097 9 ай бұрын

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

@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

@nitinbisht1520 Жыл бұрын

Thank you so much Kevin, so nicely explained each and every step. Much appreciated your efforts. I really learned a lot from this video 😊

@angelique3605 6 ай бұрын

I am impressed. Your teaching skill is top-notch. Now I can confidently create my own dashboard. Thank you for this video

@empoweredintroverts Жыл бұрын

This video was just what I needed to help recreate a dashboard for my Business Analytics class! You gave me back my weekend :)

@ros_na Жыл бұрын

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

@sekharispassion Жыл бұрын

Sir, Thank you for your valuable video on preparing dashboards. Will take note of each and every step shown in the video and try to prepare a dashboard when required by my office management. Till then will practice on the rough data (sample data) and make myself well prepared.

@hafshawahab5887 8 ай бұрын

Best video on Dashboard....it has been a saviour for me. Thank you so much for making this video. 😍 Also the video is also at its correct pace and absolutely clear. Excellent video 😊

@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.!!!!

@tazmanboo Жыл бұрын

I absolutely love your video. You are very clear and make learning easy! THANK YOU!!!

@yeganelip Жыл бұрын

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

@AlexOsborne10 2 жыл бұрын

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!