How to Create Impressive Interactive Excel Dashboard

How to Create Impressive Interactive Excel Dashboard | Ultimate Excel Dashboard Ep. 1

Рет қаралды 2,328,439

4 жыл бұрын

✅ DOWNLOAD Dashboard and Data here ► excelfind.com/tutorials/ultim...
📌 EXCEL VERSION: Microsoft Office 365 - Get it here ► geni.us/Office365_Microsoft
▬▬▬▬▬▬▬▬▬▬
🔥BIG NEWS ► Launch of excelfind.com 🔥
I just launched my new Excel Resource Website and kindly invite you to check it out.
I put a lot of work and research into it to provide you with the biggest possible value!
Main Website ► excelfind.com
Recommended Courses ► excelfind.com/courses
Tutorials ► excelfind.com/tutorials
Most Powerful Excel Add-ins ► excelfind.com/add-ins
And even better, I integrated the most up-to-date databases about all relevant functions, formulas, and shortcuts. You can use our advanced filtering system to filter by Relevance, Category and even minimum required Microsoft Office Version. That means you can learn about all new functions in Microsoft Office 365 with only one click!
Excel Functions ► excelfind.com/excel-functions
Excel Shortcuts ► excelfind.com/excel-shortcuts
If you like that website and want to help me grow, please consider to share it with everyone you know.
Thanks for your support!
▬▬▬▬▬▬▬▬▬▬
How to Create Impressive Interactive Excel Dashboard | Ultimate Excel Dashboard Ep. 1
In this Excel Tutorial you will learn how to create an impressive and interactive Excel Dashboard from scratch by combining Pivot Tables, Pivot Charts, Slicers, and a beautiful design concept.
This is the first Episode of the Ultimate Excel Dashboard Tutorial Series and it covers the creation of the basic Dashboard. The following Episodes will go deeper into specific design topics, Automation and the integration of truly advanced features like fully functional info buttons, in-tale tab functionality and a collapsable settings area with state-of-the-art radio buttons for dashboard color theme selection and modern toggle buttons to control the visibility of specific dashboard elements.
If you want to build this dashboard yourself, we recommend to upgrade your Excel Version to the latest one which is included in the Microsoft Office 365 Subscription. Find the link for current offers in the Official Microsoft Online Store below ↓
▬▬▬▬▬▬▬▬▬▬
You want to become a master in Excel and learn all modern and relevant Excel techniques?
Then definitely have a look at the following links:
🚀 OUR EXCEL RESOURCE WEBSITE ► excelfind.com
💎 RECOMMENDED ONLINE EXCEL COURSES
GoSkills is our favourite & it’s not even close. Have a look ► bit.ly/30PWMnQ
📌 EXCEL VERSION IN THIS VIDEO
We use the latest version of Excel via the Microsoft Office 365 subscription. This allows us to have all the latest features like new chart types, a huge integrated icon library, improved functions, and so much more!
If you want to upgrade your version as well, we recommend to get it from the
Official Microsoft Online Store ► geni.us/Office365_Microsoft
▬▬▬▬▬▬▬▬▬▬
You want to show your support and help me grow?
Here is what you can do.
🚀 SHARE MY NEW EXCEL WEBSITE ► excelfind.com
☕ WANT TO MAKE MY DAY?
Buy me a Coffee ► bit.ly/2Oqg6Cu
🔥 MORE AWESOME EXCEL AND POWERPOINT CONTENT
Subscribe ► bit.ly/37bcvAB
Note: Some of the links in this description are affiliate links, meaning, at no additional cost to you, we will earn a commission if you click through and make a purchase. This supports the channel and allows us to continue to produce videos like this. Thank you for your support!
#interactive #excel #dashboard

Пікірлер: 814

@HellfireCarnage 3 жыл бұрын

Best Excel dashboard tutorial I have ever seen. Very well planned, presented, and explained. Thanks for this! It has definitely encouraged me to do better designs for my own work in the future.

@MarkHooperMegalev 4 жыл бұрын

Genuinely good - I haven't rated a free Create-A-Cool-Dashboard tutorial as even worth watching before - this has a big tranche of little tips and tricks. Good effort, I wish ExcelFind all the best.

@theofficelab 4 жыл бұрын

Thank you for such a positive feedback, Mark! 😊

@MrWincoin 4 жыл бұрын

