Excel for Auditors: From Basics to Advanced Analytics – Save the Date!
Lisätiedot
Aika
09.04.2025 08:30 - 25.04.2025 08:30
Paikka
Etäyhteys
Hinta
Jäsenet:
TBA
Ei-jäsenet:
Kuvaus
Excel is a powerful tool for auditors, offering extensive features for data analysis and productivity enhancement. This training is designed to help auditors leverage Excel’s advanced functionalities to streamline their audit processes and extract meaningful insights from data.
Who Should Attend?
This training is ideal for auditors, finance professionals, and anyone involved in data analysis who wants to maximize their efficiency with Excel’s advanced tools.
What You Will Learn:
- Data Analysis in Auditing: Understanding when and how to apply data analysis at different audit stages.
- Excel Productivity Hacks: Utilizing keyboard shortcuts, tables, and automation features.
- Advanced Excel Functions: Working with pivot tables, slicers, dynamic arrays, and complex formulas.
- PowerPivot & PowerQuery: Importing, merging, and analyzing large datasets efficiently.
- Power BI Overview: Exploring data visualization and advanced analytics for audit purposes.
Training Schedule:
📌 April 9 (Morning) – Fundamentals of Audit Data Analysis & Excel Productivity
- Understanding data literacy in auditing
- When and how to apply data analysis at different audit stages
- Essential Excel shortcuts, formulas, and automation techniques
📌 April 9 (Afternoon) – Advanced Excel for Auditors
- Mastering pivot tables, slicers, and dynamic arrays
- Using PowerQuery to clean, merge, and transform audit data
- Exploring advanced Excel formulas (XLOOKUP, FILTER, TEXTSPLIT, etc.)
📌 April 25 (Morning) – PowerPivot & Power BI for Audit Professionals
- Introduction to PowerPivot for large-scale data analysis
- Creating custom measures and calculations
- Overview of Power BI for audit reporting and visualization
You can participate in a single session or attend the full training to gain a comprehensive understanding of Excel’s role in audit data analysis.
By the end of the training, participants will be equipped with practical skills to enhance their audit workflows using Excel’s most powerful tools.
Puhujat
Karlis Majevskis (CIA, CISA)
Karlis has 12 years of experience in internal auditing, with a strong background in IT management, including project management and the implementation of ERP and data analytics systems. Specializing in IT and cybersecurity audits, he has extensive expertise in Excel, PowerPivot, MS Access, and Power BI, particularly in analyzing large datasets for audit purposes. His practical approach helps auditors leverage advanced data analysis tools to enhance efficiency and decision-making in audits.