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 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
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..
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...😊
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.
@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?
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..
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 💯👌
Thanks for the video i would like to suggest you one thing is that slicer is not connected monthly sales pivot chart /pivot table. Bye the way i follow your channel for excel. your explained as a pro faculty.
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
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
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
I am from Cape Town, South Africa, I am an “aging engineer” - and will use this excellent video to create my personalised Dashboard!
One of the best tutorials in excel dashboard so far in TH-cam...
❤
I saw too many vdos on creating dashboard but urs one is amazing. Must say it was smooth and clear instruction, not many instruction.
So many helpful tips and techniques in this tutorial, Ajay! Thanks for sharing it 😉
Glad to hear that Sharon :)
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
Hatsoff... i was just clapping after watching this video for the wonderful presentation done.. Very informative
Very very beautifully explained , a layman can understand easily, many thanks for your wonderful explanation
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..
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...😊
Wow Crisp and clear 🎉
You are a legend! Keep going, and we will support you. You are the best
You're one of the best TH-cam tutors I have encountered. Very precise, you make it look simple. Thank you
Many thanks Ajay for your simple elaboration on how to make dashboard 😊👏🤛
The way you teach is amazing!! Thank you for the content, keep them coming!!
Simply the best dashboard tutorial I have come across, awesome! Keep up the good work, Ajay.
Thank you very much ajad ...but plz can you explain how i can daily add new data and update my dashboard data daily ?
Hello Ajay, wonderful explanation and it is easy to learn and pleasing to hear your lecture. Keep it up.
I have never seen any video like this in such a simple and easy way..❤❤❤❤
Thank you so much its very helpful and easy to understand!! Thank again!!
My pleasure :)
you are mind blowing Ajay ji ,,nice explanation
Love the way you teach... It makes things so simple even though complex
Thanks brother, excellent and Simple to learn tutorial for dashboard creation
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!
Thank you very much for making such an informative and knowledge-sharing video on Excel work.
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.
This is just an amazing with a clear crystal process flow.. God bless and thanks a ton for such wonderful video.
@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?
Thank you !! you made it very straight forward, easy to follow. I really appreciate it.
My pleasure 😀
Wonderful tutorial! Thanks. One i have one question. Will the dashboard update as when when new values are added?
Is it possible to create dashboard with multiple reports. If yes can you teach us
The best excel tutorial. Straight to the point!
Very great and easy to follow explanation. Good job bro 👏
Bro, Seriously this is the most useful video for me in my life❤🎉
Fantastic dashboard creation. Thank you
one of the best tutorial.. it will definitely help me .. great work
This video made me think creating dashboards is very easy 😉 Thanks for Ajay 👏👏
Great explanation step by step Ajay. Really helpful and thanks for sharing it!!
Loved your video, best video ive seen so far
Hi, can the charts in the dashboard be imported to powerpoint? This includes the Slicer.
You taught too much easy way. Thanks a lots
My pleasure 😀
Thank you, precise and very well explained 👏
Amazing bro... Keep it up and thanks for such a wonderful explanation
superb dettailed explained
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..
Thank you Ajay, you don't know how it is helpfull a lot for me🙏
My pleasure 😀
Can you send the source data
Sir thanks lot for your. video. Last month wise chart not linked sir
Very Easy and precise. Thanks a lot Sir
Excellent explanation. 😊
Many thanks for making this video. Very informative and easy to learn.
Very nice and simple presentation
Best Tut video so far I have come across ❤
Very well explained, easy and simple
Thankyou Ajay Anand, Superb explanation. Very easy to understand
Thank you very much for sharing this Dashboard Ajay. It's very helpful for us.
Thanks Ajay.. l learned so many tips..😊😊🎉🎉🎉
Can we create 3 district pivot table and then use slicer
It is my first time, I found making dashboard so easy!☺️
Very straightforward and clear
Great work, you made things easy for everyone to understand keep the good work.
Fantastic bro..... Loved it.....
One of the best video I have seen and learnt also
Very very clear explanation🎉🎉
Best Excel Dashboard tutorial video.
Thank you so much sir!!! excellent and well simplified presentation sir !!!!
My pleasure 😀
How to put Grand total in the Pivot chart? Please advise
🎉🎉🎉 you deserve my follow, like, comment and share
Excellent teaching👍🏻
very nice explanation, really appreciated
Superb man, you were amazing.😀
Very Well Explained❤❤❤Superb❤❤❤
Glad you liked it😀
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 💯👌
One of the amazing video on excel reports.
Thanks for the video i would like to suggest you one thing is that slicer is not connected monthly sales pivot chart /pivot table. Bye the way i follow your channel for excel. your explained as a pro faculty.
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
To the point and easy to understand
Really Nice training thank you
Smart teaching❤easy learning
Thanks Sir for very informative video.
I really love your video, where were you Sir, I subscribed liked loved it
Awesome video . Thanks
Hi
Great learning from this session
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
Can u please share any full project for data visualisation with excel , sql
Great work, making work look easy. Thanks.
Very informative. Great work.
Very nice sir...very informative video..❤
Excellent video,respect your work.
Superb bro....thank you...
Great videos bro impressed
Excellent job 👍👍👍
It really helpful 😊😊🎉
Hii actually I was just making a dynamic dashboard but there is an error happening with my dates can you give some suggestions
You are an excellent tutor
nice explain sir i want to create maintenance dashboard plz help me
I like this video and comment ❤❤❤❤
Very nicely explained
This really helped me. Thanks a lot
simple and awesome bro
Very informative session