Oh my goodness! I was just rejected for a job interview because I didn't know how to create a sophisticated dashboard and I did a search and found this video. In just a few minutes I learned how to create an awesome dashboard and my first slicer! I'm excited! Thank you so much for such a great video!
I think I will be in same boat :D did a trial few days ago...and how will a Sourcing and Product Dev manager will know about dashboard (abt product tracking) :D hahaha whew. they surely want us to do everything
3 observations that might help others reading my comment: 1) In the latest version of excel, there's no need to go and create new pivots everytime for a new chart. Just copy paste your existing pivot below your 1st pivot and you are done. 2) You can create multiple slicers in the 1st go by clicking on multiple options at once. 3) At last, the sales rep chart didn't interact which means the report connection, which in latest version is called filter connections, didn't work. In such cases, redo the filter connections to solve this issue.
The ease with which the 'intimidating' feature of dashboards has been explained is praiseworthy. Thank you for making this possible for everyone. Once the dashboard was completed, it brought a huge grin on my face.
Perfect! Thank you- I find it easier to learn by seeing and every time I tried to read up on these I just got lost in the technicalities. This is so much simpler and easier to follow
Hi Sir! I can't thank you enough for doing all these videos. You make learning excel so easy! I have always thought that this was a daunting task and that you have to be extremely intelligent to be able to do these things. Thank you so much! Please continue to be a blessing to others through these videos.
It was helpfully, I saw a colleague created something similar and I thought it would be super tricky but you made it very easy to understand. Appreciate your lecture 👍🏻
Thanks for imparting such wonderful tips regarding dashboard. In fact all your videos are very knowledgeable. Thank you again for sharing the information.....
Hi, please answer this question. If we change some information in the original table from which you created the pivot, will it also make changes in the dashboard automatically or is the data fixed from the original table the pivots were created?
This tutorial is amazingly good. I learned a lot from it and it gave me some inspiration for my classes (I give Excel classes to students). Thank you so much! Fan +1 😊
This is great. I made a dashboard as I listened to these instructions. Thank you.
Welcome Cheryl
Can you please share this excel sheet
Can u please share the excel
@@GuruJii can you plz share the dataset to practice?
Could you send this excel please
Aapne Izzat Paisa Dono Bachaa Liya 🙏. This is more easier than I thought. Thanks
Oh my goodness! I was just rejected for a job interview because I didn't know how to create a sophisticated dashboard and I did a search and found this video. In just a few minutes I learned how to create an awesome dashboard and my first slicer! I'm excited! Thank you so much for such a great video!
I can relate; some lessons we learn in a painful way. What job were you interviewing for?
Jjķj@@Kingco245
I think I will be in same boat :D did a trial few days ago...and how will a Sourcing and Product Dev manager will know about dashboard (abt product tracking) :D hahaha whew. they surely want us to do everything
3 observations that might help others reading my comment:
1) In the latest version of excel, there's no need to go and create new pivots everytime for a new chart. Just copy paste your existing pivot below your 1st pivot and you are done.
2) You can create multiple slicers in the 1st go by clicking on multiple options at once.
3) At last, the sales rep chart didn't interact which means the report connection, which in latest version is called filter connections, didn't work. In such cases, redo the filter connections to solve this issue.
ah ok...too much easy, learn many things on excel.. but first time watched like this.... increase knowledge
thanks guru
This video is best💯💯
I watched lots of video before this but not anyone explained that smoothly.
But you clear the concept in just 10 minutes 👍💯
The ease with which the 'intimidating' feature of dashboards has been explained is praiseworthy. Thank you for making this possible for everyone. Once the dashboard was completed, it brought a huge grin on my face.
I am currently doing a course on data analysis and visualization. This video has been so helpful and informative.
One of the most productive excel tutorials I have ever seen! Thank you!
Welcome Kristina
Same to me❤❤❤❤
Nice tutorial, It will be great if the excel sheet is shared
this video will be helpful till the last....A very practical way to teach online...
JUST DONE MY ASSIGNMENT. thANK YOU THIS WAS USEFUL
thank you so much :) i made my first dashboard through the learnings of this video
Sir thanks so much,can you please share excel sheet link
Your explanation is really easy to understand.
The most simple way to learn this. Thank you.
Perfect! Thank you- I find it easier to learn by seeing and every time I tried to read up on these I just got lost in the technicalities. This is so much simpler and easier to follow
Awesome....This is the best and easiest way to create a dashboard...Thanks a lot for making this video...very helpful.
Very interactive, simple and fantastic way.....thankyou
Thank you so much. You helped me to create my tables for job application dataset analysis. Much love from Rwanda.
Hi Sir! I can't thank you enough for doing all these videos. You make learning excel so easy! I have always thought that this was a daunting task and that you have to be extremely intelligent to be able to do these things. Thank you so much! Please continue to be a blessing to others through these videos.
Omg.. Awesome page.. Downloaded your templates from your website.. Keep doing it.. Love your work.. God bless you and God be with you 😇
It is very good video. everyone can very easily from this video. I made a dashboard acording to instructions.Thank You.
It was helpfully, I saw a colleague created something similar and I thought it would be super tricky but you made it very easy to understand. Appreciate your lecture 👍🏻
omg! this man explained all this in less words, understandable in easy way.... thank you so much 🤍
This is really very nice trick to teach MIS report. Thank you very much.
Great step by step tutorial and very informative.
Thanks for this video brother.
Thank you sir, for the productive teachings
Thank you for the great video. Will the dashboard data change when change the number from the main data sheet?
Great explanation in short time.
Thanks a lot Guruji
Thanks! You helped me save my Analytics course work!
Welcome
Hi, I am following ur lesson. Without pivot can I make dashboard
you r best guru in excel.!!!
+Deepak Vishwakarma Thank you dost
Thanks... that was a good one. Intro got a little long but the rest of it was simple and excellent.
You can directly make a pivot chart without the need of creating a new pivot table. you just need to ensure that the source data is checked correctly
dear sir your videos helpful to learn advance excel.
Great, Easy, clear in explain, awesome sir....❤
Literally it's too much good for me i just see this video just before my interview and i got all the knowledge 🙌
Excellent video designed by you...
I'm just starting to learn about dashboarding in Excel, so your video was easy to follow. Thank you.
Great video.Not publishing videos anymore in 2020?
very informative.. i have been searching the easiest way to create dashboard (not using macros)..and here we are :)
Very nicely explained I need few mores such videos.
This is really great video i ever saw very simply and easy explain Dashboard thank you so much
Thanks for this video.Very clear explanation.
Perfectly elaborated!!! 👏🏻👏🏻👏🏻👏🏻
great!, help me so much in learning how to make dashboard as a requirement in our course financial analytics
From where you done financial analytics course?
This is wonderful and so easy to understand. thank you.
Beautiful lessons Sir, thank you much for making these so easy to understand
You are leading the people how become a smart with smart work. And that is exactly you did in your video.Great learning from your video.
Thanks a lot for simplifying the tutorial. I can't believe that i learnt a lot in just a few minutes. Kudos
Amazing tutorial. Thanks a lot for making this video.❤
Thank you so much, You made it more easier that it is
thanks for this video.could you plz share this excel sheet , i want to do practice on it.
Thank u sir,all 4 parts are simply awesome 👍
Thanks for sharing dashboard and teaching us.
Can you plz share excel sheet if the same?
It helped totally. Thank you 👍😊
Thank you so much the session was very informative and helpful you are a ❤ good hearted person, God bless you as you are!!
Sir You are real guru, thanks for extending this trick.
very good easy tutorial ... thanks a lot
Excellent work. Thank you
Sir.. Wonderful .. Very very use analysis data format
Very nice thanks buddy😊 9:12
Thanks for imparting such wonderful tips regarding dashboard. In fact all your videos are very knowledgeable. Thank you again for sharing the information.....
Thank you. Badly needed. Blessings
Hi . I want to learn Excel . Do u provide class plz let me know
Great lesson. Cheers
Sir very nice way to get educated people like me
I want to take personal training
Hi, please answer this question. If we change some information in the original table from which you created the pivot, will it also make changes in the dashboard automatically or is the data fixed from the original table the pivots were created?
Really very Informative.... Thanks for sharing.. It will definitely enhance my skills..
In video the pivot table you used in what reference you made this ?
Excellent tutorial
Thank you so much for your kind service
This tutorial is amazingly good. I learned a lot from it and it gave me some inspiration for my classes (I give Excel classes to students). Thank you so much! Fan +1 😊
Brilliant video. Skillful teaching.
Awesome Instructional Video! Thanks!
Very nice....and easily explained.
But what about the large sized files....
Thanks for this dashboard tutorial bro.. simple and excellent
Hey! Can you please tell me from where can we get a table of 1000 lines or more for creating dashboard or any other analysis.
Your all videos really perfect and clear . tysm i do real like but 1 problem in u r all videos u r not given row data file it's easy and fast learning
Happy Learning, Thanks
Thanks a lot sirji,,,,hats off to yours knowledge and explaining skills thanks a lot
This is really Great. this video helped me a lot Sir. Perfect and Thanks a lot
Your explanations are very clear...i also like the way you bring out light moments to keep the it the student alert.
Thank you so much, it worked after using telegram video.
You made it so easy. Good job
HELPS ME A LOT. THANK YOU!!!
From where do you fetch table for analysis???
A well build video with all necessary basic information to create dashboard. Thanks a ton
very good presentation
Thank you …this is so helpful
Thank you so much. But im unable to acces slicer on my computer as it shows inactive. Please suggest how to activate. Thanks
Thank you!!
This is very important for me.✨
Thanks. To watch more video please visit www.myelesson.org/
Thank you so much. It was a very informative video.
Wow...it was excellent...you made my day
Loved it. Thanks!
This video is really perfect and clear. Thank you so much. I do like it.
that was very useful thank you brother
Man you took Superheroes as sales reps. That's cool.
Great lesson
Very clear. Nice Job