CPE Catalog & Events
Excelling at Excel: The Magic of Power Query
-
Online
2.00 Credits
Member Price: $89
Elevate your data analysis capabilities with our focused course on Power Query. Tailored for financial professionals, this training will show you how to get started using Power Query and teach you some of the ways to take advantage of its ability to handle messy data and automate repetitive tasks. Harness the efficiency of Power Query to revolutionize the way you work with data. Learn how to "program" your tasks once and set them on repeat, eliminating the need for repetitive, robotic work. This automation not only saves time but also ensures consistency and accuracy in your data processes. Whether you're dealing with complex datasets or simply looking to streamline your reporting processes, this course will equip you with the tools and knowledge to make Excel work for you like never before. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
How to Audit: Property, Plant, & Equipment
-
Online
2.00 Credits
Member Price: $89
Property, Plant, & Equipment is often one of the largest balances on the financial statements. This course will cover the foundation of auditing PP&E, including the related audit assertions, risks, & threats to the PP&E balance. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through some real-world examples. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
AI at Work: Practical Tools for Professionals
-
Online
1.50 Credits
Member Price: $69
Artificial Intelligence (AI) is rapidly reshaping the way financial professionals work, lead, and make decisions. Yet for many, AI still feels abstract, intimidating, or too technical. This workshop cuts through the hype and makes AI approachable, practical, and immediately useful. Designed for financial professionals, executives, and managers, this hands-on session focuses on real workplace applications that improve efficiency, clarity, and decision-making. Participants will learn how to use AI tools such as ChatGPT, Microsoft Copilot, Google Gemini and others to streamline everyday tasks, enhance strategic thinking, and free up time for higher-value work. Through live demonstrations, interactive exercises, and guided experimentation, attendees will leave confident in their ability to integrate AI into their workday, increase productivity, and take practical uses back to their teams.This course is being offered by a 3rd party vendor and will not be accessible from your My CPE page. Access information will be emailed directly to you by AICPA.
New PCAOB Quality Control Standard Overview
-
Online
2.00 Credits
Member Price: $89
Due to advances in technology, use of outside resources, and more, PCAOB released a new integrated, risk-based standard focused on accountability and continuous improvement for all PCAOB-registered firms. This course will provide an overview of the significant elements and foundational principles of this new standard. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Internal Audit: Keys to Managing an Effective Function
-
Online
2.00 Credits
Member Price: $85
The globalization of business, ongoing changes in technology, increased attention of shareholders and stakeholders and the continuing demands of the Audit Committee and senior management require a dynamic framework for managing today's internal audit department. This session, designed by a past Chief Audit Executive with significant exposure to a multitude of industries and internal audit frameworks, explores the key competencies and responsibilities of today's internal audit management and methods for meeting the requirements of the internal audit profession. We will also discuss some of the greatest challenges of the role and how to address those challenges. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Drive Results with Metrics
-
Online
2.00 Credits
Member Price: $89
Many organizations struggle to keep budgets current in an ever-changing business climate. Twenty-first century performance metrics focus on determining what budgets should be rather than what they were in the past. Using performance metrics effectively reduces work, reduces politics, provides flexibility and substantially improves the performance management process. This session will show you powerful techniques to drive your organization’s performance. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Excel for Accounting Professionals Session 6: List Comparisons and Indenting
-
Online
2.00 Credits
Member Price: $89
Major benefits of detailed Excel workbooks Understanding list comparisons in Excel is vital for improved workbook efficiency. In this webcast, the facilitator will walk you through comprehensive learning exercises that provide an overview of the following topics: Performing list comparisons Building multicolumn list comparisons Using lookups Indenting commands In-depth training for Excel upskilling This webcast is crafted to enable active participation as you follow the demonstrations. It will navigate you through the intricacies associated with working Excel columns, helping you to apply key functions effectively for significant improvements through the following: ISERROR COUNTIFS SUMIFS *Session 6 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 7: Data- Driven Workbooks and Concatenation] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-7--date-driven-workbooks-and-concatenation) to further prepare to tackle real-world issues and build powerful workbooks.*
Fiduciary Accounting Part 3: Special Accounting Elections & Distributions 26-27
-
Online
2.00 Credits
Member Price: $99
Trusts are old entities and go as far back as the Crusades when we were an agrarian society, and the only asset of any value was the land and what was produced on the land. Therefore, dividing the benefit in a trust between income and principal was logical and worked efficiently for a long time. However, times have significantly changed, and trusts are often invested in assets that don't involve land, and these assets also have great value. Often, the value lies in their growth rather than their income. New rules have developed in the fiduciary accounting area that provide elections that often result in favorable benefits to the trust and the beneficiaries. This course will explore those elections. Be sure to register for all four parts: Fiduciary Accounting Part 1: Fiduciary Duty Basics & Authority Fiduciary Accounting Part 2: Tools, Rules and Relationship to Tax Fiduciary Accounting Part 3: Special Accounting Elections & Distributions from Entities Fiduciary Accounting Part 4: The New Frontier (Total Return Trusts)Delivery Method: Individual webcastCPE Credit: 2Program Level: Intermediate
Fiduciary Accounting & Tax Planning for Estates & Trusts
-
Online
4.00 Credits
Member Price: $149
This course will review the fundamentals of fiduciary accounting and provide a reporting guide for determining whether receipts and expenditures are assigned to income or principal/corpus. Critical issues, rules, and special opportunities when preparing your clients' Form 1041 U.S. Income Tax Return for Estates and Trusts will be examined, including what is considered taxable income and allowable deductions. Planning and potential pitfalls will also be explored. This course only qualifies for 2 IRS credits. *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Corporate Storytelling in Financial Reporting
-
Online
1.00 Credits
Member Price: $55
Developments in the Management Commentary and MD&A Narrative reporting is entering a new era-one that moves beyond compliance checklists to focus on cohesive, decision-useful communication. This seminar examines the evolution of corporate narrative reporting through the revised 2025 IFRS Practice Statement 1: Management Commentary and the U.S. GAAP-based MD&A under SEC Regulation S-K, with key comparisons to help practitioners understand how each framework supports investor-focused disclosure. Using real-world examples and excerpts from the actual annual report of an IFRS reporting company, this seminar highlights how the revised Management Commentary guidance aims to improve the quality, relevance, and connectivity of narrative insights. Participants will explore its emphasis on strategy, risks, sustainability factors (ESG), key performance indicators (KPIs), and the integration of financial and non-financial information. The session also analyzes the modernization efforts in U.S. MD&A, including principles-based guidance, reduction of boilerplate disclosures, and expanded expectations for entity-specific analysis and trend-based insights. Through a comparative approach, participants learn how both frameworks are converging around common principles: enhanced connectivity, balanced presentation, entity-specific content, and alignment of strategy, performance, risk, and value creation. This practical seminar provides accounting, finance, and business professionals with the knowledge needed for better understanding the management commentary and MD&A. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Tax Update: "One Big Beautiful Bill"
-
Online
2.00 Credits
Member Price: $89
This course provides a focused analysis of the individual and small business provisions in Pub. L. 119-21 (H.R.1), "One Big Beautiful Bill." Tailored for tax professionals working with Form 1040 filers, the course explores impactful updates, from the no-tax-on-tips provision to enhanced bonus depreciation. Designed to inform planning strategies and compliance for the 2025 tax year and beyond. Participants will gain actionable insight into newly proposed deductions and expanded credits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Strategic Government Budgeting: Tools for Long-Term Sustainability
-
Online
1.00 Credits
Member Price: $39
This course equips participants with the tools and strategies needed to create sustainable, long-term budgets that align with policy goals and ensure fiscal responsibility. Participants will explore key budgeting frameworks, learn techniques for forecasting revenue and expenditures, and analyze scenarios to mitigate financial risks. The course incorporates practical exercises and case studies to provide hands-on experience with scenario planning, enhancing budget transparency and resilience. By the end of the session, attendees will have the knowledge and confidence to design and implement budgets that support long-term governmental priorities and strengthen financial stability. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
The Controllership Series: The Controllers role in ESG
-
Online
1.50 Credits
Member Price: $79
As ever more jurisdictions move toward mandatory disclosure of ESG metrics, (ex: the European Union’s new Corporate Sustainability Reporting directive and impending U.S. SEC requirements) the urgency to get those disclosures right has gone up. This course to as an introduction to the concept of requirements for Controllers and financial personnel to understand ESG disclosures .Whether the role related to ESG disclosures and information falls into the job responsibility of the controller or not is yet to be seen. However, it is clear the Controller must maintain some level of knowledge and expertise around the types and timing of such disclosures. Delivery Method: Individual webcast CPE Credit: 1.5Program Level: Basic
K2’s Excel’s Best New Features
-
Online
2.00 Credits
Member Price: $89
With the latest updates in Microsoft 365 and Office 2024, Excel is more powerful than ever. Packed with cutting-edge features, more innovative functions, and seamless collaboration tools, the newest version is designed to take your productivity to the next level. Whether you're crunching numbers, building dashboards, or collaborating across teams, these enhancements unlock faster workflows, deeper insights, and more thoughtful decision-making. Don't miss your chance to stay ahead of the curve-discover Excel's most exciting new features and learn how to put them to work for you. Your spreadsheet game is about to change-let's make it extraordinary! Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Interview Techniques & Detecting Deception
-
Online
2.00 Credits
Member Price: $89
The ability to create and ask good questions as well as the ability to know when someone is being deceptive are important skills for managers, auditors, and investigators. This session will improve your interview techniques and your lie detection abilities. Multiple videos from various movies, TV shows, and public figures showcasing the behaviors of liars are included. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Asset Misappropriation You Have It – They Want It
-
Online
2.00 Credits
Member Price: $89
Have you ever thought about stealing? If the answer is NO, then you need to find another profession because you will never be a successful fraud examiner/investigator or a financial auditor. To find fraud, you must first determine, given the opportunity through weak internal controls, how a person would steal. You have to say to yourself, given the opportunity that exists, how many ways could I take advantage of it? In other words, you must be able to think how you could steal and not be caught. So yes, to find fraud, you must first think about stealing. For a fraudster to be successful, they must make you think fraud is a legitimate transaction. They must make you think it is something that it is not. There are so many places where fraud can be hidden. It is up to you to evaluate where the risks of fraud are in an organization, then design effective investigative procedures to determine if someone took advantage of the opportunity. If they did not, how else may they have taken advantage of the opportunity? One must remember that one weakness in internal control may create several ways to take advantage of it and you must examine every such one. During this session, the many ways fraud can be hidden in asset misappropriations will be discussed. Remember, the number of ways is only limited by one’s imagination. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Eliminating Busy Season: Transforming Your Practice to Year- Round Advisory Services
-
Online
2.00 Credits
Member Price: $89
This course provides tax and accounting professionals with a comprehensive framework for transitioning from a compliance-driven busy season model to a sustainable, year-round advisory practice. Participants will explore strategies for expanding services into tax, financial, and estate planning. The course addresses both transitioning existing clients and attracting new, higher-value clients while improving efficiency, client value, and revenue stability. Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate
Procurement Standards 2026: What You Need To Know
-
Online
2.00 Credits
Member Price: $89
Federal procurement requirements under the Uniform Guidance were significantly revised effective October 1, 2024, introducing new expectations for procurement methods, internal controls, contractor oversight, and domestic sourcing preferences. This session will provide grant recipients and subrecipients with practical guidance on implementing compliant procurement procedures under 2 CFR SS200.317-200.327 and aligning procurement policies with updated federal standards, and thresholds from the FAR. Attendees will learn how to strengthen procurement documentation, apply revised competition requirements, and prepare for federal agency or Single Audit procurement system reviews. This session provides the regulatory application to develop your own SOP. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Strategic Use of Trump Accounts: Planning Opportunities for Tax Professionals
-
Online
2.00 Credits
Member Price: $89
This course provides tax and accounting professionals with a focused overview of Trump Accounts and their practical application in client planning. Participants will examine eligibility requirements, contribution rules, tax treatment, and reporting considerations. Through practical examples, the course emphasizes evaluating suitability, identifying planning opportunities, and avoiding common compliance pitfalls when incorporating Trump Accounts into client strategies. *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to terri.storer@acpen.com Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Valuing A Business: What is This Company Worth” 26-27
-
Online
4.00 Credits
Member Price: $99
What is your company worth" Is business value the single most important metric" This session discusses various business valuation methods for any stage company: start-up, spin-off, or acquisition. Many valuation methods exist. Which method is right" Which is the "best" for a given business or a given situation" CPAs and Corporate Financial Managers cannot afford to miss this course.Delivery Method: Individual webcastCPE Credit: 4Program Level: Intermediate