MICROSOFT EXCEL (SPREADSHEET)
And / Or Syntax
If Syntax
Iferror Syntax
Vlookup

Amortization Schedule
Formulation
How to create amortization schedule

Commutation Function for Life Table include calculating Net Single Premium (NSP) and Net Annual Premium (NAP)
Formulation
How to create commutation function for life table

Microsoft Excel (VBA)
Declaration variables
Link with Excel
Properties of Object

Command Button
Properties of Command Button

Conditional Structure
If ... Then ... Else
Select Case

Bond
Par Bond
Premium / Discount Bond
Callable / Putable Bond

Repetition Structure
For ... Next
Do ... Loop

Bond Amortization Schedule
Formulation
How to create bond amortization schedule

Commutation Function (Use For Next Loop)
Formulation
How to create commutation function for life table

Area Under the Graph (Use Do Loop)
Formulation
How to calculate area under the graph

Array Variables
Declaration
Dynamic Array
Multi Dimensional Array

User-Defined Function (UDF)
Properties of UDF
Declaration of variables

User Interface
Properties of User Interface
Declaration of variables (.text, .caption)
Calculation for reserve, changes in inputs that will affect the reserves and can relate with Value At Risk

Q1 : What is Actuarial Programming?
A1 : Actuarial Programming is a combination of Actuarial Science and Programming Language subject.