HOT
blank

Audit & Forensic Data Analysis with MS Excel

Finance & Accounting

Rating4.2
Enroll Now

Audit & Forensic Data Analysis with MS Excel, available at $79.99, has an average rating of 4.2, with 95 lectures, based on 149 reviews, and has 577 subscribers.

You will learn about 1. Implement Digital Analysis techniques like Benford's Law and Relative Size factor Theory (RSF) in Excel to identify red flags or fraudulent transactions 2. Use Pareto analysis (80-20 rule) and identify high value (and high risk) transactions 3. Use Statistical measures like Standard Deviation and Coefficient of variation to zero-down on transactions of audit interest 4. Re-engineer your audit processes to create dramatic efficiencies in analysis and reporting 5. Perform a ‘Time Dimension’ analysis on data, learn to interpret results 6. Perform a Vendor master clean-up and identify suspicious and fraudulent vendors 7. Connect Excel worksheet to corporate (or Tally) database & extract any data that you want 8. Connect your Excel worksheet to live data on the Internet to track (for e.g.) current value of investments 9. Get Kaleidoscopic views on data by slicing and dicing the data 10 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 work 12. Identify revenue leakages, double payments, etc. 13. Work with large data sets (even more than million rows) in Excel This course is ideal for individuals who are 1. Chartered Accountants, Managers, Team Members and Articled Trainees in Audit function (All types of Audits like Internal, Statutory, Management, Performance, etc.) or 2. Heads, Managers and Team Members in Financial Accounting function or 3. Forensic Accountants and Financial Fraud Investigators or 4. Information Systems Auditors It is particularly useful for 1. Chartered Accountants, Managers, Team Members and Articled Trainees in Audit function (All types of Audits like Internal, Statutory, Management, Performance, etc.) or 2. Heads, Managers and Team Members in Financial Accounting function or 3. Forensic Accountants and Financial Fraud Investigators or 4. Information Systems Auditors.

Enroll now: Audit & Forensic Data Analysis with MS Excel

Summary

Title: Audit & Forensic Data Analysis with MS Excel

Price: $79.99

Average Rating: 4.2

Number of Lectures: 95

Number of Published Lectures: 95

Number of Curriculum Items: 97

Number of Published Curriculum Objects: 97

Original Price: ₹3,299

Quality Status: approved

Status: Live

What You Will Learn

  • 1. Implement Digital Analysis techniques like Benford's Law and Relative Size factor Theory (RSF) in Excel to identify red flags or fraudulent transactions
  • 2. Use Pareto analysis (80-20 rule) and identify high value (and high risk) transactions
  • 3. Use Statistical measures like Standard Deviation and Coefficient of variation to zero-down on transactions of audit interest
  • 4. Re-engineer your audit processes to create dramatic efficiencies in analysis and reporting
  • 5. Perform a ‘Time Dimension’ analysis on data, learn to interpret results
  • 6. Perform a Vendor master clean-up and identify suspicious and fraudulent vendors
  • 7. Connect Excel worksheet to corporate (or Tally) database & extract any data that you want
  • 8. Connect your Excel worksheet to live data on the Internet to track (for e.g.) current value of investments
  • 9. Get Kaleidoscopic views on data by slicing and dicing the data
  • 10 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 work
  • 12. Identify revenue leakages, double payments, etc.
  • 13. Work with large data sets (even more than million rows) in Excel

Who Should Attend

  • 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 function
  • 3. Forensic Accountants and Financial Fraud Investigators
  • 4. Information Systems Auditors

Target Audiences

  • 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 function
  • 3. Forensic Accountants and Financial Fraud Investigators
  • 4. Information Systems Auditors

Challenges 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 rulethat 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.

Course Curriculum

Chapter 1: Concepts

Lecture 1: Data Files/ Resources

Lecture 2: Welcome & Introduction to Concepts

Lecture 3: Types of Analysis

Lecture 4: Business Analytics

Lecture 5: Audit Analysis and Forensic Data Analysis

Lecture 6: Formal Definitions

Lecture 7: Skill Sets & Phases

Lecture 8: Data Integrity

Lecture 9: Closing Remarks on Concepts

Chapter 2: Introduction & Data Import From ASCII

Lecture 1: Data Files/ Resources

Lecture 2: Introduction to Data Import

Lecture 3: Various Sources / File Types For Data Import

Lecture 4: Importing Data From ASCII Files – Background

Lecture 5: Importing Data From ASCII Files – Steps

Lecture 6: Closing Remarks On Importing Data From ASCII Files

Chapter 3: Introduction & Data Import From ODBC

Lecture 1: Data Files/ Resources

Lecture 2: Introduction & Background for ODBC

Lecture 3: Understanding Open DataBase Connectivity (ODBC)

Lecture 4: Installing Tally & Setting Up Systems

Lecture 5: Importing Data Using ODBC – Steps

Lecture 6: Resources To Understand Database

Lecture 7: Troubelshooting Excel-Tally ODBC Connectivity

Lecture 8: Closing Remarks On Data Import From ODBC

Chapter 4: Data Import from Web & PDF

Lecture 1: Introduction To Data Import From Web & PDF