Just checked it out. If check the separate sheet and chart, it's very simple. What impressed me is that combine all chart together and looks very great. I gotta optimize the one I just have done some days before.

@michaelthomassmith6835 3 жыл бұрын

The Report Connections component is completely game-changing for me. I normally have to create VBA ComboBoxes to alter the data in multiple charts. This is so awesome!

@theofficelab 3 жыл бұрын

Hi Michael 😊 It is really great to hear that this detail is game-changer for you. I hope this feature serves you well in your next projects. Wish you all the best!

@gargantuan4696 3 жыл бұрын

This is what employers expect when they see “proficient in excel” on your resume

@G10cK94 3 жыл бұрын

I think they expect something more, like Power Query, Power Pivot, M, DAX, VBA

@thebeautifulanimal Жыл бұрын

Yes but we are too reluctant to learn to improve ourselves.

@rodlivz Жыл бұрын

🤣🤣🤣 true, sooo true

@mustaphadiallo2134 Жыл бұрын

@@G10cK94 VO8 BO8 BB GV80AQATC JUC RELATTE HUMAIN SOGOOD SOOFUT

@Goakel 10 ай бұрын

I play on excel as hobby and self taught made a similar dashboard. I even removed pivot tables to use regular tables and charts with VBA macro to resize and change colours so it’s dynamic like a pivot chart. I’m a pipe fitter and play on excel on the weekend. So if this is advanced, yikes lol I think I should switch careers

@leanngong5512 2 жыл бұрын

Thank you so much for the free tutorials!! I I have been taking training classes and buying books and nothing I have learned were as practical and with so much detail as your tutorials. I really appreciate.

@parveenshaik1630 Жыл бұрын

honestly the best soft tutorial ive ever seen. short and straight to the point ! i love it

@FrocketGaming 4 жыл бұрын

I love Excel so much, videos like this just get me so excited.

@IrishmanMP 4 жыл бұрын

AMAZING WORK! Seriously great stuff to show the flex that Excel offers. I can't believe that I am writing this, but I am looking forward to watching the rest of your videos on this. Thank you for your kindness in helping people develop understanding for free!

@NaftuliSinger 4 жыл бұрын

Hey, that's super incredible! Can't wait for the next Ep. Btw, you could go to the View tab and untick: "Headings, Formula Bar & Gridlines", And then go to the Ribbon Display Options on the top-right (left to the minimize option) and select Auto-Hide, So it will go full screen... So it looks much nicer...

@theofficelab 4 жыл бұрын

Thanks for the awesome feedback, Naftuli 😊 That's a great input!

@Sim_Pole 3 жыл бұрын

I wouldn't believe that this masterpiece was made with Excel had he put it in full screen tbh

@NaftuliSinger 3 жыл бұрын

@@Sim_Pole Neither would I 😉

@dharmendrasaini7364 4 жыл бұрын

I saw your video, watched it for 3 minutes , paused your video and subscribed office 365 yearly.

@Eweny96 4 жыл бұрын

Thank you for your effort man! Impressive teaching abilities. You made it very easy and a lot of direct information to leverage. Thank you again.

@MsWatchdog 3 жыл бұрын

I wish I had come across this vlog when I was going for my interview 2 days ago! I used another website and they gave me the basics of doing pivot and pie charts, you just dont get the little bits that you need like him naming the data table, I was going to have an interview to work in the criminal justice system and their data is complicated but if this system was used it would have been so easy to work with. As they say never too late for anything, so glad I have come across his site. It just means that I am now more professional than most people. Thanks Bro

@theofficelab 3 жыл бұрын

Hi Naz, thanks for your amazing feedback 😊 I am glad the video was helpful even though it came a bit late for your interview. Anyway, I wish you best of luck for that position!!

@user-zj3dq4rn8z 4 жыл бұрын

Sorry, but wtffffff It's crazy cool stuff, you blow my mind

@eaaeeeea 3 жыл бұрын

Huge thanks for this! I've been planning to do a simple 'budget' Excel but you gave me inspiration to do a 'personal finances' Excel which would include investments, their projections, bank account transactions with categories, loans, savings targets etc. I really like your dashboard format and features so I'll put them to good use!

@Goakel 10 ай бұрын

Lmao if you can’t make a simple budget how do you think you’re gonna project investments on top of it all? Lololol

