How to Create Dashboard in Excel ☑️
HTML-код
- Опубликовано: 21 июл 2024
- Download Link New to Excel dashboards? Learn how to create dashboard in Excel to improve your Excel, data analysis and data visualization skills. You can make dashboard in excel in under 5 minutes after watching this video without any additional software of plugin.
Download this excel dashboard template for free from my website
to make excel dashboard and reports for yourself.
10 Most Used Formulas MS Excel
• 10 Most Used Formulas ...
Learn Basic Excel Skills For Beginners || Part 1
• Learn Basic Excel Skil...
10 Most Used Excel Formula
• 10 Most Used Excel For...
*Most Imporant Excel Formuls Tutorials*
Learn Vlookup Formula For Beginners in Excel
• Learn Vlookup Formula ...
5 Excel Questions Asked in Job Interviews
• 5 Excel Questions Aske...
Create Speedometer Chart In Excel
• Create Speedometer Cha...
Learn the Basic of Excel for Beginners || Part 2
• Learn the Basic of Exc...
Create Pareto Chart In Excel
• Create Pareto Chart In...
How to Create Dashboard in Excel
• How to Create Dashboar...
Excel Interview Questions & Answers
• Excel Interview Questi...
To watch more videos and download the files visit www.myelesson.org
To Buy The Full Excel Course visit . www.myelesson.org/product or call 9752003788
Connect with us on Facebook - / excelmadeasy
Connect with us on Twitter - / excelmadeasy 10 Most Used Formulas MS Excel
• 10 Most Used Formulas ...
Learn Basic Excel Skills For Beginners || Part 1
• Learn Basic Excel Skil...
10 Most Used Excel Formula
• 10 Most Used Excel For...
*Most Imporant Excel Formuls Tutorials*
Learn Vlookup Formula For Beginners in Excel
• Learn Vlookup Formula ...
5 Excel Questions Asked in Job Interviews
• 5 Excel Questions Aske...
Create Speedometer Chart In Excel
• Create Speedometer Cha...
Learn the Basic of Excel for Beginners || Part 2
• Learn the Basic of Exc...
Create Pareto Chart In Excel
• Create Pareto Chart In...
How to Create Dashboard in Excel
• How to Create Dashboar...
Excel Interview Questions & Answers
• Excel Interview Questi...
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
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.
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
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.
One of the most productive excel tutorials I have ever seen! Thank you!
Welcome Kristina
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 👍🏻
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
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 😊
Thank you so much for this video! Didnt know creating dashboards would be so simple 👍
perfect way to represent the financial dashboard in just few minutes...Really amazing to watch it. Keep it up and and provide us a great platform to learn. Thanks a lot.
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 👍💯
Nice and Concise! No long stories. Straight to the point! Well done
Wow, I am new to MIS and Advance excel.. your tutorials are one of the best and easy to understand.
Thanks for sharing the knowledge.. :)
I'm just starting to learn about dashboarding in Excel, so your video was easy to follow. Thank you.
Aapne Izzat Paisa Dono Bachaa Liya 🙏. This is more easier than I thought. Thanks
Good job! Short and to the point. Connecting tool for the slicers was a useful find for me.
I am currently doing a course on data analysis and visualization. This video has been so helpful and informative.
Super cool buddy. Nice explanation short,crisp and effective.
Awesome!!! Really clear and to the point. Thank you!
Thank you for the presentation, well explained. God bless u.
Thanks a lot for simplifying the tutorial. I can't believe that i learnt a lot in just a few minutes. Kudos
very useful video. Amazing. I have also seen lot of videos for dashboards, but your video was the best amount them. Well done. Keep doing these kinds of useful videos
Brilliant thank you . You have subscribed and am looking forward to viewing more of your lessons.
Thank you, I needed this sooo much :)
Welcome Dear
Cool .. Really simple and straigh forward. Please keep your coming videos as simple as this one. Thanks
This was really helpful. You made look so easy. Thank you. It was indeed happy learning.
I learned so much with you! Thank you! you are wonderful! :)
A well build video with all necessary basic information to create dashboard. Thanks a ton
Omg.. Awesome page.. Downloaded your templates from your website.. Keep doing it.. Love your work.. God bless you and God be with you 😇
Thank you so much. You helped me to create my tables for job application dataset analysis. Much love from Rwanda.
Beautiful and highly impactful tutorial. Thank you!
Your explanations are very clear...i also like the way you bring out light moments to keep the it the student alert.
Love your presentation style and info. Thanks!
Thank you so much for your time, God Bless!
Great step by step tutorial and very informative.
Thanks for this video brother.
very informative.. i have been searching the easiest way to create dashboard (not using macros)..and here we are :)
I found this tutorial very useful- thank you! Any idea why I cannot get the PT's connected to the slicer? I can only connect one and when I try to connect more, it doesn't recognize the other Pivot tables.
ah ok...too much easy, learn many things on excel.. but first time watched like this.... increase knowledge
thanks guru
Awesome....This is the best and easiest way to create a dashboard...Thanks a lot for making this video...very helpful.
Thanks for imparting such wonderful tips regarding dashboard. In fact all your videos are very knowledgeable. Thank you again for sharing the information.....
excellent video. i made a dashboard as i listen to your instructions.. well explained. thank you... ps* kattapa was the highlight!! haha
Thank you for the easy and short video. It is useful and time saving.
You are really great Sir , this is what a simple and sweet dashboard i wanted to make for my Stores and Logistics report .
Thank you so much for sharing this useful information in a systematic way...
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.
Loved it. Thanks!
This is very great video for learners. Enjoyed a lot while learning. Pl make many more on Advanced pivoting.
Good stuff. Very clearly explained and easy to follow.
Thanks sir.
Awesome Instructional Video! Thanks!
Great concise tutorial. Thanks!
Great lesson. Cheers
Thank you so much the session was very informative and helpful you are a ❤ good hearted person, God bless you as you are!!
I was wondering for a trick like this👌👏 well😊 nice explanation
Dear sir Your teaching style is very easy to learn
A lot of improvement in my excel
Thank you very much.....
Or ha sir, I am really mad for your every new video.
Excellent tutorial, this will help me in my working. Thank you very much Sir.
Thanks... that was a good one. Intro got a little long but the rest of it was simple and excellent.
Amazing !! simple to understand thank you 😃
This is awesome ! Thanks for sharing!!!
This is great!!! But now suppose if we want to add the data in the master data or Raw data as you have mentioned, will it reflect automatically or it stay the same?
Excellent!!! Thank you so much for share this information.
That was great!! Thank u for sharing!!
Thank you for your help :) great tutorial.
Amazing content. Learned a lot. Thank you.
Great Teaching! Thank you!
Thank you! This is exactly what I needed.
Beautiful lessons Sir, thank you much for making these so easy to understand
Thank you. You made it clear and simple.
thanks bro ... The way you explained the content was really good .....
This is really Great. this video helped me a lot Sir. Perfect and Thanks a lot
Thank you, this was insightful
This was great - thank you!
Sir You are real guru, thanks for extending this trick.
Thank you …this is so helpful
Thank u sir,all 4 parts are simply awesome 👍
Excellent work. Thank you
Thank you so much. It was a very informative video.
Thank you so much. This is very helpful and I shared with my colleagues.
Perfectly elaborated!!! 👏🏻👏🏻👏🏻👏🏻
Thanks for the simple explanation.
Thank you very much for the information...it is really helpful
Excellent video designed by you...
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.
THANKS FOR THE TUTORIAL.
thanks a lot! this was very useful and well explained
Thank you so much, You made it more easier that it is
It helped totally. Thank you 👍😊
Amazing tutorial. Thanks a lot for making this video.❤
Thank you for this!
Thank you, this was very clear to prepare a dashboard
This video is really perfect and clear. Thank you so much. I do like it.
Incredible Explanation. Taken my Excel Skills to next level thanks a lot for this wonderful useful video
You are most welcome!
Brilliant video. Skillful teaching.
HELPS ME A LOT. THANK YOU!!!
From where do you fetch table for analysis???
Very helpful! But I have one question, why is it that there should not be any empty cell while creating pivot? If I have a data suppose for employees working on certain days for certain no.of hours with other matrices as well and for a day an employee did not work and we dont have a zero in that cell, will it not allow me to create a pivot?
Hi !! Really a great video and i want to clarify one doubt. When we transform the data and make some changes to the data, these all the changes, may i know where it will be stored? Is there any storage thing for the modifications if we made(In transform data). If YES please tell me. Thanks in advance.
The most simple way to learn this. Thank you.
Very interactive, simple and fantastic way.....thankyou
Fantastic Presentation! Thanks for the help Sir. Regards.
Excellent tutorial