The video covers how to create a probability impact table or Risk Assessment table. If you're doing project management or risk management, you'd be creating this table or matrix chart for your program or projects. You'd need to list out the different risk criteria and then figure out the likelihood of the risk happening (the probability part) and then the impact it would have (high, medium or low). This combination of probability and impact then helps determine the risk (again high, medium or low) that specific risk has to the project.

There's bonuses to this; in addition to how to create the table and risk matrix I show how to create a drop down list, use conditional formatting for the color coding and show how to count up the different combinations of probability-impact in the matrix.

0:00 Intro
0:37 Risk Table & Risk Matrix overview
1:33 Create Risk Table
1:57 Create Drop-down List
2:45 Risk Formula Combination
5:22 Troubleshooting Tips for Risk Formula
8:17 Conditional Formatting for Risk Color Coding
9:25 Create Risk Matrix
10:45 Formula for Counting Probability-Impact Combinations
12:51 Bonus Tricks & Tips

See other Risk Management videos here 👉 [ Ссылка ]

🔔 SUBSCRIBE to my channel ➜ [ Ссылка ]

🏫 Excel Training ➜ [ Ссылка ]

📚 Excel Books & Tech Gear ➜ [ Ссылка ]

⚙️ Tools: Screencasting ➜ [ Ссылка ]

⚙️ Tools: Microsoft Office ➜ [ Ссылка ]

⚙️ Tools: TubeBuddy ➜ [ Ссылка ]

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

🎁 If you find these videos useful and want to support my channel go to
[ Ссылка ]

#excel
#msexcel
#doughexcel

свернуть