Excel Data Analysis

Training In person 14/06/2024 7 CPE-points
Excel Data Analysis
Early bird


€800,00 (€968,00 incl. VAT)

€600,00 (€726,00 incl. VAT)


€900,00 (€1.089,00 incl. VAT)

€700,00 (€847,00 incl. VAT)
Useful information

14 June 2024 - 09:00

14 June 2024 - 17:00

IIA Belgium



7 CPE-points


For managers, analyzing data is a powerful skill to enable better decision making. For auditors, data analytical skills are essential to find flaws in the process. Microsoft Excel has always been one of the most popular tools for regular data analysis thanks to its built-in pivot table functionality to report and visualize the underlying data. But nowadays Excel can do even more for you since it embedded Power Query, Data Analysis functions (DAX such as in Power BI), the Data Model and Power Pivots without any additional costs.

Target Audience 

Data analysis skills are becoming almost a prerequisite to become an auditor. In this expert course, you will learn how to perform data analysis using Excel’s most powerful and recent features.

Course Objectives

Data Analysis is a process, and it needs to be part of your Audit organization. It contains subprocesses and steps that are defined to guide you through audit testing during fieldwork and to deliver the results in the most optimal way.

Some of these steps may include:

- Understanding the infrastructure on how data moves and is stored;

- Obtaining access to coherent and complete data; 

- Downloading the data into your test environment; 

- Cleaning and preparing data; 

- Defining the tests and scenario’s that are to be performed; 

- Performing different data analysis techniques of different complexity; 

- Documenting the steps taken to be able to reperform the analysis; 

- Preparing your results for clear and understandable reporting.

Course Content

- Recap how basic pivot table functions work; 

- Demonstrate how today’s (x)lookup functions connect tables together;

- Introduce the Data Model and related Power Pivot functionalities that solves many problems, while adding and providing more complexity; 

- Get you acquainted with matrix formula’s to perform complex calculations;

- Visualize data from unstructured sources;  

- Demonstrate how VBA code can solve the most difficult problems; 

- End up with some auditing techniques embedded in Excel


Participants are expected to have practical experience in using Excel, including the use of the basic set of spreadsheet functions and formulas. Familiarity with audit concepts is recommended to maximize the benefits of this advanced course on data analysis.

Mark Dekeyser
Mark Dekeyser

Mark Dekeyser is an expert trainer and consultant related to IIA Belgium. He has a CISA certificate and is also member of ISACA. 
Between 2012 and 2021 he served as a member of the IIA Belgium Board of Directors and of the Executive Committee.
He teaches a variety of courses, among which Risk Based Auditing, Digital Transformation, Data Analysis and many more.
As a consultant he's involved in performing periodic Audit Quality Assessments for member organizations of IIA Belgium.

IIA Belgium uses cookies so that you can automatically log in to our website. We use Google's cookies to analyze activities on our website. Thanks to this we can also see how our website is used and which features you find interesting. If desired, you can change your preferences under "Cookie preferences".

Read more about cookies in our cookie policy or take a look at our privacy policy to see how we handle your personal data.

Cookie preferences