MS Excel For CM2 (Actuarial Science)

Teacher

Course Overview – Ms Excel for CM2 (Actuarial Science)

R for CM2 (Actuarial Science) is a course carefully designed to help Actuarial Science students understand the basics of R and it’s application in CM2.

Course Coverage:

The course covers topics such as Arithmetic Functions, Logical Functions, Lookup Functions, Data Visualisation in Excel, Portfolio Models, Efficient Frontier, Binomial Model, Black Scholes, Self-Financing Portfolio, Run-Off Triangles. The course provides holistic coverage of MS Excel as a software before moving into advanced application of CM2 topics.

For Whom?

This course is suitable for students appearing for CM2 Actuarial Science Exam from IFoA and IAI.

Course Features

Lectures 8
Quizzes 0
Duration 50 hours
Skill level All levels
Language English
Students 140
Assessments Yes

MS Excel 3
- Lecture1.1
  Basic Topics
- Lecture1.2
  Intermediate Topics
- Lecture1.3
  Advance Topics
Topics in CM2 5
- Lecture2.1
  Run-Off Triangles
- Lecture2.2
  Efficient Frontiers with Simulations
- Lecture2.3
  Portfolio Models
- Lecture2.4
  Binomial Models
- Lecture2.5
  Call Option Pricing & Delta Hedging