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

Поділитися
Вставка
  • Опубліковано 19 лис 2024

КОМЕНТАРІ • 44

  •  7 місяців тому +2

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

  • @kaurmanpreet123
    @kaurmanpreet123 8 місяців тому +3

    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
      @davidmclachlanproject  8 місяців тому +1

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

  • @17dario91
    @17dario91 8 місяців тому +1

    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!

  • @neocyberphile
    @neocyberphile 8 місяців тому +1

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

  • @goranstankovic7135
    @goranstankovic7135 8 місяців тому +1

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

    • @davidmclachlanproject
      @davidmclachlanproject  8 місяців тому +1

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

  • @shresthajain7778
    @shresthajain7778 2 місяці тому +2

    One of the best videos I have ever watched on youtube

  • @babilaster
    @babilaster 8 місяців тому +1

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

  • @Dude-etiquette
    @Dude-etiquette 8 місяців тому +1

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

  • @vinaykumaryadav7804
    @vinaykumaryadav7804 8 місяців тому +1

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

  • @sepandjazzi
    @sepandjazzi 8 місяців тому +2

    Thank you very much. Extremely insightful

  • @naleenbaddegama2232
    @naleenbaddegama2232 4 місяці тому +2

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

  • @R.Gohary
    @R.Gohary 9 днів тому

    thank you the video was clear & very helpful

  • @MaureenPesch
    @MaureenPesch 8 місяців тому

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

  • @VomDia
    @VomDia 6 місяців тому +1

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

  • @hananbouzid-q2z
    @hananbouzid-q2z 14 днів тому

    GREAT JOB . WELL DONE

  • @gajendra4all
    @gajendra4all 8 місяців тому +2

    Nice video David.

  • @tesfaye1982
    @tesfaye1982 27 днів тому

    Thanks for preparing this video. I can't find value from cell using xls. But, I got it using xlsx format.

  • @sudhasunder794
    @sudhasunder794 8 місяців тому +1

    Thank you so much David!

  • @pets_talk
    @pets_talk Місяць тому +1

    Thank you so much for the explanation. Quick question - can it be that the axis is confused there? It looks like Benefit should be vertical Y axis and Cost should be X or am I missing something?

  • @rcdixon76
    @rcdixon76 7 днів тому

    Excellent. New subscriber here. Thx amigo!

  • @nickyortiz1
    @nickyortiz1 3 місяці тому +1

    Thanks for sharing, I was able to do it.. very cool.

  • @elithurofficial
    @elithurofficial 8 місяців тому +1

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

  • @JohnMarshall78
    @JohnMarshall78 Місяць тому +1

    GREAT VIDEO! it helps me so F*c*ing MUCH, thank you so much!!!

  • @raniahatem8744
    @raniahatem8744 Місяць тому

    Thank you, this is super helpful. Question please Does the grid has a maximum number of projects/features that it can accept

    • @davidmclachlanproject
      @davidmclachlanproject  Місяць тому +1

      You can increase the table to any size you like, but the chart might get a bit crowded if too many are in there 🙂 Actually, you could increase the chart size too.

  • @edwingrajales_
    @edwingrajales_ 6 місяців тому +1

    Great content, thank you very much!

  • @AnupHarne-h4n
    @AnupHarne-h4n 5 місяців тому +1

    Very Nice...Thanks for sharing...

  • @danielmercado1970
    @danielmercado1970 8 місяців тому +3

    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
      @davidmclachlanproject  8 місяців тому +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.

  • @イロヘロマ
    @イロヘロマ 3 місяці тому +1

    bloody legend

  • @naveen_SDE2
    @naveen_SDE2 2 місяці тому

    Wonderful

  • @Foenix12
    @Foenix12 8 місяців тому +1

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

    • @davidmclachlanproject
      @davidmclachlanproject  8 місяців тому +2

      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 😁

    • @joelknapp9112
      @joelknapp9112 2 місяці тому

      @@davidmclachlanproject from a chart formatting perspective, if 2 features have the same cost and benefits they'll overlap. I'm currently trying to work around this.

    • @kluts4883
      @kluts4883 2 місяці тому

      @@davidmclachlanprojectisn’t it possible to show the feature names below eachother instead of overlapping when they have the same cost and benefit? Thx!

  • @one4fitness780
    @one4fitness780 8 місяців тому

    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
    @potlibyyb2757 7 місяців тому +1

    Just wow

  • @shahildays2985
    @shahildays2985 8 місяців тому +4

    MoSCoW

  • @nickram8402
    @nickram8402 6 місяців тому +1

    Good morning. How do we add the Moscow titles?

    • @davidmclachlanproject
      @davidmclachlanproject  6 місяців тому +2

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

    • @nickram8402
      @nickram8402 6 місяців тому

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