CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
2024 Revision to Government Auditing Standards Impact
-
Online
4.00 Credits
This course will provide an update of Government Auditing Standards as a result of the GAO's issuance of the 2024 Revision to Government Auditing Standards. The course will focus on the Revisions impact on financial statement audits. The course will also focus on the impact of Quality Management Standards as well as clarify as to when the concept of reporting key audit matters might apply for financial audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Microsoft Copilot Deep Dive Hands-on Bootcamp for CPAs
-
Online
2.00 Credits
Microsoft 365 is one of the most widely used business applications software suites used in business today. Microsoft Copilot is the generative AI application that is integrated directly into the Microsoft 365 ecosystem. If your firm or business is a Microsoft 365 user, this course will teach you how to use Copilot AI to optimize the use of your Microsoft 365 apps. This course will provide a comprehensive review and demonstration of how to put Microsoft Copilot AI to work for you and your clients. It is designed as a "hands-on" course that facilitates following along with the presenter to apply the features of Microsoft Copilot on your computer. Practice files will be provided so that you don't have to expose your confidential data. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Hot Topics Accounting Update - 2026
-
Online
2.00 Credits
Many accountants desire to have a quick overview of only the most current issues in accounting and financial reporting. This course will provide an executive summary of the most important changes in U.S. GAAP. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Advanced Excel for Staff - Build Reports and Analyze Data
-
Online
2.00 Credits
Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize, and structure data, apply calculations to derive key metrics, and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful, and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Entertainment, Meals & Travel Expenses: Review and Update
-
Online
2.00 Credits
This program reviews the statutory and regulatory guidance as they relate to fringe benefits. There will be an emphasis on entertainment, meals and business transportation expenses, including qualified employer-provided parking, with a focus on planning opportunities. Recent federal tax legislation, cases and rulings will also be addressed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Future of Audit: Technology, Talent & Transformation
-
Online
1.00 Credits
The audit profession stands at a critical inflection point, facing unprecedented challenges from technological disruption, evolving regulatory landscapes, and workforce transformation. This comprehensive course, based on the Pennsylvania Institute of CPAs' groundbreaking research report "The Future of the Audit: Building Relevance and Sustaining Quality," provides auditors with essential insights and actionable strategies to navigate these seismic shifts. Through expert perspectives from industry leaders including PCAOB board members, Big Four executives, and audit committee chairs, participants will explore how artificial intelligence, blockchain, and data analytics are fundamentally reshaping audit practices while creating new opportunities for value creation and risk assessment. Beyond technology adoption, this course addresses the pressing talent crisis facing the profession and offers practical solutions for building a future-ready workforce. Participants will learn how to leverage emerging technologies to enhance audit quality, understand the implications of regulatory modernization including the concept of "regulatory sandboxes," and develop strategies for attracting and retaining top talent in an increasingly competitive market. Whether you're a partner in a small firm, a manager in a large organization, or an audit professional seeking to future-proof your career, this course provides the roadmap for maintaining relevance, ensuring quality, and thriving in the evolving audit landscape. You'll leave with concrete action steps for immediate implementation and a clear vision for transforming your audit practice to meet the demands of tomorrow's financial ecosystem. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Volume to Value: A New Era of Precision Hiring in Accounting
-
Online
1.00 Credits
Volume to Value: A New Era of Precision Hiring in Accounting examines how accounting firms are shifting from high-volume recruiting models to "precision hiring" as AI adoption accelerates and talent scarcity continues. Participants will explore why traditional hiring processes often overemphasize technical accounting knowledge while under-assessing the competencies that most impact performance-critical thinking, professional communication, and AI ethics awareness. The course explains how AI-enabled recruiting tools can support candidate screening, assessment, and retention forecasting, and why firms that do not modernize their hiring approach may struggle to compete for top talent. Participants will leave with practical approaches to competency-based assessment, ethical guardrails for AI use in hiring, and a high-level implementation roadmap with metrics to evaluate quality of hire, performance, and retention. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Forgotten Managerial Accounting Tools for CPAs
-
Online
2.00 Credits
This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Managerial Accounting: Your Prescription for Better Decision
-
Online
4.00 Credits
This session revisits useful, but potentially underutilized, managerial accounting techniques. You will appreciate a fresh look at concepts you may not have considered since your college days. We will illustrate practical ways you can immediately implement managerial accounting analysis in your professional endeavors. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
You Don't Know What You Don't Know About Microsoft Excel
-
Online
8.00 Credits
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Internal Control Changes for Remote Workers
-
Online
2.00 Credits
For the past two decades the trend has been to move away from brick and mortar offices and have a greater number of people work or telecommute from home. Because of the upheaval caused by recent events, the rate of this move has been accelerated. This has and will continue to create control challenges and organizations must work to address these. Such things as moving from time based employee value to task completion based measurement and the ability to drive needed inter-company communication are just a sample of the issues with which entities must contend. This session looks at the benefits and pitfalls of workers that telecommute. It then discusses important risks and controls to consider as this trend continues and evolves in the business world. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Self-Rental Real Estate: Passive Activity & Section 199A
-
Online
2.00 Credits
This program presents a detailed analysis of the self-rental passive activity rules, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Forensic Accounting: Investigating Divorce Cases
-
Online
4.00 Credits
With over 50% of marriages ending in divorce, forensic accountants are frequently used in uncovering hidden income and assets. It is not uncommon for one spouse to hide money from another, sometimes for nefarious reasons. As a CPA, your services are valued by high-net-worth individuals who hire attorneys in their divorce proceedings. In this course, you will learn the art of financial investigations and how to uncover the truth in divorce cases, whether from offshore accounts to lifestyle analysis. Step by step, the course will teach you the valuable skills necessary in finding, analyzing, evaluating, and presenting your findings to your client and if needed, ultimately in divorce court. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Retirement Planning: Next Stage for You or Your Client
-
Online
2.00 Credits
If you or your clients are facing that stage of life where careers are passing into the background, and a new "to be determined" life is emerging, then you are entering what is called "retirement". Some people are excited, some are scared, and most are both. There are many issues and questions people face at this time - what to do with time, financial, relationships, health, identity and more. This program summarizes the key research studies, provides stories from those who have made this work, and offers thoughtful, practical exercises from my award winning book NEXT STAGE. It will help you (or your clients) address key issues and develop a Master Plan for the transition. If not now, when? This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Complete Guide to Analyze Data with Excel PivotTables
-
Online
4.00 Credits
Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
LLC's & S Corporations: a Comparative Analysis
-
Online
8.00 Credits
This course focuses on the most common aspects and tax implications of Limited Liability Companies and S Corporations. It will further compare forms of entities, along with corporate formalities compliance issues of each entity type. Electing Subchapter S status as well as reviewing the mechanics of electing Subchapter S status will be discussed. Highlights of entity specific tax forms will be discussed, as well as accountable plans, taxable fringe benefits, officer reasonable compensation, estate planning, business continuation planning and audit strategies. Schedules K-1, K-2, K-3, and effectively connected income will be reviewed in this course as well. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Finding Errors in Excel Spreadsheets
-
Online
2.00 Credits
This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Bytes, Bias, and Balance: Data Ethics for Savvy Accountants
-
Online
2.00 Credits
This course explores the transformative role of artificial intelligence (AI) in accounting and auditing, highlighting its vast potential while addressing the associated risks and ethical considerations. Participants will discover how to harness AI tools to enhance efficiency and innovation, while mitigating challenges such as overreliance, data security vulnerabilities, and ethical dilemmas. Through case studies and interactive discussions, you'll gain practical skills to navigate AI complexities, ensure trustworthy outputs, and uphold ethical standards in today's fast-paced digital environment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Behavioral Finance Biases
-
Online
1.00 Credits
If you have been a practitioner for any length of time, you know that there is often a difference between what clients should do and what they actually do. Have you ever wondered why that is? In this course, we will explore how we make decisions with less-than-perfect information. Through real-life examples and case studies, we will examine common behavioral biases and how to deal with them. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
Online
2.00 Credits
This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners "tax basis" capital accounts, now required for tax form reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.