Intro to Visual Basic for Applications for Excel

By the end of the training, participants will be able to:

• Begin writing code in Microsoft’s Visual Basic for Applications, having gained the knowledge required to do so
• Use VBA in their workplace and improve their work efficiency

This course is designed for professionals,whose role requires the frequent use of Excel, such as financial controllers, accounts clerks, etc.

Pre-Requisites:  A working knowledge of Microsoft Excel is essential.

Participants are required to use laptops (instead of other devices) for more convenience and arrange the Microsoft Excel to be installed on them prior to the webinar's date.

Sessions (DAY 1: 10:00 a.m. – 12:15 p.m., DAY 2: 10:00 a.m. - 1:15 p.m. including a 15-min break between sessions)

• What macros do and when to use them
• Overview of the VBA model
• Objects
• Properties
• Methods
• Variables and constants
• VBA Environment (how to access / important windows)
• Recording Macros

If you wish to register for the webinar, please complete the registration form.

Once your registration is submitted, you will receive an email stating the participation fee, including any discounts, if applicable. Kindly note that the payment should be settled at least two days prior to the webinar’s date for your registration to be confirmed.

If you do not receive our confirmation e-mail regarding your registration, your participation cannot be guaranteed.

Cost

€110 + VAT

Discounts available

• For more than two (3+) participants from the same company a 10% discount is available on the total cost, before the VAT and HRDA subsidy (when available). This discount only applies for participants who enrol in the same training, on the same day. This discount can only be combined with the early bird discount and the HRDA subsidy, when applicable.
• There is a 10% discount for alumni members. This discount should be applied before the VAT and HRDA subsidy and can only be combined with the early bird discount and the HRDA subsidy, when applicable. For more information on our alumni scheme, click here.  

For any queries, please contact Irini Avraam on +357 22 207 460 or at academy@kpmg.com.cy.

CPD: This webinar may contribute to Continuing Professional Development requirements. Shortly after the webinar’s date, participants will receive electronically a certificate of attendance confirming the total number of training hours (5 CPD).

Dylan Seracino
Advisor, Accounting Advisory Services, KPMG in Malta

Dylan is an Advisory Assistant within the Accounting Advisory Services (AAS) team in Malta, providing technical advice and assistance to clients in achieving compliance with accounting standards. Following a three-year period as a trainee with KPMG Malta, Dylan joined the AAS team on a full-time basis in March 2020. He provides technical advice to clients operating in diverse industries. Dylan has been involved in the preparation of financial statements for multiple clients across diverse industries. He has also been an integral team member in developing MS Excel based accounting tools such as Expected Credit Loss models for financial instruments and depreciation models for property, plant and equipment. Dylan is also passionate on assisting clients with automated functions and tailor-made solutions in accordance with the financial reporting requirements emerging from IFRS. His dissertation, in partial fulfilment for the award of the Master’s in Accountancy degree, explored the management accounting systems used by micro-joiners in Malta.