A Practical Introduction 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.
- What macros do and when to use them
- Overview of the VBA model
- 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.)
This course will provide 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.
Dates & Time:
26/09/2022, 09:00 – 11:15 (including 15 mins break)
27/09/2022, 09:00 – 12:15 (including 15 mins break)
Venue: Live online session – details of how to join the meeting will be sent once registration is complete
Early Bird Fee: €90 if purchased before 01/09/2022
Standard Fee: €110
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 each session.
Dylan Seracino, Advisor, Accounting Advisory Services, KPMG in Malta
Dylan holds the role of Advisor 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.
Kindly note that 5 KPMG Loyalty Rewards will be awarded to the first 10 bookings. After collecting 60 Loyalty Rewards, attendees will be entitled to a free CPE session of their choosing. Visit our Loyalty Rewards page to learn more.
Moreover, for every three courses booked from our KPMG Learning Suites, attendees receive a discount voucher of 40% to be redeemed on their next course purchased from any Learning Suite!
Discover more courses from our KPMG Learning Suites.
Is your employer paying for your CPE seminars? Contact us on firstname.lastname@example.org to discuss how the employer can benefit from our offers.
- Guided Learning 2 hours
- Language English