Audit & Forensic Data Analysis with MS Excel
What you will be taught
-
1. Implement Digital Analysis methods like Benford’s Law and Relative Size issue Theory (RSF) in Excel to establish purple flags or fraudulent transactions
-
2. Use Pareto evaluation (80-20 rule) and establish excessive worth (and excessive danger) transactions
-
3. Use Statistical measures like Standard Deviation and Coefficient of variation to zero-down on transactions of audit curiosity
-
4. Re-engineer your audit processes to create dramatic efficiencies in evaluation and reporting
-
5. Perform a ‘Time Dimension’ evaluation on knowledge, be taught to interpret outcomes
-
6. Perform a Vendor grasp clean-up and establish suspicious and fraudulent distributors
-
7. Connect Excel worksheet to company (or Tally) database & extract any knowledge that you really want
-
8. Connect your Excel worksheet to reside knowledge on the Internet to trace (for e.g.) present worth of investments
-
9. Get Kaleidoscopic views on knowledge by slicing and dicing the info
-
10 Automatically create, from a single report inside Excel, a report for every of the seller’s transactions (for affirmation)
-
11. Detect non-compliance with organizational insurance policies & compliance body work
-
12. Identify income leakages, double funds, and so on.
-
13. Work with giant knowledge units (much more than million rows) in Excel
Show extraShow much less
Challenges are multifarious. Overwhelming nos. of transactions, lack of typical (paper) audit path, system based mostly controls, ever rising and sophisticated compliance necessities are amongst the prime explanation why conventional strategies of accumulating and evaluating proof (like vouching and verification) are now not ample. The auditor can now not deal with Information Systems as a ‘Black Box’ and audit round it. His strategies and methods have to alter. This change is what the world calls in the present day, ‘Assurance Analytics’ i.e. knowledge evaluation from an ‘audit perspective’.
Using advance options of MS Excel, the auditor can entry shopper’s knowledge from their databases and analyse it to discharge the onerous obligation forged on him. Since over 15 years, CA Nikunj Shah has been perfecting these methods of ‘assurance analytics’. These embody digital evaluation methods like Benford’s Law, Relative Size Factor Theory (RSF) and Pareto’s 80-20 rule which have enabled auditors and forensic investigators to establish management failures and over rides, detect non-compliance with legal guidelines, zero down on questionable transactions and establish purple flags misplaced in hundreds of thousands of transactions. It is like shortly discovering the needle in a hay stack!! In this distinctive course, your favorite teacher shall share the most effective of his analysis, auditing and coaching expertise. The members shall be taught, step-by-step, the nuts-and-bolts particulars of utilizing advance options of Microsoft® Excel coupled with the trainer’s insights to use them in real-world audit conditions. Each part shall equip members with assurance analytic methods utilizing real-world examples and learn-by-doing workout routines.
Who this course is for:
- 1. Chartered Accountants, Managers, Team Members and Articled Trainees in Audit perform (All varieties of Audits like Internal, Statutory, Management, Performance, and so on.)
- 2. Heads, Managers and Team Members in Financial Accounting perform
- 3. Forensic Accountants and Financial Fraud Investigators
- 4. Information Systems Auditors
Umang Shah –
The course gives conceptual insights into many useful data analysis techniques. Nikunj was patient to share his practical world experiences to each topic which made understanding it even easier.
Atul Shah –
This is a course that all Chartered Accountants needs to enroll. The author has used story telling technique to make it interesting and have given practical insight to every topic. We need to be grateful to author for having shared his 2 decades of experience in very simple and lucid manner.
George Varghese M –
Excellent course ,Got a very good insight into the advanced excel features on data analysis ,which will be very useful in audits and business decisions
THANKYOU
Anna Logan –
The sound quality is terrible
Michaela Gabrielle Pamfilo –
I have learned a lot of excel Techniques and I gained a better understanding of different statistical theories that can be applied in auditing. Thank you!
Loganathan Nainar –
Explained the topics very well with patience. Expected few more chapters from the trainer
Sumit gill –
sir, a good learning experience especially video 1.5 but not able to download resource material metioned at 1.1. please help
Udit Vyas –
Got some great insights and also got to know about techniques and it applicability in the real life world which I never applied while auditing but I’m surely gonna do in future.
Thank You CA Nikunj Sir 🙂
Alister Pinzon –
Some sessions at the beginning were too basic, but it improves when I keep going through the course. Very good tips and very practical
Shubham Jaiswal –
Audio is not good at all, needs to be work as soon as possible.