Excel for Audit |
| Excel for Audit |
| Course Contents |
|
Session One: Introduction to Excel as CAAT Tool
|
|
Session Two: Getting Data into Excel
- Importing Text (ASCII) files
- Print Report Files
- PDF Files
- Using ODBC – Tally, Access, SQL Server
|
|
Session Three: Verifying Data Integrity of Reports
|
|
Session Four: Summarising Inventory data
|
|
Session Five: Finding Gaps (as in Cheque no. series)
|
|
Session Six: Finding Duplicates (as in vendor payments)
|
|
Session Seven: Verifying Sales made at authorised Rates
|
|
Session Eight: Drawing Statistical Samples
|
|
Session Nine: Relative Size Factor Theory (RSF)
|
|
Session Ten: Verifying Account Head Classification
|
|
Session Eleven: Stratifying Audit Population
|
|
Session Twelve: The 80 – 20 Principal
|
|
Session Thirteen: Benford’s Law
|
|
Session Fourteen: Case Studies
- Inspection Audit of Stock Broker’s Data
- Audit of Retail store in Mall
|
