How To Create A Risk Register [Step By Step Guide]

[@ProperProjectManagement]

🚀Get my project management templates 👉 properprojectmanagement.com/project-management-templates/

[@TheRealJAHWHO]

THANK YOU!!! subscribing is a no brainer. I really appreciated your explanation, very thorough! I felt like I was getting a 1:1 session. Very appreciated!!!!

[@ProperProjectManagement]

Thanks so much for the kind words Joshua. Really appreciate it and pleased to hear it was useful for you

[@nickybrock1215]

Hello, Thank you for this. I am studying this topic and thanks to this video, I now how a better understanding of what kinds of things should be on the risk registry. I truly appreciate the guide in excel. This is truly helpful!

[@ProperProjectManagement]

Glad it was helpful! Thank you for dropping a comment to let me know.

[@1step2life]

Wow, I tip my hat to you, you're such an amazing teacher. I would love to have a copy of your template. Thank you

[@ProperProjectManagement]

Thanks so much 😊 Sure, will get it over to you

[@dennismathuloe2790]

Hi, Thanks for this use full presentation, its so simple and easy to apply and also the excel guide is super fantastic.

[@ProperProjectManagement]

You are welcome!

[@37Hulk]

Easy to follow along, and quickly created , Excellent Video.

[@ProperProjectManagement]

Glad it helped! Thanks!

[@Redberry_15]

Thank you so much for the Risk register step by step guide tutorial. I would love to have a copy of the template

[@ProperProjectManagement]

You're welcome Oluwakemi. Sure, just send me an email and I'll get it over to you!

[@amandaoconnor6067]

THANK YOU. Just starting a new role and would love a copy of your formatted spreadsheet. It was an excellent presentation and very easy to follow.

[@ProperProjectManagement]

Thanks Amanda. Just send me an email and I'll get it over to you. All the best with your new role!

[@kengormley4530]

hi great risk register & risk register scale .......could you send on both please ??

[@ProperProjectManagement]

Hi Ken, send me an email and i'll get it over to you

[@maxinepears9898]

Thank you so much for sharing. I am so glad to have found you. Please may I have a copy of your completed template.

[@ProperProjectManagement]

Thanks Maxine. Sure, just send me an email and I'll get it over to you

[@gabrielosu6230]

great session Paul, made so much sense, want to build an information security risk register if you can share a template will be happy...

[@ProperProjectManagement]

Thanks, though my name is Jeremy haha. Sure will get it over to you

[@bee69ful]

Very informative and easy to understand. Thank you so much. I did purchase the templates and find them very very useful

[@ProperProjectManagement]

Amazing. So pleased to hear this. Thanks and for letting me know. All the best!

[@preciousmapfiro1233]

Hithanks for your brilliant presentation.may l please have the template .

[@ProperProjectManagement]

Great to hear it Precious. Sure just send an email and I'll send it there

[@preciousmapfiro1233]

@@ProperProjectManagement THANK YOU IN ADVANCE and HAPPY NEW YEAR !!

[@giftichekare5086]

This is great. Please I need the template. thanks

[@ProperProjectManagement]

Great to hear it! Sure just send me an email.

[@jreh3811]

How did you create the colored scale? I would like to input that into the register.

[@ProperProjectManagement]

I made that externally and added it as a picture image. You could create the same within excel, though.

[@ayomideosukoya391]

Wow this is detailed and really helpful. I am finding it hard to copy the formula correctly. Kindly send me the complete template and the formula. Thank you

[@ProperProjectManagement]

Thanks for the kind words Ayomide. Absolutely, send me an email and I'll send the template over to you.

[@CeciliaSaguet]

@@ProperProjectManagement Could you please send it to me as well.

[@netty8374]

Kindly send me a copy too. Thank you

[@ElvyJ1211]

This is excellent, would you be able to provide me a copy of the template, please. Would it be possible to add an inherent risk column as well.

[@jayblack6683]

I want to thank you for the very informative details you have provided, you explain things very well. I would love to have a copy of the Template

[@ProperProjectManagement]

Hello Jay. Pleased to hear it was useful; thanks for the kind words. Sure, just send me an email and I'll get it over to you.

[@ntandomgabhi1422]

