Functions and Case Studies within ACL™ Analytics – ACL201

Overview

This course provides a practical application of ACL™ Analytics and is designed to make you more effective in real life situations. It begins with functions for harmonizing, searching, and converting data to assist with issues and questions that are frequently encountered when performing data analytics. You are then guided through hands-on case studies that help you develop your critical thinking skills as you cleanse dirty data, prepare for analysis, perform multiple analysis, and report results.


ENROLL IN THIS COURSE

Tuition cost

$1,527

NASBA Certified CPE

16 Credits

Auditing

Why you should attend

You should attend because ACL is a versatile, powerful, and widely-used data extraction and analysis software used for audits, fraud detection, identifying anomalies in data, and risk management. It enhances auditors’ testing capabilities.

Who should attend

Those who have attended the ACL101 course or are self-taught to that level and require practice in applying ACL to typical data analytic scenarios, including further understanding in the use of functions to cope with typical objectives.

What You'll learn

You will learn from hands-on exercises and case studies, and from the explanations for using certain functions, commands, and expressions. Also, ways to document your approach, which provides essential support to your working papers.

Prerequisites

  • A Comprehensive Introduction to ACL Analytics-ACL101
  • self-taught to a comparable level

Review:

  • Data Analysis Cycle
  • Commands
  • Filters
  • Computed Fields

Functions:

-  Functions Rules
-  Presentation of Approximately 20 Functions in the Categories:

  • Conversion
  • Datetime
  • Logical
  • String
  • Misc
  • Harmonizing Data
  • Converting Data
  • Datetime Data
  • Other Functions

Case Studies:

  • Overview
  • Salesperson Commission Audit
  • Procurement Card Audit
  • Travel and Entertainment Audit
ENROLL IN THIS COURSE

Schedule your course

Use the table below to select the time and location that works best for you.

Timezone: America/Chicago

September 2021

TBD
Sep 16th, 2021-Sep 17th, 2021
SELECT THIS DATE
TBD
Sep 23rd, 2021-Sep 24th, 2021
SELECT THIS DATE
ENROLL IN THIS COURSE

ACI Learning is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.