How to Create a Risk Matrix in Excel
10.2 هزار بار بازدید -
11 ماه پیش
-
In this video, I'll guide
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-ri...
🌍 ⯆ Checkout the article here:
https://www.exceldemy.com/create-a-ri...
💻 ⯆ Similar Videos:
How to Create Traceability Matrix in ...
How to Create a Training Matrix in Excel
🚩 Stay connected with us on social media for more Excel tips and tricks!
Facebook: Facebook: ExcelDemy
Twitter: Twitter: exceldemy
LinkedIn: 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: 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:
@exceldemy2006
#excel #exceltutorial #exceltips #exceltricks
👨🏫 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-ri...
🌍 ⯆ Checkout the article here:
https://www.exceldemy.com/create-a-ri...
💻 ⯆ Similar Videos:
How to Create Traceability Matrix in ...
How to Create a Training Matrix in Excel
🚩 Stay connected with us on social media for more Excel tips and tricks!
Facebook: Facebook: ExcelDemy
Twitter: Twitter: exceldemy
LinkedIn: 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: 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:
@exceldemy2006
#excel #exceltutorial #exceltips #exceltricks
11 ماه پیش
در تاریخ 1402/06/02 منتشر شده
است.
10,214
بـار بازدید شده