Good morning Thank you for the information I'm doing my postgraduate in project management I have learned a lot from your videos It is possible to get the risk register template Regards

[@hussainwarraich8139]

Very informative and helpful as you explained in details! Thanks for sharing 😊

[@ProperProjectManagement]

Great to hear Hussain. Thanks for the kind words and pleased to hear it was helpful for you :)

[@AsharHasan-fu3ek]

Is there any way we can tag risk id in project plan? So when going through the plan we know if there is any risk associated with any task.

[@ProperProjectManagement]

I don't see why not. You would of course need unique risk identifiers for this to work, though.

[@prm2335]

Thank you so much. Very useful.

[@ProperProjectManagement]

You're welcome :D

[@shatadalt634]

Hello Paul, Great presentation with practical explanation. Please can you share template you just showed here ? thanks shaq

[@ProperProjectManagement]

Hello Shatadal. Thanks for the kind words. If you send me an email (which mine can be found on my channels about page - kzbin.infoabout), I'll get this sent right over to you! All the best.

[@Nadiapm2001]

Hi there, this is brilliant! May I please have a copy, too?

[@sammittens4589]

Thanks so much. Just got tasked with this at work and had no idea what I was doing!! Regarding the the Risk Register Scale that you created earlier on the validation sheet, is that created in the spreadsheet cells and then saved as an image? Also, is there a way to apply a formula to calculate across the entire row/down the colum, while keeping the first number as permanent and only changer the second number? Using the same 5 x 5 number format that you used and pretending we're starting at A1 (being 5 for Probability) making B5 1 for Impact, I applied the formula to B1: =A1*B5, which gives the correct result (5) for that cell, but when I drag across the row, it keeps the same shape (ie, next cell formula becomes =B1*C5 (instead of A1*C5) which gives right result by chance despite wrong method, but then the wrong results start after that at D1, where formula is =C1*D5 (30) (instead of A1*D5) ) where I need the first data cell to stay the same for the right result (ie, second result needs to be =A1*C5) ... Must be so confusing to read, sorry!! The issue is that rather than keeping A1 in the formula and multiplying with B5, C5, D5, E5, the first number in the equation is shifting across as well, so rather than staying at A1, it's multiplying B1 and then C1 etc... If that makes sense and there is a solution, I'd love to hear it! I know it's not much effort to manually type in but trying to enhance my Excel skills! Thanks!!!

[@ProperProjectManagement]

Hi Sam. That's correct - it was previously created and inserted as an image. Regarding the formula, you can leverage the $ symbol in front of the first number - this article explains it in much better detail than I could explain here: www.extendoffice.com/documents/excel/2500-excel-constant-cell-value-reference.html

[@fatousarrdarboe3725]

Hello Paul, its A superb presentation and would love to have it if possible. thank you

[@ProperProjectManagement]

Hello Fatou, thanks for your kind words. If you send me an email I'll send it right over to you :)

[@vinitpandey7636]

Hello Paul , very nice video.

[@ProperProjectManagement]

Thank you Vinit; hopefully it was helpful

[@Meme01043]

Very helpful Thank you so much

[@ProperProjectManagement]

You're welcome!

[@Meme01043]

@@ProperProjectManagement your tutorial saved my ass. Could you make more detailed ones ?

[@ahmadbakr2485]

This is incredibly thorough and beneficial. To my dismay, I'm having a difficult time copying the formula. Please provide me the template and the formula.

[@ProperProjectManagement]

Thanks so much Ahmed . If you send me an email I'll get the template right over to you - my email can be found in my about page of my channel. Take care.

[@yuenfen2160]

Thank you and very useful video

[@ProperProjectManagement]

Glad it was helpful! Thank you Yuen!

[@richardlaimo8362]

Can I have a copy of this template. Thanks

[@ProperProjectManagement]

Hi Richard. Sure, just send me an email and I'll get it over to you.

[@urszulakrysiak8657]

great presentation; can i get template and formula, please

[@ProperProjectManagement]

Thanks, Urszula. sure, just send me an email and I will get it right over to you!

[@RareSense]

Hi l bought the 8 templates but the project timeline one is locked?….

[@ProperProjectManagement]

Hello, that's news to me; sorry about this! Send me an email theproperprojectmanagement[at]gmail.com and I will get this resolved for you.

