Pivot Table with Progress Chart and Dashboard

  Рет қаралды 2,424,752

Officeinstructor

Officeinstructor

Күн бұрын

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
kzfaq.info?o=U&vide...

Пікірлер: 1 000
@wrhabibi13
@wrhabibi13 5 жыл бұрын
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
@jerrygardner2473
@jerrygardner2473 4 жыл бұрын
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.
@Officeinstructor
@Officeinstructor 4 жыл бұрын
You're very welcome! I invite you to watch the hundreds of other tutorials I have ... and Subscribe to my channel
@shaileshk4486
@shaileshk4486 2 жыл бұрын
This is perfect! i am sure anyone can implement this after going through this tutorial for just once! Thanks for explaining it so well.
@petermcmurray2807
@petermcmurray2807 4 жыл бұрын
absolutely terrific thank you. Particularly impressed by repeating the steps verbally makes it much easier to take notes of tricky keying.
@Officeinstructor
@Officeinstructor 4 жыл бұрын
You're very welcome!
@MohanRaj-yz9oc
@MohanRaj-yz9oc 5 жыл бұрын
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.
@siritamcclay-jenkins688
@siritamcclay-jenkins688 4 жыл бұрын
This tutorial is truly amazing and brilliant. Thank you for all the steps explained. Very precise!!
@parju
@parju 2 жыл бұрын
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.
@cleangene17
@cleangene17 5 жыл бұрын
Wow! I never realized how polished Excel can be! Thank you for the tutorial. It's very helpful.
@Officeinstructor
@Officeinstructor 5 жыл бұрын
You're welcome. Please subscribe to be notified about new tutorials.
@jlpayne052710
@jlpayne052710 3 жыл бұрын
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!
@Officeinstructor
@Officeinstructor 3 жыл бұрын
Glad it was helpful!
@walelignabiye3055
@walelignabiye3055 5 жыл бұрын
Thank you for sharing such a piece of good knowledge!!
@mk2373
@mk2373 6 жыл бұрын
Thanks for the Tutorial. It looked difficult in the beginning, but you made it easy to learn. Learnt something new today.
@johndonlan5956
@johndonlan5956 5 жыл бұрын
This is a very powerful instructional video. It's clear and easy to understand. Thank you Nabi ! ! !
@Valentine-xl1qz
@Valentine-xl1qz 4 жыл бұрын
What a perfect lecture and lecturer. Thank you for being so patient and crystal clear
@Officeinstructor
@Officeinstructor 4 жыл бұрын
Thank You Valentine
@sulaimonolayode1310
@sulaimonolayode1310 4 жыл бұрын
That was a brilliant walkthrough in creating a pivot table with dynamic doughnut chats.
@Officeinstructor
@Officeinstructor 4 жыл бұрын
I am happy you liked it
@waseemughal
@waseemughal 4 жыл бұрын
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 :)
@Officeinstructor
@Officeinstructor 4 жыл бұрын
Glad you liked it... Did you Subscribe to my Channel? The Best Is Yet To Come
@ernestthebo5441
@ernestthebo5441 3 жыл бұрын
Jessica and Mike are lucky to have such a great tutor!
@jolandaglans
@jolandaglans 5 жыл бұрын
Top tutorial! Thank you very much for sharing.
@knowledgetips32
@knowledgetips32 4 жыл бұрын
Really great Nice tutorial, learn steps positively .
@nelsongg347
@nelsongg347 5 жыл бұрын
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.
@Officeinstructor
@Officeinstructor 5 жыл бұрын
You are most welcome Nelson... It is my pleasure to have you among my followers... Did you subscribe? Stay tuned
@bellaqiu2851
@bellaqiu2851 6 жыл бұрын
It looks so fantastic!!!!! Thank you so much for the wonderful tutorial!!!!
@leenaat
@leenaat 6 жыл бұрын
Amazing Tutorial. thank you so much!
@arielparodi3501
@arielparodi3501 6 жыл бұрын
what a great job, Congrats! Thanks for sharing your knowledge!
@abdulahiopeyemifalade900
@abdulahiopeyemifalade900 5 жыл бұрын
Watching......This is fantastic! God bless you.
@TheElevenBravo
@TheElevenBravo 5 жыл бұрын
Great video, sir! Thank you very much for sharing your Excel skills with the rest of the world!
@Officeinstructor
@Officeinstructor 5 жыл бұрын
I'm glad you liked it.
@EricaDyson
@EricaDyson 6 жыл бұрын
Very nice tutorial. Thanks a lot!
@carmengalicia2505
@carmengalicia2505 4 жыл бұрын
Thanks for a wonderful free tutorial lesson.
@franklinm.fotang81
@franklinm.fotang81 5 жыл бұрын
This is powerful. Straight to the point!!!
@jahirussain9975
@jahirussain9975 6 жыл бұрын
It's a great tutorial for the Managers for the quick report preparations
@nazimocassimo6964
@nazimocassimo6964 4 жыл бұрын
Just a fantastic tutorial. One of the first I found easy to follow and paced to be instructive.
@Officeinstructor
@Officeinstructor 4 жыл бұрын
Thank You
@rschaefe1
@rschaefe1 4 жыл бұрын
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.
@unboxingreviewvlog7009
@unboxingreviewvlog7009 3 жыл бұрын
Me too.
@unboxingreviewvlog7009
@unboxingreviewvlog7009 3 жыл бұрын
Nice one.
@SaddamKhan-jd2sj
@SaddamKhan-jd2sj 3 жыл бұрын
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
@brotherschannel9810
@brotherschannel9810 5 жыл бұрын
pure gold of 26 minutes, can't believe its free. thank you, sir, for the wonderful video.
@Officeinstructor
@Officeinstructor 5 жыл бұрын
Did you watch my recent tutorials? I guess you'll like them too
@marjanemmanuel9574
@marjanemmanuel9574 4 жыл бұрын
Wow! That is a brilliant tutorial, I learned a lot....... Thank you very much
@simpleexcelexamples9619
@simpleexcelexamples9619 2 жыл бұрын
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 😊
@Officeinstructor
@Officeinstructor 2 жыл бұрын
You are most welcome
@tilkeshjathan
@tilkeshjathan 4 жыл бұрын
Thanks a million...... I rocked in my presentation with your guidance........Thank you so much! God bless you!
@Officeinstructor
@Officeinstructor 4 жыл бұрын
Thank you for the nice comment... Did you Subscribe to my Channel? The Best Is Yet To Come
@azizniazi9159
@azizniazi9159 5 жыл бұрын
Sir! You are really one of the great teachers .
@georgemmnl
@georgemmnl 5 жыл бұрын
This is beautifully delivered. Thank you.
@ahmdzidane
@ahmdzidane 5 жыл бұрын
it's look so nice , appreciated.
@yogitamizhangaming359
@yogitamizhangaming359 6 жыл бұрын
Phenomenal tutorial
@JD-hk5ot
@JD-hk5ot 6 жыл бұрын
I don’t normally comment on videos but this tutorial was absolutely fantastic. You have saved me a lot of time and headaches.
@Officeinstructor
@Officeinstructor 6 жыл бұрын
Thank you for the encouraging comment... Please share on your social networks
@realestatewith_sabrina
@realestatewith_sabrina Жыл бұрын
Thank you Voice is soothing and you speak at a pace to understand/follow.
@7479zm
@7479zm 5 жыл бұрын
Such a great video, I would pay to learn this yet you offered it free, I salute you.
@Officeinstructor
@Officeinstructor 5 жыл бұрын
My audience across the world deserves the BEST
@hattemghanoom9557
@hattemghanoom9557 6 жыл бұрын
Very smart and professional Thank you
@Officeinstructor
@Officeinstructor 6 жыл бұрын
Thank you for your nice comment. Please share the video on your social media
@EOO-Stand
@EOO-Stand 5 жыл бұрын
this was an awesome presentation. very patient, well articulated, and you know your stuff. the short cuts were amazing too.
@Officeinstructor
@Officeinstructor 5 жыл бұрын
You are most welcome
@Im2lazy79
@Im2lazy79 6 жыл бұрын
One on the best videos I have watched on Pivot tables...Great job!
@Officeinstructor
@Officeinstructor 6 жыл бұрын
Thank you for your nice comment. Please share the video on your social media
@Vahidutube
@Vahidutube 5 жыл бұрын
Well done Sir...Thank you for sticking to the point and explain things very clearly... Just well done...
@Officeinstructor
@Officeinstructor 5 жыл бұрын
Thank you and glad you like it... I invite you to watch my latest tutorials
@kiasca3489
@kiasca3489 4 жыл бұрын
super, thanks for teaching, left my tip :)
@kriswatson932
@kriswatson932 2 жыл бұрын
That was beautiful and so easy to follow. Thank you!
@michaelb.f.chiwoza2430
@michaelb.f.chiwoza2430 3 жыл бұрын
Now I understand pivot tables. Quite clear and easy to follow. Well explained and thank you very much, Sir.
@yimonthant2010
@yimonthant2010 5 жыл бұрын
Thank you so much!!! Love it 💖
@dimilouk9735
@dimilouk9735 5 жыл бұрын
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?
@Heavieth
@Heavieth 4 жыл бұрын
Incredible training video. Thank you sir!
@sharoanmartin7485
@sharoanmartin7485 5 жыл бұрын
Very well explained. Short and crisp instructions. Great Learning. Thanks for the Video.
@Officeinstructor
@Officeinstructor 5 жыл бұрын
Thank you
@cvanzyl73
@cvanzyl73 5 жыл бұрын
Hi there, this was a fantastic video! Thank you for this!!
@Officeinstructor
@Officeinstructor 5 жыл бұрын
Thank you Glad you like it... Watch and share my newly posted tutorials
@krishnaRaog21
@krishnaRaog21 6 жыл бұрын
Wonderful tutorial
@Officeinstructor
@Officeinstructor 6 жыл бұрын
Thank you for your nice comment. Please share the video on your social media
@rajeshvasudevan3900
@rajeshvasudevan3900 4 жыл бұрын
Thanks for an excellent session, well explained, big thanks
@megatooth419
@megatooth419 4 жыл бұрын
Hi there! I just wanted to commend you on an excellent presentation. I found it very comprehensive and your explanations were very concise. This is an extremely useful video. Many thanks
@Officeinstructor
@Officeinstructor 4 жыл бұрын
Thank you
@BMNAZEEB72
@BMNAZEEB72 5 жыл бұрын
well explained. thank you so much sir,
@kartikdindi296
@kartikdindi296 5 жыл бұрын
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
@chanderjeetyadav6431
@chanderjeetyadav6431 4 жыл бұрын
Please download Office 2016 from official website of Microsoft. I will provide you activation key
@dervaishbhai
@dervaishbhai 4 жыл бұрын
Yes u can, you need to apply the whole process on primary axis.
@sasavienne
@sasavienne 5 жыл бұрын
I downloaded the file and practiced step by step what you explained. I could learn too much from this video. Thank you so much for your great efforts.. Best regards from Germany.. 🌟 🌟 🌟
@driedjello
@driedjello 5 жыл бұрын
WOW! I didn't even know I could do this in Excel!
@gem3008
@gem3008 4 жыл бұрын
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?
@kiasca3489
@kiasca3489 4 жыл бұрын
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
@HP-sw7ht
@HP-sw7ht 5 жыл бұрын
Great video Nabil. Thanks for sharing. Think i'll have doughnuts for dessert later too. :-)
@abhinavkoranne674
@abhinavkoranne674 5 жыл бұрын
Really helpful! Thank you for the tutorial :)
@daoudandiaye3984
@daoudandiaye3984 2 жыл бұрын
Terrific lecture indeed. Thanks for your generosity!
@StephenBoothUK
@StephenBoothUK 6 жыл бұрын
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.
@alexdominguess
@alexdominguess 6 жыл бұрын
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.
@Officeinstructor
@Officeinstructor 5 жыл бұрын
I used at the time of recording Office 2016... BTW, forward compatibility always works, backward compatibility not guaranteed.
@ehmadwaqar
@ehmadwaqar 4 жыл бұрын
What exactly did you do to solve this problem. I'm facing same problem.
@melvincalve1010
@melvincalve1010 4 жыл бұрын
GENIIIIIIIIIOUSSSS!
@melvincalve1010
@melvincalve1010 4 жыл бұрын
you are so kindness
@pietrosirignano9426
@pietrosirignano9426 4 жыл бұрын
No
@raoulceasar3002
@raoulceasar3002 Жыл бұрын
Good job sir! Straight to the point explanation. Thank you!👍
@emungmanung8513
@emungmanung8513 4 жыл бұрын
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 👍👍👍
@abdelrahmanelhadad8998
@abdelrahmanelhadad8998 4 жыл бұрын
When i click on donut arrow it forces me to chose between the existing ready donut
@AliMadoobe
@AliMadoobe 6 жыл бұрын
جزاك الله Would you please add source file for downloading. The best tutorial for Pivot Table, Progress chart and Dashboard all in one place
@Officeinstructor
@Officeinstructor 6 жыл бұрын
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"
@rayhansardar2214
@rayhansardar2214 5 жыл бұрын
@@Officeinstructor what is the file's name?
@Officeinstructor
@Officeinstructor 5 жыл бұрын
File name: "Progress Doughnut Chart"
@mukundanandan8614
@mukundanandan8614 5 жыл бұрын
I do not understand how do you got some dislikes, its simply cool and easily understandable.. Appreciated..
@ravishete2602
@ravishete2602 3 жыл бұрын
@@mukundanandan8614 Because the file on link has only source, no doughnut chart, may be, the reason!:-)
@vishalgaurav5033
@vishalgaurav5033 4 жыл бұрын
Brilliant Easy to Follow, Step by Step Instructions! Kudos to the Tutor 👏🏼👏🏼
@Officeinstructor
@Officeinstructor 4 жыл бұрын
Thank You Vishal
@denellwilliams2211
@denellwilliams2211 4 жыл бұрын
Excellent tutorial! Thank you.
@christianpaul-cp6746
@christianpaul-cp6746 5 жыл бұрын
Thank you so much for sharing. I'm definitely going to enhance my presentations using these great tips!
@Officeinstructor
@Officeinstructor 5 жыл бұрын
Good for you
@pietrosirignano9426
@pietrosirignano9426 4 жыл бұрын
Bravo
@reezvi394
@reezvi394 5 жыл бұрын
This tutorial is amazing!
@lydiatakacova7755
@lydiatakacova7755 4 жыл бұрын
Fantastic tutorial, this is what I was looking for. Thank you so much!
@Officeinstructor
@Officeinstructor 4 жыл бұрын
You're very welcome!
@ibrahimothman9279
@ibrahimothman9279 4 жыл бұрын
Excellent, this is my first time to see your videos, but I would say the best instructor ever see before, clear and easy to follow step by step, well done Nabil :)
@Officeinstructor
@Officeinstructor 4 жыл бұрын
Thank you Ibrahim
@fwtrader4137
@fwtrader4137 5 жыл бұрын
Great tutorial video. thanks a lot.
@ivymedallo2240
@ivymedallo2240 5 жыл бұрын
Very detailed and informative... I can add this to my project. Thank you so much
@lucyfan2307
@lucyfan2307 5 жыл бұрын
Excellent..well paced and easy to follow
@jenokiv.2017
@jenokiv.2017 4 жыл бұрын
BRAVO SIR!! THANKS TO YOU I LOVE EXCEL NOW!! :-). Thank you so much for that great tutorial!
@Officeinstructor
@Officeinstructor 4 жыл бұрын
I'm glad you liked Excel because of my tutorials
@zein6864
@zein6864 4 жыл бұрын
Congratulations my friend !!!!!
@Godislove_700
@Godislove_700 4 жыл бұрын
I love it, great tutorial!
@okoronkwoebenezer8441
@okoronkwoebenezer8441 3 жыл бұрын
This is exceptionally wonderful. Great Knowledge. Thank you for sharing
@mahadibrahim2586
@mahadibrahim2586 5 жыл бұрын
Very helpful, thank you Nabil.
@qayoumafghan
@qayoumafghan 5 жыл бұрын
Thank you so much for the nice explanation over Pivot Table, Dashboard, Slicer, it is really easy and understandable learning, once again thanks for the service
@Officeinstructor
@Officeinstructor 5 жыл бұрын
Thank you... Glad you liked it
@MrAdmire2011
@MrAdmire2011 4 жыл бұрын
Very clear explanation, and everything step by step...brilliant...congratulations!! Awesome job!
@Officeinstructor
@Officeinstructor 4 жыл бұрын
Thank you very much!
@KashifIqbalSyed
@KashifIqbalSyed 5 жыл бұрын
Thank You very much Nabil, You are awesome. I had been trying to learn the Pivot Tables and Slicers and no was able to teach me cos I am such a thick skull. :) but you 26.28 minutes or video was extremely engaging and clearly defining each and everything that I now understand how to work with Pivot Tables and design the reports my boss has been asking for :) Thanks Very Much, Only Allah can reward you for such a great teaching,
@Officeinstructor
@Officeinstructor 5 жыл бұрын
Thank you Kashif for the nice words. It is a pleasure to be able to help you in learning a topic in Excel
@NL-kx6hq
@NL-kx6hq 4 жыл бұрын
Thank you so much for your help. It would be so helpful if you could teach how to analyse data with many branches and products
@cyruswango7596
@cyruswango7596 3 жыл бұрын
Absolutely fantastic tutorial, thank you very much.
@ghaithsandok3611
@ghaithsandok3611 6 жыл бұрын
WOW !!!!!!!!!!!!! Just AMAZING !
@Luciano_mp
@Luciano_mp 6 жыл бұрын
Sensacional, obrigado.
@maribelortiz9923
@maribelortiz9923 3 жыл бұрын
Thank you so much for sharing your knowledge about this topic. I love to improve my excel skills, specially pivots and charts and this video it's great!
@Officeinstructor
@Officeinstructor 3 жыл бұрын
Glad it was helpful!
@bounadartarik5246
@bounadartarik5246 4 жыл бұрын
Very amazingly done!! Please keep up the great job
@sushmakalote
@sushmakalote 6 жыл бұрын
Excellent Tutorial, Really thanks for this.
@aladinzahran
@aladinzahran 5 жыл бұрын
This was a great valuable education. You have done a fantastic job, and I watched it many time to learn more. You are awesome! Thanks!
@Officeinstructor
@Officeinstructor 5 жыл бұрын
Aladdin... It is for people like you that I spend long hours creating these tutorials. I am glad you liked it
@TheHimalayanDiary
@TheHimalayanDiary 6 жыл бұрын
thank you so much for such a nice explaination..
@Raining76
@Raining76 5 жыл бұрын
Truly awesome. .. thanks much 👍👌
@riyadhzihni3463
@riyadhzihni3463 2 жыл бұрын
Greetings from Indonesia. Really enjoy learning from Your tutorial. The step by step process are well explained and makes it easy to follow. Thank You!
@amstrongp2302
@amstrongp2302 4 жыл бұрын
Wow great work, I never seen such options thank you It’s clear superb
@michaelnwafor6192
@michaelnwafor6192 Жыл бұрын
Brilliant. I followed and it was like a walk in the park.
Make an Interactive Excel Dashboard in 4 Simple Steps!
19:41
Kenji Explains
Рет қаралды 191 М.
Progress Chart With Pivot Table and Slicer
20:09
Excellent Dude
Рет қаралды 18 М.
Red❤️+Green💚=
00:38
ISSEI / いっせい
Рет қаралды 65 МЛН
Вечный ДВИГАТЕЛЬ!⚙️ #shorts
00:27
Гараж 54
Рет қаралды 14 МЛН
50 YouTubers Fight For $1,000,000
41:27
MrBeast
Рет қаралды 138 МЛН
That's how money comes into our family
00:14
Mamasoboliha
Рет қаралды 11 МЛН
Progress Circle Chart Infographics in Excel Dashboard
10:48
TEKNISHA
Рет қаралды 22 М.
How to create a Simple Dashboard Report in Microsoft Excel
18:56
Ajay Anand
Рет қаралды 203 М.
Infographics: Progress Circle Chart in Excel
12:29
PK: An Excel Expert
Рет қаралды 1,1 МЛН
Info-graphics: Group of Circle Charts in Excel
15:55
PK: An Excel Expert
Рет қаралды 125 М.
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
Master Pivot Tables in 10 Minutes (Using Real Examples)
11:33
Kenji Explains
Рет қаралды 411 М.
Looks realistic #tiktok
0:22
Анастасия Тарасова
Рет қаралды 101 МЛН
Qual você NÃO comeria?
0:14
F L U S C O M A N I A
Рет қаралды 36 МЛН
Самая Благодарная Сестра ❤️
0:26
Глеб Рандалайнен
Рет қаралды 2,4 МЛН
Quem vai beber a água horrível?! 😱 #shorts #challenge
0:11
HENRIQUE & GABI
Рет қаралды 3,7 МЛН