Data security is a front-of-mind topic for most businesses because the risk and cost statistics are sobering. Each of us is in the crosshairs because a typical internet-connected computer faces a cyberattack every 39 seconds. Businesses of all sizes should be cognizant of the ethical issues that must be considered when planning their approach to...

Power BI Desktop is the authoring tool for the Power BI Ecosystem and is an essential component of the Power BI ecosystem. Power BI Desktop is a free application that is available for download.This one-hour course will demonstrate the capabilities of Power BI Desktop as your company continues its journey to increasing its data skills...

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

This final course in the series covers advanced features in Power Query (Excel version), including functions and parameters and basics of data modeling in Power BI and Power Pivot. Multiple hands-on examples help to reinforce these concepts.Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that...

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

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

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 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 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 data analytics aspects of AI in accounting. Participants will develop skills in leveraging AI tools for enhanced data analytics.