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

✅✅✅ 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

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

[@kaurmanpreet123]

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]

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

[@neocyberphile]

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

[@VomDia]

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

[@17dario91]

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]

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

[@davidmclachlanproject]

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

[@babilaster]

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

[@sepandjazzi]

Thank you very much. Extremely insightful

[@Dude-etiquette]

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

[@vinaykumaryadav7804]

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

[@gajendra4all]

Nice video David.

[@sudhasunder794]

Thank you so much David!

[@user-dn5gd1rn9f]

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

[@edwingrajales_]

Great content, thank you very much!

[@elithurofficial]

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

[@potlibyyb2757]

Just wow

[@shahildays2985]

MoSCoW

[@Foenix12]

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

[@davidmclachlanproject]

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 😁

[@danielmercado1970]

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]

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.

[@nickram8402]

Good morning. How do we add the Moscow titles?

[@davidmclachlanproject]

Add those with a text box (insert > text box) 🙂

[@nickram8402]

@@davidmclachlanproject thanks I realized after sending this and never came back to remove lol Thanks for the quick response

[@one4fitness780]

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]

It is option D I suppose.