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.

 

Learning Options

Below are the available learning options for this course:

Enterprise Solutions

Tailored Experience

Bring this course to your organization at your convenience. ACI Learning can deliver this instructor-led course for your team at a chosen location or virtually. Alternatively, choose the topic(s) you need and ACI will craft a training solution to keep your team future-proof.

Customize Your Training

NASBA Certified CPE

16 Credits

Auditing

Why you should take this course

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 take this course

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

Learning Options

Below are the available learning options for this course:

Enterprise Solutions

Tailored Experience

Bring this course to your organization at your convenience. ACI Learning can deliver this instructor-led course for your team at a chosen location or virtually. Alternatively, choose the topic(s) you need and ACI will craft a training solution to keep your team future-proof.

Customize Your Training

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.