Lecture 2: Method I – Get Data From Webpage Into Excel On Real-Time Basis

Lecture 3: Method II – Get Data From Webpage Into Excel On Real-Time Basis

Lecture 4: The Challenges In Getting Data From APDF File To Excel

Lecture 5: Four Ways To Get Data From APDF File To Excel

Lecture 6: Closing Remarks On Data Import From Web & PDF

Chapter 5: Data Cleansing

Lecture 1: Data Files/ Resources

Lecture 2: Challenges After Data Import – Cleaning, Formatting & Validating

Lecture 3: Understanding ASCII Report Files & Steps To Import Data From Such Files

Lecture 4: Cleaning Data

Lecture 5: Converting Text To Numbers

Lecture 6: Quickly Filling Blank Rows With Data

Lecture 7: Importing & Formatting Dates

Lecture 8: Ways To Audit Excel Worksheets

Lecture 9: Extract Text From Cells

Lecture 10: Closing Remarks On Cleansing Data

Chapter 6: Multi-Dimensional Analysis Of Data With Pivot Tables-Fundamentals & Intermediate

Lecture 1: Data Files/ Resources

Lecture 2: Introduction To Multi-Dimensional Analysis Of Data

Lecture 3: Understanding Pivot Table Anatomy

Lecture 4: Basic Techniques Of Analysis With Pivot Tables

Lecture 5: Quickly Get A Pivot Table Report For Each Item In Page / Filter Quadrant

Lecture 6: Apply Pareto's Rule To Zero Down On High Value / Risk Transactions

Lecture 7: Apply Pareto's Rule In Audits – Where To Apply & Where Not To Apply

Lecture 8: Closing Remarks Multi-Dimensional Analysis Of Data With Pivot Table

Chapter 7: Multi-Dimensional Analysis Of Data With Pivot Table – Advance Level 1

Lecture 1: Data Files/ Resources

Lecture 2: The Need To Create Pivot Tables From External Data Source

Lecture 3: Pivot Tables From External Data Source – Dealing With Complexities

Lecture 4: Steps To Create Pivot Table From External Data Source

Lecture 5: Re-Engineering A Business / Audit Process By Creating Pivot Tables From External

Lecture 6: Steps To Create Pivot Table From External Data Source – Continue

Lecture 7: Modify A Pivot Table Created From External Data Source

Lecture 8: Refreshing The Pivot Table Report Upon Change In Source Data

Lecture 9: Closing Remarks On Multi-Dimensional Analysis Of Data With PivotTable Intermedia

Chapter 8: Multi-Dimensional Analysis Of Data With Pivot Table – Advance Level 2

Lecture 1: Data Files/ Resources

Lecture 2: Pivot Tables & File Size

Lecture 3: The Secret Of Pivot Table Data Source

Lecture 4: Pivot Tables – Ways To Minimize File Size

Lecture 5: Access Pivot Table Source Data Even After The Source Data Sheet Is Deleted

Lecture 6: Make Pivot Table Range Dynamic

Lecture 7: Recap of All Modules On Multi-Dimensional Analysis Of Data With Pivot Tables

Chapter 9: Standard Deviation and It's Application in Audits

Lecture 1: Data Files/ Resources

Lecture 2: Revisiting Standard Deviation

Lecture 3: Standard Deviation & Risk

Lecture 4: Steps To Calculate Standard Deviation Efficiently

Lecture 5: Reporting Results

Lecture 6: Audit Areas Where Standard Deviation Analysis Can Be implemented

Lecture 7: Why Standard Deviations Cannot Be Compared? Coefficient Of Variation

Lecture 8: Steps To Calculate Coefficient Of Variation

Lecture 9: Closing Remarks On Standard Deviation And It's Application In Audits

Chapter 10: Benford's Law and It's Application in Audits

Lecture 1: Data Files/ Resources

Lecture 2: Background And Introduction to Digital Analysis Techniques

Lecture 3: Can Tossing A Coin Reveal Anybodys Character

Lecture 4: Why Are Certain Pages In My Book More Depreciated Than Certain Others?

Lecture 5: Benford's Law

Lecture 6: The Statistical Truth Behind Tossing A Coin

Lecture 7: My Trust With Benford's Law

Lecture 8: DrMark Nigrini & His Work On Application Of Benford's LawTo Identify Tax Evaders

Lecture 9: Steps To Apply Benford's Law In Excel

Lecture 10: Reading And Interpreting Results

Lecture 11: Audit Areas Where Benfords Law Analysis Can Be Implemented

Lecture 12: What If Benford's Law Does Not Apply To A Dataset

Lecture 13: What Are Cosmic Laws?

Lecture 14: Is There A Rationale Behind More 1s And Less 9s

Lecture 15: Closing Remarks Pinkham's Law And What's That ?

Chapter 11: Relative Size Factor Theory & Its Application In Audits

Instructors

Rating Distribution

  • 1 stars: 5 votes
  • 2 stars: 6 votes
  • 3 stars: 25 votes
  • 4 stars: 43 votes
  • 5 stars: 70 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Investing Courses to Learn in December 2024

Top 10 Personal Finance Courses to Learn in December 2024

Top 10 Stock Market Trading Courses to Learn in November 2024