Modern Data Analysis approach in Excel

Starts 21 Mar 2022

Overview

COVID SAFE TICKET IS REQUIRED

 

TITLE:

Modern Data Analysis approach in Excel

OVERVIEW:

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 sub-processes 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.

PREREQUISITES:

The training course Excel for Auditors is the ideal preparation prior to taking this class. Of course, if you are already skilled in the most commonly used functionalities within Excel, you can decide to immediately step into this expert training.

Modern Data Analysis approach in Excel

Modern Data Analysis approach in Excel - 21 March 2022

Sign in to register

Facilitator

About the facilitator

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.