How to Make a Prioritization Matrix in Excel (Colored Quadrants)

Рет қаралды 12,672

Күн бұрын

✅✅✅ Get this spreadsheet plus 50 MORE ready-made Excel and PowerPoint project templates here: www.etsy.com/listing/11998005...
⭐️⭐️⭐️ Get 35 Contact Hours / PDUs and 500 PMP Practice Questions in my Udemy course: www.udemy.com/course/ultimate...
⭐⭐⭐ Or Get 21 PDUs in my complete Agile course: www.udemy.com/course/the-grea...
✅✅✅ Or Get my pre-made Project Management PLAN Templates, from SCOPE to PROCUREMENT: www.etsy.com/listing/16580064...
This video shows how to make a prioritization matrix in Excel, with colored quadrants, and separate quadrants using error bars - two great techniques! Learn Excel while you create something great that you can use in your project straight away.
Timestamps:
00:00 Prioritization Matrix overview
00:47 Starting from Scratch
01:55 Making the Priorities Table
03:47 Making the Scatter Diagram
08:23 Creating the Quadrants with Error Bars
11:16 Colored quadrants on the Scatter Chart
13:56 Finished Prioritization Matrix with Colored Quadrants

Пікірлер: 30

@naleenbaddegama2232 10 күн бұрын

This is amazing. Thank you David. I used the same method to map the stages of the product life cycle for number for products.

@kaurmanpreet123 4 ай бұрын

David, your videos and explanations ate so powerful. I watched your waterfall, agile and PMP full length videos for around 10 days regularly and passed my PMP exam last weekend! Thank you so much!!!

@davidmclachlanproject 4 ай бұрын

Well done on passing your exam, that is fantastic news! 🙂🎉

3 ай бұрын

Another fantastic "take me by the hand" video, David. Thank you!

@neocyberphile 4 ай бұрын

Great video on the one of the project manager’s technical skills - prioritizing the features! Thanks David!

@17dario91 4 ай бұрын

Hi David, your videos are amazing and your attitude makes all the difference. Thanks for taking the time and effort to share this publicly with everyone, it really is precious. I will recommend your materials to my collegues. I passed my exam yesterday and your videos played a big role in that. Thanks again, Sir!

@goranstankovic7135 4 ай бұрын

Great work David as usual. Nice to see you back from the Amibroker days, these were my favourite. Happy days!

@davidmclachlanproject 4 ай бұрын

Oh that is awesome, thank you! I really loved the Amibroker days 🙂

@babilaster 4 ай бұрын

Another great video David, so clear and easy to follow. I'm actually going to use this newly created matrix right now! thank you :)

@vinaykumaryadav7804 4 ай бұрын

Thank you very much. I enjoyed following your steps and creating such an amazing matrix.

@VomDia 2 ай бұрын

😄 Rly good! Your voice's so calm that makes my schoolwork feel relaxing 😊

@Dude-etiquette 4 ай бұрын

Love your channel. I’ve learned so much. My favourite was your Microsoft projects in excel

@sepandjazzi 4 ай бұрын

Thank you very much. Extremely insightful

@user-dn5gd1rn9f 4 ай бұрын

This is a great visual. I’ll keep it in my toolbox- thank you!

@sudhasunder794 4 ай бұрын

Thank you so much David!

@edwingrajales_ 2 ай бұрын

Great content, thank you very much!

@gajendra4all 4 ай бұрын

Nice video David.

@user-dx3lm5lb4g Ай бұрын

Very Nice...Thanks for sharing...

@elithurofficial 4 ай бұрын

Awesome! Thank you for helping us new PMs man. \o

@danielmercado1970 4 ай бұрын

8:28 - Hi David. Great video, as always. Just had a quick question - did the chart titles happen to get mixed up? Or am i missing something?

@davidmclachlanproject 4 ай бұрын

You know what - they did! Darn it 😂 It should be benefit on the side and cost down the bottom. Luckily an easy change for those playing along at home 🙂 This gives us Must Haves with low cost and high benefit.

@potlibyyb2757 3 ай бұрын

Just wow

@Foenix12 4 ай бұрын

Great example! Only one thing is not covered. What if two features have the same cost and benefits?

@davidmclachlanproject 4 ай бұрын

Oh great question. In that case we can look at additional, less tangible ways to prioritize, e.g. which one is faster to deliver? Are there any cross-market benefits with other products or departments? Any improved brand awareness? Improved customer reviews? Improved ease of use, or ease of manufacture? Or, the Product Owner or Sponsor may just like one better than another 😁

@shahildays2985 4 ай бұрын

MoSCoW

@one4fitness780 4 ай бұрын

Hi david can you help me plz with this question Which of the following statements about slack time and milestones are true? 1. Slack time represents the amount of time a task may be delayed without delaying the entire project. 2. A milestone is a moment in time that marks the completion of the project's major deliverables. 3. Slack time allows the project manager to move resources from one task to another to ensure that the project is finished on time. 4. A milestone requires resource allocation and needs time to be completed. Option A : 1 and 4 only Option B : 2 and 3 only Option C : 1, 2, and 3 only Option D : 1, 2, 3, and 4

@potlibyyb2757 3 ай бұрын

It is option D I suppose.