@jimsnellen6222 3 жыл бұрын

Wow, I’m very impressed. The other videos will definitely be on my watch list. You did a fabulous presentation and I will be sharing this video as well as your web site. Great job!

@theofficelab 3 жыл бұрын

Thanks, Jim! That's great to hear 😊 I am happy you like it and will continue to watch the series. And many thanks for sharing.

@krisso2019 4 жыл бұрын

I made a dashboard using Excel recently. I didn't know that slicers can be used and make dashboards interactive to manage large data. Thank you for the tutorial!

@theofficelab 4 жыл бұрын

My pleasure 😊 I am happy you like it!

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

Your presenting method and outcome are incredible. In most tutorials, the presenter wasted 1/3 of the clip talking none sense. Different from them, your tutorials go straight to point and easy to follow. thanks for sharing this.

@MuhammadFadli-to4ie 4 жыл бұрын

Hi, This is one of incredible dashboard that I ever seen,with a simple touch can be so meaningful and also very well explained, I'm looking forward to your next content broo!!!!

@theofficelab 4 жыл бұрын

Glad you like it!

@gerlontube 4 жыл бұрын

I'm on vacation leave today, and yet I got excited to get back to work to this..

@israelobiagba5842 4 жыл бұрын

Wow! I can't just stop being amazed by this great work!!!

@camergal 4 жыл бұрын

I am blown away by this! Impressive combination of creative and analytic traits. Well done!

@theofficelab 4 жыл бұрын

Thank you 😊

@koomky 3 жыл бұрын

you are not a datasheet builder, but more..an artist

@vivekchharia1135 3 жыл бұрын

Although i knew most of the stuff already, but to put it all together and learning about dash board was greatly helpful. Very educating, cant thank you enough.

@jam-hu 4 жыл бұрын

Amazing. This is art and analytics combined. Btw, you can adjust the order of cells in a pivot table by dragging them like regular cells.

@theofficelab 4 жыл бұрын

Thanks, Jamal 😊

@cielcam5721 4 жыл бұрын

I wish I knew this when I was still in college.. Making presentation with excell instead of powerpoint will definitely make my friends dropped their jaw..

@shellshock10 4 жыл бұрын

honestly as long as you don't use text you're good.

@RR-tq2ee 3 жыл бұрын

i know right. I thought i was a genius because i had "creative powerpoint" and then my mind blown away when i see this..

@johnmosugu 8 ай бұрын

It's definitely the best Excel Dashboard for me, and presented by a Guru in the field! Thank you for this excellent presentation.

@TheRealErised 4 жыл бұрын

Love the video! A much nicer way of presenting my data. My boss is gonna love me!

@dougjones1639 2 жыл бұрын

Such a great tutorial! So many things to learn here that can be applied to other types of dashboards. Thank you.

@rajshekhar2626 4 жыл бұрын

I had no idea excel had come along so far. I'm seeing some of these features for the first time.

@managedbywhitney8214 4 жыл бұрын

Great tutorial! Really enjoyed building this out

@theofficelab 4 жыл бұрын

Thanks, my friend! That is awesome to hear 😊

@stephenfahey7402 4 жыл бұрын

I didnt even know you could do this in excel. Excellent tutorial, I cant wait for the next 2 episodes. Looking forward to them. thank you very much

@theofficelab 4 жыл бұрын

Thank you so much for your positive feedback, Stephen 😊 I'm glad to have you on board! The second episode will be coming soon.

@evitabernadettegutierrez7688 3 жыл бұрын

This is amazing ❤️ Easy to understand and not boring. This is the best how to video I've watched.

@cejaybagiao8436 3 жыл бұрын

Wow. I love it that it's presented like a cooking show. Preparing the ingredients on the first part and cooking them on the final part. Plus I envy your skill man. What a good taste and talent you have. Kudos!

@theofficelab 3 жыл бұрын

Thanks man. Appreciate it!

@rwlcrz 3 жыл бұрын

The beauty of excel I've wanted

@victoriac1156 4 жыл бұрын

I love your videos. I am loving all the ideas and learning you are imparting. Thank you so much!!

@TheJcumby3 4 жыл бұрын

OK and WOW! I have to create a dashboard and had no idea how. I stumbled upon your video today and I have now created a beautiful board! This was so easy. It took me a while to reformat the data information but beyond that I have success. Looking forward to exploring more of your tutorials.

