Excel Pivot analysis for accounting transactions - Workshop 2018

Identifier: 83287389

Duration: 1 day

Language: English

Cost:

Action

Overview

For REPs, Member staff and Group (3+) registrations, complete & email registration form to cpd.malaysia@cpaaustralia.com.au

Download brochure & registration form

 

Presenter:
Mr Stanley Wong

This workshop discusses on how various types of transaction audit trails are being analysed in Microsoft Excel and also how to discover irregularities in the transaction audit trails by finding the common patterns in your purchase, sales, and GL structure. 

 

Key topics covered:

  • Microsoft Excel Pivot Table
  • Information required for Pivot Analysis
  • Trend, Pattern and Spot Check
  • Pitfalls Discovery

Note: Bring own laptop with MS Excel 2010/2013/2016 installed on Windows version

Objectives

  • Analyse the Sales and Purchase Transaction
  • Identify the General Ledger account code that is vulnerable to the Pitfalls
  • Explore the Microsoft Excel Pivot Table Functions
  • Recognise the Pivot Table Analysis for sales, purchase and ledger transactions 

All our workshops are available via in-house training.

Audience

Accounting Department, SME and Corporates, Freelance accounting professionals, Internal Audit, Business Owners 

 

Course Structure

Title
Status
loading data
loading...