|
Title: ACL Scripts and Functions
Class Date: July 22-23, 2010
Time: 8:30am ?5:00pm
Instructor: Marc Garcia
Location: St Edward’s Professional Education Center (PEC), Echelon III Building, Room 107, 9420 Research Blvd, Austin, Texas 78759
Price: $650
Early Bird Discount: $600 if you register by July 8, 2010.
Laptop Requirement for Course - Class participants must choose one of the following three options:
1. Bring a laptop to the class with a working copy of ACL already installed. Please be sure to test your ACL software when you are not connected to your office network. A public wireless Internet connection is available in the training room.
2. Bring a laptop to class without a working copy of ACL. You will need to “borrow?the use of the ACL software from the instructor. You will receive a copy of the ACL software for you to install before the class. There is an extra fee of $25 for this option. This fee helps cover the cost of distributing the software.
3. Rent an ACL-equipped laptop from the instructor for use during the class. There is a limited number of these laptops available so please reserve it early. There is an extra fee for this option as follows:
$75 for this class (“ACL Scripts & Functions?; or,
$150 for both classes ("Introduction to ACL" on 07/19 - 07/21 and "Scripts & Functions" on 07/22 - 7/23).
When Registering: If you aren't providing your own laptop and ACL software, please designate in the Comments field on the online registration form which option you will use for this class. If you are opting for #2 or #3, someone will contact you prior to the class date to make arrangements.
Course Prerequisites: Participants should have completed the Introduction to ACL training course or have similar work experience using ACL.
Who Should Attend: Internal and external auditors, financial managers, chief accountants, fraud investigators, IS/IT auditors, or anyone interested in learning how to fully leverage ACL scripts and functions to add power and detail to their analysis and to fully automate their data analysis and continuous monitoring routines.
Course Description:
This is your class if you want to take your ACL skills to the next level and learn all you can about creating and using ACL scripts and functions! This 2.0-day interactive “hands-on?course will present basic, intermediate, and advanced ACL script development and usage techniques. ACL scripts allow the user to automate virtually any ACL task. Scripts are critical to the development and operation of any ACL-based continuous audit system. ACL scripts can also be used to setup and preserve best practices. This course will also cover 30 of the more commonly used ACL functions. ACL functions allow the user to perform a wide-range of data analysis operations, including isolating, investigating, and normalizing data in order to add power and detail to your analysis.
Course Objectives:
At the conclusion of this course, each participant will be able to:
Create ACL expressions incorporating 30 of the more commonly used ACL functions.
Deploy these functions as part of ACL filters; command "if" statements; default and other values for computed fields; and within ACL scripts.
Design, develop, and utilize static and interactive ACL scripts.
Design, develop, and utilize complex, multi-step ACL scripts.
Create the necessary scheduler code in order to auto-launch ACL, ACL projects, and specific ACL scripts within a project.
Create, test and use ACL Standard Applications.
Course Outline:
Day One
Review of Basic Concepts
ACL commands
ACL expression builder
The ACL log file
Other material as necessary
ACL Functions
Bit and character functions
Conversion functions
Date and time functions
Financial functions
Logical functions
Mathematical functions
String functions
Miscellaneous functions
Various Function Exercises
Day Two
ACL Scripts
Scripts defined
Creating and using static scripts.
Creating & using interactive scripts.
Create and test scripts to operate for continuous monitoring purposes.
Various script exercises.
Building Standard Applications
ACL standard applications defined
Creating ACL applications
Using ACL applications
Standard application exercise
Comprehensive Class Exercise
Course Wrap-up & Discussion
Instructor Bio: Marc Garcia
Marc Garcia has over 19 years of audit, data analysis, and ACL experience. He has nine years of experience in presenting various levels of ACL training classes. He is a graduate of Texas State University with a degree in Computer Information Systems.
CPE: 16 hours
Level: Intermediate/Advanced
Type of class: Audit/IT
TX Board of Public
Accountancy Sponsor Number: 009317
Cancellation Information:
Cancellation Date: July 8, 2010
To cancel your registration from this course, please call or email
the course contact listed below. If a cancellation is received after the cancellation
date, the registrant will be charged $200. You may send a substitute at no extra cost.
If you are making travel plans to come to the training, please make "refundable" air and hotel reservations or wait until 14 days before the class to actually book your reservations. Courses are occasionally canceled or rescheduled due to low enrollment. We determine whether a course has enough participants approximately 16 days prior to the course date. If we cancel or reschedule, we will email the participant no later than 14 days before the original class date. Solutions Training will not pay for cancellation/change fees associated with travel and hotel arrangement changes.
Class participants will
be billed after the class. Payment should be made to SOLUTIONS TRAINING GROUP,
Federal Tax ID: 20-2732184 and mailed to 2701 Maria Anna Rd, Austin, TX 78703.
If you have any questions, please contact Shannon Bieberdorf at (512) 914-5557
shannon-solutions@austin.rr.com.
For additional information
about this class, please contact Laurie Garrant at laurie@solutionstraininggroup.com,
(512) 914-5567.
|
