Course Detail(ADT192v : Data Analytics for Auditors: Using Microsoft Excel to perform Data Analytics of an Audit Engagement (Live Webinar))

ADT192v : Data Analytics for Auditors: Using Microsoft Excel to perform Data Analytics of an Audit Engagement (Live Webinar) NEW

3.50 CPE Hours (Category 5)
Live Webinar

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
  • Discuss the Audit Guidance Statement AG13 on the documentation guideline for Data Analytics in a Financial Statement Audit

Case studies and sample data files on Payables, HR and Cash and Bank related process will be used to illustrate the use of simple Microsoft Excel functions to perform the above data analytics.

 

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

27 Aug 2024 (9:00 AM - 12:30 PM)

Fee (inclusive of GST)

For Members: $ 183.12
For Non-Members: $ 218.00

Programme Facilitator(s)

Daniel Chee

Venue

Live Webinar in or outside of
Singapore

Date & Time

19 Nov 2024 (9:00 AM - 12:30 PM)

Fee (inclusive of GST)

For Members: $ 220.18
For Non-Members: $ 261.60

Programme Facilitator(s)

Daniel Chee

Venue

Live Webinar in or outside of
Singapore

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).
 

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
  • Discuss the Audit Guidance Statement AG13 on the documentation guideline for Data Analytics in a Financial Statement Audit

Case studies and sample data files on Payables, HR and Cash and Bank related process will be used to illustrate the use of simple Microsoft Excel functions to perform the above data analytics.

 

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

Date & Time

27 Aug 2024 (9:00 AM - 12:30 PM)

Fee (inclusive of GST)

For Members: $ 183.12
For Non-Members: $ 218.00

Programme Facilitator(s)

Daniel Chee

Venue

Live Webinar in or outside of
Singapore