The global body for professional accountants

7
UNITS

Face-to-face event | ACCA

Automate Excel VBA using ChatGPT

Through engaging instruction and the guidance of ChatGPT, participants will discover how to wield the power of VBA macros with confidence and ease - equipped with the skills to write VBA code and automate tasks in Excel using ChatGPT.

Overview

Person touching huge screen

Embark on a transformative journey in this online workshop tailored for individuals eager to harness the magic of VBA programming but unsure of where to begin.

Through engaging instruction and the guidance of ChatGPT, participants will discover how to wield the power of VBA macros with confidence and ease.

By the end of this training, participants will emerge equipped with the skills to write VBA code, automate tasks in Excel, and unleash their creativity in spreadsheet automation with the help of ChatGPT.

  • VBA Fundamentals Overview: Begin with an introduction to VBA programming, covering essential concepts and principles.
  • Interactive VBA Workshop with Accounting Scenarios: Engage in hands-on activities tailored to accounting applications, where participants will automate diverse common accounting tasks within Excel.
  • Incorporating ChatGPT for VBA Macro Creation: Explore the utilisation of ChatGPT to facilitate the creation of VBA macros, allowing for seamless coding assistance and refinement.

Daryl Aw

Daryl is the founder and Managing Director of Skybots Pte Ltd. Skybots provides automation solutions for accounting, audit, tax, corporate secretarial and finance processes, helping companies in their digital transformation journey. These solutions involve using ChatGPT, Analytics and Robotic Process Automation (RPA) to automate tedious and repetitive processes for companies to successfully achieve significant productivity gains.

He was previously a lecturer in Singapore Polytechnic leading the accounting faculty in RPA and Sustainability projects. In his previous role as the lead in Strategic Partnerships in Singapore Polytechnic Business Innovation Centre, he led collaborations with different organisations such as the Singapore Accountancy Commission (SAC), the Institute of Singapore Chartered Accountants (ISCA) and the National Council of Social Services (NCSS) to drive digital transformation in the different sectors.

With 9 years of teaching experience, he has trained many students to implement RPA robots for industry partners, leading the collaboration between SP and ISCA to help SMPs adopt digital solutions in 2019 as part of IMDA’s Accountancy Industry Digital Plan. In 2022, he was nominated for The President’s Awards for Teachers. In 2021, he emerged as the champion at the ISCA RPA Hackathon.

Before joining Singapore Polytechnic, he was an auditor with EY Singapore providing auditing services to public listed and private companies in various industries. 

CPD units

Attendance to this session will accord you with 7.0 CPD units (ACRA Category 5). A CPD certificate will be sent to you by email within 2 business days after your completion of this workshop.

Requirements

Please bring along your own computer with wi-fi access and charging cable with Microsoft Office and Excel installed for this session.

What is Included

This workshop will include Lunch and two tea breaks. F&B Refreshments will be provided. Please check your dietary requirements when you book.

Price

Member 405 SGD

Affiliate 415 SGD

Approved employers 455 SGD

Student 415 SGD

Public 490 SGD

Location

Singapore

Date & time

26 May 2025

Course provider

ACCA logo