Risk Register Template using MS Excel 

Thank you for an informative video. You've explain it in detail that is why I understand it very well. Again, thank you.

Hi, thank you for doing this tutorial as it helps me a lot. However, I'm struggling to think about how I can make the worksheet readable. Some of my columns like mitigation plan and impact have long statements, thus when I view or scroll my worksheet it I cant view the whole-cell unless I decrease the window size by 80% and below. Is there any way to fix this? thank you. appreciate your knowledge sharing here. thanks a lot

Thanks

Hmmm. I think Column E shouldn’t be called “Priority” but it should be called as “Severity” instead. Some of these high severity risks could be set aside as they could simply be transferred to another group to resolve. Hence, the priority doesn’t mean much. Furthermore, until a mitigation, a contingency or a resolution is determined, there is no point for it to be placed as a high priority. Why would you prioritise something before you are able to have an actionable solution for it. Without an actionable work on it, you would just lower its priority and set the risk item aside - making the Column E pointless. Doesn’t ISO 31000:2018 follow this principle of Severity instead of Priority?

Hello Sir Many thanks. May i Have copy of the your excel file and Also why did you choose limit value instead of list into data validation.

Clearly explained thank you

thank you you put alot of effort in explaining in detail.

Hi thank you for this, however in risk Matrix's the same value may mean different things. For example, Impact 5 X 1 Likelihood may be red but Impact 1 x 5 Likelihood may be green. How do you format the table so that it is conditional depending on which way round the cell value is put for the likelihood and impact?

wow it is so easy to do it. thank you

Sir pahingi po ako template

Very Informative

thank you so much