ACTEX Learning Presents:
ACTEX eLearning Webinar:
Data Visualization Practices and Principles in Excel
July 18, 2018 from 1:00 to 2:30 PM Eastern Time
Co-Sponsored by the Canadian Institute of Actuaries
1.8 SOA CPD, CAS CE Credits/Training Hours
This is a potential source of 1.5 hours of CPD for the Canadian Institute of Actuaries
All prices are in USD
Actuaries do a great job of analyzing data and models, but often fall short in effectively communicating results. This can be especially true in the area of data visualization. This session will explore how to create the most effective visualizations for different types of data regularly used by actuaries, providing examples in Excel, the spreadsheet regularly used by actuaries. Join us to build your skills with the tool you already use.
- Establish and expand upon principles of data visualization with emphasis on how to improve graphs to relay information visually
- Review the most effective ways to illustrate various types of data including:
1. Time series
2. Categorical and grouped data
3. Multidimensional data sets
4. Large data sets
5. Data with geographic components
- Recognize ways to visualize data within the spreadsheet itself – not just by using the graphing functions and charts including:
1. Conditional formatting
3. Tile grid maps
Who Should Attend This Webinar?
Any actuary or financial professional interested in improving data communication through visualization using Excel.
Mary Pat Campbell, FSA, MAAA, PRM
Instructor Mary Pat Campbell, FSA, MAAA, PRM, is Vice President, Insurance Research at Conning in Hartford, Connecticut. In the past, she also taught 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, such as at the 2015 SOA Annual Meeting: "Session 30: How to Keep Your Spreadsheets Out of the Headlines". Over the past two years, she has written a series of 5 articles on data visualization for CompAct, the newsletter of the SOA Technology Section. She is a member of the European Spreadsheet Risks Interest Group and on the SOA Modeling Section Council (2015 - 2018).
The registration fee includes 180-day unlimited on-demand access to this event and the handouts. All prices are in USD.
Multi-Connection Corporate Customers: ACTEX will provide a self-registration site and activation key for your participants. The first 100 will be enrolled in this webinar. This makes it easy to offer continuing professional development opportunities without the need for administrative attention.
Please Note: Participants must agree to the ACTEXeLearning.com Site Policy in order to access this webinar.
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.
Discount for Full-Time Students:
Students with current enrollment as a full-time student at any college/university are eligible for a 50% discount off ACTEX Webinar 1-2 participant options. In order to access this discount, please email proof of enrollment using your college/university e-mail address to Support@ActexMadRiver.com. Examples of enrollment proof would be a copy of your registration information, or an unofficial transcript.
Discount for Active Military Personnel:
Active U.S. Military personnel are eligible for a 50% discount off ACTEX Webinar 1-2 participant options. In order to access this discount, please email us at Support@ActexMadRiver.com from your military email address.
Discount for Educators:
Faculty members of any accredited higher-education institution are eligible for a 50% discount off ACTEX Webinars. In order to access this discount, please contact us via email at Support@ActexMadRiver.com using your college/university e-mail address.
Discount for Regulatory Actuaries:
Regulatory Actuaries (Regulators) are eligible for a 30% discount off ACTEX Webinars. In order to access this discount, please contact us via email at Support@ActexMadRiver.com using your government e-mail address.