Risk Assessment Matrix in Excel in 15 Minutes!

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

КОМЕНТАРІ • 76

  • @alvinthepmofficial
    @alvinthepmofficial  Рік тому +7

    ►► Download the FREE Risk Register Exercise File: → www.alvinthepm.com/risklog/

    • @manilla1107
      @manilla1107 10 місяців тому

      Thank you men

    • @manilla1107
      @manilla1107 10 місяців тому +1

      من الجزائر شكرا لكم من اعماق قلبي ❤❤❤❤

    • @alvinthepmofficial
      @alvinthepmofficial  10 місяців тому

      You're welcome! @@manilla1107

    • @RadhaR-y5h
      @RadhaR-y5h 3 місяці тому +1

      Thanks for this video

    • @alvinthepmofficial
      @alvinthepmofficial  3 місяці тому

      @@RadhaR-y5h My pleasure

  • @pallavagarwal5572
    @pallavagarwal5572 8 днів тому +1

    Thanks a lot for this informative video.. It was very helpful..

  • @purplemma3071
    @purplemma3071 7 місяців тому +1

    Great video, thanks! Carefully breaks down each step to a level total Excel newbies (me!) can follow, and everything worked exactly as described :)

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

    thank you.. this was very useful, especially compared to alot of other videos on the tube.. cheers

  • @MsMoniqueLG
    @MsMoniqueLG 16 днів тому +1

    Great video. Thank you

    • @alvinthepmofficial
      @alvinthepmofficial  16 днів тому +1

      So glad you found it helpful, Monique!

    • @MsMoniqueLG
      @MsMoniqueLG 16 днів тому +1

      @@alvinthepmofficial Is a Risk assessment and Risk Form the same thing? Do you have a video for creating a risk form?

    • @alvinthepmofficial
      @alvinthepmofficial  16 днів тому +1

      @@MsMoniqueLG If you mean a Risk Assessment Form, then yes they would be the same thing. It may depend though on your organization and what specifically they're looking for.

  • @thecryptoguy-je6rh
    @thecryptoguy-je6rh 3 місяці тому

    With this one video, you just changed how we operate. Thank you.

  • @Rich4live
    @Rich4live 7 місяців тому +1

    Thank you very much for you're effort sir !

  • @shabnamneeraj2330
    @shabnamneeraj2330 Рік тому +1

    thankyou sooo much,, very helpful video... I created a risk matrix for a business plan using this video. It came out very well.. thankyou

  • @arkamukherjee8412
    @arkamukherjee8412 10 місяців тому +1

    This video was so much helpful in preparing for case interview. Thank you very much for such amazing content.

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

    Your video was absolutely amazing! Very clear and incredibly helpful! You’ve gained a new subscriber 😊

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

      Karen, thank you so much and so glad you found the video helpful! Glad to have you as a new subscriber :)

  • @The_Man_From_The_Dog
    @The_Man_From_The_Dog Рік тому +2

    Hello, thank you so much for your video! It was very interesting, and I repeated this matrix in Excel. It looks pretty cool 👍

    • @alvinthepmofficial
      @alvinthepmofficial  Рік тому +2

      So glad you found it helpful! Feel free to share it with anyone else you know who might find it helpful!

  • @АлександрАмяльев-ц7з
    @АлександрАмяльев-ц7з 10 місяців тому +1

    Thank you for your help and advice!

  • @sokhaputh2092
    @sokhaputh2092 Рік тому +1

    Thanks a lot, Alvin, for your Excel Risk Assessment, it very useful. 🙏

    • @alvinthepmofficial
      @alvinthepmofficial  Рік тому +2

      THANK YOU for the positive and encouraging words, it truly means a lot!

  • @yarden513
    @yarden513 3 місяці тому

    This is great. Thank you! When plotting on the graph, the points are relative to each other and only extend the x,y axis as far as the highest value in the Risk Log. For example, when plotting only one risk with an impact of 1 and a probability of 1, you get a Score of 1 (very low risk). However, the graph will show it in the upper right corner of the graph (visually making it look very high) as the x and y axes only go from 0 to 1.2. What do you suggest would be the solution for this?

  • @Nagermax
    @Nagermax 10 місяців тому +1

    Amazing, thank you! Are you going to make a video showing how to create a risk burndown chart?

    • @alvinthepmofficial
      @alvinthepmofficial  10 місяців тому +1

      Glad you found it helpful, I"ll add that to my list of future videos to create 👍

  • @mlo8943
    @mlo8943 9 місяців тому +1

    Lovely!! Very helpful

  • @JuanCarlosVillalbaCárdenas
    @JuanCarlosVillalbaCárdenas 22 дні тому

    is file not is full? please download, thanks

  • @sowjanyajvp447
    @sowjanyajvp447 4 місяці тому

    Great info, thank you very much!

  • @bryancaron1664
    @bryancaron1664 5 місяців тому

    Great video, although I would like to know how to create the LEGEND please?

  • @robamymarkillie5984
    @robamymarkillie5984 Рік тому +1

    Brilliant, thank you so much

  • @shepherddancehallnation
    @shepherddancehallnation Рік тому +5

    The legend came outta nowhere? How do I create that?

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

    How do you know if one threat row entry is a low medium or high probability? How did you create that logic?

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

      You have to discuss the impact and severity of a risk based on your discussions with your team.

  • @prarthanabharathi4094
    @prarthanabharathi4094 Рік тому

    Thank you for the video! Well explained!

  • @shepherddancehallnation
    @shepherddancehallnation Рік тому +1

    Excellent Content

  • @bibeksodari3200
    @bibeksodari3200 Рік тому

    Thank you !! It was a very informative video. But , As I was using Microsoft Excel Version 2007 , it didn't find the option - "value from cell" . How can I overcome this problem ?

  • @emreozer4400
    @emreozer4400 Рік тому +2

    Thank you ❤

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

    Sir 4 points are not showing in risk matrix graph .tell us the solution?

  • @larsche
    @larsche 11 місяців тому

    Thanks for the video. I like it. I keep getting an error message when I try to link the axis titles to the impact and probability cells. What am I not seeing here? Any idea? This is what it looks like in the formula bar: =RiskLog[[#Headers];[Impact (I)]]
    By the way, the semicolon is used in Norway, instead of the comma (no idea why). The error message is generic (are all parentheses in place, are you sure it's a formula and not something else, etc.)

  • @aleenamariya2397
    @aleenamariya2397 7 місяців тому

    Thank you so much ❤

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

    excellent

  • @UserHandle0702
    @UserHandle0702 4 місяці тому

    Your content is very good 3 video from you today all likes

  • @mukuldesai5638
    @mukuldesai5638 Рік тому

    Hi Alvin can i buy this please

  • @tripledair
    @tripledair Рік тому +1

    Sheesh, wish I could Like this twice.

    • @alvinthepmofficial
      @alvinthepmofficial  Рік тому +1

      THANK YOU for your kind words, and I'm so glad you found it helpful!

  • @snaveen4218
    @snaveen4218 Рік тому +2

    Hi alvin. Myself Naveen. I am from India. I cannot able to purchase your exam simulator. Is there any other way like PayPal?

    • @alvinthepmofficial
      @alvinthepmofficial  Рік тому +2

      @Naveen, great to hear from you! Feel free to send me a message with this link so I can help you get access to the simulator you need: www.alvinthepm.com/contact/

  • @onsongoisaiah1130
    @onsongoisaiah1130 Рік тому

    You did well but the set up of the chart colour on the gradient scale is not random but would be based on the cumulative rink rating.

  • @TDYoung07
    @TDYoung07 7 місяців тому

    You dont know how long ive been searching for a decent 5x5 for my RIO board. Any way i can make it NOT a gradient. My customer isnt fond of it.

  • @shadyhamzawy8358
    @shadyhamzawy8358 11 місяців тому +1

    ❤❤❤❤❤

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

    Don’t bother downloading the template from the website it doesn’t have the graphs.

    • @alvinthepmofficial
      @alvinthepmofficial  7 місяців тому +1

      Sorry to hear you didn't gain value out of this, my website explicitly states that it's a Risk Register Template. Also, to set expectations, my video walks you through step-by-step with how to create the Risk Assessment Matrix using the data in the Risk Register File, which is completely FREE.

    • @aussiegruber86
      @aussiegruber86 7 місяців тому

      @@alvinthepmofficial which is fine it’s your spreadsheet, but what happens with the name and email address we had to hand over to realise it was basically an empty spreadsheet.

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

    Your concatenate doesnt work at all, Sir...

  • @danny69297
    @danny69297 Рік тому

    Worths mentioning that this approach won't work in web excel - both microsoft and google

  • @godswillgodswill5973
    @godswillgodswill5973 Рік тому

    Your vedios are good but, you are doing things without explaining, we don't know the Microsoft you are using, we you don't mention how you highlight from top to bottom.
    In summary, you are only addressing certain people, nothing basic, for me it's a 1 out of 5

  • @IdaliaPerez-ud5pf
    @IdaliaPerez-ud5pf 10 місяців тому

    @Alvinthepmofficial how would I go about directly contacting you?