ΠΕΡΙΓΡΑΦΗ

KPMG Academy Cyprus has teamed up with KPMG Learning Academy (Malta) to co-host the webinar “A practical intro to Visual Basic for Applications for Excel”. 

Visual Basic for Applications (VBA) provides users with a platform, which can be used to automate repetitive tasks. VBA is often overlooked, even though it provides added layer of functionality and enhances the flexibility of Excel and other Microsoft Office applications. This course will highlight where VBA is best suited and practically show attendees how to best exploit this added functionality. During this short but helpful webinar, professionals will learn how to use VBA, automate their routine tasks, save time and improve their productivity.

The first day of the webinar will be mainly theoretical whereas the second day, participants will be guided to apply the new theory in practice and thus strengthen their skills. 

ΣΚΟΠΟΣ ΣΕΜΙΝΑΡΙΟΥ

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.

ΠΕΡΙΣΣΟΤΕΡΕΣ ΠΛΗΡΟΦΟΡΙΕΣ

Agenda

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

Trainer

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.