Computer Assisted Audit Techniques Using Excel
Click here for a PDF copy
Tax agencies can substantially improve the effectiveness and productivity of their audit work by making use of electronic records. This course develops and improves auditor skills for using Excel to process electronic records.
At the completion of this course, students will have the confidence and skills to conduct an audit using electronic records. From the initial contact with the taxpayer in knowing what types of records and information to request, to the completion of the final schedules, the auditor will have the basic skills in Excel to process electronic records.
The course is designed as a basic course for all state auditors who have a need to process electronic records in an audit environment.
Students should have basic skills in Excel. They should be able to work with cells and ranges and should know how to move, copy, paste and sort. Students also should be able to insert formulas for computations (e.g., sum).
Student should also have basic MS File Explorer skills, including an understanding of the basic directory and folder structure of a computer, including the ability to move, copy, paste and delete files.
Each participant is required to have a laptop computer with Excel 2010, and a CD-Drive or a free USB port to enable the sharing of files. Some of the material is based on Excel VBA which requires the VBA functionality enabled. Students should also be able to adjust the security level to a low setting or it should be preset to a level that will accept macros.
WARNING: Failure to comply with the student requirements may prevent the student from being able to participate in many of the class examples and exercises. Students should check with their IT Departments to insure that their computers are in compliance.
Introduction to the knowledge and skills needed to work with electronic records during an audit.
In addition to numerous Excel and Access files students will receive a comprehensive course binder which includes the course material and exercises.
INSTRUCTIONAL DELIVERY METHOD:
Group-Live with exercises
RECOMMENDED CPE CREDIT:
Contact Antonio Soto at (202) 650-0296.
PROGRAM DAY ONE: 8:00 am - 5:00 pm
|| Working with Functions
|| Text Functions
|| Verifying Data
|| Indexing Data
|| Statistical Functions
|| Information Functions
|| Math Functions
|| Converting text to numeric data
|| Working with dates
|| Formatting Functions
|| VLOOKUP Function
|| IF Functions
PROGRAM DAY TWO: 8:00 am - 5:00 pm
|| Audit Filter
|| Pivot Tables
|| Importing External Data
|| Miscellaneous Tips and Features
We encourage states to host this course along with
Basic Random Sampling during the same week.
For more information on MTC's training programs, please visit the Training Program page.