This course was previously known as DGT087: Robotic Process Automation (RPA), Visual Basic for Applications (VBA) and ChatGPT Designed for Accountants by Accountants (Classroom)
It is mandatory for all participants to be equipped with a laptop (Microsoft OS, Windows 10, 4 gig ram, i5 core), pre-installed with either Microsoft Excel 2010, 2013, 2016 (full licence) or any latest version, to optimise the learning experience. If you have a Microsoft Office 365 subscription, you will need to have a locally installed Excel 365 application in your PC or laptop. Macros cannot be executed when the workbook containing them is opened in Excel online. Also, kindly note that Mac Excel version has limited Excel functionality.
This comprehensive course is designed to empower accounting and finance professionals to use robotic process automation (RPA) and visual basic for applications (VBA) to build robots that can automate accounting and finance processes.
On the completion of this course, you will be able to:
- Understand the potential of RPA, VBA, ChatGPT, and Copilot for accounting and finance processes.
- Perform Prompt engineering with ChatGPT and Copilot to generate VBA code and explore the potential of ChatGPT and Copilot for accounting and finance processes.
- Utilise VBA macros to automate accounting processes.
- Create basic RPA robots for accounting processes using Microsoft Power Automate Desktop.
- Develop a digital transformation plan with consideration to implementation steps and change management for their organisation.
Programme Outline
Introduction to RPA, VBA, ChatGPT and Copilot
- Overview of RPA, VBA, ChatGPT, and Copilot
- Understand the benefits and potential of RPA, VBA, ChatGPT and Copilot in the accounting and finance domain
- Discuss how these tools can enhance and changing existing job roles
- Practical use cases for these tools for these different job roles
Hands-on Session: Using ChatGPT and Copilot to generate code
- Step-by-step guidance on interacting with ChatGPT and Copilot
- Set-up to keep information confidential for PDPA purposes
- Provide pre-built prompts for different use cases to initiate conversations with ChatGPT and Copilot
- Explore structure queries in order to maximise the effectiveness of ChatGPT in generating accurate responses
- Introduction to prompt engineering
- Generate and run code to automate accounting and finance processes.
Hands-on Session: Building VBA macros
- Fundamentals of VBA
- Write VBA macros with ChatGPT and Copilot Assistance
- Utilise VBA to automate accounting processes in Excel
- Sales calculations
- Approval Checks against approval matrixs
- Split data into different listings for approvals
- Compiling sales data from various sheets into Masterfile for analysis
- Debugging and Refining ChatGPT and Copilot generated codes
Hands-on Session: Building RPA robots
- Fundamentals of RPA
- Build 4 RPA robots for accounting processes
- Data entry into accounting systems
- Data extraction from accounting systems
- Sending customized mass emails
- PDF extraction
Developing a Digital Transformation Plan for your company
- Identify potential use cases and create a roadmap for digital transformation
- Explore the steps and considerations for implementing digital solutions within an organisation
- Understand the importance of change management in implementing digital transformations
- Discuss strategies to address challenges, overcome resistance, and ensure successful adoption of such technologies
Please note that the duration of each session is approximate and can be adjusted as per the requirements and pace of the participants.
Training Methodology
Facilitated learning which includes classroom or practical sessions in a workshop.
Closing Date for Registration
1 Week before Programme or Until Full Enrolment.
Intended For
Accountants, auditors, tax professionals, finance professionals, corporate secretarial professionals and admin staff from different staff levels, including accounts executives, accountants, managers and directors.
Competency Mapping
Category 5 = 14.00 Hours
Schedule & Fees
Date & Time
23 Jun 2025 (9:00 AM - 5:00 PM)
24 Jun 2025 (9:00 AM - 5:00 PM)
Fee (inclusive of GST)
SGD pricing -
For Members:
$ 779.35
For Non-Members:
$ 925.41
Programme Facilitator(s)
Daryl Aw
Venue
60 Cecil Street
ISCA House
Singapore 049709
Date & Time
22 Sep 2025 (9:00 AM - 5:00 PM)
23 Sep 2025 (9:00 AM - 5:00 PM)
Fee (inclusive of GST)
SGD pricing -
For Members:
$ 935.22
For Non-Members:
$ 1,110.71
Programme Facilitator(s)
Daryl Aw
Venue
60 Cecil Street
ISCA House
Singapore 049709
Date & Time
04 Dec 2025 (9:00 AM - 5:00 PM)
05 Dec 2025 (9:00 AM - 5:00 PM)
Fee (inclusive of GST)
SGD pricing -
For Members:
$ 935.22
For Non-Members:
$ 1,110.71
Programme Facilitator(s)
Daryl Aw
Venue
60 Cecil Street
ISCA House
Singapore 049709
Testimonial
Funding
1] NTUC Union Training Assistance Programme (UTAP)
NTUC members enjoy 50% *unfunded course fee support for up to $250 each year when you sign up for courses supported under UTAP. NTUC members aged 40 and above can enjoy higher funding support up to $500 per individual each year, capped at 50% of unfunded course fees, for courses attended between 1 July 2020 to 31 December 2025.
*Unfunded course fee refers to the balance course fee payable after applicable government subsidies. This excludes material fees, registration fees, misc. fees etc.
This course is approved for UTAP support for intakes conducted between 05 December 2024 – 31 March 2025.
As UTAP is given on calendar year basis, and calculated based on year of training taken, it cannot be accumulated.
- Maintained paid-up NTUC membership before course, throughout course duration and at the point of claim and;
- Course by training provider must be supported under UTAP and training must commence within the supported period and;
- Unfunded course fee must not be fully sponsored by company or other types of funding
- Unfunded course fee must be S$20.00 and above, and;
- Member must achieve a minimum of 75% attendance for each application and sat for all prescribed examination(s), if any and;
- UTAP application must be made within 6 months after course ends.
For more information on UTAP Funding and to submit for UTAP claims, please visit https://www.ntuc.org.sg/uportal/programmes/union-training-assistance-programme. Terms and conditions apply.
Programme Facilitator(s)
Daryl Aw
Daryl Aw is the founder and Managing Director of Skybots Pte Ltd in Singapore. Skybots provides automation solutions for accounting, tax, audit, corporate secretarial, finance and sustainability processes, helping companies in their digital transformation journey. These solutions involve using Robotics Procession Automation (RPA), data analytics and Artificial Intelligence tools such as ChatGPT to automate tedious and repetitive processes for companies to successfully achieve significant productivity gains. These robots can be seen here: https://www.skybotssg.com/
He was previously a lecturer in Singapore Polytechnic leading the accounting faculty in RPA and Sustainability projects. He was the lead in Strategic Partnerships leading collaborations with the Singapore Accountancy Commission (SAC), the Institute of Singapore Chartered Accountants
(ISCA) and the National Council of Social Services (NCSS).
He has overseen the implementation of more than 100 robots for more than 300 organisations. In 2021, he emerged as the champion at the ISCA RPA Hackathon. In 2022, he was nominated for The President’s Awards for Teachers.
Before joining Singapore Polytechnic, he was an auditor with EY Singapore providing auditing services to public listed and private companies in various industries. He is a Chartered Accountant with ISCA.
This course was previously known as DGT087: Robotic Process Automation (RPA), Visual Basic for Applications (VBA) and ChatGPT Designed for Accountants by Accountants (Classroom)
It is mandatory for all participants to be equipped with a laptop (Microsoft OS, Windows 10, 4 gig ram, i5 core), pre-installed with either Microsoft Excel 2010, 2013, 2016 (full licence) or any latest version, to optimise the learning experience. If you have a Microsoft Office 365 subscription, you will need to have a locally installed Excel 365 application in your PC or laptop. Macros cannot be executed when the workbook containing them is opened in Excel online. Also, kindly note that Mac Excel version has limited Excel functionality.
This comprehensive course is designed to empower accounting and finance professionals to use robotic process automation (RPA) and visual basic for applications (VBA) to build robots that can automate accounting and finance processes.
On the completion of this course, you will be able to:
- Understand the potential of RPA, VBA, ChatGPT, and Copilot for accounting and finance processes.
- Perform Prompt engineering with ChatGPT and Copilot to generate VBA code and explore the potential of ChatGPT and Copilot for accounting and finance processes.
- Utilise VBA macros to automate accounting processes.
- Create basic RPA robots for accounting processes using Microsoft Power Automate Desktop.
- Develop a digital transformation plan with consideration to implementation steps and change management for their organisation.
Programme Outline
Introduction to RPA, VBA, ChatGPT and Copilot
- Overview of RPA, VBA, ChatGPT, and Copilot
- Understand the benefits and potential of RPA, VBA, ChatGPT and Copilot in the accounting and finance domain
- Discuss how these tools can enhance and changing existing job roles
- Practical use cases for these tools for these different job roles
Hands-on Session: Using ChatGPT and Copilot to generate code
- Step-by-step guidance on interacting with ChatGPT and Copilot
- Set-up to keep information confidential for PDPA purposes
- Provide pre-built prompts for different use cases to initiate conversations with ChatGPT and Copilot
- Explore structure queries in order to maximise the effectiveness of ChatGPT in generating accurate responses
- Introduction to prompt engineering
- Generate and run code to automate accounting and finance processes.
Hands-on Session: Building VBA macros
- Fundamentals of VBA
- Write VBA macros with ChatGPT and Copilot Assistance
- Utilise VBA to automate accounting processes in Excel
- Sales calculations
- Approval Checks against approval matrixs
- Split data into different listings for approvals
- Compiling sales data from various sheets into Masterfile for analysis
- Debugging and Refining ChatGPT and Copilot generated codes
Hands-on Session: Building RPA robots
- Fundamentals of RPA
- Build 4 RPA robots for accounting processes
- Data entry into accounting systems
- Data extraction from accounting systems
- Sending customized mass emails
- PDF extraction
Developing a Digital Transformation Plan for your company
- Identify potential use cases and create a roadmap for digital transformation
- Explore the steps and considerations for implementing digital solutions within an organisation
- Understand the importance of change management in implementing digital transformations
- Discuss strategies to address challenges, overcome resistance, and ensure successful adoption of such technologies
Please note that the duration of each session is approximate and can be adjusted as per the requirements and pace of the participants.
Training Methodology
Facilitated learning which includes classroom or practical sessions in a workshop.
Closing Date for Registration
1 Week before Programme or Until Full Enrolment.
Intended For
Accountants, auditors, tax professionals, finance professionals, corporate secretarial professionals and admin staff from different staff levels, including accounts executives, accountants, managers and directors.
Competency Mapping
Category 5 = 14.00 Hours
Programme Facilitator(s)
Daryl Aw
Daryl Aw is the founder and Managing Director of Skybots Pte Ltd in Singapore. Skybots provides automation solutions for accounting, tax, audit, corporate secretarial, finance and sustainability processes, helping companies in their digital transformation journey. These solutions involve using Robotics Procession Automation (RPA), data analytics and Artificial Intelligence tools such as ChatGPT to automate tedious and repetitive processes for companies to successfully achieve significant productivity gains. These robots can be seen here: https://www.skybotssg.com/
He was previously a lecturer in Singapore Polytechnic leading the accounting faculty in RPA and Sustainability projects. He was the lead in Strategic Partnerships leading collaborations with the Singapore Accountancy Commission (SAC), the Institute of Singapore Chartered Accountants
(ISCA) and the National Council of Social Services (NCSS).
He has overseen the implementation of more than 100 robots for more than 300 organisations. In 2021, he emerged as the champion at the ISCA RPA Hackathon. In 2022, he was nominated for The President’s Awards for Teachers.
Before joining Singapore Polytechnic, he was an auditor with EY Singapore providing auditing services to public listed and private companies in various industries. He is a Chartered Accountant with ISCA.