CIASP

COURSE OUTLINE

This revolutionary program will help you shrink the time you spend in conducting your audits and in preparing your reports from months to days/hours/minutes. You can accelerate your audit and accounting process by applying the magic tricks in Excel!

Gain great savings on time and cost by letting your data do the talking. With simple techniques in Excel, you can quickly identify areas of interest and focus to help your team become more effective in conducting audit and fraud examination.

Participants will also be guided on how to access, validate, manipulate, and analyze voluminous transactions.

This program is ideal for accountants and auditors, or for anyone who works on Excel.

Get the most from the training using Excel 2010 or 2013. This program does not support Excel in MAC computers.

____________________________________

What participants say about our program

The technical training session was complete and comprehensive and has enlightened me with the functionality and power of excel. The different techniques in performing the different functions that I thought were only available in ACL or other programs can also be performed in excel with ease. This will guarantee a boost in confidence, not only in performing data analysis but also in delivering other engagements as a professional auditor. - Anonymous

""I've learned that excel is one of the most under rated and under appreciated tool. This training gave me a new perspective on Data Analytics & Visual Presentation. Had I known these techniques (I've learned from this Workshop), I would have doubled or tripled my productivity." - Anonymous

Phases

Planning your project
Acquire the data
Access the data
Verify the integrity of data
Analyse the data
Report your findings

Cases

Accelerating Upload of Data
The objective of this case is to demonstrate how we can accelerate and cleanse errors in data format.

Validating Data
The objective of this case is to demonstrate how to validate data by looking at the transaction totals, duplicate and missing transactions.
Manipulating data I Date
The objective of this case is to demonstrate how to manipulate dates by slicing and combining certain components.

Manipulating data I Alpha 1
The objective of this case is to demonstrate how to manipulate alpha characters (“text”) by slicing and combining certain components.
Manipulating data I Alpha 2
The objective of this case is to demonstrate how to manipulate alpha characters (“text”) by writing it right.

Normalizing data
The objective of this case is to normalize data so they can be easily understood by ordinary readers
Cleansing data
The objective of this case is to master the art of creating the desirable flat file format.

Accelerating reports
The objective of this case is to demonstrate how you can further accelerate completing your regular reports.
Creating amazing visuals 1
The objective of this case is to demonstrate ways how to create amazing visual presentations.
Presenting to win
The objective of this case is to practice the art of preparing good visual presentations, with emphasis on the target audience of the presentation. This will test the participant's mastery of the key learning from this workshop.
Creating amazing visuals 2
The objective of this case is to demonstrate ways how to quickly prepare impressive charts
Consolidating data
The objective of the case is to be able to consolidate multiple sheets into desirable data format.