Pivot is probably the most used feature in Excel. On the pivot output, if we want to filter the data to quickly check for any specific information, excel dosen't have the filter option enabled. In this video we will see how we can find a work around and trick excel into getting the filter enabled. 

Useful for auditors and accountants, this video explains about how Fuzzy Lookup add-in can be used to identify duplicate vendors, using duplicate names through Fuzzy Lookup.

Useful for auditors, this video explains about how one can check Bank account changes in vendor master for potential vendor payment fraud through vlookup and IF functions.

Purchase Order (PO) approvals are generally inbuilt in ERP systems, which is triggered generally based on the PO value, among other parameters.

This controls is circumvented by raising multiple low value PO to the same vendor, so that lower level of approval is required for such low value PO's.

We would see how we can check for these instances in Excel using Pivot and Vlookup using "False" value.

Super quick video on 2 techniques that can be used to remove unwanted space when copy-pasting numbers from excel to word.

RSF compares the maximum and next maximum amount to identify abnormal transactions.  In this video, we will understand more about RSF and how we can identify RSF in excel.

Spreadsheet, in this instance an Excel has become imperative in our day to day life and has become the heart which powers the financial and operational decisions. How can we audit the spreadsheet ?

In this video, we will look into few audit areas and how we can do the audit.

Spreadsheet, in this instance an Excel has become imperative in our day to day life and has become the heart which powers the financial and operational decisions. How can we audit the spreadsheet ?

Powerful function, which can do just more than total !

Probably the most known and least used statistical tool by Auditors, should be the first analysis that one should do when starting an IA or Forensic Audit.

We will see briefly what is Benford's law and practical tips for using it.