Information Technology

This course introduces users to the Power Query Editor, using the Excel version of Power Query, and includes a hands-on transformation exercise using the editor. 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...

This course explores the data analytics aspects of AI in accounting. Participants will develop skills in leveraging AI tools for enhanced data analytics.

This course introduces accounting, auditing, and finance professionals to the emerging field of agentic AI: autonomous, goal-driven systems capable of planning, acting, and learning with minimal human intervention. Participants will explore how agentic AI differs from traditional automation (RPA) and generative AI, and how these agents are being deployed in finance and accounting. The course...

This course introduces key cybersecurity concepts tailored for financial professionals. It emphasizes the CPA's role in cyber risk management, key terminology, and practical steps to foster a security mindset, integrating cybersecurity with financial reporting.

This course explores the workflow of making connections to various data sources using the Excel version of Power Query. 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...

Append queries combine two or more queries into one output query that is a combination of the originals. This course discusses best practices for creating append queries using Power Query (Excel version) and includes hands-on exercises to enable the user to demonstrate what they have learned.Power Query is an "ETL" tool that extracts, transforms, and...

With the Power BI ecosystem, a complete business intelligence solution, your company can begin the data analytics journey with Excel. Excel contains two data tools of the Power BI ecosystem to begin developing data skills: Power Query and Power Pivot. Beginning your data journey with an application your business users are already familiar with will...

As accounting firms and financial institutions deploy agentic AI, they face significant governance challenges. This course focuses on cybersecurity, data governance, and risk management practices essential for the safe and effective use of autonomous systems. Participants will examine frameworks such as NIST AI RMF and the CSA's red-teaming guidelines, as well as case studies on...

A merge query combines two queries that have a common column or columns. This course discusses best practices for creating merge queries using Power Query (Excel version) and includes hands-on exercises to enable the user to demonstrate what they have learned.Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has...

The accounting profession is rapidly shifting from a compliance-centered focus to one that demands insight, foresight, and strategic advisory skills. This course explores the "why" behind this transformation and highlights the critical role data analysis plays in helping CPAs remain relevant and competitive.This course provides a high-level overview of the skills and mindset required to...