ACL Academy

Stoked to get behind the wheel of the ACL suite but not quite sure where to begin?

ACL’s got you covered with ACL Academy. From deep-dive courses to bite-sized tutorials, Academy’s in session 24/7.

Executing your audit in Projects

1.5 CPE credits

BASIC

This beginner-level course teaches you to leverage ACL GRC to conduct an audit. In this course, you’ll use the Projects module to plan, create, and execute an audit.

By the end of this course, you’ll be able to:

  • Perform all aspects of fieldwork in one centralized, cloud-based location
  • Implement effective, measurable remediation plans
  • Squash mayhem and introduce order to your request list workflow

Preparing & analyzing data in Results

2 CPE credits

BASIC

This beginner-level course teaches you to leverage ACL GRC to conduct an audit. In this course, you’ll use the Results module to process, automate, and visualize exception data workflows.

By the end of this course, you’ll be able to:

  • Successfully prepare and analyze data
  • Effectively identify and remediate issues that arise
  • Streamline processes by automating your workflow
  • Engage stakeholders with stimulating, interactive visualizations

Reporting your audit in Projects & Reports

2 CPE credits

BASIC

This beginner-level course teaches you to leverage ACL GRC to conduct an audit. In this course, you’ll use the Projects and Reports modules to conclude an audit and create beautiful reports.

By the end of this course, you’ll be able to:

  • Design and customize powerful, engaging reports
  • Share your reports with various stakeholders

Identifying strategic objectives and risks

1 CPE credits

BASIC

In today’s rapid and evolving organizational environments, risk management teams are challenged in establishing an enterprise risk management framework, creating a comprehensive risk inventory, and supporting a consistent risk taxonomy to further define and rank all the risks faced by their organization. This course offers guidance on identifying strategic objectives and risks using the Strategy module.

By the end of this course, you’ll be able to:

  • Identify your organization’s strategic objectives
  • Identify strategic risks threatening your organization’s objectives

Implementing enterprise risk management

1.5 CPE credits

BASIC

Assessment of different types of risks is often managed with disparate processes in separate parts of the organization. Make sure this doesn’t happen to you: complete this course and learn how to assess, prioritize, and respond to risk using one integrated system.

By the end of this course, you’ll be able to:

  • Assess strategic risk
  • Prioritize strategic risk
  • Respond to risk

Reporting and monitoring risk

1 CPE credits

BASIC

Continuous reporting and monitoring of strategic risks is an intensive and dynamic process that requires organization-wide participation. In this course, you’ll learn how to report and monitor risk using the Strategy, Projects, and Results modules.

By the end of this course, you’ll be able to:

  • Track assurance
  • Monitor risk
  • Report risk

Testing Controls in Projects

BASIC

This course is intended for auditors and compliance professionals who want to streamline their control testing initiatives and demonstrate assurance over their risk mitigation effectiveness using ACL GRC.

By the end of this course, you’ll be able to:

  • Create a project from an ACL template
  • Create a Risk Control Matrix (RCM)
  • Understand how risk assessments can be automated using assessment drivers
  • Evaluate control design by performing walkthroughs
  • Test control effectiveness
  • Understand how to increase efficiency and accuracy of control testing using ACL Analytics
  • Measure risk mitigation effectiveness and demonstrate assurance

Automating approval workflows in Results

2 CPE credits

INTERMEDIATE

In this course, you’ll learn how to design, build, and automate an approval workflow in the Results module. You’ll get hands-on experience using event reports, questionnaires, and triggers so you can reduce manual processes and free up time to focus on higher value work.

By the end of this course, you’ll be able to:

  • Design an approval workflow using event reports, questionnaires, and triggers
  • Build a workflow in the Results module
  • Fully automate an approval workflow

Communicating findings, measuring success, and automating monitoring

2.5 CPE credits

INTERMEDIATE

In this course, you’ll learn how to engage and delight your audience with captivating, interactive visualizations, metrics, and storyboards to communicate your findings

By the end of this course, you’ll be able to:

  • Build visualizations that communicate results of the approval workflow
  • Create metrics that track the efficiency and adoption of the approval workflow
  • Design a storyboard using visualizations and metrics to tell your organization’s story

Performing post-detection analysis

1.5 CPE credits

INTERMEDIATE

In this course, you’ll perform post-detection analysis on approval workflow data using ACL Analytics.

By the end of this course, you’ll be able to:

  • Identify policy violations such as approvals made by someone who’s not the employee’s manager
  • Identify red flags of waste and abuse
  • Test the efficiency of the approval process

