Mastering Data Analytics in Excel – Practical Workshop | Globaltraining

Mastering Data Analytics in Excel - Practical Workshop

Date(s) and Time(s)
24 May 2021 - 09:00 AM
7 hours
Email Address
University of Nicosia / Computer Lab: B111


Costas Perdikis

The aim of the seminar is to explain the different functions and formulas of Excel, as well as how these can be used to help auditors succeed.

During the seminar, a number of functions and formulas will be explained and participants will be able to practice all functions and formulas discussed. Examples will be given that could be used to detect fraud, errors, etc.

By analyzing big data of transactions and comparing data from different sources, internal control can detect fraud, ineffectiveness, or non-effectiveness in compliance.


The seminar will help participants better understand what terms like data analytics, data analysis, and CAATs mean, the need for retrieval of the “right” data and their validation methods. This seminar will analyze practical applications in the various business cycles, in the journal entries review together with anti-fraud tests. In addition, the course will offer a demonstration of some of the industry-standard tools and data visualization tools.

Participants’ Profile:

Internal Auditors, Compliance Officers, Information Security Auditors, External Auditors, Consultants