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

UTAP Funding

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

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 Jun 2025 (9:00 AM - 12:30 PM)

Fee (inclusive of GST)


SGD pricing -

For Members: $ 188.57
For Non-Members: $ 224.54


Programme Facilitator(s)

Daniel Chee

Venue

Live Webinar in or outside of
Singapore
Date & Time

19 Sep 2025 (9:00 AM - 12:30 PM)

Fee (inclusive of GST)


SGD pricing -

For Members: $ 226.72
For Non-Members: $ 269.23


Programme Facilitator(s)

Daniel Chee

Venue

Live Webinar in or outside of
Singapore
Date & Time

12 Dec 2025 (9:00 AM - 12:30 PM)

Fee (inclusive of GST)


SGD pricing -

For Members: $ 226.72
For Non-Members: $ 269.23


Programme Facilitator(s)

Daniel Chee

Venue

Live Webinar in or outside of
Singapore

Testimonial

Funding

1] NTUC Union Training Assistance Programme (UTAP)
UTAP (Union Training Assistance Programme) is an individual skills upgrading account for NTUC members.

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 01 April 2024 and 31 March 2025. *This excludes miscellaneous fees such as GST and registration fee etc.
 
This course is approved for UTAP support for intakes conducted between 19 March 2025 – 31 March 2027.
 
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.

To submit for UTAP claims, please visit http://skillsupgrade.ntuc.org.sg/. Terms and conditions apply.
Should you have queries on the funding scheme, you can email to UTAP@e2i.com.sg or call NTUC Membership Hotline at 6213-8008

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 Jun 2025 (9:00 AM - 12:30 PM)
Fee (inclusive of GST)


SGD pricing -

For Members: $ 188.57
For Non-Members: $ 224.54


Programme Facilitator(s)

Daniel Chee

Venue

Live Webinar in or outside of
Singapore


Other courses you might like

View Courses 
20.00
CPE Hours
Blended Learning (with Live Webinar + Classroom)

SCAQ Academy Professional Programme – Assurance

08 Apr 2025 - 11 Jun 2025

7.00
CPE Hours
Live Webinar

Common Audit Inspection Findings & Practical Ways to Address Them (Live Webinar)

16 May 2025 - 16 May 2025

  • UTAP
3.50
CPE Hours
Live Webinar

Understanding the Impact of Various SSAs on the Auditor's Report

23 May 2025 - 23 May 2025