ACP Certification

CERTIFICATION

ACP Certification

Take the next step to advance your career and differentiate yourself. Showcase your in-depth knowledge, skills, and proficiency to employers by becoming an ACL Certified Professional (ACP).

Basics of ACL Analytics

1.5 CPE credits

BASIC

This beginner-level course teaches the basics you’ll need to get started using ACL Analytics. If you’re a new or beginner user of ACL Analytics, look no further – this course is for you.

By the end of this course, you’ll be able to:

  • Navigate the ACL Analytics platform
  • Create Quick Filters to gain insight into your data
  • Use Quick Sort and sort your data in ascending or descending order
  • Run various commands on your data
  • Track your workflow using the log
  • Differentiate between data types (like character, numeric, and datetime)
  • Import an Excel file into ACL Analytics
  • Follow ACL best practices (like effectively organizing your files and projects)

Filters, computed fields & functions in ACL Analytics

2.5 CPE credits

BASIC

This course introduces filters, computed fields, functions, and how they’re used to analyze data in ACL Analytics. This course is designed for beginner-level users who want to get started with creating filters and computed fields in ACL Analytics.

By the end of this course, you’ll be able to:

  • Identify where expressions are used in ACL Analytics
  • Differentiate between filters and computed fields
  • Create filters and Quick Filters
  • Create computed fields
  • Define what an ACL function is and how it can be used

Importing & preparing data in ACL Analytics

4 CPE credits

BASIC

This course explores various methods of importing data into ACL Analytics and focuses on best practices for preparing data to ensure data integrity. This course is designed for beginner-level users who want to get started with analyzing source data in ACL Analytics.

By the end of this course, you’ll be able to:

  • Identify data sources and methods of acquiring data
  • Import various source files into ACL, including fixed-width, delimited, and Excel files
  • Verify if data was imported correctly
  • Combat integrity threats with integrity tests
  • Calculate controls to verify the correctness of imported data using COUNT, TOTAL, STATISTICS commands
  • Test the quality of data by checking for bounds, completeness, and uniqueness
  • Assess whether data is reasonable using association testing and recalculation

Analyzing data in ACL Analytics

3 CPE credits

BASIC

This beginner-level course teaches you the basics needed to start utilizing ACL Analytics to increase your efficiency in analyzing data, assess and reconcile data from disparate systems, and achieve analysis objectives.

By the end of this course, you’ll be able to:

  • Group data into meaningful categories to identify issues and outliers
  • Identify trends between issues to find root causes of problems
  • Differentiate between reordering methods Quick Sort, SORT, and INDEX
  • Extract relevant data subsets to focus your analysis or isolate issues
  • Identify methods of combining data from multiple systems in order to make comparisons between them

Remediating issues & reporting results

3 CPE credits

BASIC

This beginner-level course teaches you the basics of using ACL Analytics together with ACL Results Lite to automate remediation workflows and present results to key stakeholders through visualizations and storyboards.

By the end of this course, you’ll be able to:

  • Navigate the ACL Results Lite platform
  • Import data from ACL Analytics into Results
  • Create and configure questionnaires to gather follow-up responses
  • Create and configure triggers to automate follow-up actions
  • Add different types of visualizations to an interpretation
  • Present results of your analysis through storyboards
  • Export data or logs from ACL Analytics

Introduction to scripting in ACL Analytics

2 CPE credits

BASIC

This beginner-level course teaches the basics needed to start scripting in ACL Analytics. This course takes the data analysis techniques learned in ACL Analytics Foundations and teaches you how to automate them.

By the end of this course, you’ll be able to:

  • Automate processes using basic scripting
  • Import various source data types using scripts
  • Prepare data for analysis using scripts
  • Identify and apply the correct command syntax needed to achieve desired objectives
  • Follow scripting best practices (such as prefixing variable names)
  • Follow future-proofing best practices (such as commenting)

ACL Analytics Applications

10 CPE credits

INTERMEDIATE

This intermediate-level course follows a case study approach and builds off the skills learned in ACL Analytics Foundations. Case studies include business-relevant data such as sales commission, accounts payable, travel & entertainment, and procurement card expenses.

