Advanced Data Analysis in Excel

Event dates: 27 Nov 2020

Overview

Due to the new COVID-19 measures, this training will change to a “virtual” format.

Description

This advanced IIABel training course will help auditors to perform powerful data analyses. Lesser known expert Excel techniques bring self-service business intelligence to their desk. Power Pivots bring a lot more freedom to auditors because they will have powerful, easy-to-use data analysis tools right on their laptops without having the IT department to come for help…

Content

– With Power Pivot for Excel, auditors can import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and Pivot Charts—all without requiring IT assistance.
  • Data Analysis Expressions (DAX) is a new formula language that extends the data manipulation capabilities of Excel to enable more sophisticated and complex grouping, calculation, and analysis. The syntax of DAX formulas is similar to that of Excel formulas.

– Excel’s advanced and expert functionalities are essential to ensure further data analysis so that timely business decisions can be made.

They include:
  • Advanced pivot tables;
  • Deep diving matrix formulas;
  • Flat file, Benford and Gaps analysis;
  • Complex lookup, index, match and offset functions;
  • Consolidation and stratification; o Audit functionalities in Excel;

Please note

This training “Excel for Auditors” is an expert course which requires advanced Excel skills, such as pivot tables, matrix formulas, lookup and reference functions and more. Learn more Excel is positioned as the one and only most important tool for auditors to support them throughout their daily activities, whether it comes to risk analysis or control testing. Every day, auditors typically live and breathe in Microsoft Excel.

IIABel therefore offers a variety of training courses that will help auditors to get acquainted with basic, intermediate, advanced, expert and master skills within Excel.

PLEASE DON’T FORGET TO BRING YOUR OWN LAPTOP (Office 2013 or Office 2016 required)

Advanced Data Analysis in Excel

This advanced IIABel training course will help auditors to perform powerful data analyses. Lesser known expert Excel techniques bring self-service business intelligence to their desk.

Facilitator

About the facilitator

Mark Dekeyser

Internal Audit Process Manager KBC / Board Member IIABel

Mark Dekeyser is an Audit Methodologist and Audit Trainer at KBC Group. Prior to that he was IT Auditor also at KBC Group. He obtained CISA and is also member of ISACA. As an Audit project leader he's working on Audit Quality Assessments, Risk Based Auditing and the continuous improvement of the Audit processes. As a professional ICT trainer he’s also involved in the KBC training school. He became member of the IIA Belgium Board of Directors in 2012, where he now helps to ensure IIA Global’s strategy is implemented in the local institute.