Risk Assessment Matrix in Excel in 15 Minutes!

Learn how to create a Risk Assessment Matrix in Excel in 15 minutes! The Risk Assessment Matrix is an incredibly helpful tool to visualize risks on your project to identify the Probability and Impact a risk may have on your project. What are the most severe risks that require your team's focus and mitigation efforts?

Watch until the end of this Risk Assessment Matrix Excel Tutorial to learn: 1) How to create a Master Risk Table in Excel, and 2), How to Create a Risk Assessment Matrix in Excel that automatically updates whenever you update your Risk Register.

------------------------------------------
🔥 RESOURCES I RECOMMEND:
------------------------------------------
Udemy Courses:

Coursera Courses:

🔥 PROJECT MANAGEMENT CERTIFICATION

Please note that some links are affiliate links and I may earn a small commission for any purchase through these links. As an Amazon Associate I earn from qualifying purchases.

// Watch my other Project Management Career Videos:

ATTRIBUTES:

Licensed under Creative Commons: By Attribution 3.0 License

[thecryptoguy-jerh]

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

[purplemma]

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

[arkamukherjee]

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

[badrianoABF]

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

[shabnamneeraj]

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

[sokhaputh]

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

[Richlive]

Thank you very much for you're effort sir !

[shepherddancehallnation]

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

[Nagermax]

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

[prarthanabharathi]

Thank you for the video! Well explained!

[UserHandle]

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

[bibeksodari]

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 ?

[tripledair]

Sheesh, wish I could Like this twice.

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

[govindsharma]

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

[aussiegruber]

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

[danny]

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

[godswillgodswill]

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

[snaveen]

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

[yarden]

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?