By the end of this course, you’ll be able to:

  • Apply ACL Analytics in a structured data analysis process
  • Critically determine and assess objectives and planning
  • Develop critical application of key functionality
  • Break apart high-level objectives into manageable steps in ACL Analytics
  • Import various source data types
  • Prepare data for analysis (data integrity tests such as controls, bounds, completeness, uniqueness, relationships and reliability; critically assessing whether integrity issues will impair analysis objectives)
  • Identify and apply the ACL Analytics functionality needed to achieve desired objectives
  • Test issues to identify trends that may be indicative of cause(s) of them
  • Create working paper documentation showing your objectives, the analysis steps, and results

Importing PDFs, reports, & via ODBC in ACL Analytics

INTERMEDIATE

This intermediate-level course builds on the skills learned in ACL Analytics Foundations and teaches you how to import data from report files, PDFs, and ODBC-compliant systems.

By the end of this course, you’ll be able to:

  • Import a report file into ACL Analytics
  • Import a PDF file into ACL Analytics
  • Import data from an ODBC-compliant database into ACL Analytics

ACL Analytics Scripting

ADVANCED

This advanced-level course builds on the scripting basics taught in ACL Analytics Foundations.

By the end of this course, you’ll be able to:

  • Create simple and interactive scripts to implement automated routines, continuous monitoring and gain further insight into your data
  • Automate advanced analysis techniques such as keyword and outlier analysis
  • Increase scripting efficiency and readability
  • Perform advanced techniques such as agile scripts (creating a script within a script)

Basics of datetime fields

INTERMEDIATE

This intermediate-level couse will increase your computed field proficiency. You’ll create ten computed datetime fields, analyze them, and script your processes

By the end of this course, you’ll be able to:

  • Create computed fields that parse different values from a datetime field to:
    1. Separate the month, day, and hour values
    2. Convert the computed month, day, and hour fields to character fields
    3. Identify the day of the week of a date
    4. Identify the month (name) of a date
    5. Calculate the fiscal year of a date
    6. Calculate the fiscal quarter of a date
  • Analyze computed datetime fields to:
    1. Determine the number of and subtotaled amount of transactions within a fiscal year, month, and fiscal quarter
    2. Convert the computed month, day, and hour fields to character fields
    3. Create detailed transaction sumamries by month and day of week, user ID and day of week, user ID and hour
    4. Script your process and reuse the computed fields and analysis in next year’s table

Payroll

INTERMEDIATE

This intermediate-level course teaches you how to apply ACL Analytics in the area of Payroll. You’ll run ten different tests to identify issues related to payroll expenses that warrant further investigation.

By the end of this course, you’ll be able to:

  • Analyze data in the area of Payroll and identify employees:
    1. Paid before their hire date
    2. With suspicious pay variances
    3. Paid after termination
    4. Who received overtime who are ineligible
    5. Paid more overtime than they should’ve been
    6. Who worked more overtime than the policy states
    7. Who use a suspiciously minimal amount of vacation
    8. Who take more than their allowable vacation
    9. With suspiciously similar addresses
    10. With a suspicious number of salary increases

Basics of ACL GRC Analytics Exchange

ADVANCED

You asked, we answered. This ACL GRC Analytics Exchange course offers bite-sized tutorials to get you up to speed with the basics of Analytics Exchange. Learn to manage users, create data containers, convert ACL Analytics scripts for Analytics Exchange, import projects from ACL Analytics into Analytics Exchange, and run an Analytic in Analytics Exchange.

By the end of this course, you’ll be able to:

  • Manage users and permissions
  • Create collections and folders
  • Convert scripts from ACL Analytics to Analytics Exchange
  • Create an analytic and work with tags
  • Import projects from ACL Analytics into Analytics Exchange
  • Run and edit scripts in Analytics Exchange

ACDA Intermediate Certification

CERTIFICATION

ACDA Certification

Take the next step to advance your career and differentiate yourself. Showcase your in-depth knowledge, skills, and proficiency to employers by becoming an ACL Certified Data Analyst (ACDA).

ACDA Intermediate certification is comprised of four levels intended to assess your capabilities as an intermediate-level data analyst. You should be comfortable importing, preparing and analyzing data, reporting findings, and writing basic scripts.

ACDA Advanced Certification

CERTIFICATION

ACDA Certification

Take the next step to advance your career and differentiate yourself. Showcase your in-depth knowledge, skills, and proficiency to employers by becoming an ACL Certified Data Analyst (ACDA). The ACL Certified Data Analyst (ACDA) Advanced designation is an industry-recognized certification which showcases your skills and abilities to automate data analysis through scripting.

ACDA Advanced certification is comprised of three levels intended to asses your scripting proficiency. You should be comfortable writing scripts to solve business challenges as well as troubleshooting broken scripts written by others.