How to create Automatic Risk Matrix in Excel | For Security Professionals | Complete Guide In Hindi

WhatsApp group for Security Professionals:
chat.whatsapp....
#riskmatrix #RiskManagement #RiskMapInExcel
Risk maps are useful for visualizing your organizational risks on the basis of their impact and likelihood.
To make your Risk Matrix Fully Automatic you can use Excel formulas (TEXTJOIN) and simple tables to create them in minutes.
In this tutorial, you will learn how to make your own Security Risk Matrix with Microsoft Excel.
Original Video Credits👇
====================
• How to create risk map...
Hey!! I am Shashank Walia, Corporate Guy 📍Physical Security & Brand Protection Specialist
I upload videos on:
📌 Microsoft Excel
📌 Microsoft Powerpoint
📌 Professionals Resume Building Tips
📌 Interview Tips
📌 Book Reviews
📌 Free online learning sources
STAY IN TOUCH:
Facebook: / askshashank
Instagram: / askshashank
Linkedin: / shashankw. .
*************************************************************
Watch these interesting videos:
✔ VlookUp for Beginners:
www.youtube.co....
✔ Advance Excel Functions:
www.youtube.co....
✔ Convert Linkedin into Resume PDF:
www.youtube.co....
✔Learn Excel Pivot Table:
www.youtube.co....
************************************************************
This video is related to:
risk,risk assessment,risk management,risk assessment and management,risk reduction and disaster management,disaster risk reduction in hindi,risk reduction,crisis management strategies,crisis management plan,business continuity planning,asis,psp,cpp tutorial,risk assessment training video,risk assessment and internal control,risk assessment matrix,information security risk management,information security risk assessment

[@rksingh8551]

Great. Very usefull information shared.

[@CorporateGuy]

Thank you ☺️

[@dvictorjayaseelan8889]

Excellent..Shashank...I am becoming your fan now...

[@CorporateGuy]

Thank you so much sir,,,it great to have you in my professional network...

[@mahee03ful]

Excellent!

[@CorporateGuy]

Thank you ☺️

[@kU-uc3gl]

good job

[@advento0939]

Great, i loved this.

[@AbdulMajeed-hx4jv]

Good

[@geetanjalithakur7036]

Keep it up👍👍

[@raniaafifa3382]

Thank you this is very helpful. I'd like to ask, what if we use the risk ID and title for the sentence in the risk matrix? Do we re-use the textjoin formula to combine them?

[@MrShailendra612]

Good going Shashank...

[@CorporateGuy]

Thank you sir 😊

[@MrShailendra612]

@@CorporateGuy shashank how about to develop excel based security daily situation report dashboard... actually i already did but i like you to develop the same such kind

[@CorporateGuy]

Sure no problem we will do that,,let me know what do you want to include in that report

[@MrShailendra612]

@@CorporateGuy
1. Daily deployment
2. Visitors
3. Contract manpower
4. Material movement with previous day balance
5. Material receipt
6. OGP movement
7. Commute vehicles movement
8. SAS footfall
9. Security incident trends
10. Miscs

[@CorporateGuy]

Okay got it 👍

[@zeenee1262]

Pls provide a solution for this on excel 2007
Many thanks

[@zeenee1262]

Dont know abt VBA

[@suhasranalkar5250]

Thanks. Can we use same formula in lower version of excel ? If No please suggest alternate solution.

[@CorporateGuy]

I think you can't use it in below 2019 but if know little bit of VBA,,,I think this article might help you
stackoverflow.com/questions/45843881/textjoin-udf-for-excel-2013
Otherwise I will find another alternative

[@user-ef9ic5ei7x]

Please share the xls file link

[@mbusozulu1126]

My excel cannot pick up the risk table when applying the textjoin formulae for impact and probabilty

[@CorporateGuy]

You neee to make sure that you are using the latest version

[@user-ef9ic5ei7x]

There is no download file in description

[@CorporateGuy]

Will share, thanks for infor

[@prasad08888]

@@CorporateGuy Dont see file in the description to download

[@CorporateGuy]

Hi, I am really sorry I have lost that file. I will try to find it and upload the link.