Programme Objective
The accounting sector is commonly plagued by voluminous work, manual and repetitive processes. Accounting practices are also under pressure to cut overhead costs in these trying times.
RPA is a simple and intuitive tool which can help reduce inefficiencies and inaccuracies of repetitive mundane tasks due to human error and limitation. Anyone without prior programming knowledge can easily pick up the skill to create and deploy an RPA robot to perform tasks such as data entry of journal entries into the accounting system, preparation of reports, and automating repetitive processes done by employees on a daily basis.
This course aims to equip participants with the skills to easily create simple and useful RPA scripts to identify such processes and implement automation on accounting and finance processes. Participants do not need to have prior coding or programming knowledge. At the end of the course, participants will be able to automate their own manual and repetitive processes, freeing up time for more value added tasks.
This course includes an in-class assignment
Programme Outline
Course Learning Outcomes
By the end of the course, learners will be able to:
A. Understand what RPA is and how it can automate processes
B. Identify types of accounting and finance processes suitable for RPA implementation
C. Participant will develop RPA scripts using case examples during the course under the guidance of the trainer
Course Content & Structure
| Topics | No. of Hours |
A | | Self-Reading |
| Day 1: 9am to 5pm Introduction to RPA | 0.5 hour (Live Webinar) |
B | Develop RPA scripts to automate selected audit processes through the following case examples using a RPA software (6.5 Hours): - Case study 1 – Accounts receivable confirmation preparation process
- Case study 2 – Data entry from excel working file to accounting system
- Case study 3 – data extraction from accounting system to excel
| 6.5 hours (Live Webinar) |
C | Day 2: 9am to 12pm - Case study 4 - Sending of emails (1 hour)
- Case study 5 – excel automation of reports (1.5 hours)
Discussion on the potential adoption of RPA within our organization and work and it’s benefit (0.5 hours) | 3 hours (Live Webinar) |
| Total Hours | 10hrs |
Notes to Participant:
- Participants to bring their own laptop (see note 2 below) that is downloaded with the following software:
b. Outlook application
c. Microsoft excel
- Specifications of the laptop: windows OS, i5, 8 gig RAM and have access to internet.
- Participants are required to complete and submit an individual RPA assignment together with a recording of the running script on the 2nd day of the training. Participants who have met the requirements of the assignment will be awarded with a Certificate of Competency.
Pre-requisites
Please take note of the following admission requirements:
- Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsory
- Mandatory for video camera to be turned on throughout the course
- Display your official name (as per NRIC) in Zoom, to facilitate attendance taking
Training Methodology
1.5 days training: Facilitated learning which includes virtual classroom or practical sessions in a workshop.
Closing Date for Registration
29 Oct 2020
Intended For
Accountants and finance professionals from different staff levels, including accounts executives, accountants, managers and directors.
Schedule & Fees
Testimonial
Funding
No funding Available!
Programme Facilitator(s)
Programme Objective
The accounting sector is commonly plagued by voluminous work, manual and repetitive processes. Accounting practices are also under pressure to cut overhead costs in these trying times.
RPA is a simple and intuitive tool which can help reduce inefficiencies and inaccuracies of repetitive mundane tasks due to human error and limitation. Anyone without prior programming knowledge can easily pick up the skill to create and deploy an RPA robot to perform tasks such as data entry of journal entries into the accounting system, preparation of reports, and automating repetitive processes done by employees on a daily basis.
This course aims to equip participants with the skills to easily create simple and useful RPA scripts to identify such processes and implement automation on accounting and finance processes. Participants do not need to have prior coding or programming knowledge. At the end of the course, participants will be able to automate their own manual and repetitive processes, freeing up time for more value added tasks.
This course includes an in-class assignment
Programme Outline
Course Learning Outcomes
By the end of the course, learners will be able to:
A. Understand what RPA is and how it can automate processes
B. Identify types of accounting and finance processes suitable for RPA implementation
C. Participant will develop RPA scripts using case examples during the course under the guidance of the trainer
Course Content & Structure
| Topics | No. of Hours |
A | | Self-Reading |
| Day 1: 9am to 5pm Introduction to RPA | 0.5 hour (Live Webinar) |
B | Develop RPA scripts to automate selected audit processes through the following case examples using a RPA software (6.5 Hours): - Case study 1 – Accounts receivable confirmation preparation process
- Case study 2 – Data entry from excel working file to accounting system
- Case study 3 – data extraction from accounting system to excel
| 6.5 hours (Live Webinar) |
C | Day 2: 9am to 12pm - Case study 4 - Sending of emails (1 hour)
- Case study 5 – excel automation of reports (1.5 hours)
Discussion on the potential adoption of RPA within our organization and work and it’s benefit (0.5 hours) | 3 hours (Live Webinar) |
| Total Hours | 10hrs |
Notes to Participant:
- Participants to bring their own laptop (see note 2 below) that is downloaded with the following software:
b. Outlook application
c. Microsoft excel
- Specifications of the laptop: windows OS, i5, 8 gig RAM and have access to internet.
- Participants are required to complete and submit an individual RPA assignment together with a recording of the running script on the 2nd day of the training. Participants who have met the requirements of the assignment will be awarded with a Certificate of Competency.
Pre-requisites
Please take note of the following admission requirements:
- Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsory
- Mandatory for video camera to be turned on throughout the course
- Display your official name (as per NRIC) in Zoom, to facilitate attendance taking
Training Methodology
1.5 days training: Facilitated learning which includes virtual classroom or practical sessions in a workshop.
Closing Date for Registration
29 Oct 2020
Intended For
Accountants and finance professionals from different staff levels, including accounts executives, accountants, managers and directors.
Programme Facilitator(s)
