|
Auditing
Through the Computer Using Microsoft Excel
Course
Objective
At
this seminar, you will gain:
-
an understanding of the steps in auditing relational database
files
-
an understanding of the entire computer operations using Microsoft
Windows
-
an understanding of the concept of Files and Folders under Microsoft
Windows
-
an understanding of how to use Microsoft Excel to perform electronic
audit
-
a practical knowledge of how to use Microsoft Excel to
audit their computerized Payroll System, Bank
List, Debtors, Creditors and any other electronic file
-
an understanding of various types of computer errors, frauds and
irregularities that may be committed
and how to detect, prevent and recommend for corrections
-
an understanding of how to retrieve electronic data files from
their sources and bring them to Auditors
computer desktop, laptop, LAN, etc for data interrogation
-
an understanding of how to use Microsoft Excel to trap exception
conditions
Course Outline
.
Overview of Computer Operations
.
Overview of Microsoft Excel Operations
.
How Electronic Files are Kept and their method of access?
.
Fundamentrals of CAAT Applications
.
Hands-on Introduction to Microsoft Excel Operations
.
Importing Data to Microsoft Excel Environment
.
Understanding Data File Structures
.
Getting started with Electronic Audit: saving the file after
the import
.
Direct file itnerrogation
.
Processing: Testing Data Integrity; Testing for Gap, Duplicates,
Sequence, etc.
Counting, Totalling, Sorting, Summarizing
.
Performing Statistical Functions; Using Non-Statistical functions;
Cell Referencing;
Introducing 3 Dimensional Worksheet Functions, Interrogating multiple
files
.
Processing very large files
.
Access Methods to Input Data, Accessing Data from diverse
computer platforms
.
Reports: Designing and customized Reports
.
Real Life Applications with different Case Studies
.
Real Life Applications with your payroll data files
Who
Should Attend?
The
above workshop is designed for Internal Auditors, External
Auditors, Control Executives and Professional working in Information
Security Department of his/her organization
Dates
Duration
Venue
Cost (N)
Oct. 15-19
5 Days Ultimate
Systems Solutions Training Center
38, 500
110b Awolowo Way, Ikeja, Lagos, Nigeria
Nov. 05-09
5 Days
"
38,
500
Nov. 26- 30
5 Days Ultimate
Systems Solutions Training Center
38, 500
110b Awolowo Way, Ikeja, Lagos, Nigeria
Provision
Executive
Leather Bag, Lunch, Tea Break, Various Accounting Modules as stated
above on diskette, One Computer Per Participant, Group Photograph,
Workshop Materials
Note
Depending
on your choice, we can also run the above course for you in either
your office or your training center. But the number of participants
would not be less than 5.
| 