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.
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!
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!
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!!
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.
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.
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..
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
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 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.
All the dashboards I saw in internet are about sales or budget, which it is great, but it feels short for the tasks I need to do. I understand this is the most common subject to create a dashboard, but it is also the easiest.
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!
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...
Excellent presentation and explanation... Requesting you to explain how to create Dash board. In this episode up to 22:00 mins I'm able to understand... you said you will cover creating of dash boards in next episode.. Please share the link how to create dash board design... What is the basic was of creation.
Hi Madhav. Thanks for your kind feedback 😊 Here is the full playlist with all episodes: ruclips.net/p/PLPI5vz7nkUqpZzCifiJRFgHfI0flJJp5Y Episode 2 teaches the creation of the background & tile design, Episode 3 teaches how to create custom slicer designs. Hope that was what you were looking for
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.
Beautiful. Just what I needed at just the right time. I registered for your site. Subscribed to your YOUTube channel, and even signed up for some of the other services found on you site.
Hey Denis, that is awesome to hear 😊 Thank you so much for letting me know and great to have you on board! Just out of curiosity: What service did you sign up for? I am still optimising and rearranging that site to create the best experience possible for my audience and your feedback would be really beneficial to me. Thank you in advance! I wish you a beautiful day! 🙌
Thanks for your instant feedback 😊 And I am glad to see you have a look at the add-ins. If you are looking for big value, my personal recommendation is XLTools. I am using it myself. It's a huge toolbox of additional features and it makes many tasks so much easier and quicker! Anyway, all the best to you and I am happy to have you as my subscriber!
Since you helped me with your feedback I want to give you the discount code EXCELFIND10 that saves you another 10% if you use this link ► bit.ly/2UfIfAp
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!
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
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!!!!
Its amazing.. Its not just pretty but how innovative. I have subscribed for all new learning but why you stop upload videos?? I cam see last video almost 9 month ago.. You should not stop these amazing exercise 😊.. I am looking for end to end vba video and expecting from your channel 😊👍
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.
This has to be the coolest dashboard ever. Thanks Mate! Absolutely stunning. Would you mind advising how one can extract a data through VBA script? I did not find it at the end of the video. Kudos to you. Keep up the great work.
Hi Pushpaj, thanks for your amazing feedback 😊 Regarding the data creation (and to be clear here, they are not extracted but created synthetically based on probabilities and simulation), I will release a separate tutorial video on that at the end of this tutorial series. So just hit the notification bell und you'll be informed instantly once I released it. I wish you a great day!
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!
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.
I am using an online version of Excel (I have a Chromebook...) and the quarters do not appear in the rows box when I drag the date field down (06:04), do you know if there is a way around this?
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
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.
I saw your video, watched it for 3 minutes , paused your video and subscribed office 365 yearly.
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!
Probably the best Microsoft excel tutorial I have ever seen.
The best Microsoft Excel Tutorial!
Thanks for that amazing feedback, Eric 😊
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!
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!!
honestly the best soft tutorial ive ever seen. short and straight to the point ! i love it
yeah to sell you the dashboard at the end ..........
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! 😊
It's definitely the best Excel Dashboard for me, and presented by a Guru in the field! Thank you for this excellent presentation.
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.
one of the best out of 16 videos i checked .
Thanks, Jinu. I appreciate it!
Finally with proper explaination and step by step tutorial (without fast forwarding repeating steps)
Good Job👏👏👏
Glad you liked it!
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..
I couldn,t belive how much i learned by just watching simple tutorial.
Thank you 😊 That's great to hear!
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
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!
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.
You are outdone everyone in excel
But we have power bi
Much easier and faster
But you are really talented
Just the kind of the dashboard I saw in some of the videos and now hope to replicate them myself.
By far the best Office Tutorial Channel! Awesome!
Thank you so much, Justus 😊
I love Excel so much, videos like this just get me so excited.
I made the same in Excel 2013. The only thing I did not have is the ICON and Map facility.
Thank you for sharing....
you are not a datasheet builder, but more..an artist
One of the best dashboard videos I've watched
Thanks, Arnold 😊 I appreciate it!
I had no idea excel had come along so far. I'm seeing some of these features for the first time.
All the dashboards I saw in internet are about sales or budget, which it is great, but it feels short for the tasks I need to do. I understand this is the most common subject to create a dashboard, but it is also the easiest.
Awesome. Earned the like straight from the thumbnail!!
Thank you, r4v3n58! That's great to hear.
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'm from Brazil and I love your classes.
I am blown away by this! Impressive combination of creative and analytic traits. Well done!
Thank you 😊
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 😉
The best Excel dashboard video I have seen in this content I am an aspiring Data Analyst.
Awesome.. Keep up the good work bro👍👍👍👍
Thanks, Bro 😊 I definitely will!
Super awesome. I live how you played with the colors and the map trick - to link it to the pivot table with the formula, cause otherwise it won't work
Glad it was helpful! 😊
Excellent presentation and explanation... Requesting you to explain how to create Dash board. In this episode up to 22:00 mins I'm able to understand... you said you will cover creating of dash boards in next episode.. Please share the link how to create dash board design... What is the basic was of creation.
Hi Madhav. Thanks for your kind feedback 😊
Here is the full playlist with all episodes:
ruclips.net/p/PLPI5vz7nkUqpZzCifiJRFgHfI0flJJp5Y
Episode 2 teaches the creation of the background & tile design, Episode 3 teaches how to create custom slicer designs.
Hope that was what you were looking for
new subscriber here. i love the visual, audio and most especially the content presentations...this is way higher than my current excel knowledge. :-)
Many many thank for this awesome tutorial. Finally I finished it after 4 days.
Wow. Beautiful work!
Thank you very much!
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 😊
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.
Super demonstration. Anybody can easily learn. I recommend. All the best 👍
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.
Mind blowingly simple...thanks man
Beautiful. Just what I needed at just the right time. I registered for your site. Subscribed to your YOUTube channel, and even signed up for some of the other services found on you site.
Hey Denis, that is awesome to hear 😊 Thank you so much for letting me know and great to have you on board!
Just out of curiosity: What service did you sign up for?
I am still optimising and rearranging that site to create the best experience possible for my audience and your feedback would be really beneficial to me.
Thank you in advance!
I wish you a beautiful day! 🙌
The Office Lab it was envato elements. Also checking out some of the add-in options.
Thanks for your instant feedback 😊
And I am glad to see you have a look at the add-ins. If you are looking for big value, my personal recommendation is XLTools. I am using it myself. It's a huge toolbox of additional features and it makes many tasks so much easier and quicker!
Anyway, all the best to you and I am happy to have you as my subscriber!
Since you helped me with your feedback I want to give you the discount code EXCELFIND10 that saves you another 10% if you use this link ► bit.ly/2UfIfAp
This is a great step-by-step video. Definitely subscribing to the channel.
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.
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 really amazing video on real interactive dashboard with really beautiful eye catching visuals!!😃🙏
Great teaching! THANKS!!!
My pleasure 😊 Thanks for your positive feedback!
my goodness, excel was made only for this guy.
I'm glad that I found your channel. it's just incredible. Thanks for the tutorials
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!
Excellent.. Simple and easy to learn
Thanks a lot
👍Amazing tutorial ! Thank you sir
Its amazing.. Its not just pretty but how innovative. I have subscribed for all new learning but why you stop upload videos?? I cam see last video almost 9 month ago.. You should not stop these amazing exercise 😊.. I am looking for end to end vba video and expecting from your channel 😊👍
Best productive exel video ever 🙏 huge respect
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.
Check out my new website excelfind.com for the Free Version of the Dashboard 🚀
⬇ *FULL TUTORIAL SERIES PLAYLIST*
[Ep. 1] Basic Dashboard ► ruclips.net/video/cKkXtyjleX4/видео.html
[Ep. 2] Background & Tile Design ► ruclips.net/video/NfEqCdfl23k/видео.html
[Ep. 3] Modern Slicer Design ► ruclips.net/video/CbDTFfoePZY/видео.html
[Ep. 4] Auto-Refresh Pivot Charts ► ruclips.net/video/Xdq7SE-z-Aw/видео.html
[Ep. 5] Interactive Info Button ► ruclips.net/video/RZW-vQRr0nY/видео.html
[Ep. 6] Interactive Dashboard Tabs ► ruclips.net/video/2qN5jUiJWMY/видео.html
[Ep. 7] Interactive Settings Menu ► ruclips.net/video/fCFGqj4QcJU/видео.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
Thank you. Very well explained. You have a new subscriber 👍
Thanks for your awesome feedback, Mike 😊 And great to have you with us!
the format of sample data on teh website linked above is completely different to whats in this video. Cant even rebuilt the dashboard on my machine
This is AWESOME! So creative Marco! #subscribed
Thank you so much, bro! These words out of your mouth mean a lot to me 😊
@@theofficelab Well deserved. I'm glad I stumbled across your content! Looking forward to your future vids!
Such an amazing tutorial.😍😍😍😍😍 Can you please make a video on the HR dashboard?
Awesome work.
Some great tips and tricks.
Thanks for inspiration! Hope you will upload more like these!
It is possible to do this on google sheets ?
I totally loved!!! congrats, this is simple stunning!
Thank you so much!!
Amazing dashboard tutorial,I love your design!!
Nice work! Looks amazing
I love your videos. I am loving all the ideas and learning you are imparting. Thank you so much!!
Splendid...nice presentation and explanation...
This has to be the coolest dashboard ever. Thanks Mate! Absolutely stunning. Would you mind advising how one can extract a data through VBA script? I did not find it at the end of the video. Kudos to you. Keep up the great work.
Hi Pushpaj, thanks for your amazing feedback 😊 Regarding the data creation (and to be clear here, they are not extracted but created synthetically based on probabilities and simulation), I will release a separate tutorial video on that at the end of this tutorial series.
So just hit the notification bell und you'll be informed instantly once I released it.
I wish you a great day!
I'm on vacation leave today, and yet I got excited to get back to work to this..
Absolutely loved it... amazing work
Thank you very much! 😊
Its magic or what ? I can't believe that !! You are super cool man
Great Video brtha. Keep up the great work & wish you continued success in ALL aspects of life👊🏼👍🏼
Thank you, Lenny 😊 That is very kind of you!
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!
Woah.. This is amazing.. Gave me soo many ideas for integrating online marketing channel data
Great 👍 Happy to hear that!
Sorry, but wtffffff
It's crazy cool stuff, you blow my mind
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.
My goodness this dashboard looks absolutely gorgeous!
Awesome, thank you! Subscribed instantly.
Love it, JarlVarg 🙌 great to have you on board!
Ditto
@@MrMrlosteruk Thanks, Simon! I appreciate it 😊
I am using an online version of Excel (I have a Chromebook...) and the quarters do not appear in the rows box when I drag the date field down (06:04), do you know if there is a way around this?
Beautifully made and explained
You made it look so simple and easy. Brilliant job.
Thank you! 😊
great job I immediately subscribed! I want more of this
Thanks for the sub! There's definitely more to come 😊
Fantastic- Please upload more Videos for Dashboard
Loved it all the way, learnt a lot..... just built my first dash board..yay
Simply wow! Recommend watching the whole video--so many neat tips and tricks
Loved it ❤️ super helpful. Thanks
instantly subscribed. this is amazing
Thanks, Kevin! Great to have you on board 😊
Learned a lot - thank you!
Fantastic video and perfect explanation!
Thank you for your positive feedback, mowburnt 😊
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!
Thanks, man 😊 there will be a lot more awesome stuff coming!
This is great for people who aren't smart enough to use excel.
Love the video! A much nicer way of presenting my data. My boss is gonna love me!
Best Tutorial presentation ever.
This is awesome. Cant wait for the next episode!!
Thanks, Rich 😊 Next episode coming in a few hours!
Absolutely incredible! I never know you could do this!
Thanks, Murray 😊
ruclips.net/video/hjF6xSLktXQ/видео.html
I have an issue with 32:10, where I followed your formula but I receive an error "Reference isn't valid".
Thank you, this is a great tutorial on the dashboard design.