Pivot Table with Progress Chart and Dashboard
Вставка
- Опубліковано 9 лип 2024
- In this Training Video I'll show you how to create a Pivot Table in Excel with dynamic Progress Doughnut Chart and a Dashboard.
Impressive result with an easy to use step by step guiding.
you can download the start file and follow along by clicking on the link
www.amazon.ca/clouddrive/shar...
****** COMPLETE COURSE ******
Watch my latest Tutorial, which is a Complete Course on Dashboard Creation using Form Controls:
• From Data to Dynamic D...
Watch How to create a searchable drop list in Excel Just like Google
ua-cam.com/users/edit?o=U&vide... - Навчання та стиль
This is perfect! i am sure anyone can implement this after going through this tutorial for just once! Thanks for explaining it so well.
absolutely terrific thank you. Particularly impressed by repeating the steps verbally makes it much easier to take notes of tricky keying.
You're very welcome!
thanks for explaining everything step by step and easy to follow. I'm not native english but your pronunciation is clear and brief for me
Thank you for sharing such a piece of good knowledge!!
This tutorial is truly amazing and brilliant. Thank you for all the steps explained. Very precise!!
i was hesitant to watch another excel dashboard like youtube video but honestly you really did a tremendous job explaining and showing what you did thank you so much!
Glad it was helpful!
Thanks for the Tutorial. It looked difficult in the beginning, but you made it easy to learn. Learnt something new today.
This is a very powerful instructional video. It's clear and easy to understand. Thank you Nabi ! ! !
what a great job, Congrats! Thanks for sharing your knowledge!
very clear and concise information and very easy to understand, I feel this is something I could do now, so many tutorials seem to be too quick, but I picked this up a lot more easily with the clear, relaxed voice and explanations - thank you.
You're very welcome!
I invite you to watch the hundreds of other tutorials I have ... and Subscribe to my channel
This is powerful. Straight to the point!!!
Top tutorial! Thank you very much for sharing.
Wow! I never realized how polished Excel can be! Thank you for the tutorial. It's very helpful.
You're welcome. Please subscribe to be notified about new tutorials.
Amazing Tutorial. thank you so much!
Jessica and Mike are lucky to have such a great tutor!
It looks so fantastic!!!!! Thank you so much for the wonderful tutorial!!!!
With your video populated on one monitor, i was working in another monitor to create what my Boss requested me to do and i've done it with success and pride, all because of you. Thank You again, my friend.
What a perfect lecture and lecturer. Thank you for being so patient and crystal clear
Thank You Valentine
Very well presented and easy to understand. I created my first dashboard and it was great to learn new things. Very well appreciated by all. The whole new experience of reporting.
Thank you! Gracias! If I had known another language I would have thanked you in it too. I'm here because I'm taking my first steps in Data Analisys and Pivot Tables are a must for that.
You are most welcome Nelson... It is my pleasure to have you among my followers...
Did you subscribe?
Stay tuned
Thanks for a wonderful free tutorial lesson.
That was a brilliant walkthrough in creating a pivot table with dynamic doughnut chats.
I am happy you liked it
This is beautifully delivered. Thank you.
Watching......This is fantastic! God bless you.
Really great
Nice tutorial, learn steps positively .
Very nice tutorial. Thanks a lot!
Thank you
Voice is soothing and you speak at a pace to understand/follow.
Sir! You are really one of the great teachers .
Just a fantastic tutorial. One of the first I found easy to follow and paced to be instructive.
Thank You
it's look so nice , appreciated.
Incredible training video. Thank you sir!
That was beautiful and so easy to follow. Thank you!
super, thanks for teaching, left my tip :)
Well done! Just the one step of using the equals and cell for the text box was new to me (along with much more) and worth watching.
Me too.
Nice one.
using equal in cell text box will only work if =GetPivot function is off. If you don't want to off it then you'll need to create a helper-identical column of Sales Revenue
WOW! I didn't even know I could do this in Excel!
Wow! That is a brilliant tutorial, I learned a lot....... Thank you very much
Such a great video, I would pay to learn this yet you offered it free, I salute you.
My audience across the world deserves the BEST
Thanks a million...... I rocked in my presentation with your guidance........Thank you so much! God bless you!
Thank you for the nice comment... Did you Subscribe to my Channel? The Best Is Yet To Come
pure gold of 26 minutes, can't believe its free. thank you, sir, for the wonderful video.
Did you watch my recent tutorials?
I guess you'll like them too
Excellent tutorial! Thank you.
Phenomenal tutorial
Thank you so much!!! Love it 💖
Amazing, no doubt Mr. Mourad is a great tutor and I understand easily of every single word he said. Sir, thank you again from London, UK :)
Glad you liked it... Did you Subscribe to my Channel? The Best Is Yet To Come
Really helpful! Thank you for the tutorial :)
Very smart and professional
Thank you
Thank you for your nice comment.
Please share the video on your social media
well explained. thank you so much sir,
Good job sir! Straight to the point explanation. Thank you!👍
Terrific lecture indeed. Thanks for your generosity!
Hi there, this was a fantastic video! Thank you for this!!
Thank you
Glad you like it... Watch and share my newly posted tutorials
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 😊
You are most welcome
Great video, sir! Thank you very much for sharing your Excel skills with the rest of the world!
I'm glad you liked it.
It's a great tutorial for the Managers for the quick report preparations
Well done Sir...Thank you for sticking to the point and explain things very clearly... Just well done...
Thank you and glad you like it... I invite you to watch my latest tutorials
Great video thank you. Could we modify the data to implement conditional formatting, i.e change in Green if for example above 80%, but red otherwise?
I don’t normally comment on videos but this tutorial was absolutely fantastic. You have saved me a lot of time and headaches.
Thank you for the encouraging comment... Please share on your social networks
Thanks for an excellent session, well explained, big thanks
Wonderful tutorial
Thank you for your nice comment.
Please share the video on your social media
I thoroughly enjoyed your tutorial! Thanks so much. I did want to inquire though if you could explain the intent of how the helper column impacts the progress doughnut chart? Why exactly was that necessary (the '=1' equates to 100% is what I figured) but how does that actually interplay into the chart in the interactivity part?
minute 11:30 , it shows a secondary axis which 39% is the actual sale ( the actual part that will be seen) and 61% the transparent which is the leftover, non sale
One on the best videos I have watched on Pivot tables...Great job!
Thank you for your nice comment.
Please share the video on your social media
this was an awesome presentation. very patient, well articulated, and you know your stuff. the short cuts were amazing too.
You are most welcome
Great video Nabil. Thanks for sharing. Think i'll have doughnuts for dessert later too. :-)
GENIIIIIIIIIOUSSSS!
you are so kindness
No
This is exceptionally wonderful. Great Knowledge. Thank you for sharing
I love it, great tutorial!
When i click on donut arrow it forces me to chose between the existing ready donut
First of all I would like to than you for awesome presentation. In this tutorial I'm unable change series chart type since custom combination is not available to select secondary axis. Note:- I am doing this on Excel 2007
Please download Office 2016 from official website of Microsoft. I will provide you activation key
Yes u can, you need to apply the whole process on primary axis.
Fantastic tutorial, this is what I was looking for. Thank you so much!
You're very welcome!
Great tutorial for me. Thank you very much. We wait for the next!
Cool.
I've just used this in one of my dashboards. One problem I've run into is that for certain filter combinations some of the rows have no output (the value is zero) so Excel hides it which means that the doughnuts pick up the wrong row. I had to use the field settings to make sure it shopws row with no data.
By the eay, what version of Excel are you usign there? At work I have to use Excel 2010 because of compatibility with vertical applications, that doesn't let you do the secondary axis. On my personal machine I have Office 365 Pro Plus (Semi-Annual channel) which does but I noticed that some of the settign look different. If I create the dashboar don my personal machien it still works in 2010 on my work machine. Thanks.
In this case you have to make sure that all Seller ( for example) have done some sales on all regions so you can insert a data for all seller for all regions with 0 amount. So even if the seller did not sell for an specific region it would appear as 0. That is how I resolved here.
I used at the time of recording Office 2016...
BTW, forward compatibility always works, backward compatibility not guaranteed.
What exactly did you do to solve this problem. I'm facing same problem.
جزاك الله
Would you please add source file for downloading.
The best tutorial for Pivot Table, Progress chart and Dashboard all in one place
Thank you for the nice comment. Kindly share my tutorials to your social media... You can download the start file by going to my website www,OfficeInstructor.ca and click on "Downloads"
@@Officeinstructor what is the file's name?
File name: "Progress Doughnut Chart"
I do not understand how do you got some dislikes, its simply cool and easily understandable.. Appreciated..
@@mukundanandan8614 Because the file on link has only source, no doughnut chart, may be, the reason!:-)
Brilliant. I followed and it was like a walk in the park.
Very helpful, thank you Nabil.
Very nice and helpful for a beginner like us. No idea who all dislike this tutor.. anyway m very much happy and definitely try with my project with this formula 👍👍👍
Now I understand pivot tables. Quite clear and easy to follow. Well explained and thank you very much, Sir.
This tutorial is amazing!
Very detailed and informative... I can add this to my project. Thank you so much
Brilliant Easy to Follow, Step by Step Instructions! Kudos to the Tutor 👏🏼👏🏼
Thank You Vishal
My Friend, you are a legend, thank you!
Wow, mindblown. Thank you!
Absolutely fantastic tutorial, thank you very much.
WOW !!!!!!!!!!!!!
Just AMAZING !
Nobody would have explained it better than u did.Thank u so much.
Thank you my friend
This is really great. Thanks for sharing.
Absolutely amazing!
Excellent Tutorial, Really thanks for this.
This is very cool! thank you so much for sharing your skills!
Very well explained. Short and crisp instructions. Great Learning. Thanks for the Video.
Thank you
Thank you very much for this amazing tutorial.
Very amazingly done!! Please keep up the great job
Excellent..well paced and easy to follow
Great!!! Very Much Practical and Live.. Thanks a lot..
Amazing video! Easy to follow and execute. Thank you!
You're very welcome!
Excellent job! Love the pace & clarity.
Thank you for the encouragement
Bravo, you did it. Thanks a lot.
Great job! Thank you so much.
mind blown. very well done.
You ... just ... ROOOOCK! Wonderful!
Glad you like it... Thank you
Share and Subscribe
Really helpful, thank you!
Thanks for putting this up. Detailed and we'll explained.
Thank you so much. Very simple and clear explanation running through the video and same time action taking place on laptop