Audit & Forensic Data Analysis with MS Excel

1. Implement Digital Analysis techniques like Benford’s Law and Relative Size factor Theory (RSF) in Excel to identify red flags or fraudulent transactions2. Use Pareto analysis (80-20 rule) and identify high value (and high risk) transactions3. Use Statistical measures like Standard Deviation and Coefficient of variation to zero-down on transactions of audit interest4. Re-engineer your audit processes to create dramatic efficiencies in analysis and reporting5. Perform a ‘Time Dimension’ analysis on data, learn to interpret results6. Perform a Vendor master clean-up and identify suspicious and fraudulent vendors7. Connect Excel worksheet to corporate (or Tally) database extract any data that you want8. Connect your Excel worksheet to live data on the Internet to track (for e.g.) current value of investments9. Get Kaleidoscopic views on data by slicing and dicing the data10 Automatically create, from a single report within Excel, a report for each of the vendor’s transactions (for confirmation)11. Detect non-compliance with organizational policies compliance frame work12. Identify revenue leakages, double payments, etc.13. Work with large data sets (even more than million rows) in ExcelShow moreShow lessChallenges are multifarious. Overwhelming nos. of transactions, loss of conventional (paper) audit trail, system based controls, ever increasing and complex compliance requirements are amongst the prime reasons why traditional methods of collecting and evaluating evidence (like vouching and verification) are no longer adequate. The auditor can no longer treat Information Systems as a ‘Black Box’ and audit around it. His methods and techniques have to change. This change is what the world calls today, ‘Assurance Analytics’ i.e. data analysis from an ‘audit perspective’.Using advance features of MS Excel, the auditor can access client’s data from their databases and analyse it to discharge the onerous duty cast on him. Since over 15 years, CA Nikunj Shah has been perfecting these techniques of ‘assurance analytics’. These include digital analysis techniques like Benford’s Law, Relative Size Factor Theory (RSF) and Pareto’s 80-20 rule that have enabled auditors and forensic investigators to identify control failures and over rides, detect non-compliance with laws, zero down on questionable transactions and identify red flags lost in millions of transactions. It is like quickly finding the needle in a hay stack!! In this unique course, your favourite instructor shall share the best of his research, auditing and training experience. The participants shall learn, step-by-step, the nuts-and-bolts details of using advance features of Microsoft® Excel coupled with the instructor’s insights to apply them in real-world audit situations. Each section shall equip participants with assurance analytic techniques using real-world examples and learn-by-doing exercises.Who this course is for:1. Chartered Accountants, Managers, Team Members and Articled Trainees in Audit function (All types of Audits like Internal, Statutory, Management, Performance, etc.)2. Heads, Managers and Team Members in Financial Accounting function3. Forensic Accountants and Financial Fraud Investigators4. Information Systems Auditors