A Practical Introduction to Visual Basic for Applications for Excel

A Practical Introduction to Visual Basic for Applications for Excel

This course can be delivered to your organisation as part of our bespoke Corporate Training Solutions, at your own time and your own convenience. Contact us on kla@kpmg.com.mt or call us on +356 2563 6363 or on +356 9963 6363 for more information on how we can take care of your organisation’s training needs.

Course Description:

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.

Course Outline:

  • 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

Target Audience:  This course is designed for professionals in business whose roles requires the frequent use of Excel (financial controllers, accounts clerks, etc.)

Learning Outcomes:

This course provides attendees with the knowledge required to begin writing code in Microsoft’s Visual Basic for Applications. Attendees will be provided with a basis on which they can further develop their skills through the practical application of the knowledge gained through this course.

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

Venue: Kindly contact us on kla@kpmg.com.mt to indicate your preferred training method; online or in-person.

CPE Hours: This course qualifies for 5 hours of Structured CPE which can be classified as Professional Competency. A certificate of attendance will be provided at the end of the session.

Trainer:

Dylan Seracino, Assistant Manager, Accounting Advisory Services, KPMG in Malta

Dylan Seracino

Dylan holds the role of Assistant Manager 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 in Accountancy degree, explored the management accounting systems used by micro-joiners in Malta.

Discover more courses from our KPMG Learning Suites.


Is your employer paying for your CPE seminars? Contact us on kla@kpmg.com.mt to discuss how the employer can benefit from our offers.

Terms and conditions.

Course Features

  • Guided Learning 5 hours
  • Language English
  • Assessments
Dylan Seracino

Assistant Manager

Dylan holds the role of Assistant Manager within the Corporate Accounting Advisory Services (CAAS) 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 in Accountancy degree, explored the management accounting systems used by micro-joiners in Malta.