Hi. I am from Cape Town in South Africa. I am an "ageing accountant" and taught myself excel by trial and error. I loved your video on creating a dashboard. It will definitely assist me. Keep up the brilliant work!
Great way to explain people . Must say you have a very smooth & clear voice to teach people about complex topics . Love to see more relevant videos. Keep it up..
Hi Ajay, Few suggestions: 1) it's helpful to include currency in sales amount, this example refers to Sales amount in Rupees, so helpful to have Rs symbol in Sales Amount 2) We can add Slicer's Reporting Connection to 'Sales by Months' pivot chart as well. Let me know your thoughts
Omg...I have created it for the first time...never got a mentor like u...the method u were teaching just awesome....beginners can also learn easily....thanks to ur teaching skill...😊
@ajay I have separate small table categories. I want main table pivot slicer list to have this independent data. This is static list or table . Any idea how to?
Very nicely explained with a reasonable speed. Can we keep adding more data into sheet or pivot table and dashboard will take that data into the different graphs or dashboard will be automatically updated.
Dear thanks for a such informative video ,I just want to learn that , after calculating business growth in pivot table in % ,how can we add it in dashboard in form of % in graph or column..
After failing in phone interview, bec I never worked on Dashboard before in excel, interviewer asked, do u know dashboard, I told I have worked on Charts and Graphs in but not on Dashboard, then I searched on TH-cam your video, it's really amazing, after watching this video should I add Dashboard in my CV or not or still a lot to learn about Dashboard please guide
Please check the video description. If you are staying outside India, check the following link. ajay-7-shop.fourthwall.com/en-inr/products/excel-dashboard-practice-files
very nice video and good and easy steps to learn excellent and keep it up the video creation u are excellent knowledgable person , iam retd mechanicle engineer no age limit for learning 💯👌
Hi. I am from Cape Town in South Africa. I am an "ageing accountant" and taught myself excel by trial and error. I loved your video on creating a dashboard. It will definitely assist me. Keep up the brilliant work!
Hi did you manage to create one
One of the best tutorials in excel dashboard so far in TH-cam...
❤
So many helpful tips and techniques in this tutorial, Ajay! Thanks for sharing it 😉
Glad to hear that Sharon :)
Great way to explain people . Must say you have a very smooth & clear voice to teach people about complex topics . Love to see more relevant videos. Keep it up..
Hi Ajay,
Few suggestions:
1) it's helpful to include currency in sales amount, this example refers to Sales amount in Rupees, so helpful to have Rs symbol in Sales Amount
2) We can add Slicer's Reporting Connection to 'Sales by Months' pivot chart as well.
Let me know your thoughts
Go to the number you will get option in last line of the series where you can turn currency in to Rupees
Very very beautifully explained , a layman can understand easily, many thanks for your wonderful explanation
You're one of the best TH-cam tutors I have encountered. Very precise, you make it look simple. Thank you
Omg...I have created it for the first time...never got a mentor like u...the method u were teaching just awesome....beginners can also learn easily....thanks to ur teaching skill...😊
Hello Ajay, wonderful explanation and it is easy to learn and pleasing to hear your lecture. Keep it up.
Thank you so much its very helpful and easy to understand!! Thank again!!
My pleasure :)
Simply the best dashboard tutorial I have come across, awesome! Keep up the good work, Ajay.
Many thanks Ajay for your simple elaboration on how to make dashboard 😊👏🤛
I have never seen any video like this in such a simple and easy way..❤❤❤❤
You are a legend! Keep going, and we will support you. You are the best
you are mind blowing Ajay ji ,,nice explanation
Bro, Seriously this is the most useful video for me in my life❤🎉
Can you send the source data
The best excel tutorial. Straight to the point!
Thanks Ajay.. l learned so many tips..😊😊🎉🎉🎉
Thanks brother, excellent and Simple to learn tutorial for dashboard creation
Great explanation step by step Ajay. Really helpful and thanks for sharing it!!
Very well explained, easy and simple
Really Nice training thank you
This was very helpful, very easy to follow. I was able to create a dashboard for a project I was leading using your video. Great job!
Very great and easy to follow explanation. Good job bro 👏
Thank you !! you made it very straight forward, easy to follow. I really appreciate it.
My pleasure 😀
Love the way you teach... It makes things so simple even though complex
Wow Crisp and clear 🎉
Superb man, you were amazing.😀
This video made me think creating dashboards is very easy 😉 Thanks for Ajay 👏👏
Very Easy and precise. Thanks a lot Sir
Thank you Ajay, you don't know how it is helpfull a lot for me🙏
My pleasure 😀
Thank you very much ajad ...but plz can you explain how i can daily add new data and update my dashboard data daily ?
Best Tut video so far I have come across ❤
Best Excel Dashboard tutorial video.
You taught too much easy way. Thanks a lots
My pleasure 😀
Excellent explanation. 😊
Very Well Explained❤❤❤Superb❤❤❤
Glad you liked it😀
This is just an amazing with a clear crystal process flow.. God bless and thanks a ton for such wonderful video.
Wonderful tutorial! Thanks. One i have one question. Will the dashboard update as when when new values are added?
Very very clear explanation🎉🎉
One of the best video I have seen and learnt also
Fantastic dashboard creation. Thank you
Fantastic bro..... Loved it.....
@ajay
I have separate small table categories. I want main table pivot slicer list to have this independent data. This is static list or table . Any idea how to?
Smart teaching❤easy learning
I like this video and comment ❤❤❤❤
Superb bro....thank you...
Very nicely explained with a reasonable speed. Can we keep adding more data into sheet or pivot table and dashboard will take that data into the different graphs or dashboard will be automatically updated.
Simplified yet it was a very clear and meaningful explanation within a short time. Excellent brother. Thanks
It is something I was searching for.❤
Very straightforward and clear
Thanks Sir for very informative video.
Sir thanks lot for your. video. Last month wise chart not linked sir
Thankyou Ajay Anand, Superb explanation. Very easy to understand
Thank you very much for sharing this Dashboard Ajay. It's very helpful for us.
Excellent video,respect your work.
Many thanks for making this video. Very informative and easy to learn.
Thank you so much sir!!! excellent and well simplified presentation sir !!!!
My pleasure 😀
Excellent! Thanks for sharing the most valuable video.
To the point and easy to understand
Dear thanks for a such informative video ,I just want to learn that ,
after calculating business growth in pivot table in % ,how can we add it in dashboard in form of % in graph or column..
It is my first time, I found making dashboard so easy!☺️
Great work, making work look easy. Thanks.
Very nice sir...very informative video..❤
Hii actually I was just making a dynamic dashboard but there is an error happening with my dates can you give some suggestions
Superb. Very simple way to lot. Tks
It really helpful 😊😊🎉
Very nice and simple presentation
Hi, can the charts in the dashboard be imported to powerpoint? This includes the Slicer.
You taught too much easy way. 😊
thank you for your sharing Excell Dashboards
Good video easy to understand
Very informative. Great work.
After failing in phone interview, bec I never worked on Dashboard before in excel, interviewer asked, do u know dashboard, I told I have worked on Charts and Graphs in but not on Dashboard, then I searched on TH-cam your video, it's really amazing, after watching this video should I add Dashboard in my CV or not or still a lot to learn about Dashboard please guide
One of the amazing video on excel reports.
Excellent teaching👍🏻
Great work, you made things easy for everyone to understand keep the good work.
Great work
Could you please give me the link to download the video Excel file?.
Please check the video description. If you are staying outside India, check the following link.
ajay-7-shop.fourthwall.com/en-inr/products/excel-dashboard-practice-files
Can u please share any full project for data visualisation with excel , sql
Very useful , thank you so much
My pleasure 😀
very nice video and good and easy steps to learn excellent and keep it up the video creation u are excellent knowledgable person , iam retd mechanicle engineer no age limit for learning 💯👌
Month wise sales were not connected to slicer
Well simplified. You're the best Tutor I have encountered.
Best tutorial thanks 👍
Hi
Great learning from this session
I am not getting Insert slicer as you have shown in your video, in my excel it is not allowed to select
very nice explanation, really appreciated
Nice tutorial. Thanks for sharing
How to put Grand total in the Pivot chart? Please advise
very nice awsome... you explained whole concept in simple way....🍉🍌
Thanks for the great work, this was really helpful
Thanks a lot it was well explained
You are an excellent tutor
Smooth 👌 thank you...😊
My pleasure 😀
Hi, useful tips. Thank u so much
Very helpful!
Awesome.. Very easy and helpfull
nice explain sir i want to create maintenance dashboard plz help me