Audit & Forensic Data Analysis with MS Excel

$89.99

Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
Disclosure
SKU: B800526E Category:
(10 customer reviews)
Product is rated as #1 in category Data Analysis

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

10 reviews for Audit & Forensic Data Analysis with MS Excel

4.2 out of 5
2
3
1
0
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. 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.

    Helpful(0) Unhelpful(0)You have already voted this
  2. 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.

    Helpful(0) Unhelpful(0)You have already voted this
  3. 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

    Helpful(0) Unhelpful(0)You have already voted this
  4. Anna Logan

    The sound quality is terrible

    Helpful(0) Unhelpful(0)You have already voted this
  5. 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!

    Helpful(0) Unhelpful(0)You have already voted this
  6. Loganathan Nainar

    Explained the topics very well with patience. Expected few more chapters from the trainer

    Helpful(0) Unhelpful(0)You have already voted this
  7. Sumit gill

    sir, a good learning experience especially video 1.5 but not able to download resource material metioned at 1.1. please help

    Helpful(0) Unhelpful(0)You have already voted this
  8. 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 🙂

    Helpful(0) Unhelpful(0)You have already voted this
  9. 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

    Helpful(0) Unhelpful(0)You have already voted this
  10. Shubham Jaiswal

    Audio is not good at all, needs to be work as soon as possible.

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    Audit & Forensic Data Analysis with MS Excel
    Audit & Forensic Data Analysis with MS Excel

    $89.99

    Courses Online
    Logo
    Compare items
    • Total (0)
    Compare
    0
    Shopping cart