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

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

50.803 Lượt nghe
How to Make a Prioritization Matrix in Excel (Colored Quadrants)
✅✅✅ Get this spreadsheet plus 50 MORE ready-made Excel and PowerPoint project templates here: https://www.etsy.com/listing/1199800561/50-project-management-templates-in-excel ⭐️⭐️⭐️ Get 35 Contact Hours / PDUs and 500 PMP Practice Questions in my Udemy course: https://www.udemy.com/course/ultimate-project-management-pmp-35-pdus/?referralCode=304F47999BDAF3A4BEBE ⭐⭐⭐ Or Get 21 PDUs in my complete Agile course: https://www.udemy.com/course/the-greatest-agile-course-ever-pmi-acp/?referralCode=FFEDDD9C64F8DB8605AB ✅✅✅ Or Get my pre-made Project Management PLAN Templates, from SCOPE to PROCUREMENT: https://www.etsy.com/listing/1658006489/the-best-project-management-plan 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