A new product will be added to your cart each time you click the Product button.
If additional options exist (checkboxes) to further customize your product and you'd like to choose one of the them, please select the option before clicking the product button to add to your cart.
Click here to edit your cart.
All prices shown in USD | Click here to view our digital terms
ACTEXeLearning Presents: ACTEX eLearning Webinar: Excel VBA for Beginners: Part 1 - Getting Started with VBA
For the complete beginner in VBA, this session looks 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 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 presented Part 2 of this webinar building upon the topics covered in this session, and applied them 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 (and part two) are for you!
About Your Instructor
Mary Pat Campbell, FSA, MAAA, PRM
Mary Pat Campbell, is Vice President of 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).