Principles for Actuarial Spreadsheet Design with Mary Pat Campbell, FSA, MAAA, PRM

Principles for Actuarial Spreadsheet Design with Mary Pat Campbell, FSA, MAAA, PRM

December 9th, 2015 from 1:00pm – 2:00pm EST

This course qualifies for 1.2 SOA CPD and CAS CE Credits.

http://ift.tt/1I8Zedk

Specific topics to be covered include:
• Considering why one should (or should not) do certain things, not only how.
• How to structure the flow of information through your spreadsheet together with appropriate documentation
• Building spreadsheets with future changes in mind
• Why using the INDEX/MATCH combination is preferable to VLOOKUP
• Considerations on the use of Named Ranges


Principles for Actuarial Spreadsheet Design with Mary Pat Campbell, FSA, MAAA, PRM