Information Technology

This hands-on course introduces accountants, auditors, and finance professionals to agentic AI by simulating autonomous behavior using the basic version of ChatGPT. Participants will use role-play, prompt engineering, and guided interaction loops to create agents that simulate planning, decision-making, and communication workflows. No coding or advanced access is required. Participants will practice designing task-specific prompts,...

This course teaches the user how to perform data transformations in Power Query, using a hands-on approach. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables...

This course covers a number of useful transformations using Power Query (Excel version) to clean, enrich, and shape data. Coverage includes pivoting and unpivoting, filtering and grouping, fuzzy matching, and more, with hands-on exercises for users to practice these skills.Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a...

This course explores generative AI (genAI) and prompt engineering and the relevance of these tools to accounting. The course will explain how generative AI differs from non-generative AI and help participants to understand current use, limitations, and risks associated with genAI integration in audits and financial reporting. The course will also explore best practices for...

This course explores how generative AI is revolutionizing cybersecurity. It highlights opportunities, such as enhanced threat detection, and risks, including AI-driven phishing and malware, particularly in financial contexts.

Using a variety of hands-on exercises, this course enables users to learn how to add columns using Power Query (Excel version). Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access...

A data-driven culture can only occur when there is collaboration, communication, and cooperation between everyone in your organization.Collaboration can only occur in the Power BI ecosystem when your organization works in the cloud with Power BI.com, also known as the Power BI Service, a software as a service available on the Power Platform.This one-hour course...

This course covers the key components of IT governance and risk management through interactive discussions and hands-on activities. By the end of the course, participants will have a thorough understanding of the function of IT governance within an organization, including roles and responsibilities and key frameworks. In addition, participants will learn about IT risk identification...

In today's interconnected world, safeguarding information systems is crucial. This course will provide a comprehensive understanding of SOC engagements, exploring the types of reports (SOC 1, SOC 2, and SOC 3) and the related management assertions. The use of the reports for internal controls over financial reporting (ICFR) and operations and compliance will be analyzed....