Upcoming ACL Training Courses, Dates, Locations & Pricing
Course | Dates | Location | Pricing |
ACL - Beginner / Intermediate / Continuous Monitoring | November 8-10 2011 | Tampa,FL | $900 USD |
ACL - Beginner / Intermediate / Continuous Monitoring | TBD | Calgary, AB Canada | $900 USD |
* Please provide all attendee contact information in the registration fields provided. A confirmation email with specific location details and refund policy will be sent to you following your purchase. Additionally, any future updates regarding the class will also be sent via email.
** REQUIRED: Laptop with ACL license installed.
***Cancellation Policy: $100 cancellation charge up to one week (7 days or more) prior to the training start date and the remaining money will be refunded. Within a week (6 days or less) of the training to start date, any cancellations will result in a credit for a future training class and no money will be refunded.
**** Corporations & Government Entities: Customized training available for groups of 6 or more. Use our contact form to find out more about pricing and class customization using your company's data.
Corporate/Government Entities
ACL Training Overview
Our courses are designed to enable the inexperienced or novice user to advance their knowledge of ACL to an intermediate/advanced level and exposing them to many of the "best practices" used today. Leveraging real world data, we teach you how to overcome the common pitfalls within various data types, as well as how to get the most out of ACL.
We begin with basic data imports, but incorporate more advanced techniques such as script writing early in the course; to provide the most effective means of using ACL in practice.
The training is presented using a hands-on approach by an ACL Certified Data Analyst with years of practical experience in all industries and delivering training classes for over 10 years.
Attendees are not required to be experienced with ACL to realize the objectives of this course, but some level of prior ACL experience will help in the overall understanding and application of these techniques afterward. Attendees are required to bring a laptop with an ACL license in order to ensure that the hands on exercises can be completed.
Sunera also offers training for corporate and government clients with groups of 6 or more. Contact us using our contact form to find out more about pricing and class customization using actual company data.
Sunera also has the ability to provide CPE credits for those who complete the course. Each complete day will earn 7 CPE credits.
Sunera LLC 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 the final authority of the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be addressed to the National Registry of CPE Sponsors, 150 Fourth Avenue North, Suite 700, Nashville, TN 37219-2417. Telephone 615.880.4200. Web site www.nasba.org. Sponsor # 108908
ACL Course Overview
The first day will cover the basics of ACL to ensure the participants understand the fundamentals of the tool. Furthermore, the focus will be on how and when to practically use each ACL technique.
Day 1 will include:
- Project organization
- Data imports
- Tables / formats / log files
- Setting up fields and variables
- Filters
- ACL basic functionality
- Sort / Summarize / Joins
- Managing through data issues
- Date fields
- Introduction to Scripts
The second day will be focused on reinforcing some of the lessons learned on Day 1, developing basic and advanced scripts, and tackling some of the more difficult data issues including importing from pdf reports.
Day 2 will include:
- Advanced scripting techniques
- Group / Loop commands
- Anti-fraud techniques
- User input handling / interactive functionality
- Introduction to continuous monitoring techniques
The third day will be focused on establishing a continuous monitoring program using ACL. Scripts will be designed to take advantage of ACL’s ability to store and compare data over time.
Day 3 will include:
- Continuous Monitoring Techniques
- Variable Substitution
- ODBC connections
- Types of continuous monitoring procedures
- User input handling to support CM
- Working with dated tables
- Other continuous monitoring techniques
ACL Training Daily Schedule & Requirements
Daily Class Schedule
8:30AM Arrival & Set-up
9:00AM-12:00PM Class Instruction
12:00PM-1:00PM Lunch (on your own)
1:00PM-5:00PM Class Instruction
*Two 15 minute breaks will be provided each day.
Requirements
- Laptop with ACL license installed
