Place: New Delhi
Workshop on
Assurance Analysis
– Tools & Techniques with
MS- Excel
Committee on Information Technology
Institue of Chareterd Accountants of India
Overview
Critical decisions by auditors are increasingly being based on data analytics rather than on intuition or gut
feeling. ICAI’s CIT presents thoughtfully designed, power packed training programme for members in
profession to enable them implement data analytics and statistical techniques in audit and attestation
services
.
12 CPE Hours
Objective:
To ensure that participants get a complete hang on
select, cutting-edge Excel functionalities and also
learn to apply these functionalities in real world Audit
situations & interpret results.
 Data Import
 Multi-Dimensional Analysis
 Statistical Sampling
 Benford’s Law
 General Ledger scrutiny
Methodology:
Hand on Exercises in Excel 2007 on real world (realistic) data files with brief lectures and brain
storming sessions. Participants have to bring their own laptop with Office 2007/2010.
Training Content:
Module
1 Data Import
– Getting
Data into
Excel.
2 – MultiDimensional
Analysis of
data &
Reporting
3 – Statistical
Sampling
4 – Benford’s
Law
5 - General
Ledger
scrutiny
Excel Functionality
Learn techniques of Data Import from varied sources like, Text files (ASCII format,
including .dat files), web pages, RDBMS like SQL Server (including on-line
connectivity to refresh data on real time basis), Tally database, etc. and even
PDF files.
Use Pivot tables to slice & dice data, tabulate, cross-tabulate, get running totals
(e.g. running balance of a bank account), view amounts / quantities as % of rows
/ columns, produce Top 3 or Top 10 reports, group sales by weeks, months,
quarters, etc., apply the Pareto’s (80-20) principal to identify high value
transactions or analyse large data sets (even more than million rows)
Learn to use Binomial distribution to determine sample size; set tolerable rate of
misstatement, expected population exception rate, and confidence level, draw
samples using various statistical sampling techniques like Random Sampling,
Systematic Sampling, Probability Proportional to size Sampling, determine how
representative are your samples to the population, and finally extrapolate the
results of evaluation of sample to the population to manage audit risk involved in
the attestation.
Use Benford’s Law to identify irrational repetition of digits so that you can zero
down on suspicious transactions that may indicate irregularities or even fraud.
Use various excel functionalities like advance filters and standard deviation to
identify questionable transactions.
Faculty: Main Faculty for training program is CA Nikunj Shah B.Com., LL.B., FCA, DISA, CIA, ACFE, who
practices mainly in data analytics for Internal audits, fraud detection, investigations and business
intelligence. He has over 12 years of experience in training corporate teams on using advance
features of MS Excel to bring effectiveness and efficiencies in MIS reporting, analysing and
interpreting data
Workshop Chairman: CA. Rajkumar S. Adukia
( Chairman, IT Committee and CCM, ICAI )
Registration:
DD/ At Par Cheque in Favor of Secretary, ICAI,
Payable at Delhi at following address :
Secretary, Committee on Information Technology
A-29, ICAI Bhawan, Hostel Block, 7th Floor, Noida201309, 01203045963/961,
Email:[email protected]
Fees:
Rs 5000/- for ICAI Members, http://www.icai.org/ccm.html?progid=859 ( Online Payment )
Rs 6000/- for Non-Members, http://www.icai.org/ccm.html?progid=858 ( Online payment )
Date: 12-13 June , 2015