[@sirajahmed4944]

Hey, very informative video. I would like to have the template but not sure how to get your mail address? Can you help

[@ProperProjectManagement]

Hello Siraj. Thanks! You can find my email via my channels about page.

[@sammust9238]

I need this template too. Thanks in advance.

[@samuel4092]

You absolute beauty. Could you create a full RAID log in Excel

[@ProperProjectManagement]

Thanks Sam... I shall get recording!

[@samuel4092]

@@ProperProjectManagement Thanks.

[@obinnaokoli9029]

thanks for the explanation, pls I would love a copy of the risk template

[@ProperProjectManagement]

Sure, will get it sent over.

[@shahrozekhan4404]

Could you please share with me the template? I cannot find an email address in the about section of the channel.

[@ProperProjectManagement]

Hello Shahroze, its under business enquiries.

[@tedhodnett5389]

Hi, this was of great help and very informative, could I please request a copy of both formats please.mzny regards

[@ProperProjectManagement]

Thanks Ted, thanks for the kind words. Sure, send me an email and I'll get them sent over to you!

[@peterawomoyi2251]

Very detailed information. Thanks. Can you please send me your template. Thanks.

[@ProperProjectManagement]

Thanks Peter. Sure, just send me an email and I'll get it over to you.

[@SidSoman]

I would like to have this template.

[@netty8374]

Hi, thank you for this info. Starting a new role and would need your template. 😊

[@ProperProjectManagement]

Best of luck with your new role!

[@paulstrachan3081]

Hi, great video. Could I have the risk register template also please? Thanks, Paul

[@ProperProjectManagement]

Hello Paul - sure. Please send me an email to theproperprojectmanagement[at]gmail.com and I'll respond with the template :)

[@paulstrachan3081]

Hey, sorry, I sent an email yesterday shortly after your prompt reply. Did you miss it in your junk? Thanks, Paul

[@wilsonsiroi2024]

Iam so impressed with your presentation here. I am not an expert in excel but would really love to create the same to use. Will you please kindly send me the template. I would be very grateful. Thank you

[@udaygollapalli3252]

Hey, this was a very useful session. It would be great if you could share across the template.

[@ProperProjectManagement]

Thanks Uday, glad it was helpful! If you send me an email I will reply with the template there. You can find my email in my about page of my channel. Take care

[@anuradhaguruge6858]

Hi Thanks for sharing.Could i have risk register template ?

[@ProperProjectManagement]

Hi Anuradha. Yes, of course. Feel free to send me an email and request there. I'll send over right away: theproperprojectmanagement[at]gmail.com

[@besonalora3572]

Absolutely great I would love the template but I do not see your email ?

[@ProperProjectManagement]

Hello. Thank you. You can get it via my channels about page.

[@akramqubati508]

Hi Paul ,I need this template please?

[@ProperProjectManagement]

Hello Akram. Feel free to send an email to my email (found in my about page on my channel) and I'll get it over to you right away! :)

[@krt6442]

Love this. I sent you an email requesting the formula for the priority level. Thanks.

[@ProperProjectManagement]

Thank you KRT! Received, working on this right now!

[@krt6442]

@@ProperProjectManagement thx friend

[@ProperProjectManagement]

@@krt6442 Your welcome. Take care!

[@olayioyeseun2758]

Hello, thanks for the video please can i have a copy of the risk register. Thanks

[@GinaGani-vo9fc]

Thanks for this great tutorial and video. Interested in the template sir? How do i get your email to request for this template please? Thanks

[@ProperProjectManagement]

Hello. Via my YT's about page, thanks

[@GinaGani-vo9fc]

@@ProperProjectManagement Thank you for your reply. I just did. Thank you in advance

[@johndonagher4285]

Great video man

[@ProperProjectManagement]

Glad you enjoyed. Thank you!

[@simonsobah-ampong8026]

Good stuff. Just subscribed.

[@ProperProjectManagement]

Awesome!

[@eugenephiri6703]

Kindly asking for the template please

[@ProperProjectManagement]

Hi Eegune. Sure just send me an email and I'll get it over to you

[@afsal1314]

Beneficial video, could you send me the template and formula.

[@ProperProjectManagement]

