|
Auditing
Through the Computer Using ActiveData for Excel
Course Objective
With
several computers being in use today and a large proportion of
financial records being in digital format, Aditors and Fraud Examiners
need easy to use, high performance tools that can sift through
enormous amounts of data quicly and effectively.
This
course will assist Auditors, Fraud Examiners, and Management in
implementing data analysis routines using ActiveData (CAAT) for
Microsoft Excel. Participants will be able to use this software
to prevent and proactively detect organizational inefficeiency,
ineffectiveness and fraud.
The
course will work you through 16 common fruad detection, cash recovery
and audit tests within the accounts payable, accounts receivable
and general ledger audit areas. It will also introduce you to
the powerful combination of ActiveData & Excel.
Course
Content
-
Getting to know about ActiveData for Excel: Installation requirement,
working environment, importing data, analysis features, cost,
etc.
-
The Workbook Functions: Workbook Navigator, Global Find/Replace,
Workbook History/ Favourite, Index Workbooks, Revert and Import
-
The Worksheet Functions: Data Relation and Merging, Merge Sheets,
Match Sheet, Compare Sheets, Query Sheet, Split Sheet, Sorting,
Sampling and Formating
-
The Rows Functions: Tagging rows by formulas, example, by column
values and by match. Working with Tags: Moving, Copying, Filtering,
Deleting and Inverting the tags.
-
The Columns Functions: Adding Calculated Columns, Spliting Columns,
Arranging Columns and Combining Columns
-
Cells Functions: Formatting Selected Cells for proper audit reports,
Converting Selected Cells and Transposing Selected Cells
-
Analysis Functions: Group Summary, Top/Bottom Items, Age, Stata,
Duplicates, Gaps, Approximate Column Match, Descriptive Statistics
and Digital Analysis using Benford's Law
-
Walking through 16 common audit tests within the accounts payable,
accounts receivable and general ledger audit areas
-
Step-by-step audit tests in accounts payable, accounts receivable
and general ledger
-
Case Studies: Auditing Payroll Files:
Who
Should Attend?
This
workshop is specifically designed for Auditors, Accountants, Fraud
Examiners, Database Administrators and Control Executives who
have acquired Microsoft Excel Knowledge to at least an introductory
level. The course could also be of immense benefit to executives
in similar profession but the preminary knowledge of Microsoft
Excel is a must.
Dates
Duration
Venue
Cost (N)
May 07-11 5
Days Ultimate
Systems Solutions Training Center
40, 500
110b Awolowo Way, Ikeja, Lagos, Nigeria
May 21-25
5 Days
"
40,
500
Jun. 25- 29
5 Days Ultimate
Systems Solutions Training Center
40, 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.
| 