How to Make a Risk Assessment Matrix in Excel 

Thank you, David, for your obvious explanation. The tutorial is handy and easy to implement.

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.

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!

Amazing job teaching how to effectively make a solid risk matrix. Highly approve.

Thank you so much for all your time David, I prepared by myself after seeing your video, thanks a ton

Great job, easy to comprehend and to put in use

Great stuff David, awesome channel.

Very nice. It's cool the visualization of the risk after its control action.

A big thank you David!!!!!!!!!, all the way from South Africa

Thank you very much for the tutorial on setting this up.

The best risk assessment template I have ever seen, thanks so much

Thanks for this excellent model and your inputs were great.

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

Big thanks mr.david from saudi arabia 🇸🇦🇸🇦🇸🇦🇸🇦🇸🇦🇸🇦

Excellent spreadsheet, thank you. I was able to replicate it easily.

Thank you for the clear explanation.

Wonderful teaching and Excel skills to explain risk matrix. Highly appreciated.

This will help a lot of folks! Great explanation, keep making more and more videos.

A very useful template. Thank you, David.

Thank you so much for the inspiring risk assessment matrix. This has saved us so much time.

Incredible video, it helped so much at my work! Thank you so much🤩🎯

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.

Thank you so much, David. Your video helps me understand this and get ready for my upcoming assessment.

Thank you so much David.....What a excellent way to explain . Sweet and Quick !!

Thank you for the clear, helpful tutorial and instruction on formulas! I will create something great!

Thank you David you are great teacher

I have done so many RA, but loved your video. Thank you David

Greetings from South America....You really helped me a lot, Thanks for everything!!!!

Excellent tutorial!

good one

Good stuff! Thanks for sharing.

Thank you, man. I love this.

Thank you so much for such a useful video!

A lot of cool tips in this video. Amazing.

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.

Fantastic!! Great content!!!

Great explanation, thanks!

WOW this is amazing thank you!

quite helpful thanks a lot David,,

Excellent.. very impactful

Great video - Thanks for sharing your risk matrix.

This was done very quickly!

Great video. Was able to develop a similar tool for our company. Thanks

Very well formulated !

Did this for an assignment for school but am going to start using it for work, thanks!

that is SO SO COOL! thank you so much! truly appreciated the step by step guide to build this!

thank you very, this is exactly what I needed

Thank you very much, appreciated your hardwork,

This is absolutely one of the best videos. Clear explanations with the spreadsheet. I will use this in my projects. 👍👍

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 u so much, it’s really helpful.. hope u make more videos like this!

amazing effort , wish all the best

Amazing, so helpful. Subscribed

amazing... thanks learned a lot

Very good, thanks

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

thank you so much David

Fantastic!

Thank you, i need this lesson..... nice 💕

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 are so good!

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.

Thanks for sharing.

Very helpful

Helping. Thanks 🙏

Done it, thank you! I had to battle with US/UK formula syntax differences, it eventually worked!

Wow! that's cool !

I cannot thank you enough for these videos. I passed PMP after Watching your videos and have been a fan ever since. Thank you

You are the best

Awesome!!!

Thanks alot

Thanks David. In the Governance, Risk Management and Compliance (GRC) Risk Assessments, we use a similar kind of Risk Matrix to perform Inherent and Residual Risk Assessments. One improvement that may be added to your Excel template is the addition of "Key Risk Indicators (KRIs) and Risk Root Cause Analysis (RRCA) columns so that one may clearly understand the risk and control mapping, Risk Generating parameters, and Root Cause that made a particular risk as of High, Medium or Low Significance. Consultants and Risk & Compliance professionals need these additions because they have to go deep into the risk assessment process for relevant risk mitigation plans and decisions. These were just few of my suggestions for the Template enhancement, based on my experience. Thank you

thank you !

Tried this and it worked perfectly! Thank you. Would help though if you could go through the formulaes at a slower pace though.

Very good

amazing job teaching thanks so much please show the inherent risk count formula I cant make please show step by step

Thank. Realy this matrix for risk management

thank you thank you thank you

Nice 👍

Superb! Lots of Excel lessons learnt from this Risk Matrix Template. Thank you for sharing this, Dave.

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

Bravo !

Saved my ass. got a sub from me. Had to fix one of my clients risk registers. Thanks David!

One of the best tutorial I've ever seen.. Hut off Sir

nice!

Nice

David, thank you much for this risk mitigation chart. It's brilliant! Question: What's the easiest way to add rows to risks without upsetting the tables on the right?

Great application. Is it possible to write the risk IDs into the matrix instead the total number of risks by using the count function?

Impactful and understandable, will be Super cool if you provide that here :P

شكرا جزيلا ديفيد استفدت كثيرا من هذا الفيديو رئيس قسم السياسة الاحترازية والمخاطر النظامية مصرف ليبيا المركزي

Great content, I would appreciate if other videos can be done at lower pace

@David McLachlan Fantastic tutorial. Works a treat, THANKS! Question : in Risk Count table, how to adjust formula so only counting OPEN status Risks (not Closed status)? Thanks

Educative and relevant video, but try to explain the detailed process you use to insert all the data in excel please. I find it quite challenging

Very nice looking but to make it more useful I would like to know how to add additional rows and for these additional rows to be automatically included in the count analysis. Also maybe to automatically sort them according to the risk as you go along.

Mr.David, this video is very useful and effective.Thank you for teaching us on this. I have one observation, when selecting Low in probablity and low in impact , the risk rating field is becoming blank. please guide me on this to correct it

Great video, thank for putting this out there. Quick question, regarding the counter formulas on the matrix, Mine is not counting its coming up with zeros (0) how can I fix this? thanks again

Great template, could you consider doing a video on AI incorporation as PM tools?

Cool, finally I managed to write all formulas!!! But it was hard...for my level you are too quick 😞 If I can suggest, to dummies like me (😋😋), consider that these formulas work if your computer is set in English!! I had to translate it all in italian😜😜 Thank you!!!!!!

It's a great one. But what's the shortcut in deleting the contents but not colors of the duplicate matrix?

IF you want something done right, do it yourself!