Skip to Content
Search
An intergovernmental state tax agency whose mission is to promote uniform and consistent tax policy and administration among the states, assist taxpayers in achieving compliance with existing tax laws, and advocate for state and local sovereignty in the development of tax policy.
The Commission
About Us
Email Updates
MTC History
Member States
Multistate Tax Compact
Programs & Committees
Bylaws
Officers & Executive Committee Members
Executive Committee Archive
Litigation Committee Archive
Annual Reports
Policy Statements & Resolutions
Public Participation Policy
News
Paull Mines Award
Wade Anderson Memorial Award
Annual Business Meeting Archive
Uniformity
About Uniformity
Uniformity Charter
Uniformity Process
Adopted Uniformity Recommendations
Uniformity Meeting Archives
Standing Subcommittee
Current & Recent Uniformity Projects
Article IV
Amicus Briefs
Nexus
Multistate Voluntary Disclosure Program
Multistate Voluntary Disclosure Application
Member States
Nexus Committee
State Tax Amnesties
State Tax Amnesties Archive
Audit
Audit Member States
Taxpayer-Initiated Joint Audits
Audit Committee
Audit Committee Archive
Audit Training Programs
Resource Documents
Audit Program Links
Events & Training
Training Program
Upcoming Training Events
Faculty Biographies
Training Program Fees
Frequently Asked Questions
Past Commission Meetings
Resources
Uniform Sales & Use Tax Resale Certificate
Policy Research
Amicus Briefs
Legislation
Alternative Dispute Resolution
Tax Stratification and Estimation Program (TSEP)
Employment Opportunities
State Sales & Use Tax Registration Forms
Fundraiser Sales Tax Law
Research, Presentations, & Publications
Career Information Websites
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.
OBJECTIVE:
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.
AUDIENCE:
The course is designed as a basic course for all state auditors who have a need to process electronic records in an audit environment.
PREREQUISITES:
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.
STUDENT COMPUTER REQUIREMENTS:
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.
PROGRAM LEVEL:
Intermediate
PROGRAM CONTENT:
Introduction to the knowledge and skills needed to work with electronic records during an audit.
COURSE MATERIALS:
In addition to numerous Excel and Access files students will receive a comprehensive course binder which includes the course material and exercises.
ADVANCE PREPARATION:
None
INSTRUCTIONAL DELIVERY METHOD:
Group-Live with exercises
RECOMMENDED CPE CREDIT:
16 hours
FIELD OF STUDY:
Computer Science
(
View the Fields of Study
)
REGISTRATION INFORMATION:
Contact
Sherry Tiggett
at (202) 650-0296
PROGRAM DAY ONE: 8:00 am - 5:00 pm
1.
Working with Functions
2.
Text Functions
3.
Verifying Data
4.
Indexing Data
5.
Statistical Functions
6.
Information Functions
7.
Math Functions
8.
Converting text to numeric data
9.
Working with dates
10.
Formatting Functions
11.
VLOOKUP Function
12.
IF Functions
PROGRAM DAY TWO: 8:00 am - 5:00 pm
1.
Audit Filter
2.
Pivot Tables
3.
Importing External Data
4.
Miscellaneous Tips and Features
For more information on MTC's training programs, please visit the
Training Program
page.
Back to top