How to Make a Risk Assessment Matrix in Excel
444,958
Published 2022-03-11
👍 Ready made and ready to use.
How to make a Risk Assessment Matrix in Excel.
Fill out this Risk Assessment and it will show you how many risks you have in each category - Sustainable, Moderate, Severe or Critical, before and after your controls. Perfect for your next project!
Timestamps:
00:00 Risk Assessment Overview
03:12 General sheet colours and headings
04:38 Making the risk matrix
07:07 Risk drop down lists
08:16 Automatic risk ratings
10:15 Colouring the risk ratings
11:43 Counting the risks in the risk matrix
15:30 Finished Risk Assessment
#ProjectManagement #Excel #Risk
All the Project Template videos in Excel and PowerPoint: • How to Create Excel and PowerPoint Te...
All Comments (21)
-
Thank you, David! I just passed my PMP exam today in my first attempt. I just watched your entire PMP playlist. No other course taken!
-
Thank you, this was a very helpful video. It was well paced for an advanced Excel user and the model is overall simple to understand and use.
-
Amazing job teaching how to effectively make a solid risk matrix. Highly approve.
-
Thank you for the class on Risk Register. I found it quite resourceful. I would appreciate a copy of the Template with the example demonstration. The Impact would be very useful to me as well.
-
Thank you so much for all your time David, I prepared by myself after seeing your video, thanks a ton
-
I've just noticed your channel and I really like the content. I'm currently writing on my master thesis and your videos about SIPOC and Swim-Lane helped me a lot! I'm really interested into lean-management and related methods and concepts.
-
This is one of the best tutorials I’ve seen! Thank you so much. Helped not only at work but with my Masters Thesis! Thank you
-
Thank you so much David! I love it. I had so much fun doing my matrices following your video. I subscribed to your channel around a year ago and sometimes I wonder why I am still a subscriber and then when I need it, I remember. I used to have a version of risk matrice but this one is much better! Thanks again for sharing such valuable content.
-
Big thanks mr.david from saudi arabia 🇸🇦🇸🇦🇸🇦🇸🇦🇸🇦🇸🇦
-
Did this for an assignment for school but am going to start using it for work, thanks!
-
Thank you David, it helps me alot. It is very clear explanation, please share another risk models for the enviromental subject as now I am aiming the master degree in enviromental Study.
-
You talk about Risk Matrix's like Steve Erwin talked about animals. Thank You, great content as always. #riskmatrix #pmbok #pmp #capm #projects #riskmanagement #enjoylife
-
Great tutorial! I am yearning to know how you created the Risk Matrix with all the different colors for Sustainable, Moderate, Severe, and Critical. Also, you promised to demonstrate how to move form Low, Medium, High and use numerals or figures. Can someone help me especially with how to create the colors in the Risk Matrix and link them with the Risk Assessment table's inherent and residual risks. Thanks
-
I have done so many RA, but loved your video. Thank you David
-
The best risk assessment template I have ever seen, thanks so much
-
Thank you so much for the inspiring risk assessment matrix. This has saved us so much time.
-
Nicely done. Good for one person entering data as they will have a consistent view of what 'Low' etc means. Be aware, this is not a tool or technique for a sizeable business because you cannot arrive at a total measure of risk, only count how many risks of each colour. 2 yellows might equal an orange - or not, 2 oranges equal a red - or not.
-
Very nice. It's cool the visualization of the risk after its control action.
-
Thank you for the clear, helpful tutorial and instruction on formulas! I will create something great!
-
Excellent spreadsheet, thank you. I was able to replicate it easily.