This is great, with expert formatting advice. David is the Bob Ross of EXCEL!
@tubethis777
2 жыл бұрын
A very complex explanation for a simple concept and very focused on formatting, it's great if we want to learn two things at once; it would have been nice to get real life data example rather than options, thanks
@davidmclachlanproject
2 жыл бұрын
Thank you for the feedback! Hoping the chapters helped to skip to the part a person wanted to hear. For the real examples: pretend the "data" column is called "Defects", and the "Options" column is called "Names", or even "Systems". Then we can see how many defects are coming out of which system, or are created by a certain person - just one example.
@tubethis777
2 жыл бұрын
@@davidmclachlanproject thanks David, I'll try again as you suggest. At the end I just wanted to see how the conclusion was defined by applying the 80/20 rule so I can use it as guide in real life scenarios. Thanks again.
@jasonhunter7143
Жыл бұрын
To say you are the best is an understatement
@JacquiQUINLAN-p1o
9 ай бұрын
I keep getting lost on the part where if I want to select all the data vs copy and paste from chart to chart. I realize you jump for a reason, but that is the MOST important aspect to me. Do you have an updated video with this explanation?
@cristianlopezmusic
8 ай бұрын
Agreed. It was a bit too fast and maybe a bit more explanation would help.
@kevindurham8980
Жыл бұрын
I really appreciate the way you described the entire process. I eventually utilized the Pareto Chart template I obtained from Someka and it turned out great. Thank you for sharing the video.
@JESUSISMYEVERYTHING2
2 жыл бұрын
Too fast teaching for beginners should've made it bit slow so beginners can follow along while they practically make
@MarcosAlvarezGuzman
5 ай бұрын
Fast, Efficient, excellent.
@bckzilla
2 жыл бұрын
Currently I don't really need a Pareto chart, but this is such a great explanation of how to create one, when ever I need it. Thanks a lot.
@ronaldnatalia1724
Жыл бұрын
Hi David good day to you. Thank you for this training. I finally found a learning channel for excel that what I need.
@abdelrahmankasm3798
2 жыл бұрын
Really amazing video with senior experience in Excel.... thanks a lot
@Omar-kk5jp
10 ай бұрын
man you are awesome I just done it for my assignment,, thanks a lot
@HuaxingCao
8 күн бұрын
讲解的很专业
@sheldon9623
Жыл бұрын
He's like the Bob Ross of Excel
@GianYawnYT
Жыл бұрын
bro what happen at 9:15
@josephusman3998
Жыл бұрын
Exactly!
@andrewwooddell3874
Жыл бұрын
Great video. You like spreadsheets the way I do, I really missed my calling
@arpandoshi9878
2 жыл бұрын
Excellent explanation 🙏.
@elizabete6327
10 ай бұрын
Thank You for Your help !!!
@StopWhining491
Жыл бұрын
Looks like a combo chart, which Excel includes in its chart choices.
@maureencharagu8279
Жыл бұрын
well explained. thanks
@shrikantbadge3978
5 ай бұрын
Very helpful
@katg1264
8 ай бұрын
What does the 70% mean?
@LouG77
Жыл бұрын
why not use the pareto chart in excel?
@jlopez327
5 ай бұрын
David, question for you sorry if you covered this in your video and I missed it - on the gant chart when tasks are completed am I to adjust the start and end date to reflect the true time it took to complete vs the planned time?
@emmanuelbasam1381
Жыл бұрын
Awesome @David! Is it possible to make some tutorials on CPI, SPI and other Project Management key Metrics? Thanks
@wwillis2220
Жыл бұрын
David I’m looking for a Pareto chart for Inventory Coordinator do you feel you template will help?
@shabanafzal9440
Жыл бұрын
Nicely explained
@bsharmomani3871
9 ай бұрын
Thank you
@MT-vc2jg
Ай бұрын
Impossible to follow the part where he 'Formats as a Table' The cursor is COMPLETLEY invisible, too fast, cant recreate how he gets that second smaller 'Format as a table' pop up box. VERY frustrating, had to go to use another KZitem vid for this. Maybe its just me.
@DingoSlinger
8 ай бұрын
When formatting as a table I do not get the pop-up box the say my table has headers so I never get the sorting options any help?
@jeellescas7938
2 жыл бұрын
Hello great video! I just wanted to ask what is a pareto line? And what does it signify?
@davidmclachlanproject
2 жыл бұрын
Ah, the Pareto line represents the Pareto principle, where 80% of our opportunities come from 20% of the inputs. Once the cumulative percentage line goes over the Pareto line, all the opportunities to the left of it (the bars) are the 80% majority.
@harveynguyen6789
2 жыл бұрын
Very good
@jacquelinepug5546
2 жыл бұрын
When I try to paste the line onto the original chart the whole chart just disintegrates into a straight line! I tried doing it with both data point on the original chart but then I can not find a way to format the one set of date into a line. Please help :)
@davidmclachlanproject
2 жыл бұрын
Oh no! Does selecting one of the lines and putting it on a different axis help? Otherwise, you could select all three columns of data at once (hold CTRL and drag each column, "Data", "Cumulative" and "Line" to select), create a line chart, and then select the cumulative line, right click and format axis, then select secondary axis. The Pareto line goes on the secondary axis also. Hoping this helps!
@corazonignacio3894
2 жыл бұрын
Do you have video for Vendor Delivery Performance in a Pareto chart
@Iam-yv7fq
5 ай бұрын
can someone explain the pareto line being 70%? why 70%?
@davidmclachlanproject
5 ай бұрын
Ah - there is no specific reason. Many people will use 80%. Sometimes I find that 80% is too much. The main idea is that a large amount of outcomes will come from a few inputs 🙂
@Pepperlizing18
Жыл бұрын
How do I arrange it from the highest to the lowest
@StopWhining491
Жыл бұрын
Sort the values
@steveowen5143
9 ай бұрын
Too fast for me dude. But a nice looking template.
@20appel
Жыл бұрын
Option 4 should be 98% not 99% ???
@cyberdyers
Жыл бұрын
great, but i got lost @ 20% of the video, if you could explain this a little bit slower.
@Chaosonthegame
8 ай бұрын
fire your editor for skipping at 9:15, you started with the bar upside down and ended with it on the right side after the cut
@kudratmallik4398
2 жыл бұрын
Too Fast !!
@lizfidel
Жыл бұрын
SO many aesthetics made you forget a HOW TO KZitem VIdeo is basically about how stuff is DONE! difficult for a person to even follow
@GianYawnYT
Жыл бұрын
too fast discussion
@josephusman3998
Жыл бұрын
Terrible explanation. Started well but decided to change focus. Why did you decide to lose traction. Should have continued on building the chart individually
Пікірлер: 52