@shiningcopper 4 жыл бұрын

make complex things simple and easy. beautiful!

@freespirit1869 4 жыл бұрын

A M A Z I N G ..!!

@50kT 3 жыл бұрын

DAAAAAMN lol so glad I started learning VBA to increase my excel functionality. But this design level you show is insane..... Didn't even realize this was possible, like you said! 👏👏

@theofficelab 3 жыл бұрын

Thank you 😊 Glad you like it!

@info2satish 4 жыл бұрын

This is really amazing video on real interactive dashboard with really beautiful eye catching visuals!!😃🙏

@elshanmehdiyev6474 4 жыл бұрын

the dashboard looks fascinating!

@HichamBenhssayne 3 жыл бұрын

I'm glad that I found your channel. it's just incredible. Thanks for the tutorials

@yudhym9310 2 жыл бұрын

WOW, amazing work, never imagine excel can do such a thing... its even WOW with all pivot chart work together... You really bring it to another level man, just AWESOME really appreciate it, many many thanks, GBU

@justusrippert2413 4 жыл бұрын

By far the best Office Tutorial Channel! Awesome!

@theofficelab 4 жыл бұрын

Thank you so much, Justus 😊

@TraderPulse 4 жыл бұрын

This was such a fun project for me to complete! Thank you :)

@saheebabatra 4 жыл бұрын

This is so helpful! Thanks so for sharing this, cant wait to check out more useful content from your channel.

@VinceWilliams 4 жыл бұрын

This is a great step-by-step video. Definitely subscribing to the channel.

@fahad5247 Жыл бұрын

Finally with proper explaination and step by step tutorial (without fast forwarding repeating steps) Good Job👏👏👏

@theofficelab Жыл бұрын

Glad you liked it!

@amelahadzicmba 4 жыл бұрын

This dashboard is F AHHHMAZING.

@MurrayFrost 4 жыл бұрын

Absolutely incredible! I never know you could do this!

@theofficelab 4 жыл бұрын

Thanks, Murray 😊

@azamsyed8827 4 жыл бұрын

kzfaq.info/get/bejne/ntB2aduEsdHYiIU.html

@richmartin8314 4 жыл бұрын

This is awesome. Cant wait for the next episode!!

@theofficelab 4 жыл бұрын

Thanks, Rich 😊 Next episode coming in a few hours!

@NS-gv9ud 4 жыл бұрын

TYSM ! I love the theme, I just finished your tutorial and looks amazing.

@theofficelab 4 жыл бұрын

Thanks for this amazing feedback, N S! 😊

@deanverappan5803 2 ай бұрын

INCREDIBLE! Thank you!

@ericbeard7007 4 жыл бұрын

Probably the best Microsoft excel tutorial I have ever seen. The best Microsoft Excel Tutorial!

@theofficelab 4 жыл бұрын

Thanks for that amazing feedback, Eric 😊

@catchradioactive 4 жыл бұрын

Really insightful video. Big thanks for sharing the video. Can't wait to see some more amazing content from you. Keep the good work up mate!

@theofficelab 4 жыл бұрын

Thanks, man 😊 there will be a lot more awesome stuff coming!

@judithbredy2195 3 жыл бұрын

Amazing! You explained it so easily. Thank you! 5 stars!!

@dakshbhatnagar 2 жыл бұрын

Just the kind of the dashboard I saw in some of the videos and now hope to replicate them myself.

@AljimmyAM 4 жыл бұрын

hey man. this is a really intereating way of applying excel. thanks for this. please keep teaching us! 🙏🙏

@TheGalargolor Жыл бұрын

Many many thank for this awesome tutorial. Finally I finished it after 4 days.

@MrPants1970 4 жыл бұрын

This is brilliant! I need to build a balanced scorecard and some measures, this would look stunning! I just need to make a background....

@richardmwambanga2423 4 жыл бұрын

This is amazing indeed! 😀 Waiting for episode 2 😊

@theofficelab 4 жыл бұрын

Thanks, Richard 😊 Episode 2 is already online: kzfaq.info/get/bejne/hMx1pKaVy9KWY58.html

@ketulshah5037 4 жыл бұрын

Mind blowingly simple...thanks man

@user-nb1is5wc4k 3 жыл бұрын

