VBA for Accountants by Accountants

ACC_DGT050i

English

Course Description

Synopsis:

The accounting sector often faces extensive workloads, characterized by manual and repetitive tasks. In response to current economic pressures, companies are increasingly striving to reduce overhead costs. Visual Basic for Applications (VBA) emerges as one of the essential tools that accountants can leverage to automate tax, audit, accounting, finance, and corporate secretarial processes, resulting in substantial productivity gains.

In this comprehensive course, Daryl Aw, the founder and MD of Skybots, will provide step-by-step guides and real-world examples of VBA in action. By the end of this course, you will be able to pave the way for a more efficient and productive professional practice.

This course will cover the following: - 

  • Introduction to VBA
  • Using ChatGPT and Copilot to generate VBA code
  • Practical examples in accounting and finance

 

Intended For:

  • Audit Professionals / PAIP 
  • Finance Professionals  / PAIB 
  • Public Sector Finance
  • Business Owners

 

Competency Mapping:

  • CPE Category 5 = 1.5 Hours
Instructor Image

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.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.
View profile

Course Rating

4

Speaker's Rating

4

1.5 CPE Hours

Lesson(s)

6

Related courses

Maximising Resource Efficiency in Accounting Practices with AI

Creating a Dashboard in Excel

Building the Digital Fortress: Safeguarding Against Cyber Fraud (Part TWO)

Building the Digital Fortress: Safeguarding Against Cyber Fraud (Part ONE)

What We Can Learn from Cryptocurrency Scams: Top 5 Warning Signs

Tech3 Forum 2024 Accounting and Finance Track: Technology in Finance: The Future Imagined

RPA Using Power Automate for Accountants by Accountants

RPA for Accountants by Accountants: Creating an Action Plan

ChatGPT and Copilot for Accountants by Accountants

Designing an Excel Template for Accounting Tasks: Efficiency Starts Here (Part 2)

Designing an Excel Template for Accounting Tasks: Efficiency Starts Here (Part 1)

Risk Management in the Cyber and Digital Era

Learn anytime, anywhere.

Connect with us

Useful Links