Risk Assessment Matrix in Excel in 15 Minutes!

[@alvinthepmofficial]

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

[@manilla1107]

Thank you men

[@manilla1107]

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

[@alvinthepmofficial]

You're welcome! @@manilla1107

[@RadhaR-y5h]

Thanks for this video

[@alvinthepmofficial]

@@RadhaR-y5h My pleasure

[@purplemma3071]

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

[@alvinthepmofficial]

So glad you found it helpful!

[@badrianoABF]

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

[@alvinthepmofficial]

I'm so glad you found the video helpful!

[@arkamukherjee8412]

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

[@alvinthepmofficial]

So glad you found it helpful!

[@shabnamneeraj2330]

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

[@alvinthepmofficial]

So glad you found the video helpful!

[@karenheidii]

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

[@alvinthepmofficial]

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

[@Rich4live]

Thank you very much for you're effort sir !

[@alvinthepmofficial]

My pleasure!

[@The_Man_From_The_Dog]

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

[@alvinthepmofficial]

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

[@thecryptoguy-je6rh]

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

[@alvinthepmofficial]

So glad I could bring value to you with this video

[@Nagermax]

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

[@alvinthepmofficial]

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

[@sokhaputh2092]

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

[@alvinthepmofficial]

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

[@pallavagarwal5572]

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

[@alvinthepmofficial]

So glad you found it helpful!

[@АлександрАмяльев-ц7з]

Thank you for your help and advice!

[@alvinthepmofficial]

My pleasure, glad I could help out!

[@yarden513]

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?

[@mlo8943]

Lovely!! Very helpful

[@alvinthepmofficial]

Glad you found it helpful!

[@MsMoniqueLG]

Great video. Thank you

[@alvinthepmofficial]

So glad you found it helpful, Monique!

[@MsMoniqueLG]

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

[@alvinthepmofficial]

@@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.

[@govindsharma7738]

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

[@alvinthepmofficial]

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

[@prarthanabharathi4094]

Thank you for the video! Well explained!

[@arthurtouzot58]

Great one

[@alvinthepmofficial]

So glad you enjoyed the video!

[@robamymarkillie5984]

Brilliant, thank you so much

[@alvinthepmofficial]

I'm so glad you found the video helpful!

[@sowjanyajvp447]

Great info, thank you very much!

[@alvinthepmofficial]

Really glad you found the video helpful!

[@shepherddancehallnation]

Excellent Content

[@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]

Thank you ❤

[@alvinthepmofficial]

So glad you found it helpful, Emre Ozer!

[@bryancaron1664]

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

[@shepherddancehallnation]

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

[@aleenamariya2397]

Thank you so much ❤

[@alvinthepmofficial]

My pleasure, Aleena!

[@larsche]

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.)

[@JuanCarlosVillalbaCárdenas]

is file not is full? please download, thanks

[@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.

[@UserHandle0702]

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

[@alvinthepmofficial]

THANK YOU, that means a lot!

[@TheJaebeomPark]

excellent

[@snaveen4218]

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

[@alvinthepmofficial]

@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/

[@riazrahman9678]

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

[@mukuldesai5638]

Hi Alvin can i buy this please

[@TDYoung07]

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.

[@tripledair]

Sheesh, wish I could Like this twice.

[@alvinthepmofficial]

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

[@shadyhamzawy8358]

❤❤❤❤❤

[@alvinthepmofficial]

Glad you found it helpful!

[@aussiegruber86]

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

[@alvinthepmofficial]

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]

@@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]

Your concatenate doesnt work at all, Sir...

[@danny69297]

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

[@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]

@Alvinthepmofficial how would I go about directly contacting you?