How to Create a Risk Matrix in Excel

In this video, I'll guide you through the steps to create a risk matrix in Excel. You'll learn how to set the probability and severity of an event. In addition, you’ll learn about absolute cell references and how to use them in Excel formulas. Also, you’ll explore Conditional Formatting to apply fill color based on the values in the matrix. With practical examples and step-by-step instructions, you'll be able to implement this risk matrix in your own Excel spreadsheets effortlessly.
👨‍🏫 Instructor: Farihatul Mim
🎥 Editor: Prantik Chowdhury
✨ ⯆ Resources:
F4 - To make cell references absolute
Ctrl + B - To make text bold
Ctrl + 1 - To open the Format Cells dialog box
▬ Contents of this video ▬▬▬▬▬▬▬▬▬▬
0:00 - Intro
0:52 - Setting Probability Criteria of an Event
1:25 - Setting Severity Criteria of an Event
3:29 - Assigning Values to Probability
4:07 - Entering Formula
5:06 - Filling the Risk Matrix
6:52 - Retrieving Value from a Risk Matrix in Excel
📚 ⯆ DOWNLOAD the workbook here:
www.exceldemy.com/create-a-ri...
🌍 ⯆ Checkout the article here:
www.exceldemy.com/create-a-ri...
💻 ⯆ Similar Videos:
• How to Create Traceabi...
• How to Create a Traini...
🚩 Stay connected with us on social media for more Excel tips and tricks!
Facebook: / exceldemy
Twitter: / exceldemy
LinkedIn: / exceldemy
🙋‍♂️ Stuck with an Excel formula or a VBA code? You can post your questions or upload your Excel file to get in touch with the professionals and get the solution you need.
ExcelDemy Forum: exceldemy.com/forum/
👉 If you found this video helpful, don't forget to subscribe to our channel for more Excel tutorials, tips, and tricks! Hit the subscribe button and turn on notifications, so you never miss an upload. By subscribing, you'll be supporting our channel and helping us to reach more people who can benefit from our content. Thank you for watching, and we'll see you in the next video!
🔔 ⯆ Subscribe on KZbin:
/ @exceldemy2006
#excel #exceltutorial #exceltips #exceltricks

[@2abei]

That was Awesome!

[@exceldemy2006]

Hello @2abei, You are most welcome. Please stay connected with us. Regards ExcelDemy

[@hayatullahjabari7629]

That was a great explanation with details.

[@exceldemy2006]

Hello @hayatullahjabari7629, Glad it was helpful! Please stay connected with us. Regards ExcelDemy

[@b4uaction538]

Thank you so much this video is most helpful for me

[@exceldemy2006]

Hello @adorable_writes, Thanks for your appreciation, it means a lot that our videos are helpful to you. Please stay connected with us. Regards ExcelDemy

[@redhat5414]

i like both the presenation and voice

[@antonynganga7868]

Nice vlog..inspiring Sister🎉

[@exceldemy2006]

Thank you! Stay connected with Exceldemy for more helpful content! 🎉❤ Regards, Exceldemy Team!

[@waonetipi2148]

Details.......thank U

[@exceldemy2006]

Hello @waonetipi2148, Thanks for your appreciation. Please stay connected with us. Regards ExcelDemy

[@hayatullahjabari7629]

From 4:35 to 5:00 I didn't understand how you do x3 times F4? When I pressed f4 it took me to "computer only... Duplicate... extend and Projector Only" options. Can you please explain 4:35 to 5:00 please. Thanks

[@exceldemy2006]

Dear @hayatullahjabari7629, If F4 is taking you to the "computer only... Duplicate... extend and Projector Only" that means F4 has a pre-assigned shortcut related to display options ("Computer Only," "Duplicate," "Extend," "Projector Only"). This conflict can override the default Excel behavior of toggling absolute references. Please check your keyboard settings to see if F4 has any pre-assigned shortcuts related to display. Most systems allow customizing these shortcuts. Or you can use the alternate Ctrl+ (hold Ctrl and press ~) keyboard shortcut to toggle absolute references within formulas.

[@xxxXavier]

on which data you have implemented this, wasted my time here

[@exceldemy2006]

Hello, Apologies for any inconvenience. For your convenience, the download link to access our dataset is provided in the description. However, to ensure clarity and ease of access, we are including it once more. Please download the dataset from this link: www.exceldemy.com/create-a-risk-matrix-in-excel/#download Regards ExcelDemy