Mastering Data Analytics in Excel – Practical Workshop | Globaltraining

Mastering Data Analytics in Excel - Practical Workshop

Date(s) and Time(s)
21 October 2020 - 09:00 AM
7 hours
Email Address
University of Nicosia / Globaltraining


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