**NEW** MS Excel and Data Analysis for Auditors: Online seminar 14.06.2021 bis 15.06.2021

Seminar objectives:

MS Excel offers a quick overview of databases as well as extensive analysis functions and various options to present analysis results in graphical diagrams. Internal audit often uses Excel for auditing as well as for evaluating and processing audit data.

In this two-day workshop, you will learn both the basic concepts of Excel and how to use and handle Excel as a working and analysis tool.

Seminar contents:

Part I

• Principles of Data Analysis
  • General procedures, legal requirements, data protection
• Basics of Excel functions and formulas
• Import of data from different forms
• Filter functions in Excel
• Data processing with Excel formulas and filters
• Creating and editing pivot tables
• Presentation of results
• Various graphical display options

Part II

• Database structures and their relations
• Dealing with Big Data
• Analysis options
  • Benford analysis, ABC analysis etc.
• Case studies based on existing data
• Analysis of master databases
  • Analysis of journal entries
  • Evaluation of an order process or a payment proposal list
• Outlook on future developments such as BI, robotics, AI etc.

Participants:

• Younger employees, entry-level internal audit

Prerequirements:

• Basic knowledge of Excel

Speakers: Jonas Gehrke