Risk Assessment Matrix in Excel in 15 Minutes!

►► Download the FREE Risk Register Exercise File: → www.alvinthepm.com/risklog/
Learn how to create a Risk Assessment Matrix in Excel in 15 minutes! The Risk Assessment Matrix is an incredibly helpful tool to visualize risks on your project to identify the Probability and Impact a risk may have on your project. What are the most severe risks that require your team's focus and mitigation efforts?
Watch until the end of this Risk Assessment Matrix Excel Tutorial to learn: 1) How to create a Master Risk Table in Excel, and 2), How to Create a Risk Assessment Matrix in Excel that automatically updates whenever you update your Risk Register.
------------------------------------------
🔥 RESOURCES I RECOMMEND:
Fast Forward MBA In Project Management: amzn.to/3ELz8Pk
Making Things Happen: amzn.to/3ga7KQR
Project Management for the Unofficial Project Manager: amzn.to/3TtoKQt
------------------------------------------
Udemy Courses:
Practical Project Mgmt- bit.ly/UdemyPracticalPM
Beginner to PROject Manager- bit.ly/ProPMCourse
Ultimate Agile Scrum Master Training- bit.ly/PSM1Course
Scrum for Beginners Training- bit.ly/ScrumCourse
Learn JIRA with real-world examples- bit.ly/JIRACourse
Coursera Courses:
Google Project Management Certification: imp.i384100.net/GooglePMCourse
UC Irvine Applied Project Management Certification: imp.i384100.net/UCIrvinePM
UC Irvine Project Management Specialization: imp.i384100.net/PMPrinciples
Engineering Project Management Specialization: imp.i384100.net/EngrPM
Leadership & Management Specialization: imp.i384100.net/LeadershipCourse
Leading Teams Specialization: imp.i384100.net/LeadingTeams
🔥 PROJECT MANAGEMENT CERTIFICATION
CAPM Exam Resources: www.alvinthepm.com/capm-exam-...
PMP Exam Resources: www.alvinthepm.com/pmp-resour...
PMI-ACP Exam Resources: www.alvinthepm.com/pmi-acp-ex...
💻 MY FAVORITE GEAR: www.alvinthepm.com/gear/
Camera: amzn.to/3vTnwEJ
Microphone: amzn.to/3RERFj3
Camera Tripod: amzn.to/3bEORUp
Please note that some links are affiliate links and I may earn a small commission for any purchase through these links. As an Amazon Associate I earn from qualifying purchases.
// Watch my other Project Management Career Videos:
Learn Microsoft Project in 20 Minutes: • How to Use Microsoft T...
How to use Microsoft Teams for Managing Projects: • How to Use Microsoft T...
Day in the Life of a Project Manager: • Day in the Life of a P...
How to Become a Project Manager: • How to Become a Projec...
Project Manager Salary REVEALED: • Project Manager Salary...
The Perfect Resume to Land Your Project Manager Job: • The Resume That Got Me...
Become A Certified Professional Scrum Master: • How to Pass PSM™ 1 Cer...
ATTRIBUTES:
Icons made by Freepik (www.freepik.com) from www.flaticon.com/
Deadly Roulette by Kevin MacLeod (incompetech.com)
Licensed under Creative Commons: By Attribution 3.0 License
creativecommons.org/licenses/b...
DISCLAIMER: All material has been created with the careful consideration of, and ensuring compliance with PMI’s Code of Ethics and Professional Conduct. Please read the full Disclaimer at this link: www.alvinthepm.com/disclaimer/
Alvin the PM is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to www.amazon.com.

