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.
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.
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
Thanks for imparting such wonderful tips regarding dashboard. In fact all your videos are very knowledgeable. Thank you again for sharing the information.....
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 👍🏻
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 😊
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?
Hello, first of all I'd like to say thanks to you for this video... I've implemented the same thing but getting #REF error because I've linked the table in the dashboard with pivot whenever I'm using a filter showing #REF error...what to do to get rid of the same... please help
Tried the same but facing issues with the report connections. It displaying only one pivot table and not the other one. Have seen couple of videos in youtube but not resolution yet. Kindly suggest.
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
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.
One of the most productive excel tutorials I have ever seen! Thank you!
Welcome Kristina
Same to me❤❤❤❤
Aapne Izzat Paisa Dono Bachaa Liya 🙏. This is more easier than I thought. Thanks
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.
ah ok...too much easy, learn many things on excel.. but first time watched like this.... increase knowledge
thanks guru
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.
Thank you so much. You helped me to create my tables for job application dataset analysis. Much love from Rwanda.
I am currently doing a course on data analysis and visualization. This video has been so helpful and informative.
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
Very interactive, simple and fantastic way.....thankyou
Awesome....This is the best and easiest way to create a dashboard...Thanks a lot for making this video...very helpful.
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.
Omg.. Awesome page.. Downloaded your templates from your website.. Keep doing it.. Love your work.. God bless you and God be with you 😇
Great step by step tutorial and very informative.
Thanks for this video brother.
Your explanation is really easy to understand.
The most simple way to learn this. Thank you.
this video will be helpful till the last....A very practical way to teach online...
Thanks... that was a good one. Intro got a little long but the rest of it was simple and excellent.
Thanks for imparting such wonderful tips regarding dashboard. In fact all your videos are very knowledgeable. Thank you again for sharing the information.....
JUST DONE MY ASSIGNMENT. thANK YOU THIS WAS USEFUL
thank you so much :) i made my first dashboard through the learnings of this video
This is really great video i ever saw very simply and easy explain Dashboard thank you so much
I'm just starting to learn about dashboarding in Excel, so your video was easy to follow. Thank you.
Thanks a lot for simplifying the tutorial. I can't believe that i learnt a lot in just a few minutes. Kudos
Very nicely explained I need few mores such videos.
Beautiful lessons Sir, thank you much for making these so easy to understand
It is very good video. everyone can very easily from this video. I made a dashboard acording to instructions.Thank You.
omg! this man explained all this in less words, understandable in easy way.... thank you so much 🤍
Thank you sir, for the productive teachings
Thank you so much the session was very informative and helpful you are a ❤ good hearted person, God bless you as you are!!
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 👍🏻
Great explanation in short time.
A well build video with all necessary basic information to create dashboard. Thanks a ton
This is wonderful and so easy to understand. thank you.
Perfectly elaborated!!! 👏🏻👏🏻👏🏻👏🏻
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 😊
Thanks for this video.Very clear explanation.
This is really very nice trick to teach MIS report. Thank you very much.
Amazing tutorial. Thanks a lot for making this video.❤
Great, Easy, clear in explain, awesome sir....❤
Your explanations are very clear...i also like the way you bring out light moments to keep the it the student alert.
Thanks! You helped me save my Analytics course work!
Welcome
Excellent video designed by you...
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?
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.
Thank you for the great video. Will the dashboard data change when change the number from the main data sheet?
This video is really perfect and clear. Thank you so much. I do like it.
Thank you so much. This is very helpful and I shared with my colleagues.
Great lesson. Cheers
THANKS FOR THE TUTORIAL.
Sir.. Wonderful .. Very very use analysis data format
Thank you. Badly needed. Blessings
Awesome Instructional Video! Thanks!
Thank you so much. It was a very informative video.
This is really Great. this video helped me a lot Sir. Perfect and Thanks a lot
Literally it's too much good for me i just see this video just before my interview and i got all the knowledge 🙌
very informative.. i have been searching the easiest way to create dashboard (not using macros)..and here we are :)
Excellent tutorial
Really very Informative.... Thanks for sharing.. It will definitely enhance my skills..
Thank you so much, You made it more easier that it is
Thank you so much for this video! Didnt know creating dashboards would be so simple 👍
Hi, I am following ur lesson. Without pivot can I make dashboard
It helped totally. Thank you 👍😊
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?
very good easy tutorial ... thanks a lot
Excellent work. Thank you
HELPS ME A LOT. THANK YOU!!!
From where do you fetch table for analysis???
Hello, do you have some data to practice making this dashboard??
Thank u sir,all 4 parts are simply awesome 👍
In video the pivot table you used in what reference you made this ?
You made it so easy. Good job
Thank you!!
This is very important for me.✨
Thanks. To watch more video please visit www.myelesson.org/
Thanks a lot Guruji
thats great , but if i did changes in main data its not changing in dashboard , pl guide
Hello, first of all I'd like to say thanks to you for this video... I've implemented the same thing but getting #REF error because I've linked the table in the dashboard with pivot whenever I'm using a filter showing #REF error...what to do to get rid of the same... please help
Thank you, this was insightful
Thank you so much. But im unable to acces slicer on my computer as it shows inactive. Please suggest how to activate. Thanks
Can we show overall count on pivot chart. Chart shown in video shows monthly trend only and not overall count or percentage
Brilliant video. Skillful teaching.
Thanks a lot sirji,,,,hats off to yours knowledge and explaining skills thanks a lot
Does it automatically change when we add or remove entries in raw data?
Good job! Short and to the point. Connecting tool for the slicers was a useful find for me.
Nice and Concise! No long stories. Straight to the point! Well done
dear sir your videos helpful to learn advance excel.
Thank you very much for the information...it is really helpful
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
Tried the same but facing issues with the report connections. It displaying only one pivot table and not the other one. Have seen couple of videos in youtube but not resolution yet. Kindly suggest.
Please where can I find the data you used
Wow...it was excellent...you made my day
Thank you for the presentation, well explained. God bless u.
Cool .. Really simple and straigh forward. Please keep your coming videos as simple as this one. Thanks
Great video.Not publishing videos anymore in 2020?
Very clear. Nice Job
Great lesson
Happy Learning, Thanks
very good presentation
Incredible Explanation. Taken my Excel Skills to next level thanks a lot for this wonderful useful video
You are most welcome!