Event Information

Share this event

Date and Time



Event description


Lagos: December 1-2 | Abuja December 8-9

Active data for Excel is a Computer Aided Audit Tool (CAAT) used in manipulating & auditing data, analyzing data and computing values on Data. It is an add-in on Microsoft excel. i.e it is a software that runs on Microsoft excel platform. This application can perform audit tasks in a simpler way than other CAAT Tools like ACL, IDEA and CASEWARE. It adds over 100 features to Excel audit capabilities

The simplicity of Activedata for excel makes it an enviable tool in the hand of analysts and auditors. Some of the application areas of this application are:

Superior Control over Corporate Data

Data Analysis and Audit

Complex age analysis & statistical detail

Fraud & Error Detections

Fraud control & continuous monitoring

Complex data stratifications& classification

Time savings &efficiency

Financial & accounting controls

Available Features for imaginable audit works

Available Date

Lagos : Dec 1-2

Abuja: Dec 8-9

Time : Sat: 9.00 am – 4.30 pm

Sun: 12.00 pm – 4.30 pm


Lagos :Phiret Energy Training Hall, No1, Adegbeyemi Street Off Allen Avenue Ikeja

Abuja: Bratim Training Hall, Central Business District

Fees: 30,000

Payment Details: Account Name : Jplus System Solutions

Bank: StanbicIbtc

Account Number: 0013842678

Early Registration :

Lagos : 25,000 for payment on or before 27th of November, 2018

Abuja : 25,000 for payment on or before 3rd of December , 2018

Payment details send to or

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 or

Deliverables: Certificate on completion, Training Manual, Cds (Data/video)

Training Outline

  • Introduction
  • Sorting a worksheet in a simpler way
  • Column to row transposition
  • Format Sheet Command
  • Group Summary
  • Audit Trail
  • Sheet Merging
  • Sheet Navigation
  • Sheet Indexing
  • Query
  • Explanation of the “Original Row” Column
  • Split Sheet Command
  • Workbook Navigation
  • Column Split
  • Column Combine
  • Cell Conversion
  • Column Fill
  • Aging Analysis
  • Gap Analysis
  • Duplicate Analysis
  • Top/Bottom Analysis
  • Sampling
  • Stratification
  • Summary and Pivot Table
  • Case Study

Share with friends

Date and Time


Save This Event

Event Saved