Пікірлер: 61

  • @alvinthepmofficial
    @alvinthepmofficial Жыл бұрын

    ►► Download the FREE Risk Register Exercise File: → www.alvinthepm.com/risklog/

  • @manilla1107

    @manilla1107

    6 ай бұрын

    Thank you men

  • @manilla1107

    @manilla1107

    6 ай бұрын

    من الجزائر شكرا لكم من اعماق قلبي ❤❤❤❤

  • @alvinthepmofficial

    @alvinthepmofficial

    6 ай бұрын

    You're welcome! @@manilla1107

  • @prarthanabharathi4094
    @prarthanabharathi409410 ай бұрын

    Thank you for the video! Well explained!

  • @arkamukherjee8412
    @arkamukherjee84126 ай бұрын

    This video was so much helpful in preparing for case interview. Thank you very much for such amazing content.

  • @alvinthepmofficial

    @alvinthepmofficial

    6 ай бұрын

    So glad you found it helpful!

  • @badrianoABF
    @badrianoABF4 ай бұрын

    thank you.. this was very useful, especially compared to alot of other videos on the tube.. cheers

  • @alvinthepmofficial

    @alvinthepmofficial

    4 ай бұрын

    I'm so glad you found the video helpful!

  • @sokhaputh2092
    @sokhaputh209211 ай бұрын

    Thanks a lot, Alvin, for your Excel Risk Assessment, it very useful. 🙏

  • @alvinthepmofficial

    @alvinthepmofficial

    10 ай бұрын

    THANK YOU for the positive and encouraging words, it truly means a lot!

  • @sowjanyajvp447
    @sowjanyajvp4477 күн бұрын

    Great info, thank you very much!

  • @alvinthepmofficial

    @alvinthepmofficial

    5 күн бұрын

    Really glad you found the video helpful!

  • @shepherddancehallnation
    @shepherddancehallnation Жыл бұрын

    Excellent Content

  • @user-in2ep6ln1e
    @user-in2ep6ln1e6 ай бұрын

    Thank you for your help and advice!

  • @alvinthepmofficial

    @alvinthepmofficial

    6 ай бұрын

    My pleasure, glad I could help out!

  • @user_gh16wh82b8
    @user_gh16wh82b89 ай бұрын

    Hello, thank you so much for your video! It was very interesting, and I repeated this matrix in Excel. It looks pretty cool 👍

  • @alvinthepmofficial

    @alvinthepmofficial

    9 ай бұрын

    So glad you found it helpful! Feel free to share it with anyone else you know who might find it helpful!

  • @shabnamneeraj2330
    @shabnamneeraj23308 ай бұрын

    thankyou sooo much,, very helpful video... I created a risk matrix for a business plan using this video. It came out very well.. thankyou

  • @alvinthepmofficial

    @alvinthepmofficial

    8 ай бұрын

    So glad you found the video helpful!

  • @purplemma3071
    @purplemma30713 ай бұрын

    Great video, thanks! Carefully breaks down each step to a level total Excel newbies (me!) can follow, and everything worked exactly as described :)

  • @alvinthepmofficial

    @alvinthepmofficial

    3 ай бұрын

    So glad you found it helpful!

  • @Rich4live
    @Rich4live3 ай бұрын

    Thank you very much for you're effort sir !

  • @alvinthepmofficial

    @alvinthepmofficial

    3 ай бұрын

    My pleasure!

  • @robamymarkillie5984
    @robamymarkillie598410 ай бұрын

    Brilliant, thank you so much

  • @alvinthepmofficial

    @alvinthepmofficial

    10 ай бұрын

    I'm so glad you found the video helpful!

  • @mlo8943
    @mlo89435 ай бұрын

    Lovely!! Very helpful

  • @alvinthepmofficial

    @alvinthepmofficial

    5 ай бұрын

    Glad you found it helpful!

  • @emreozer4400
    @emreozer4400 Жыл бұрын

    Thank you ❤

  • @alvinthepmofficial

    @alvinthepmofficial

    Жыл бұрын

    So glad you found it helpful, Emre Ozer!

  • @UserHandle0702
    @UserHandle07027 күн бұрын

    Your content is very good 3 video from you today all likes

  • @alvinthepmofficial

    @alvinthepmofficial

    5 күн бұрын

    THANK YOU, that means a lot!

  • @TheJaebeomPark
    @TheJaebeomPark4 ай бұрын

    excellent

  • @aleenamariya2397
    @aleenamariya23973 ай бұрын

    Thank you so much ❤

  • @alvinthepmofficial

    @alvinthepmofficial

    3 ай бұрын

    My pleasure, Aleena!

  • @onsongoisaiah1130
    @onsongoisaiah113011 ай бұрын

    You did well but the set up of the chart colour on the gradient scale is not random but would be based on the cumulative rink rating.

  • @Nagermax
    @Nagermax6 ай бұрын

    Amazing, thank you! Are you going to make a video showing how to create a risk burndown chart?

  • @alvinthepmofficial

    @alvinthepmofficial

    6 ай бұрын

    Glad you found it helpful, I"ll add that to my list of future videos to create 👍

  • @shepherddancehallnation
    @shepherddancehallnation Жыл бұрын

    The legend came outta nowhere? How do I create that?

  • @bryancaron1664
    @bryancaron1664Ай бұрын

    Great video, although I would like to know how to create the LEGEND please?

  • @bibeksodari3200
    @bibeksodari32008 ай бұрын

    Thank you !! It was a very informative video. But , As I was using Microsoft Excel Version 2007 , it didn't find the option - "value from cell" . How can I overcome this problem ?

  • @larsche
    @larsche7 ай бұрын

    Thanks for the video. I like it. I keep getting an error message when I try to link the axis titles to the impact and probability cells. What am I not seeing here? Any idea? This is what it looks like in the formula bar: =RiskLog[[#Headers];[Impact (I)]] By the way, the semicolon is used in Norway, instead of the comma (no idea why). The error message is generic (are all parentheses in place, are you sure it's a formula and not something else, etc.)

  • @govindsharma7738
    @govindsharma77382 ай бұрын

    How do you know if one threat row entry is a low medium or high probability? How did you create that logic?

  • @alvinthepmofficial

    @alvinthepmofficial

    2 ай бұрын

    You have to discuss the impact and severity of a risk based on your discussions with your team.

  • @mukuldesai5638
    @mukuldesai56388 ай бұрын

    Hi Alvin can i buy this please

  • @tripledair
    @tripledair10 ай бұрын

    Sheesh, wish I could Like this twice.

  • @alvinthepmofficial

    @alvinthepmofficial

    10 ай бұрын

    THANK YOU for your kind words, and I'm so glad you found it helpful!

  • @shadyhamzawy8358
    @shadyhamzawy83587 ай бұрын

    ❤❤❤❤❤

  • @alvinthepmofficial

    @alvinthepmofficial

    7 ай бұрын

    Glad you found it helpful!

  • @TDYoung07
    @TDYoung073 ай бұрын

    You dont know how long ive been searching for a decent 5x5 for my RIO board. Any way i can make it NOT a gradient. My customer isnt fond of it.

  • @snaveen4218
    @snaveen4218 Жыл бұрын

    Hi alvin. Myself Naveen. I am from India. I cannot able to purchase your exam simulator. Is there any other way like PayPal?

  • @alvinthepmofficial

    @alvinthepmofficial

    Жыл бұрын

    @Naveen, great to hear from you! Feel free to send me a message with this link so I can help you get access to the simulator you need: www.alvinthepm.com/contact/

  • @SUPERSONIC_ARCHERY
    @SUPERSONIC_ARCHERY2 ай бұрын

    Your concatenate doesnt work at all, Sir...

  • @aussiegruber86
    @aussiegruber863 ай бұрын

    Don’t bother downloading the template from the website it doesn’t have the graphs.

  • @alvinthepmofficial

    @alvinthepmofficial

    3 ай бұрын

    Sorry to hear you didn't gain value out of this, my website explicitly states that it's a Risk Register Template. Also, to set expectations, my video walks you through step-by-step with how to create the Risk Assessment Matrix using the data in the Risk Register File, which is completely FREE.

  • @aussiegruber86

    @aussiegruber86

    3 ай бұрын

    @@alvinthepmofficial which is fine it’s your spreadsheet, but what happens with the name and email address we had to hand over to realise it was basically an empty spreadsheet.

  • @danny69297
    @danny69297 Жыл бұрын

    Worths mentioning that this approach won't work in web excel - both microsoft and google

  • @godswillgodswill5973
    @godswillgodswill597311 ай бұрын

    Your vedios are good but, you are doing things without explaining, we don't know the Microsoft you are using, we you don't mention how you highlight from top to bottom. In summary, you are only addressing certain people, nothing basic, for me it's a 1 out of 5

  • @IdaliaPerez-ud5pf
    @IdaliaPerez-ud5pf6 ай бұрын

    @Alvinthepmofficial how would I go about directly contacting you?