I recently started work as an executive assistant and this video has been a godsend in building my registry spreadsheets. Thank you so much for the formulas and for teaching me things about Excel I had no idea about
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 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
Hi love your suggestion.. do you have any additional template or materials that explains this? I am new to risk assessment and I was wondering if you can share any additional information. Much appreciated..
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
Thank you for this video. On your risk matrix, if you multiply probability "Very Low" by Impact "Very High" that should be Moderate and not Severe. I stand corrected
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?
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.
Hi David, Such great tutorials and so helpful. I am stuck though. I have created a matrix for the first time ever, and it works but i cannot for the life of me get the cell that works to copy down to the others. I have watched the video and followed the instructions but just cannot get it to copy down and it just remains blank. My mind tells me that it is a simple fix but then my mind is simple too . Any assistance would be appreciated, regards
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
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!!!!!!
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.
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
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 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.
@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
Question David: Do you have a method of quantifying or qualifying high/medium/low probability or impact? What I've found conducting risk assessments is that people often don't know whether the probability of an event occurring is high/medium/low, and their definition of high/medium/low impact is very subjective.
Yes, good question! We'd usually tackle this with Risk Definitions, where we outline what the "Impact" and "Likelihood" mean specifically at each level (i.e. a specific cost, or a specific number of occurrences). It will often be different in different projects, teams or industries, so it's a good idea to get together as a team and brainstorm / decide together. Good fun! 🙂
Hi David, this video is excellent, yep, I ended up purchasing the template. How would would I go about changing some of the terminology to match my current risk matrix? using terms Like Likelihood and Consequence, instead of severe-changing it to extreme etc...
Good question. You can reach out to me on Etsy, but in general you can change the terms "Probability" or "Impact" anywhere you like, to anything else you like. For the terms "Very Low / Very High" etc, if you change those words in the table in column X and Y in the One Page sheet, they will change anywhere else in the sheet. For the terms like Moderate, Severe etc, if you change those words in the top risk table (O5 to U10 in the One Page sheet) they will update everywhere else in the sheet too. You would just need to update the conditional formatting to suit that new word.
Hi! Thank you so much for this tutorial! I have a question / request, can you make an example on how to map the hazard/variable into the risk matrix tabel instead of just counting the risk matrix itself?
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
Hi, love this risk matrix but I'm wondering, ISO standards look at Risk & Opportunities, can a column be added to make this a risk/opportunity matrix? If the item is marked as an opportunity then your color/rating would essentially reverse/be opposite?
Hi David, great tutorial. I need little assistance, why my inherent matrix cells colors are getting delete after applying formula and I'm getting the count values too?
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!
That is amazing 🙂 Congratulations on passing your PMP!
I cannot thank you enough for these videos. I passed PMP after Watching your videos and have been a fan ever since. Thank you
I recently started work as an executive assistant and this video has been a godsend in building my registry spreadsheets. Thank you so much for the formulas and for teaching me things about Excel I had no idea about
Thank you so much for all your time David, I prepared by myself after seeing your video, thanks a ton
Thank you so much, David. Your video helps me understand this and get ready for my upcoming assessment.
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.
Big thanks mr.david from saudi arabia 🇸🇦🇸🇦🇸🇦🇸🇦🇸🇦🇸🇦
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
Those are great suggestions! Thank you 🙂
Hi love your suggestion.. do you have any additional template or materials that explains this? I am new to risk assessment and I was wondering if you can share any additional information. Much appreciated..
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
Nicely done and refreshing to see all formulations after a long time. this will be a good guide for developing templates
Amazing job teaching how to effectively make a solid risk matrix. Highly approve.
A very useful template. Thank you, David.
Tried this and it worked perfectly! Thank you. Would help though if you could go through the formulaes at a slower pace though.
Sir, Could you please email me the Excel Sheet...
Greetings from South America....You really helped me a lot, Thanks for everything!!!!
Done it, thank you! I had to battle with US/UK formula syntax differences, it eventually worked!
Hi. What was your challenge with this? I am having some difficulties aswell but am struggling to solve it
@@per469 US commas should be replaced with ; in formulas (ie semicolon)
Great video David, great speaking tone and depth of information.
Very nice. It's cool the visualization of the risk after its control action.
Did this for an assignment for school but am going to start using it for work, thanks!
Thank you for this video. On your risk matrix, if you multiply probability "Very Low" by Impact "Very High" that should be Moderate and not Severe. I stand corrected
I have done so many RA, but loved your video. Thank you David
Thank you, David, for your obvious explanation. The tutorial is handy and easy to implement.
This was a fabulous tutorial. Thank you!
The best risk assessment template I have ever seen, thanks so much
A big thank you David!!!!!!!!!, all the way from South Africa
Thank you for the great video. Very neat quality tool and a lesson in excel at the same time!
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?
amazing job teaching thanks so much please show the inherent risk count formula I cant make please show step by step
Thank you Mr David. its really helpful.
that is SO SO COOL! thank you so much! truly appreciated the step by step guide to build this!
This will help a lot of folks! Great explanation, keep making more and more videos.
Amazing Job David , Great , Really appreaciate your videos
Thank you for the clear, helpful tutorial and instruction on formulas! I will create something great!
Thank u so much, it’s really helpful.. hope u make more videos like this!
Thank you so much David.....What a excellent way to explain . Sweet and Quick !!
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.
Crickey's! This show piece is on high-speed visuals!!
Wonderful teaching and Excel skills to explain risk matrix. Highly appreciated.
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.
amazing effort , wish all the best
A lot of cool tips in this video. Amazing.
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
Thank you very much for the tutorial on setting this up.
Hi David, Such great tutorials and so helpful. I am stuck though. I have created a matrix for the first time ever, and it works but i cannot for the life of me get the cell that works to copy down to the others. I have watched the video and followed the instructions but just cannot get it to copy down and it just remains blank. My mind tells me that it is a simple fix but then my mind is simple too . Any assistance would be appreciated, regards
Excellent spreadsheet, thank you. I was able to replicate it easily.
Thank you so much David. That is well elaborated.
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
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!!!!!!
One of the best tutorial I've ever seen.. Hut off Sir
Great video - Thanks for sharing your risk matrix.
Thank you David you are great teacher
Superb! Lots of Excel lessons learnt from this Risk Matrix Template. Thank you for sharing this, Dave.
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.
9:07
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
Excellent.. very impactful
Thank you so much for the inspiring risk assessment matrix. This has saved us so much time.
Great explanation, thanks!
An excellent video! Thank you David. Are you able to do a version that can be incorporated into MS Power BI? That would be really helpful.
Amazing, so helpful. Subscribed
Thank you very much, appreciated your hardwork,
This was done very quickly!
Thank you for the clear explanation.
Thanks for this excellent model and your inputs were great.
Great stuff David, awesome channel.
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.
شكرا جزيلا ديفيد استفدت كثيرا من هذا الفيديو رئيس قسم السياسة الاحترازية والمخاطر النظامية مصرف ليبيا المركزي
It is my pleasure 🙂
Great video. Was able to develop a similar tool for our company. Thanks
Great application. Is it possible to write the risk IDs into the matrix instead the total number of risks by using the count function?
Thank you so much for such a useful video!
Great job, easy to comprehend and to put in use
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
Incredible video, it helped so much at my work!
Thank you so much🤩🎯
Excellent tutorial!
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.
@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
Thank you, i need this lesson..... nice 💕
Exellent work. 👍
thank you very, this is exactly what I needed
Thank you, man. I love this.
Question David: Do you have a method of quantifying or qualifying high/medium/low probability or impact? What I've found conducting risk assessments is that people often don't know whether the probability of an event occurring is high/medium/low, and their definition of high/medium/low impact is very subjective.
Yes, good question! We'd usually tackle this with Risk Definitions, where we outline what the "Impact" and "Likelihood" mean specifically at each level (i.e. a specific cost, or a specific number of occurrences). It will often be different in different projects, teams or industries, so it's a good idea to get together as a team and brainstorm / decide together. Good fun! 🙂
Hi David, this video is excellent, yep, I ended up purchasing the template. How would would I go about changing some of the terminology to match my current risk matrix? using terms Like Likelihood and Consequence, instead of severe-changing it to extreme etc...
Good question. You can reach out to me on Etsy, but in general you can change the terms "Probability" or "Impact" anywhere you like, to anything else you like.
For the terms "Very Low / Very High" etc, if you change those words in the table in column X and Y in the One Page sheet, they will change anywhere else in the sheet.
For the terms like Moderate, Severe etc, if you change those words in the top risk table (O5 to U10 in the One Page sheet) they will update everywhere else in the sheet too.
You would just need to update the conditional formatting to suit that new word.
Hi! Thank you so much for this tutorial! I have a question / request, can you make an example on how to map the hazard/variable into the risk matrix tabel instead of just counting the risk matrix itself?
Or the formula if your willing. Thanks!
Thanks for this David. How do you get to keep the colour when you copy the risk matrix? Mine just disappears as they are tied to the text.
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
amazing... thanks learned a lot
Hi, love this risk matrix but I'm wondering, ISO standards look at Risk & Opportunities, can a column be added to make this a risk/opportunity matrix? If the item is marked as an opportunity then your color/rating would essentially reverse/be opposite?
Fantastic!! Great content!!!
Great content, I would appreciate if other videos can be done at lower pace
thank you so much David
Hey, I love the sheet but I'm more interested in how you recorded yourself infront of the sheet..if you could share I'd appreciate it.
You are so good!
Good stuff! Thanks for sharing.
Fantastic!
quite helpful thanks a lot David,,
Hi David, thank you for the tutorial! Instead of counting the risk, is there a way to list the ID of an occurrence on the matrix chart?
Hi there, have you worked this out yet as this is what I am trying to do on it?
Hi David, the matrix seems excellent, However the formula is giving me error. I'm using excel 2019. Hope you can help me
Thank. Realy this matrix for risk management
Can you copy and paste the formula here for the inherent risk and residual risk matrix tables and/or post some simple text instructions?
Can this also be done without Excel and without a computer? Can it be done with a pencil, paper, and with or without a calculator?
Hi, can you make a video or creating spread sheet for asset prioritization and criticality
Hi David, great tutorial. I need little assistance, why my inherent matrix cells colors are getting delete after applying formula and I'm getting the count values too?