Functions and Case Studies within ACL™ Analytics – ACL201


This two-day course is a practical application of ACL™ Analytics, designed to make you more effective in real life situations. The course commences with a presentation of functions for harmonizing, searching and converting data to assist with issues and questions that are frequently encountered when performing data analytics. You will gain hands-on experience and real-world explanations for using these functions as your ACL™ Certified Trainer leads you through this presentation. You will then be guided through three hands-on case studies (approximately half-day duration each) which will help you develop your critical thinking skills as you cleanse dirty data, prepare for analysis, perform multiple analysis objectives and report your results. You will learn how to document your approach by effectively separating objectives into manageable milestones that will make it easier to determine which ACL command, expression or function should be used. This documented approach will provide essential support to your working papers.

What you will 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.


  • Data Analysis Cycle
  • Commands
  • Filters
  • Computed Fields

- 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

Further information

ACI Learning
ACI Learning
2 Days
Scheduled dates
Course type:
Amsterdam, Atlanta, GA, Bandar Seri Begawan, Boston, MA, Burlington, MA, Cape Town, Charlotte, NC, Chicago, IL, Dallas, TX, Denver, CO, Dubai, Dublin, Dublin, OH, Hong Kong, Houston, TX, Las Vegas, NV, London, Manila, New York, NY, Oman, Orlando, FL, Philadelphia, PA, San Antonio, San Diego, CA, San Francisco, CA, Seattle, WA, Singapore, Virtual Training Room Only, Washington, DC

Contact Information

ACI Learning

6855 S. Havana St.
Suite 230
80112 USA