This video demonstrates how to automate risk assessment in excel. Once you select the impact score and the likelihood score, excel automatically finds out the overall risk assessment score.
This video also covers
-conditional formatting
-index function in excel
-match functions in excel
-and the combination of the index and match functions
-also shows how to create a drop-down list for fast data entry.