This course covers prescribed curriculum by IFoA and IAI for CM1 B including MS Excel and Modeling in MS Excel for Actuarial Science.
The paper covers topics like Annuaties, Feasibility Study, Life Insurance Pricing & Reserving etc.
White Knight Ventures was the first in industry to start MS Excel & R For Actuarial Science in 2015 for training insurance companies and actuarial students alike.
CM1B (MS Excel for CM1)
Updated as per latest guidelines by IFoA and IAI till 2021.
Addresss and Text Formulae
Shortcuts, Custom Formatting and Data Validation
Paste Special and VLookup
Vlookup, And, Or and If Functions
If, Lookup Functions, Index Match, Indirect
Datedif, Custom Formatting, Index Match
Sumif, Date Formulae, Sumproduct, PMT, PPMT, PV, Text to Column
Sumif, Countif, External Data, Formula Auditing, Offset, Loan Schedules, Errors
Advance Filter, VLookup with Match, Conditional Formatting
Pivot Table
Charts and What If Analysis
CM1B Doubts
Loan Schedules Class
Premium Calculation and Reserves Part 1
Premium Calculation and Reserves Part 2
Project Appraisal Class