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:
https://www.exceldemy.com/create-a-risk-matrix-in-excel/#download

⯆ Checkout the article here:
https://www.exceldemy.com/create-a-risk-matrix-in-excel/

⯆ Similar Videos:
https://youtu.be/Gv5oH-NIbCw
https://youtu.be/tJLjk2A24f8

Stay connected with us on social media for more Excel tips and tricks!
Facebook: https://www.facebook.com/ExcelDemy/
Twitter: https://twitter.com/exceldemy
LinkedIn: https://www.linkedin.com/company/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: https://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 YouTube:
https://www.youtube.com/@exceldemy2006
#excel #exceltutorial #exceltips #exceltricks

Please take the opportunity to connect and share this video with your friends and family if you find it useful.