Risk Register Template in Excel

Want me to coach/mentor/advise you in your project management career? This link shows you how: influentialpmo.com/1-to-1-adv...
Want to join me for group Zoom calls? Join the membership space here: / influentialpmo
#projectmanagement
My gift to you - a free risk register template. Get your download here and then watch the video to understand the fields: geni.us/riskregister
Timestamps:
0:00 - Intro to get a free risk register template
1:04 - Risk Register Template in Excel
1:17 - Project Name, Project Manager and Date
1:59 - Risk Heatmap, Risk Impact and Risk Likelihood / Probability
2:36 - Risk ID as a Unique Identifier of Risk
2:52 - Risk Name / Risk Title
3:04 - Risk Description - the Risk, the Cause and Impact
3:20 - Date the Risk was Captured
3:28 - Risk Owner
4:01 - Risk Scores based on Impact and Likelihood for Pre-Mitigation, Current and Post-Mitigation
5:52 - Risk Responses - Avoid, Reduce, Fallback, Transfer, Share, Accept
6:04 - Risk Mitigation Plan and Actions
6:15 - Progress Update
6:33 - Risk Proximity
6:47 - Workstream
6:57 - Operational or Project Risk
7:34 - Risk Escalation Level
7:46 - Last Review Date and Next Review Date
8:18 - Target Completion Date
8:38 - Historical Progress in Managing the Risk
8:53 - Notes
9:03 - Final Notes and Recommendations
#RAID #riskmanagement

[@InfluentialPMO]

Hey, hope you enjoy the video and make good use of the risk register template. I mentioned that I had made a video about Risk Proximity - the link to it is here: kzbin.info/www/bejne/f5KVqWeqfpt7a5Y

[@aibbieaguirre4680]

Thank u

[@nickgutteridge5988]

Recently found your channel having just started as a PM, some fantastic content that I'm slowly working through to get me up to speed and on my way to being a great PM! Thanks!

[@InfluentialPMO]

Congratulations on an excellent career choice Nick! And good luck in that role. If ever there’s anything you’re struggling with, just let me know. The best video ideas come from the community. Feel free to connect on LinkedIn if you’re on there. Thanks 😃

[@tpmash]

Thank You 🙏🏽🙏🏽🙏🏽🙏🏽🙏🏽

[@smartacademy4067]

This is really amazing. You made it quite simple.

[@InfluentialPMO]

Thank you - I’m glad it’s been helpful to you.

[@mohammedshahnewazkarim250]

Fantastic. I learn something new here.

[@Rock32188]

Thanks for nice explanation and would appreciate if you tell me about fallback means in this template.

[@bengarick]

Great register. Personally, I prefer the term probability over likelyhood, it's more concrete as a term and one that favours a percentage value int he subconcious... it also means that, instead of heat map, you can use the term Probability Impact Grid (PIG). Date Capture - I find is usefull but less relevant of Date event likley to occur which will inform on Proximity Love and agree with your views on Risk owner! Pre, Current and post mitigation scores - also know as Inherent, residual and target. I'd personally have the drop down to show as the text description and not the numerical value and have that calcualte behind the scens. It removes the dependencie to people having to refer the the legend and avoids 'accidental' on shared logs. Love the review Dates!! I also like to try aim for quantative risk impacts over qualitative and try get PM's to cost the risk impact... not easy to get them to do so until I explain its a best estimate on resource cost to fix. Great video as ever!

[@InfluentialPMO]

Thanks for the feedback. I know what you mean about probability vs likelihood - I often flip flop on which to use. I think in an older video I used both terms which I didn’t notice until editing. Wasn’t happy with that! I’m delighted that you enjoyed the video. 👍

[@markharris7804]

Brilliant, thanks.

[@InfluentialPMO]

You're welcome 😀

[@growqueen]

Perfect thank you.

[@InfluentialPMO]

Glad you like it - hope it proves to be useful. 😃

[@jmccoy2406]

I am new to the PM world. These videos have been beneficial, and I love your content. Do you have a video on developing a Project Masterlist? I am currently trying to make one. I want a quick snapshot of the projects, including budget information (over multiple years). Do you have any suggestions? Maybe you have a video that covers this that goes by another name.

[@InfluentialPMO]

Hi Jeremy, thanks for the feedback. I’ve not build a project master list for the channel as you describe. There is a status report template video, but I suspect that may not cover the right timeframes for you. Would you interest be in learning how to arrive at the information that would go into the master list, or is it more about how to collate and present the information?

[@jmccoy2406]

@@InfluentialPMO The status report video and instructions were excellent. I agree it does not capture the timeframe. Right now, tips on how to collate and present the information would be helpful. Tracking budgets over three years is causing the excel sheet to look messy. After watching your videos, I probably should have used PowerPoint

[@SuperMan-xr4tg]

thanks so much. CHeers Mate

[@InfluentialPMO]

You’re welcome 👍

[@harrygilbert3738]

Great video, thanks. I have a query regarding why a stand-alone risk register would be required, if continually measuring actions driven by a solid timing plan? (By the way, this is not a criticism, I’m genuinely interested) when I review timing and project actions tri-weekly, risks are identified within the actions log, and are highlighted and actioned as a sub-action to the original action - this will identify the owner(s) of the risk and prompt a plan to be made to mitigate appropriately. I’m clearly missing something, possibly that it’s not required for my line of work (automotive engineering projects) or it’s a tool that I’m not utilising and should be? Thanks again.

[@InfluentialPMO]

Hi Harry - interesting question. Consider the risk register a place to capture threats/uncertainties and you plan for reducing their impact and likelihood. You could do it in a single action plan, but my guess is you could very quickly populate a large proportion of your action plan with activities to manage risk, losing track of the most important activities. It could also be confusing for others to follow depending on how much detail you include about the risk, it’s cause and impact. I believe the best approach is actually something in the middle. A risk register and an action plan with some overlap where key risk mitigation actions are visible and trackable in the action plan.

[@harrygilbert3738]

@@InfluentialPMO I agree, had a thought about it’s uses in my line of work - yes, it would be a great way of capturing / treating risks as a separate reporting format, especially to the seniors. I’ll be making some mods to the spreadsheet on Monday! Thanks for the advice 👍🏻

[@sophio1471]

this has been helpful as i am writing our first risk register, i subscribed but have not received the template.....

[@InfluentialPMO]

Hi, please check your junk mail for a verification email to confirm your details. It loads the template directly from that.

[@hichempro1481]

The template is not downloadable because there is a problem with the link, it is possible to get the template in another way

[@InfluentialPMO]

I've just tested and the link seems to work - it goes to a public Patreon page where the document can be freely downloaded.

[@terriushampwaye8268]

Send me a template long side done