How to Create Impressive Interactive Excel Dashboard | Ultimate Excel Dashboard Ep. 1
ฝัง
- เผยแพร่เมื่อ 23 ม.ค. 2020
- ✅ 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
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.
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.
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.
honestly the best soft tutorial ive ever seen. short and straight to the point ! i love it
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.
Thank you for such a positive feedback, Mark! 😊
This is what employers expect when they see “proficient in excel” on your resume
I think they expect something more, like Power Query, Power Pivot, M, DAX, VBA
Yes but we are too reluctant to learn to improve ourselves.
🤣🤣🤣 true, sooo true
@@G10cK94 VO8 BO8 BB GV80AQATC JUC RELATTE HUMAIN SOGOOD SOOFUT
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
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!
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!
I'm on vacation leave today, and yet I got excited to get back to work to this..
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!
I saw your video, watched it for 3 minutes , paused your video and subscribed office 365 yearly.
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...
Thanks for the awesome feedback, Naftuli 😊 That's a great input!
I wouldn't believe that this masterpiece was made with Excel had he put it in full screen tbh
@@Sim_Pole Neither would I 😉
I love Excel so much, videos like this just get me so excited.
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.
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!
Lmao if you can’t make a simple budget how do you think you’re gonna project investments on top of it all? Lololol
Thanks so much for putting this tutorial together, it fantastic! I put together a similar one from your instruction but I'm having trouble with the mapping chart. When I use the slicer for the pivot table to filter the territories it only updates the original pivot table but not the data referencing the pivot table that the map is using. I've followed everything you had done but this one piece is really causing me some difficulty. Any idea what might be causing this? Thanks again!
It's definitely the best Excel Dashboard for me, and presented by a Guru in the field! Thank you for this excellent presentation.
I had no idea excel had come along so far. I'm seeing some of these features for the first time.
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.
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.
Thanks, Jamal 😊
you are not a datasheet builder, but more..an artist
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..
honestly as long as you don't use text you're good.
i know right. I thought i was a genius because i had "creative powerpoint" and then my mind blown away when i see this..
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.
make complex things simple and easy. beautiful!
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
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!!
You should do a tutorial on dynamic horizontal tables. I have a binomial tree with headers and am having extreme difficulties getting the horizontal data to display in a organized matter on a pivot table.
Such a great tutorial! So many things to learn here that can be applied to other types of dashboards. Thank you.
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!
My pleasure 😊 I am happy you like it!
I am blown away by this! Impressive combination of creative and analytic traits. Well done!
Thank you 😊
Wow! I can't just stop being amazed by this great work!!!
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!
Thanks man. Appreciate it!
Love the video! A much nicer way of presenting my data. My boss is gonna love me!
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!!!!
Glad you like it!
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!
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.
This is brilliant! I need to build a balanced scorecard and some measures, this would look stunning! I just need to make a background....
Great tutorial! Really enjoyed building this out
Thanks, my friend! That is awesome to hear 😊
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.
I'm glad that I found your channel. it's just incredible. Thanks for the tutorials
the dashboard looks fascinating!
This was such a fun project for me to complete! Thank you :)
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
This is amazing ❤️ Easy to understand and not boring. This is the best how to video I've watched.
I love your videos. I am loving all the ideas and learning you are imparting. Thank you so much!!
Sorry, but wtffffff
It's crazy cool stuff, you blow my mind
The beauty of excel I've wanted
This is really amazing video on real interactive dashboard with really beautiful eye catching visuals!!😃🙏
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! 👏👏
Thank you 😊 Glad you like it!
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
Thank you so much for your positive feedback, Stephen 😊 I'm glad to have you on board! The second episode will be coming soon.
Many many thank for this awesome tutorial. Finally I finished it after 4 days.
Just the kind of the dashboard I saw in some of the videos and now hope to replicate them myself.
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.
Mind blowingly simple...thanks man
TYSM ! I love the theme, I just finished your tutorial and looks amazing.
Thanks for this amazing feedback, N S! 😊
This is a great step-by-step video. Definitely subscribing to the channel.
This dashboard is F AHHHMAZING.
Amazing! You explained it so easily. Thank you! 5 stars!!
By far the best Office Tutorial Channel! Awesome!
Thank you so much, Justus 😊
Finally with proper explaination and step by step tutorial (without fast forwarding repeating steps)
Good Job👏👏👏
Glad you liked it!
A M A Z I N G ..!!
Genius! And so aesthetic as well as being technically sophisticated.
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.
Probably the best Microsoft excel tutorial I have ever seen.
The best Microsoft Excel Tutorial!
Thanks for that amazing feedback, Eric 😊
hey man. this is a really intereating way of applying excel. thanks for this. please keep teaching us! 🙏🙏
Excel nice tutorial kaibigan may bago na naman akong natutunan salamat po
Hi, found this incredibly informative, well made video, hopefully you get the channel growth you are looking for! I am trying to use the map function in a country where the region breakdown is not automatic, is this something you can manually update? Or who is best to email to ask for it to be an added function? Long shot but hopefully you can help!
INCREDIBLE!
Thank you!
This is so helpful! Thanks so for sharing this, cant wait to check out more useful content from your channel.
Absolutely LOVE this video. Thanks so much for sharing your expertise!
Best Tutorial presentation ever.
Simply wow! Recommend watching the whole video--so many neat tips and tricks
You made it look so simple and easy. Brilliant job.
Thank you! 😊
Amazing dashboard tutorial,I love your design!!
The best Excel dashboard video I have seen in this content I am an aspiring Data Analyst.
Very impressive and inspirational! Will try to apply this to my visualize my project data.
Check out my new website excelfind.com for the Free Version of the Dashboard 🚀
⬇ *FULL TUTORIAL SERIES PLAYLIST*
[Ep. 1] Basic Dashboard ► th-cam.com/video/cKkXtyjleX4/w-d-xo.html
[Ep. 2] Background & Tile Design ► th-cam.com/video/NfEqCdfl23k/w-d-xo.html
[Ep. 3] Modern Slicer Design ► th-cam.com/video/CbDTFfoePZY/w-d-xo.html
[Ep. 4] Auto-Refresh Pivot Charts ► th-cam.com/video/Xdq7SE-z-Aw/w-d-xo.html
[Ep. 5] Interactive Info Button ► th-cam.com/video/RZW-vQRr0nY/w-d-xo.html
[Ep. 6] Interactive Dashboard Tabs ► th-cam.com/video/2qN5jUiJWMY/w-d-xo.html
[Ep. 7] Interactive Settings Menu ► th-cam.com/video/fCFGqj4QcJU/w-d-xo.html
Your superb Creator and excellent teacher. God bless
@Zaeem Hassan thanks for the note. I just checked it, the link works for me. What issue do you face when you click on it?
all I can say is wow. I love it. Done subscribing
new subscriber here. i love the visual, audio and most especially the content presentations...this is way higher than my current excel knowledge. :-)
So Great, I can't wait to try it myself!
Wow! Right after watching this, I wanna go to work.
Loved it ❤️ super helpful. Thanks
Nice work! Looks amazing
Loved it, thank you so much!
Thank you, this is a great tutorial on the dashboard design.
I'm from Brazil and I love your classes.
Amazing tutorial!! Thanks for putting this together and sharing.
Godbless you Sir for making this helpful video.
THANK YOU THANK YOU THANK YOU!
That's a very good course!
I thoroughly enjoyed watching this video, he explained it very well.
Loved it all the way, learnt a lot..... just built my first dash board..yay
Thank you for the great dashboard and data - very good of you
Wow, this is easy to follow and full of new tricks! Thanks for the video.
Thanks so much. Your video was absolutely incredible and extremely useful!😊
Thank you for the tutorial!
Learned a lot - thank you!
Absolutely awesome! Thanks!
Super demonstration. Anybody can easily learn. I recommend. All the best 👍
This is awesome. Cant wait for the next episode!!
Thanks, Rich 😊 Next episode coming in a few hours!
Really liked the Gradient Line chart - haven't seen that before, thanks :)
Great video, thank you very much. One question though: You mention in the video that there is a second tutorial which explains how to create the dashboard background. Im not sure which one of your uploads you are refering to though. Can you please clarify this for me?
Hi Christoph,
thanks for your positive feedback 😊
Regarding your question: Sorry for the confusion, I will upload them one by one. The second one will be online within the next few days. So if you have subscribed and activated the notification bell for my channel, you'll be informed as soon as it is online 👍
My goodness this dashboard looks absolutely gorgeous!
Thanks for inspiration! Hope you will upload more like these!
I totally loved!!! congrats, this is simple stunning!
Thank you so much!!