Announcement: Access the latest SOA updates on COVID-19 at

Due to unusually high email volume in Customer Service, you may experience a longer response time than usual. We apologize for any inconvenience this may cause.

Advanced Training for Microsoft ® Excel: Making Data Cleanup Easy Webcast

August 9, 2017


Technical Skills & Analytical Problem Solving


Presented by

Smaller Insurance Company & Technology Sections


Noon-1:30 p.m. ET


This webcast takes place via the Internet.

Registration Fees

Registration is now closed. The SOA Customer Service Center is available to assist you Monday through Friday, 8:00 a.m. to 5:00 p.m. CDT. Please call +1-888-697-3900.

Who Should Participate

All actuarial users of Excel.


Are you tired of piecing together data provided in text files, Excel files, web pages and even the body of emails, just so you can get started with your analysis? Until now, updates have been tedious and error prone, with a great deal effort to cut and paste. This painful process stops today.

In this webcast you will learn how to clean, reshape and combine your data with ease, no matter where it comes from. Using the new Power Query engine in Excel, converting ASCII files into tables, combining multiple text files and even un-pivoting data is not only simple, but an investment in the future. Whether your data comes from a database or a collection of other sources, this incredible tool can help you transform horrible data structures into those that Excel loves to consume. It is refreshable with a single click!

If you need to learn one skill in Excel today, how to work with Power Query is it.  Not only will it change the way you get and transform data in Excel, but it's also the system used to collect data for Power BI desktop, meaning these skills are transferable to other programs. 

How the live webcast works and what it includes

You do not need any special equipment. On August 8, 2017, before 2:00 p.m. ET you will be sent detailed webcast instructions via email including the Web address for accessing the presentation. Any handouts that are available will also be sent.  You will follow along with both the slide presentation and the audio portion of the broadcast over the Internet.  The registration fee includes:

The registration fee includes:

  • One access code to the live webcast;
  • One Internet connection;
  • One phone connection (to be used only if experiencing sound issues or if in a conference room with a group);
  • One set of presentation materials; and
  • Access to the subsequent webcast recording.

Please note that each access code may only be used for  one location , even if you register for more than one participant.

Post-Webcast Purchase Opportunity

For those who are interested in SOA webcasts but are unable to participate in the live event, access to an archived recording of the webcast will be available for purchase approximately 10 business days following the event by using the following  link .