We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

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

Schedules

Aug 31, 2019 - Sep 01, 2019
Sat 09:00 AM — 04:00 PM
Sat, Sun 12:00 PM — 04:00 PM
No. of Days: 2
Total Hours: 14
No. of Participants: 20
Reviews
Be the first to write a review about this course.
Write a Review
Jplus System Solutions is a fast growing IT/Training consulting firm, which was established with the sole aim of bringing IT solutions to the door step of our client. Jplus provide leading professional services to organisation by deploying necessary tools and human resources who are capable of delivering best performance thereby giving our customers value for their investment
We bring people, methods and technology together to provide concise, actionable and practical consulting assistance and advice to our clients.
JPLUS SYSTEM SOLUTIONS
2348141575531
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.