Course Detail(ADT192 : Data Analytics for Auditors: Using Microsoft Excel to perform Data Analytics of an Audit Engagement (Classroom))

ADT192 : Data Analytics for Auditors: Using Microsoft Excel to perform Data Analytics of an Audit Engagement (Classroom) NEW

3.50 CPE Hours (Category 5)
Classroom

To reduce the environmental impact and contribute to sustainability efforts, ISCA will contribute our part by eliminating the printing of course materials for selected courses with effect from 2023.

Tips: To make your paperless learning experience more enjoyable, you may bring along a digital device such as a Windows based laptops or tablets to read your online materials during the class. QR code will be provided in the class for you to download the materials in PDF.

Join us and be a Difference Maker!

 


 

 

Programme Objective

Auditors are increasingly looking to leverage on technology including data analytics tools to enhance the quality of their audits and more effectively deal with large volumes of data. This seminar course aims to provide practical examples of data analytics that can be performed in an engagement of financial statements audit. 

Programme Outline

  • Identifying unusual transactions for further investigation:
    • Round sum payments
    • Duplicate payments
    • Transactions that bypass controls
  • Identifying potential cut-off issues
  • Payroll irregularities
  • Performing completeness test on transactions

Case studies and sample data files will be used to illustrate the use of simple Microsoft Excel functions to perform the above data analytics.

NOTE: Participants are encouraged to bring along laptop for the session to follow the illustrations and practise the case study hand-on. 

Training Methodology

Lecture style with exercises / case studies

Closing Date for Registration

1 week before programme or until full enrolment.

Intended For

Assistant Audit Managers, Audit Managers and Partners

Competency Mapping

Category 5 = 3.50 Hours

Schedule & Fees

Date & Time

30 Apr 2024 (9:00 AM - 12:30 PM)

Registration is closed

Fee (inclusive of GST)

For Members: $ 214.73
For Non-Members: $ 256.15

Programme Facilitator(s)

Daniel Chee

Venue

60 Cecil Street
ISCA House
Singapore 049709

Testimonial

Funding

No funding Available!

Programme Facilitator(s)


Chee Hay Kheong, Daniel
FCA (Singapore)

 

Daniel is a Fellow Chartered Accountant of Singapore. He holds an Honours degree in Accountancy from the National University of Singapore and was a Certified Information Systems Auditor (CISA). He has more than 13 years of experience in the accounting profession, having worked for one of the Big 4 accounting firms both in Singapore and in the United Kingdom. He has also more than 5 years of senior management experience with multi-national corporations, managing their operations in Singapore and Asia.

Daniel has served as an adjunct Associate Professor in the department of accounting at the National University of Singapore (NUS), teaching the Audit and Assurance and Advanced Audit and Assurance modules. After NUS, he served as an Adjunct Professor in the accounting department of the Singapore University of Social Sciences (SUSS), teaching the Audit and Assurance module.

Daniel also provided professional training to members of the Institute of Singapore Chartered Accountants (ISCA), the Singapore Institute of Directors (SID), public accounting firms and training providers.

Daniel was formerly a committee member of both the IT Committee and the Examination Committee of ISCA, and was also a committee member of the Disciplinary Sub-Committee of Accounting and Corporate Regulatory Authority (ACRA).
 

To reduce the environmental impact and contribute to sustainability efforts, ISCA will contribute our part by eliminating the printing of course materials for selected courses with effect from 2023.

Tips: To make your paperless learning experience more enjoyable, you may bring along a digital device such as a Windows based laptops or tablets to read your online materials during the class. QR code will be provided in the class for you to download the materials in PDF.

Join us and be a Difference Maker!

 


 

 

Programme Objective

Auditors are increasingly looking to leverage on technology including data analytics tools to enhance the quality of their audits and more effectively deal with large volumes of data. This seminar course aims to provide practical examples of data analytics that can be performed in an engagement of financial statements audit. 

Programme Outline

  • Identifying unusual transactions for further investigation:
    • Round sum payments
    • Duplicate payments
    • Transactions that bypass controls
  • Identifying potential cut-off issues
  • Payroll irregularities
  • Performing completeness test on transactions

Case studies and sample data files will be used to illustrate the use of simple Microsoft Excel functions to perform the above data analytics.

NOTE: Participants are encouraged to bring along laptop for the session to follow the illustrations and practise the case study hand-on. 

Training Methodology

Lecture style with exercises / case studies

Closing Date for Registration

1 week before programme or until full enrolment.

Intended For

Assistant Audit Managers, Audit Managers and Partners

Competency Mapping

Category 5 = 3.50 Hours

Programme Facilitator(s)

Chee Hay Kheong, Daniel
FCA (Singapore)

 

Daniel is a Fellow Chartered Accountant of Singapore. He holds an Honours degree in Accountancy from the National University of Singapore and was a Certified Information Systems Auditor (CISA). He has more than 13 years of experience in the accounting profession, having worked for one of the Big 4 accounting firms both in Singapore and in the United Kingdom. He has also more than 5 years of senior management experience with multi-national corporations, managing their operations in Singapore and Asia.

Daniel has served as an adjunct Associate Professor in the department of accounting at the National University of Singapore (NUS), teaching the Audit and Assurance and Advanced Audit and Assurance modules. After NUS, he served as an Adjunct Professor in the accounting department of the Singapore University of Social Sciences (SUSS), teaching the Audit and Assurance module.

Daniel also provided professional training to members of the Institute of Singapore Chartered Accountants (ISCA), the Singapore Institute of Directors (SID), public accounting firms and training providers.

Daniel was formerly a committee member of both the IT Committee and the Examination Committee of ISCA, and was also a committee member of the Disciplinary Sub-Committee of Accounting and Corporate Regulatory Authority (ACRA).
 


Upcoming Schedule

Registration is closed

Date & Time

30 Apr 2024 (9:00 AM - 12:30 PM)

Fee (inclusive of GST)

For Members: $ 214.73
For Non-Members: $ 256.15

Programme Facilitator(s)

Daniel Chee

Venue

60 Cecil Street
ISCA House
Singapore 049709