Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > General Actuarial
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

DW Simpson
Actuarial Jobs

Visit our site for the most up to date jobs for actuaries.

Actuarial Salary Surveys
Property & Casualty, Health, Life, Pension and Non-Tradtional Jobs.

Actuarial Meeting Schedule
Browse this year's meetings and which recruiters will attend.

Contact DW Simpson
Have a question?
Let's talk.
You'll be glad you did.


General Actuarial Non-Specific Actuarial Topics - Before posting a thread, please browse over our other sections to see if there is a better fit, such as Careers - Employment, Actuarial Science Universities Forum or any of our other 100+ forums.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 11-24-2015, 03:06 PM
santi.actex's Avatar
santi.actex santi.actex is offline
Member
Non-Actuary
 
Join Date: Sep 2014
Location: Winsted, CT
College: Franciscan University Alumni
Favorite beer: Yuengling Traditional Lager
Posts: 222
Default Upcoming Webinar: Principles for Actuarial Spreadsheet Design

Introducing ACTEX's New Webinar Series for Professional Development!
Secure your spot for December 9th!


Early bird pricing available through December 1st!
Group pricing and college student discounts available, see below for details!



Whether you are a newcomer to actuarial spreadsheet design or have been practicing for years, this 1-hour session will cover high-level principles of spreadsheet design with a special focus on actuarial needs and issues, as well as specific practical implementation tips.

The webinar will be instructed by Mary Pat Campbell, FSA, MAAA, PRM, who is Vice President, Insurance Research at Conning in Hartford, Connecticut. Mary Pat also teaches courses on computing (Excel, Access, and VBA) and business writing for actuarial science students at the University of Connecticut.

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

Pricing:
1-2 participants: $49 **Early bird pricing available through 12/1**

Discounts for groups using one connection are available; please call customer service to place a group order.

Enroll today on ActexMadRiver.com
Reply With Quote
  #2  
Old 11-24-2015, 05:38 PM
Malcolm's Avatar
Malcolm Malcolm is offline
Member
CAS AAA
 
Join Date: Apr 2007
Location: the Middle
Posts: 4,343
Default

This webinar overlaps with an Academy professionalism webinar. That could cut into your target audience as we near the end of the year and folks make sure they've got that all-important professionalism CE.
__________________
Life is unfair
Reply With Quote
  #3  
Old 11-24-2015, 06:14 PM
2pac Shakur 2pac Shakur is offline
Member
SOA
 
Join Date: Jun 2003
Location: short
Posts: 94,211
Default

Yea - I saw this - by Mary Pat Campbell.
Head of the anti-vlookup brigade.


Index Match sucks!
Long live vlookups!
__________________
Reply With Quote
  #4  
Old 11-24-2015, 06:15 PM
santi.actex's Avatar
santi.actex santi.actex is offline
Member
Non-Actuary
 
Join Date: Sep 2014
Location: Winsted, CT
College: Franciscan University Alumni
Favorite beer: Yuengling Traditional Lager
Posts: 222
Default

Hi Malcom,

Thank you for bringing this to our attention. Unfortunately we can not change the webinar date/time, but please note that a recording of the webinar will be available for 180 days after the live session.
Reply With Quote
  #5  
Old 11-24-2015, 06:25 PM
whoanonstop's Avatar
whoanonstop whoanonstop is offline
Member
Non-Actuary
 
Join Date: Aug 2013
Location: Los Angeles, CA
Studying for Spark / Scala
College: College of William and Mary
Favorite beer: Orange Juice
Posts: 5,899
Blog Entries: 1
Default

Quote:
Originally Posted by 2pac Shakur View Post
Yea - I saw this - by Mary Pat Campbell.
Head of the anti-vlookup brigade.


Index Match sucks!
Long live vlookups!
There are people who still use VLOOKUP?

-Riley
__________________
Reply With Quote
  #6  
Old 11-24-2015, 06:29 PM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 90,502
Blog Entries: 6
Default

You don't have your professionalism credit for the year yet?

It's pretty difficult to avoid all the other webcasts going on. As Santi says, after the session, those who register will have access to the recording of the session.

And yes, I will address the VLOOKUP vs. INDEX/MATCH controversy (among other things).
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #7  
Old 11-24-2015, 06:31 PM
2pac Shakur 2pac Shakur is offline
Member
SOA
 
Join Date: Jun 2003
Location: short
Posts: 94,211
Default

Quote:
Originally Posted by whoanonstop View Post
There are people who still use VLOOKUP?

-Riley
smrt people
__________________
Reply With Quote
  #8  
Old 11-24-2015, 06:45 PM
Malcolm's Avatar
Malcolm Malcolm is offline
Member
CAS AAA
 
Join Date: Apr 2007
Location: the Middle
Posts: 4,343
Default

Quote:
Originally Posted by whoanonstop View Post
There are people who still use EXCEL?

-Riley
IFYP
__________________
Life is unfair
Reply With Quote
  #9  
Old 11-24-2015, 06:46 PM
Malcolm's Avatar
Malcolm Malcolm is offline
Member
CAS AAA
 
Join Date: Apr 2007
Location: the Middle
Posts: 4,343
Default

Quote:
Originally Posted by campbell View Post
You don't have your professionalism credit for the year yet?
.
Working on 2016. Maybe 2017.
__________________
Life is unfair
Reply With Quote
  #10  
Old 11-24-2015, 06:47 PM
2pac Shakur 2pac Shakur is offline
Member
SOA
 
Join Date: Jun 2003
Location: short
Posts: 94,211
Default

Quote:
Originally Posted by Malcolm View Post
IFYP
MAN!
you are the kewlest actuary EVER
__________________
Reply With Quote
Reply

Tags
actex, excel, professionalism, spreadsheet, webinar

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 11:11 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.20046 seconds with 9 queries