ACTEX eLearning Webinar: Actuarial Technical Toolbox: Getting the Most Out of Excel
Preventing and Fixing Errors
1.8 SOA/EA CPD, CAS CE Credits/Training Hours
Let’s face it, spreadsheets are one of the largest workhorses in actuarial work and business work in general. Various groups organizations have developed best practices and guides for using Microsoft Excel, but very few focus directly the needs of actuaries. This webinar series will focus on the use and functionality of Microsoft Excel in an actuarial setting so you can add more technical skills to your technical toolbox! Excel 2010 used for examples, but applications work in all versions of Excel.
The second presentation in our Actuarial Technical Toolbox webinar series, Preventing and Fixing Errors, reviews and explores Microsoft Excel’s built-in tools for tracing errors in Microsoft Excel and the Microsoft Excel Visual Basic (VBA) Editor. Comprehension of these tools are sure to make your spreadsheets bulletproof!
The following tools and best practices will be demonstrated in great detail so you can follow along, and ask questions along the way:
- Debugging tools within the Microsoft Excel Visual Basic Editor
- Error-checking tools within Microsoft Excel
- Diagnosing formula errors
- Using data validation to prevent user errors.
Instructor Mary Pat Campbell, FSA, MAAA, PRM, is Vice President, Insurance Research at Conning in Hartford, Connecticut. She also teaches courses on computing (Excel, Access, and VBA) and business writing for actuarial science students at the University of Connecticut.
Mary Pat has had a long interest in spreadsheet best practices in actuarial work, writing for SOA publications on the topic since 2007. She has also spoken for SOA webcasts and at meetings on spreadsheet issues, most recently at the 2015 SOA Annual Meeting: "Session 30: How to Keep Your Spreadsheets Out of the Headlines". She is a member of the European Spreadsheet Risks Interest Group and on the SOA Modeling Section Council (2015 - 2018).
Who Should Attend?
Practicing actuaries and actuarial students who are looking to improve their Microsoft Excel skills within the actuarial profession.
EA Credit Information:
The Joint Board for the Enrollment of Actuaries (JBEA) has approved ACTEX as a qualifying sponsor of continuing professional education (CPE) programs for enrolled actuaries.
ACTEX believes in good faith that you may earn continuing professional education (CPE) non-core non-ethics credits under the Joint Board for the Enrollment of Actuaries (JBEA) rules for attending this webinar. The JBEA makes the final determination about what constitutes core, non-core, ethics, or non-ethics CPE and the number of CPE credit hours allocated.
The registration fee includes access to the webcast recording and supplemental materials for up to 180 days.
All prices are in USD.
Participants must agree to the ACTEXeLearning.com Site Policy in order to access this webinar.
Actuarial Technical Toolbox: Getting the Most Out of Excel” is an independent webinar series and is not affiliated with, nor has it been authorized, sponsored, or otherwise approved by Microsoft Corporation.
What is the difference between 10+ participants & 1-connection and 10+ participants & Multi-connection?
'Connection' refers to how many participants will access our Webinar by signing-in at ACTEXeLearning.com.
Customers who have purchased a 1-connection option will have the purchaser sign-in and share the video on their monitor (or via video-conference, Skype or other video sharing format) with up to the number of participants purchased for. Username and password information is not to be shared with the other participants.
Customers who have purchased our Multi-connection option will be sent login information and an access key. Each participant will then be able to login on their own computer, with their own username & password, at their own convenience.
- Access information is sent to the email address listed under Shipping Information on your order.
- If you have 8+ participants needing their own access you should select our Multi-connection option for the best value.
- All registrations include 180-day unlimited on-demand access to the Webinar and the handouts.