Focus & Features:

With the increasing focus to automate processes and the need to operate in the digital platform, Companies and executives have increasingly relied on the use of data and information in making decisions and actions towards achieving their purpose. As a result of this shift, it is imperative for auditors to be able to understand what the data shows and use it to create value-adding recommendations. However, auditors are deterred from maximizing it due to the competencies needed to import, cleanse, analyze, interpret and transform these data to information.


To address these challenges, internal audit professionals began to use tools which are generally known as Computer –Assisted Audit Techniques or "CAATS." One of the tools that are commonly used by internal audit professionals in the Philippines is Microsoft (MS) Excel. This course will aid internal auditors in maximizing their use of MS Excel in conducting various audit activities ranging from data understanding, importing and extracting, analysis, and reporting, among others. The methodologies include a combination of lectures, case studies and group discussions to provide a comprehensive learning process.



What You Will Learn

Beginning with the End in Mind!

  • Formulating reports based on the requirements.

Data and Database: An Overview

  • Database Components:
  • Data Types,
  • Database Anomalies:
  • Database Normalization Process.

Visualizing Data in MS Excel

  • Finding and highlighting cells based on a pre-determined condition/s,
  • Creating in-cell bar charts with data bars,
  • Maximizing the use of Conditional Formatting,
  • Creating heat maps with color scales,
  • Using Charts in presenting large volumes of information.

Formatting your Worksheets

Importing, Extracting and Exporting Data from other sources


Verifying and Protecting the Integrity of your Data

  • Sum Totals, Count Totals, Hash Totals, etc.
  • Data file size

MS Excel as a Tool for Data Analysis

  • Sorting, filtering and grouping data,
  • Data cleansing,
  • Finding duplicates and gaps,
  • Relating, Joining and merging data from various sources, and
  • Using Powerful Functions/Formulas.

Summarization and Reporting: Pivot Table and Charts


Case Studies and Group Discussions


Who Should Attend



This seminar is ideal for internal auditors, cross-functional teams with audit oversight and control functions, and day-to-day professionals involved in the analysis and reporting of various Company information (i.e. Financial Planning and Budgeting, Treasury, General Accounting and Comptroller, etc.). This is also a general course for anyone interested to increase their knowledge and skills on the use of MS Excel.


No. of CPE: 7

Location

Virtual set-up/via Zoom

See route

Contact us

For additional event or venue information, please email training@iia-p.orgYou can also reach us at +63 9409551

Sponsors and Partners