Free

EXCEL FOR AUDITORS USING ACTIVEDATA FOR EXCEL

Event Information

Share this event

Date and Time

Location

Location

Friends Who Are Going
Event description

Description

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. Various tools available in the market are designed to help you extract and analyze data to assist in reporting potentially inefficient and ineffective processes, including fraud, waste, and abuse of corporate resources. Often the use of these tools requires specialized training and is limited to a handful of people within an audit department.

We are pleas to introduced Activedata for Excel. Activedata 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

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: September 29, 30 and 1st October 2017

Duration: 3 days

Time: Fri- Sat : 10.00 am – 4.30 pm

Sun: 12.00 pm – 4.30 pm

Venue: National Library Abuja

Central Business Area

Fees: 30,000

Payment Details: Account Name : Jplus System Solutions

Bank: StanbicIbtc

Account Number: 0013842678

Early Registration : Payment on or before 22nd Sept is 25,000

Payment details send to jplussystem@yahoo.com

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

www.jplussystem.com

www.facebook.com/jplus.systems

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

The training will be facilitated by Buoye Jide and Others. Jide is a season facilitator in Excel, Audit Command Language, Active data for Excel, Idea, Dashboard design and implementation.

He has a good working knowledge of CAAT tools for financial analysis, detection of control weaknesses, and identification of suspicious transactions and profiling of channels/branches for enhanced profitability

At Jplus system Solutions he has since been actively involved in Training and IT consultancy services for some of the clients listed below

Lagos Chamber of Commerce and Industry, Abuja Electricity Distribution Company, Office of the Budget of the Federation, Colgate Palmolive Nigeria, Great Nigeria Insurance (Audit Unit), Redeemed Christian Church Of God Olive Parish Banana Island, Kehinde Karim Chartered Accountants & Co, MBH Power Limited, Nigeria Life Provident Company, Platinum Stream Consulting , N.N.Fems Industries, Advanced Chemical International Limited etc.

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

Location

Save This Event

Event Saved