ANNOUNCEMENT

MICROSOFT EXCEL MACROS AND EXCEL VBA WEBINAR SERIES 2022

I. ABOUT THE PROGRAM

Microsoft Excel is a widely used software by a common person for all their regular use and work. The application is so handy and popular in nature, which always accessible at the fingertip, hence makes it as the most convenient and useful application for developing customised models for personal and office related solutions. There are many advance features of Excel yet to be explored by members of the Actuarial profession, even after long years of their association with the tool, particularly the most prominent features like MACROS and Excel VBA. Learning advanced excel, including VBA, Macros and .net may be an added advantage and investment for an actuarial student for their journey to the qualification and employability. The opportunity to learn from an expert faculty could be a feather on the cap.

Most employers are looking for actuarial resources, irrespective of the class and category of employment assumes a commanding knowledge in Excel and VBA, without which the “performance matters”; the training program also envisages to offer this unique opportunity of learning.

Why Actuaries to master Microsoft EXCELVBA and EXCEL MACROS?

VBA is acronym for Visual Basic for Applications. Excel VBA is Microsoft’s programming language, which can be used to write MACROS in Excel and also works with the other Microsoft Office programs, like Word and PowerPoint. Actuarial professionals often find themselves doing repeating tasks in excel like copy-pasting subsets of data to different sheets, and sometimes the tasks are more complex like uploading data to a website. With VBA, macros can be programmed to automate tasks like these, turning a series of manual operations into a single button click

Gaining expertise and command over excel macros and excel VBA and its advanced features may be a game changer for a candidate. This MS Excel skill has been primary and will remain as primary requirement for all future times for better and smarter performance. At the time of Actuaries expanding their horizon to Data science and analytics, the Excel Macros and VBA will make a huge difference between those who “Know and do not Know”

II. PROGRAM SCHEDULE:

Webinars will start on 25th April 2022, which will be conducted in 15 sessions of 90 minutes each duration. Participants expected to work on their assignments on a regular basis to maintain the continuity of learning and practice. Details of the program along with contents are available in ANNEXURE-I

Recorded videos of all webinars will be made available in the member’s login page till 30th June, 2022- Daily Timing 7.00PM-8.30PM. However, it is highly recommended to attend all LIVE sessions without fail for optimum benefit out of the program.

III. REGISTRATION:

• Registration fee

• Students : Rupees Three thousand (`3,000.00) only
• Fellows and Associates: Rupees Five Thousand ((`5,000.00) plus 18% GST
• Non-members : Rupees Eight Thousand (`8,000.00) plus 18% GST

• Registration menu : Login to IAI >>>Online coaching>>Registration
• Registration opens : On 31^st March, 2022 6.00PM.
• Registration closes : On 25^th April, 2022 00PM.

IV.FACULTY

Dr. Deepak Kumar Singh, PhD (IIT, Kanpur), MTech (IIIT, Allahabad) is the CEO of DK Infosolutions Private Limited and visiting faculty of Indian Institute of Information Technology, Lucknow. He is the Chair- Incubation centre at Jaipuria Institute of Management at Lucknow. He has also an advisor to many Companies, Institutions and the Government of UP for their different projects. A passionate teacher, he also has trained many executives and students in India, China, Japan, Singapore and Tanzania. He is also the Lead trainer, EY-IMT Ghaziabad joint course on Data Analytics.

V.BENEFITS OF ATTENDING THE PROGRAM:

• Unique opportunity to learn of end-to end of MS Excel Macros and Excel VBA
• Interacting with one of the best faculty in
• Best utilisation of interim period before next exam
• Learning excel using the daily spare time
• Highly subsidised fees
• For unemployed students, the training leads to higher employability
• For employed members, the program bring in better efficiency in work
• Helps to improve performance in CM1B, CM2B examinations
• High value addition for employments in wider areas like Data Science & Analytics

VI.CONTACT:

Point of contact for all related queries: Mr. Ravindra Mastekar at: ravindra@actuariesindia.org or 022 62433348

Program Schedule

March 31st, 2022