Absolutely awesome! Thanks!

@sgarcata 2 жыл бұрын

Genius! And so aesthetic as well as being technically sophisticated.

@RyanMendenhallSEO 2 жыл бұрын

Absolutely LOVE this video. Thanks so much for sharing your expertise!

@erumjawed966 2 жыл бұрын

Learned a lot - thank you!

@leonardo03231315 3 жыл бұрын

Simply wow! Recommend watching the whole video--so many neat tips and tricks

@tooracho4713 3 ай бұрын

Best Tutorial presentation ever.

@estherdorenbos1540 Жыл бұрын

Loved it, thank you so much!

@jackvain6817 Жыл бұрын

Amazing dashboard tutorial,I love your design!!

@r4v3n58 4 жыл бұрын

Awesome. Earned the like straight from the thumbnail!!

@theofficelab 4 жыл бұрын

Thank you, r4v3n58! That's great to hear.

@omermor6624 3 жыл бұрын

So Great, I can't wait to try it myself!

@chrststllkmp 4 жыл бұрын

Nice work! Looks amazing

@shazebalikhan9407 3 жыл бұрын

You made it look so simple and easy. Brilliant job.

@theofficelab 3 жыл бұрын

Thank you! 😊

@MsOfficeLearning 2 жыл бұрын

👍Amazing tutorial ! Thank you sir

@thomasstansfield5544 2 жыл бұрын

Wow, this is easy to follow and full of new tricks! Thanks for the video.

@mimixcoach 3 жыл бұрын

Loved it ❤️ super helpful. Thanks

@BlondeMallo2 3 жыл бұрын

THANK YOU THANK YOU THANK YOU! That's a very good course!

@letslearnexcel 4 жыл бұрын

Amazing and very attractive idea :D. Very well explained in a very professional and efficient manner. I have applied the same in my company :D. thanks for sharing this.

@theofficelab 4 жыл бұрын

Thanks, ProAngeL 😊 that's awesome to hear!

@ladyashephd727 3 жыл бұрын

Thank you for your Tutorials, I'm looking forward to growing my skills. I've already invested in numerous courses' on Udemy taught by you.

@jaymieleong2785 3 жыл бұрын

This is amazing and impressed me. All this while I would like to do a dashboard like this, but not skillful to build it. Thanks, this is awesome sharing.

@mariacarolinafilgueirapaul6413 2 жыл бұрын

I'm from Brazil and I love your classes.

@harozongaming2256 3 жыл бұрын

Thank you for the tutorial!

@josterkoso3418 4 жыл бұрын

Wow! Right after watching this, I wanna go to work.

@harshitsingh-dn7gl 4 жыл бұрын

Eagerly waiting for next part

@daniellesmith9726 3 жыл бұрын

enjoyed this tutorial; thanks!

@estebanmerello 3 жыл бұрын

I totally loved!!! congrats, this is simple stunning!

@theofficelab 3 жыл бұрын

Thank you so much!!

@noveleodacua1339 3 жыл бұрын

new subscriber here. i love the visual, audio and most especially the content presentations...this is way higher than my current excel knowledge. :-)

@karlding1462 7 ай бұрын

Thank you, this is a great tutorial on the dashboard design.

@johncatsicas101 4 жыл бұрын

Thank you for the great dashboard and data - very good of you

@jsolivas1516 3 жыл бұрын

Super helpful Thank You!

@pilotgundul 3 жыл бұрын

Thank you man!! i like it so much

@dbasannar 2 жыл бұрын

I thoroughly enjoyed watching this video, he explained it very well.

@casimirpampo 4 жыл бұрын

Wow! This is lit! Thank you for sharing!

@theofficelab 4 жыл бұрын

It's my pleasure 😊 I'm glad you like it!

@MagdaS-wv7jz Жыл бұрын

Amazing tutorial!! Thanks for putting this together and sharing.

@sherikalm 3 жыл бұрын

Amazing tutorial!

@ShawnFX 2 жыл бұрын

My goodness this dashboard looks absolutely gorgeous!

@praisejaravani8639 Жыл бұрын

Thanks so much. Your video was absolutely incredible and extremely useful!😊

@jinumongeorge 4 жыл бұрын

one of the best out of 16 videos i checked .

@theofficelab 4 жыл бұрын

Thanks, Jinu. I appreciate it!