Risk Modelling with Microsoft Excel
DESCRIPTION
Given that, the ability to identify, assess and manage exposure to risk in an organization is integral to the pursuit of value, strategic-minded organizations have made a critical change from the traditional view of risk as something to avoid, but instead, develop models to manage risk exposures across all parts of their organizations so that, at any given time, they incur just enough of the right kinds of risk—no more, no less—to effectively pursue strategic goals. This practical and highly intensive Risk Modelling programme equips participants with the skills needed to develop a system and a set of tools for automating risk assessment, risk profiling based on risk matrix best practices and risk intelligence dashboards and reporting.By participating in this course participants will learn about:
- The Risk Modell Framework
- Designing risk Registers and Matrix – Tables and Parameters
- Automating risk assessment and profiling with Excel’s advanced functions and tools
- Developing a risk dashboard that measures and tracks Key Risk Indicators and presents a risk summary
- How to create a bevy of risk exposure and management charts and data visualizations to highlight key issues pertaining
- How to automate risk intelligence analytics and reporting
- Developing a mini-risk data warehouse