Hello Afsal. Sure, send me an email and I'll send it your way

[@jwahlton]

I would like a copy of the risk register. How do I email you?

[@ProperProjectManagement]

You can get my email from my channels about page. Thanks

[@hellwworld9625]

totally loved it

[@ProperProjectManagement]

Thanks, glad it was useful!

[@kabeloogomoditseshashane421]

Hi, thanks for this video. It was very useful. Please share the risk register over the email

[@marjantavakoli395]

It was really helpful and make it easy 🙏could you please send me copy of template .Thanks

[@ProperProjectManagement]

Good to know Marjan. Sure just send me an email.

[@corneliadye-sharpe3914]

Hi great tutorial! would you send me the template please?

[@ProperProjectManagement]

Hi Cornelia. Thanks for the kind words. Send me an email and I'll get it over to you right away :)

[@annekinyanjui5585]

Thanks for wonderful presentation. Kindly assit with the template

[@ProperProjectManagement]

Thanks Anne, pleased to hear it!

[@GeorgeFoster-jb6cw]

Can You Please send me Both risk Register templets , Very interesting

[@ProperProjectManagement]

Hello George. Sure thing!

[@toniakparteh8964]

i need this template please

[@ProperProjectManagement]

Hello Tonia. Send me an email via my about page and I'll send it over right away. Best.

[@d4ss29]

Hi , i have sent an email with request to get risk register template. plz share. thx

[@ProperProjectManagement]

Hello. I have just sent across. Look out for it :)

[@fredrickoareojehomon1932]

Pls I need the template. Thanks

[@ProperProjectManagement]

Hey Frederick. Link for the template is in the description. Thanks.

[@Ludwigfw]

Hello! Would you please send me a copy of your template? Thank you very much!

[@ProperProjectManagement]

Hello; sure just send me an email and I'll send it right over to you!

[@terrymorocco5327]

Would love a copy of this

[@ProperProjectManagement]

Hello Terry. Sure, just send an email so I can get it to you. Thanks

[@waltonsaunders9400]

How do I get a free risk register?

[@ProperProjectManagement]

Hello Walton. Send me an email (you can find it in my channels about page) and I'll send it to you directly from there.

[@beamatasova4949]

hi, Well explained video, could you please send me the template?

[@ProperProjectManagement]

Sure, will get it sent over.

[@CeciliaSaguet]

mm It wasnt clear on priority level formula... any help anyone?

[@ProperProjectManagement]

Hello Cecilia. Sorry about that. The formula for the first row of the priority column is: =IF(E10*F10=0,"",E10*F10) Simply drag it down from there.

[@keishadooner7002]

Hi, Please can you send me the template? Thanks :)

[@ProperProjectManagement]

Sure, just send me an email and I'll get right onto it!

[@vicgeorge4611]

Can I have this template please?

[@ProperProjectManagement]

Sure; drop me an email via my channels about page and I'll ping it across! :)

[@msharialgamdi9560]

great work!!! can you send me the excel please

[@ProperProjectManagement]

Thanks. Sure, will send it over email.

[@azizb9754]

Could you please send me a template pls

[@ProperProjectManagement]

Hi Aziz. Sure, send me an email and I'll get it over to you

[@kevinjackson5191]

Great video thanks.....but who on earth pronounces mitigation that way!?!?!?! :D

[@ProperProjectManagement]

Thanks, Kevin. Me by the sound of it!

[@ianallen7306]

Can you please send me the excel template

[@ProperProjectManagement]

Hi Ian. Sure will get it over to you.

[@midhunkrishna6562]

Its good

[@LeanneStLouis]

Great video. Sent email for formula and template. Thanks

[@ProperProjectManagement]

Sent! all the best.

[@JohnsonUche-m8m]

Please share the template with me...

[@ProperProjectManagement]

Sure, will get it sent over.

[@shahrukhdaud7989]

👍👍👍👍

[@ProperProjectManagement]

Thank you

[@GertRich]

Great piece of demonstration. Kindly share this template with me via email

[@ProperProjectManagement]

Will do

[@dracoac4227]

Hey, can I please have a copy of this template?

[@ProperProjectManagement]

Hello. Sure, just send an email so I can get it to you. Thanks