Details
Auditors today are constantly challenged to reduce the time spent testing while adding more value to their organization and their clients. One way to accomplish this is by taking advantage of access to available data to identify unusual patterns and anomalies that provide focus to testing strategies..
We are pleas to introduced Activedata for Excel. Activedata for Excel add over 100 tools, specifically for use by Auditors and Accountants. It is designed to support audit and control functions across all aspects of an organization and to put powerful data analysis tools in the hands of your entire department.
ActiveData for excel runs as addin in excel environment, which most auditors use every day, and has been designed with ease of use at its core
Key Benefits?
Save countless hours of work and reduce the time spent on monotonous tasks
Create opportunities to provide additional services
Add value to all of the work you perform
Reduce your exposure to risk
Improve job satisfaction and confidence in your work
Easy to Implement and Validate
Training Details
Date: 3 , 10th August 2019 (Saturday only)
Time : Sat: 9.00 am – 4.30 pm
Venue: Phiret Energy Training Hall
1. Adegbeyemi street
Off Allen Avenue,Ikeja
Fees: 35,000
Payment Details: Account Name : Jplus System Solutions
Bank: StanbicIbtc
Account Number: 0013842678
Early Registration : 30,000 for payment on or before27th of JAugust2019
Payment details send to [email protected] or [email protected]
Invitation Letter: Available on Demand
Participants are to come with their laptop
In-House Training: for in-house Training call 08141575331
For registration and enquiry call Jide on 08141575331 or Tope -08060875359
For further details visit www.jplussystem.com or www.facebook.com/jplus.systems
Deliverables: Certificate on completion, Training Manual, Cds (Data/video)
Training Outline
- Overview of Activedata for Excel
- DATA CLEANSING AND INTEGRITY TESTING
o Using Worksheet format command
o Cells conversion to (number,text,date)
o Removing blanks rows and Columns
- DATA ANALYSIS
o Summarizing transactions
o Preparing Trial
o Detecting duplicated transactions using duplicate command
o Detecting missing invoice number,cheque no etc. using gap command
o Preparing debtors profile using age analysis command
o Sampling
o Digital analysis using Bedford law
o Stratification
o Adding calculated columns for reconfirmation
o Data consolidation using combine command
o Splitting transactions by date and group
- DATA EXTRACTION AND DATABASE INTERROGATION
o Using Activedata query by formula command
o Using Activedata query by example command
o Using Activedata query by March
o Using ODBC
- DATA RECONCILIATION
o Reconciliation of two month payroll using Join and Merge command
o Reconciliation of sales data
o Comparing worksheets using compare command
o Tagging exceptional transactions using Tag command
- COLUMNS MANIPULATION
o Splitting transactions into two or more columns
o Combining multiple columns into one
o Duplicating columns
