
Table of Contents/Timestamps
0:00 How to Use Excel Dark Mode
2:90 Using the Accounting Number Format Excel
7:45 How to Split Cells in Excel
11:19 How to Group Worksheets in Excel
13:50 How to Add Error Bars in Excel
17:53 How to Indent in Excel
21:28 Excel Format Painter - How to use it
26:02 How to Insert Checkboxes in Excel
34:27 How to Fix the Spill Error in Excel
38:27 How to Lock Cells in Excel
Table of Contents/Timestamps
0:00 How to Record a Macro in Excel
6:28 How to Delete a Named Range in Excel
10:39 How to Insert a Page Break in Excel
13:56 How to Fix Missing Scrollbar in Excel
17:26 How to Insert a Heat map in Excel
21:07 How to Fix the Name Error in Excel
26:18 How to Move Rows and Columns in Excel
30:06 How to Remove Space in Excel
32:52 How to Add Bullet Points in Excel
37:20 How to Make a Pie Chart in Excel
Ten Excel Tips and Tricks - Part 3 – Bonus
0:00 Freeze Rows in Excel
2:09 How to Convert Microsoft Excel to Word
5:23 How to Stop Excel rom Rounding
8:45 How to Calculate SUBTOTAL in Excel
12:02 How to Add an Excel Slicer
15:40 How to Graph a Function in Excel
19:42 How to Convert Text to Number in Excel
23:35 How to Copy Visible Cells Only
29:02 How to Add a Secondary Axis in Excel
37:32 How to Select Non-Adjacent Cells in Excel
This course covers the fundamentals of financial risk management, with a focus on practical implementation and application. It will focus on variety of risks that financial managers face and the tools available for managing them. Particularly, we shall focus on credit risk, interest rate, foreign exchange risk, and operational risk.
Extreme market events are a key risk management concern, especially in the aftermath of the global financial crisis and the many unresolved issues it presented. We will be investigating some of the biggest financial shocks through case studies and solve these cases by applying the concepts acquired in this course.
The course seeks to explain what risk and risk management means in a corporate setting, common methods for managing and measuring risk and developing a risk management strategy.
Students attending this course are expected to have a basic knowledge of finance and accounting. This course is aimed at those who want to understand the essentials of risk management. Please note that this course does not serve as a preparation for the FRM exams.
After finishing this course, students will be able to:
• Distinguish between risk, uncertainty, and randomness
• Distinguish between risk management and risk measurement
• Understand the importance of risk governance
• Describe risk budgeting and understand its role in risk governance
• Realize the importance of managing people, processes, technology, and organizational structure for effective risk management
• Recognize the difference between idiosyncratic and systematic risks
• Define, classify, and distinguish between financial risks
• Identify and understand the principles of credit, foreign exchange, interest rate, and operational risk
• Recognize probability, standard deviation, Value-at-Risk (VaR), and scenario analysis/stress testing as risk measurement metrics
• Distinguish between risk prevention and avoidance
• Define and apply the concepts of self-insurance, risk shifting, and risk transfer
• Realize insurance as a way to transfer risks
• Recognize outsourcing and derivatives as two ways of shifting risk.
This course includes:
5+ hours of video tutorials
39 individual video lectures
Certificate of completion