Actex Logo
ACTEX eLearning Webinar: Excel VBA for Beginners, Part 1 - Getting Started with VBA [Recording]
Author: Campbell
Availability: In-Stock
Publisher: ACTEX
Excel VBA for Beginners, Part 1 - Getting Started with VBA [1-2 participants & 1 connection] [Recording] - $69.00
Excel VBA for Beginners, Part 1 - Getting Started with VBA [3-9 participants & 1 connection] [Recording] - $199.00
Excel VBA for Beginners, Part 1 - Getting Started with VBA [10+ participants & 1 connection] [Recording] - $289.00
Excel VBA for Beginners, Part 1 - Getting Started with VBA [10+ participants & Multi-connection] [Recording] - $499.00

Share: 

ACTEXeLearning Presents:

ACTEX eLearning Webinar: Excel VBA for Beginners:
Part 1 - Getting Started with VBA

1.8 SOA/EA CPD, CAS CE Credits/Training Hours

 

For the complete beginner in VBA, this session is going to look at the basics of how to use VBA in Microsoft Excel. For those with some VBA experience, this session will give you the comprehensive overview needed to fully understand what VBA can do for you. Instructor Mary Pat Campbell will provide an overview of VBA's features so you can take the knowledge and apply it to your workflow. 

Specific topics covered will include:

  • Setting up the VBA environment in Excel
  • Navigating around the VBA editor
  • VBA "Stuff": Objects, Methods, and Events
  • Using the Macro recorder
  • Writing your first subroutine
  • Writing your first user-defined function
  • Resources for growth

Sound like a lot to cover in 90 minutes?  It is!  Mary Pat will present a second webinar on June 23rd that will build upon the topics covered in this session and apply it to automation within VBA. Whether you're new to Microsoft Excel's VBA functionality, or looking to understand all that VBA has to offer, this webinar is for you!


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).


PRICING

The registration fee includes access to the webcast recording and supplemental materials for up to 180 days.
All prices are in USD.


Please Note:  Participants must agree to the ACTEXeLearning.com Site Policy in order to access this webinar.

Discount for Full-Time Students:
Students with current enrollment as a full-time student at any college/university are eligible for a 50% discount. 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 the course tuition fee. 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 20% discount. In order to access this discount, please contact us via email at Support@ActexMadRiver.com using your college/university e-mail address.

Discount for Educators for Class Use:
Instructors at any accredited higher-education institution are eligible for a 50% discount off any of the 3+ Participants registration options for viewing with students. 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. In order to access this discount, please contact us via email at Support@ActexMadRiver.com using your government e-mail address.