Respected sir your video osm but speak slowly plz.
@lutzkonig7987
2 жыл бұрын
Great application. Is it possible to write the risk IDs into the matrix instead the total number of risks by using the count function?
@dvicmel
Жыл бұрын
Hi David, the matrix seems excellent, However the formula is giving me error. I'm using excel 2019. Hope you can help me
@georgeaggreyosodo5087
2 жыл бұрын
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
@actorashwani
Жыл бұрын
Send it to Shark tank India Judges. They would need this after investing in so many companies.😂
@kalehiwotnardos3803
Жыл бұрын
amazing job teaching thanks so much please show the inherent risk count formula I cant make please show step by step
@davidsoto4394
Жыл бұрын
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?
@norhainimohamad6288
Ай бұрын
Thank you so much. help me to close NCR for ISO17025 🙂
@firstallll
Жыл бұрын
Why don't you kindly give us this spreadsheet ready made
@aparisg9734
Жыл бұрын
Totaly agreed this Sheet must be shared by master Dave
@pickleman01
Жыл бұрын
@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
@governanceriskcompliancegr9963
Жыл бұрын
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
@davidmclachlanproject
Жыл бұрын
Those are great suggestions! Thank you 🙂
@pabloandrade339
Жыл бұрын
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..
@michaeljcalleja
2 жыл бұрын
Tried this and it worked perfectly! Thank you. Would help though if you could go through the formulaes at a slower pace though.
@zatifkhan2120
Жыл бұрын
Sir, Could you please email me the Excel Sheet...
@connormaguire
Жыл бұрын
@@zatifkhan2120 did he email you the sheet? could i have a copy too haha
@princeofheroes7218
2 жыл бұрын
IF you want something done right, do it yourself!
@terri.yeah.
2 жыл бұрын
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!!!!!!
@RahulSharma-pt6up
Жыл бұрын
Thank you so much for all your time David, I prepared by myself after seeing your video, thanks a ton
@moeie
6 ай бұрын
Hello! I would love to just buy this template alone. Is that possible?
@sivarammallela1177
Жыл бұрын
Impactful and understandable, will be Super cool if you provide that here :P
@annesummers2522
Жыл бұрын
I was with you all the way up to the automatic risk ratings. It wasn't shown how you got to where you got with index and match :(
@alexismargiolis4170
2 жыл бұрын
The formula in the risk rating does not copy down to the rest as the values change, how can I get some of them to stay the same but just copy the formula down without manually changing the value (the values I would of thought should stay the same not change)
@moorkothhithin
4 ай бұрын
@davidmclachlanproject - how can I do a risk assessment matrix if there are more cells such as Probability, Cost Impact, Schedule Impact, and Reputational Impact. Which formula works to compare all these cells to provide an output in the Risk Score cell. Please advise. Thank you.
@rachelnarepua9050
25 күн бұрын
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.
@reshmikunnath912
Жыл бұрын
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!
@davidmclachlanproject
Жыл бұрын
That is amazing 🙂 Congratulations on passing your PMP!
@peacenformi5763
2 жыл бұрын
Hi pls help I have a 5th round interview with the Senior Director and l don't know what to expect from this interview. It's a 45 mins interview and l don't know what to prepare for. I am new to Scrum. Thanks
@Onemust1magine
2 жыл бұрын
Its disappointing I can't buy just this template, it only offers a $50 pack of 50+ other templates which is a great deal but a waste for me. I was looking to just use this one since its very well made.
@stephenfoster9009
Жыл бұрын
You could build in in Excel
@dbr64
Жыл бұрын
Hey. Where can you buy these excel spreadsheets? Thanks.
@romeoperida2498
Жыл бұрын
@@stephenfoster9009⁹90⁰9 L
@abhishekvishakha
Жыл бұрын
Hey, let me know I can build this exact sheet and provide to you in 50$ ??
@databuild-f1n
11 күн бұрын
Great video David, great speaking tone and depth of information.
@dougbeaver3757
8 ай бұрын
Having trouble with some formulas. Can't find the excel template. Any assistance is appreciated.
@robertomollo7827
10 ай бұрын
I really appreciate Sir but requires quite sometime to understand better
@themotobanditshow
2 жыл бұрын
Saved my ass. got a sub from me. Had to fix one of my clients risk registers. Thanks David!
@davidortega3393
10 ай бұрын
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.
@davidmclachlanproject
10 ай бұрын
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! 🙂
@jonathanpollock7279
2 жыл бұрын
I cannot get the Index and Match function to work at all. Any tips?
@yungpants538
2 жыл бұрын
=INDEX(Q$6:U$10;MATCH(F6;P$6:P$10;0);MATCH(G6;Q$5:U$5;0)) -> that would be the code. In his example it worked with commas "," but in my and your case it should work with semicolon ";". Hopefully I was a bit of a help :) Have a nice day
@alm3rof674
2 жыл бұрын
@@yungpants538 Do you know why the matrix stays at 0? it's not adding up
@nazzartareev
6 ай бұрын
@@yungpants538 you're a lifesaver!
@DP-1868
8 ай бұрын
Hi David. Can I buy this for step by step instructions to follow? I am a bit slow and would appreciate creating this for myself. How can I contact you?
@charityvugutsa8235
Ай бұрын
Thank you so much David. That is well elaborated.
@samontaos2
2 жыл бұрын
Great video. Was able to develop a similar tool for our company. Thanks
@rifqifazriansyah6795
Жыл бұрын
Thank u so much, it’s really helpful.. hope u make more videos like this!
@josephking6913
28 күн бұрын
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.
@nsanch0181
2 ай бұрын
Thank you for the great video. Very neat quality tool and a lesson in excel at the same time!
@timmyhiggins5220
6 ай бұрын
The problem here is when you expand the rows in the risk log, you will automatically expand the risk matrix making it look awful
@محمدعلي-ب3س8خ
Жыл бұрын
شكرا جزيلا ديفيد استفدت كثيرا من هذا الفيديو رئيس قسم السياسة الاحترازية والمخاطر النظامية مصرف ليبيا المركزي
@davidmclachlanproject
Жыл бұрын
It is my pleasure 🙂
@bangalorenokia
Ай бұрын
Amazing Job David , Great , Really appreaciate your videos
@PreciousNwokoma-hh4mj
5 ай бұрын
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.
@TheAbdominalSnowman
9 ай бұрын
I can't get the formula to work, and I have set it up cell for cell and bit by bit in the formula. does anyone know why it won't work for me?
@IhwanulIman
3 ай бұрын
Thank you, David, for your obvious explanation. The tutorial is handy and easy to implement.
@nurzhasabdikenov
7 ай бұрын
Matrix is wrong. Hello from Astana IT University students
@manuelmejia2730
Жыл бұрын
Greetings from South America....You really helped me a lot, Thanks for everything!!!!
@OmbeniUwingeneye
6 ай бұрын
Thank you so much, David. Your video helps me understand this and get ready for my upcoming assessment.
@mohamedhersi2366
Жыл бұрын
Thank. Realy this matrix for risk management
@jadeforman1878
2 жыл бұрын
Excellent spreadsheet, thank you. I was able to replicate it easily.
@Akashnipillayweimers
2 жыл бұрын
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.
@syedghouri3441
Жыл бұрын
Thank you very much, appreciated your hardwork,
@vendelaakuasika3614
2 ай бұрын
How did you got to the point of filling inn the sustainable, moderate and the rest, i don't understand how you got to that point, was it copied from the sheet orr where exactly did that bit got into the sheet?
@ubyn
Ай бұрын
Hi David, can you add a download link for the complete excel sheet ?
@Mosesshumbusho
6 ай бұрын
A very useful template. Thank you, David.
@jamuth5111
2 ай бұрын
I could not get the Countifs function to count the cells properly I spent like 2 hours trying to trouble shoot not sure what the problem is
@gabrielatroncoso9846
6 ай бұрын
how to solve the spill issue in the formula in the residual risk? I have tried to unmerged the cells and still not working
@supriaingole4811
3 ай бұрын
For some reasons, the formula for risk rating does not work for me. Can anyone help please?
@MickaelDuval-ml4do
8 ай бұрын
Dear David McLachlan, I am contacting you because I bought your PAC but I would like to know if it is possible to add in the inherent Risk Matrix (before control) and if I can double or triple this parameter to have it all in one? I want to put, Inherent Risk - Safety, Inherent Risk - Cost, Inherent Risk - Time. Thank you in advance and I love your explanation please keep going!
@betran2657
2 жыл бұрын
Thank you very much for the tutorial on setting this up.
@emmanuelbasam1381
Жыл бұрын
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
@MarinaKozul-l3c
Жыл бұрын
I have tried the formula =INDEX(Y$6:AC$10,MATCH(G4,X$6:X$10,0),MATCH(H4,Y$5:AC$5,0)) Its not working for me... any ideas what I have done wrong?
@jugokadi8394
2 ай бұрын
Very interesting, but why the video quality is so poor?
@jacksonmagriplis6617
2 жыл бұрын
Great stuff David, awesome channel.
@nisarasadi9379
Жыл бұрын
Excellent.. very impactful
@KNizak-ev1ki
Жыл бұрын
Thank you, i need this lesson..... nice 💕
@nge292
2 жыл бұрын
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.
@thomaschristy9163
Жыл бұрын
9:07
@SaraEbrahimi-n1q
6 ай бұрын
Do you have a video doing this for bigginers on Google spreadsheet?
@jonothanduran2618
Жыл бұрын
Amazing job teaching how to effectively make a solid risk matrix. Highly approve.
@karikoga320
Жыл бұрын
Many thanks for this. I need to buy the templates but I am failing to access your website. I get the error message “429 Too Many Requests” Kindly assist
@assh8272
8 ай бұрын
Big thanks mr.david from saudi arabia 🇸🇦🇸🇦🇸🇦🇸🇦🇸🇦🇸🇦
@mezobiko22
Жыл бұрын
amazing effort , wish all the best
@assh8272
7 ай бұрын
Please i need this file, can you send it to me? Or link? 🔗 .. plesae 🙏🏽
@vivianibekwe
2 жыл бұрын
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.
@pedrohenriquecarneiro904
Жыл бұрын
Very nice. It's cool the visualization of the risk after its control action.
@braysonfadhili5891
4 ай бұрын
Helping. Thanks 🙏
@jrkns1981
Жыл бұрын
Thank you, man. I love this.
@still.the.1
Жыл бұрын
The Index Match formula keeps giving me a problem with the formula...
@vinaymjable
7 ай бұрын
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
@shoaibmq
Жыл бұрын
amazing... thanks learned a lot
@glorytotheheroes
Ай бұрын
The chance that a substance, activity or process will cause harm or loss is: Risk Assessment Hierarchy of control Risk Risk Factor ?
@omedlpg
4 ай бұрын
Thank you for the clear explanation.
@cindya5043
4 ай бұрын
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?
@alm3rof674
2 жыл бұрын
This is the formula but lets say I have a cell with the same valuable it stays at 0, can you check the formula =IF(COUNTIFS($F$6:$F$14,$W4,$G$6:$G$14,$X$6)=0,"",COUNTIFS($F$6:$F$14,SX4,$G$6:$G$14,$X$6))
@emiliotrejo2586
Жыл бұрын
Great explanation, thanks!
@phillipmashura8619
Жыл бұрын
Sir, How do I create Formulas in a Risk Register. Like when the Risk register is already set. How do I insert new formulas
@BrissoParrothead
Жыл бұрын
Tried for a few hours with no joy - not sure why. Kept throwing errors. Also your explanation doesnt explain some of the code like the use of the 0 in the formula and $ in the arrays. Reasons for that?
@ForeseeForewarn
6 ай бұрын
The easiest parts of the template construction were given thorough direct instruction, while the more complex aspects of creating the template were glossed over. I was with you until the last bit where you had prepopulated formulas for the matrices. I am not Excel savvy and cannot understand how to put those together or when $ are essential to your template.
@LeeCharnock-w4q
10 ай бұрын
Great video great spreadsheet but I can not get the formular for risk rating to work, I can not see what you are doing and reading the formular will not translate on my Sheet. I never get $ in mine and even if i add them it does not work. Managed it to say Ref even though Probability and impact are filled in.
@sofiyalototska2432
2 жыл бұрын
Incredible video, it helped so much at my work! Thank you so much🤩🎯
@kassimssemujju4957
2 жыл бұрын
thank you very, this is exactly what I needed
@ntuthukosolomonmkhwanazi9205
Жыл бұрын
A big thank you David!!!!!!!!!, all the way from South Africa
@MrWalksy06
Жыл бұрын
Hi great video. Is this template available rather than making it myself (not to that level with Excel currently) thanks
@zafi2250
Жыл бұрын
thank you thank you thank you
@pedrohenriquecarneiro904
Жыл бұрын
A lot of cool tips in this video. Amazing.
@royyogobrata5440
Жыл бұрын
Hi David can you please send me the link for this specific spreadsheet, so I can purchase and download it. Thanks
@edomarusenicholas1502
Жыл бұрын
Thank you very much Dave, It was quite informative. Can i have a template of this?
@tuanhoangzx1802
21 күн бұрын
Thanks David
@wongamemani4554
16 күн бұрын
where can i download this template?
@nafissatoublack1234
Жыл бұрын
He goes way too fast, how did he even make the shadings? I'm starting from scratch and I'm lost
@christianpolytechnique7404
8 ай бұрын
Hi David,at marker 14:21, you say you left the 3 without a $ sign, what do you mean by that?
@davidvose2475
2 жыл бұрын
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.
Пікірлер: 232