CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
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.
Understanding and Creating an Internal Control System
-
Online
8.00 Credits
Successful organizations, both large and small, must understand the importance of effective internal controls and be able to develop a system of controls that will keep the entity on its intended course. Moreover, those that design policies and procedures benefit by knowing why control measures are necessary. This session sets forth internal control concepts and explains the importance of strong internal control policies. The material highlights some of the reasons that measures are needed and it also provides an overview of control creation methods. Finally, it discusses ways to successfully implement the developed policies and procedures. Participants that take this course will gain a well-rounded understanding of internal control procedures of all types. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Profiles in Fraud
-
Online
2.00 Credits
Nobody is immune to fraud risk. This course opens with stories of real fraud perpetrators then examines the similarities between the fraud perpetrators, discovering that they all have many common traits. It finishes with techniques accountants can use to deter these behaviors. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Beyond the Basics: Financial Ratios You Might Be Overlooking
-
Online
1.00 Credits
Overview: Understanding your company's financial health requires more than just traditional metrics. This webinar is designed to reveal deeper insights through advanced, underutilized financial ratios. In this session, accounting and finance professionals will explore metrics such as operating leverage, free cash flow yield, and margin of safety-tools that go beyond standard ratios to deliver nuanced perspectives on profitability, risk exposure, and operational efficiency. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Navigating IRS Correspondence: Responding to IRS Letters
-
Online
2.00 Credits
Participants will learn how to interpret the most common IRS correspondence, adhere to response deadlines, and effectively communicate with the IRS to resolve issues and minimize risks. It provides professionals with knowledge and strategies needed to handle the most common notices including audit requests, collections & return inquiries as well as error notices. Focusing on best practices to ensure compliance and avoiding penalties or escalation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Unconscious Bias for Managers, Supervisors, and Executives
-
Online
2.00 Credits
Understanding unconscious bias is key to creating an inclusive workplace and to making the best business decisions. This course explores the concept of unconscious bias, the science behind it, and how it can affect the way employers hire, evaluate, and treat employees. We will also discuss strategies employers can use to reduce unconscious bias and create a more inclusive workplace.
How to Audit Expenses & Payables
-
Online
2.00 Credits
It is imperative that audit staff understand the fundamentals of expenses & payables. This course will cover the basics of auditing expenses, accrued liabilities, and other payables, including the related audit assertions, risks, & threats to the expenses & payables balances. 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.
Workforce Transformation and Talent Management in 2025
-
Online
1.00 Credits
The accounting profession faces unprecedented workforce challenges that demand a fundamental rethinking of traditional firm structures. This course examines why the century-old pyramid practice model is becoming obsolete and presents the inverted pentagon framework as a sustainable alternative. Based on comprehensive research showing that 52% of firms expect to shrink by 20% or more in the next five years, participants will learn how to restructure their firms to thrive with fewer entry-level staff while expanding specialized expertise. The course explores the "6 Ps of Business Model Transformation" - Precision Hiring, Proactive Retention, Practical Technology Implementation, Pricing Expertise, Practice Area Expansion/Focus, and People Acceleration. Drawing from success stories in manufacturing, healthcare, and technology industries, attendees will discover proven strategies for accelerating staff development, implementing effective knowledge transfer programs, and building sustainable talent pipelines in an era of technological disruption and demographic shifts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Google Gemini AI for Accountants
-
Online
2.00 Credits
This course provides a concise overview of Gemini AI, Google's advanced multimodal artificial intelligence model. It explains how Gemini is integrated into different Google products, including Gmail, Docs, Sheets, Slides, and as a stand-alone chatbot. Participants will learn how Gemini enhances productivity by summarizing email threads, suggesting responses, drafting emails, generating formulas, creating tables, and more. By the end of the course, students will have a solid foundation in understanding Gemini AI's role in the evolving landscape of artificial intelligence. 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.
Tax Implications of Retirement Plan Distributions
-
Online
1.00 Credits
This session will address the complex rules of retirement distributions, review key provisions of the SECURE Act 2.0, and provide practical strategies of maximizing tax benefits for your client. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethics: 10 Crucial Qualities of High Character CPAs
-
Online
2.00 Credits
What can you do to enhance your commitment to the highest ethical standards of the profession? How will doing so bring you more business? In this unique and engaging ethics course, the instructor, Dr. Bruce Weinstein, The Ethics Guy (R), reveals ten crucial qualities of CPAs. They are: 1. Honesty 2. Accountability 3. Care 4. Courage 5. Fairness 6. Gratitude 7. Humility 8. Loyalty 9. Patience 10. Presence (focus or mindfulness) You're already a good CPA and a good person. This course will show you how to be even better. The result will be greater satisfaction in your professional relationships, a deeper commitment to the profession of accounting, and much more business. Please note that this is a stand-alone course for 2 CPE credits in Behavioral Ethics, but you'll maximize your ROI by also taking "Ethics: How to Build and Keep Your A-Team". Together these courses are two of the surest pathways to sustained success in accounting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
What's Changing in A&A for Governmental Entities (2026/27)
-
Online
4.00 Credits
This comprehensive course provides a timely update on key accounting and auditing developments affecting governmental entities, bringing together recent standard-setting, auditing, and compliance changes into a single, cohesive learning experience. Participants will begin with an update on major pronouncements issued by the Governmental Accounting Standards Board, including GASB Statements No. 103, 104, and 105, along with a high-level overview of active GASB exposure drafts and ongoing projects. Emphasis is placed on understanding how these changes affect governmental financial reporting, disclosures, and communication with stakeholders. The course then shifts to auditing developments, covering significant updates to the Yellow Book issued by the U.S. Government Accountability Office, including changes related to quality management, effective dates, and recent updates to the Green Book. Participants will also gain insight into the GAO's implementation delay and its implications for audit planning. Finally, the course addresses recent changes affecting Single Audits, including the 2024 Uniform Guidance overhaul, updates to Appendix B of the AICPA GAS/Single Audit Guide, recent Office of Management and Budget (OMB) memoranda, and reporting changes related to SAM.gov. Designed for auditors, preparers, and financial leaders working with governmental entities, this course helps participants understand how recent accounting and auditing changes intersect-and what to watch for as expectations continue to evolve. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Fundamentals of Form 1040 -- Business
-
Online
4.00 Credits
This course builds on the foundational knowledge from Part 1, Fundamentals of the 1040 - Core Concepts. It expands into business income taxation and additional reporting requirements. Participants will learn how to accurately report self-employment income, income from pass-through entities on Form 1040. This course covers Schedule C, Schedule E, and essential forms such as Form 7203 and Form 7217 to ensure accurate tax preparation for clients with business activities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
CPA to CFO: Essential Competencies for Finance Leaders
-
Online
1.00 Credits
The path from CPA to CFO has evolved dramatically in recent years, with only 43% of S&P 1000 CFOs holding CPA licenses in 2022, down from 55% a decade earlier. This comprehensive course, based on groundbreaking research from the Pennsylvania Institute of CPAs surveying over 320 CEOs and hiring executives, reveals what today's leaders truly seek in CFO candidates and provides a roadmap for CPAs to secure their seat at the executive table. Participants will discover the five critical competencies that distinguish successful CFO candidates: forward-looking financial acumen that goes beyond traditional reporting, strategic leadership skills including critical thinking and strategy creation, the evolving role of emotional intelligence, industry-specific expertise requirements, and the balance between technical proficiency and visionary leadership. Through practical frameworks, real-world examples, and actionable strategies, attendees will learn how to transform their CPA foundation into a comprehensive skill set that meets the dynamic demands of modern CFO roles, whether in high-growth companies, nonprofits, or traditional corporations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
SEC Case Studies: Ethical Dilemmas in Finance and Accounting
-
Online
2.00 Credits
Overview: Ethical challenges in finance and accounting can be complex and far-reaching, impacting not only individual careers but also entire organizations and the public trust. This webinar will provide a practical exploration of the ethical considerations professionals face in today's financial landscape. Through real-world case studies, participants will examine common ethical issues, learn to navigate conflicts between financial performance and ethical integrity, and gain tools for making sound decisions under pressure. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Money: Strategic Ways to Improve Cash Flow
-
Online
4.00 Credits
Cash flow management is often the most important task of any CFO or financial leader. Regardless of whether one works in start-ups or established companies, non-profit or for-profit entities, cash flow makes our organizations run. Have you ever wondered whether you are optimizing your company's cash flow? In this course, we will explore how to improve your company's cash flow using analysis and financial theories in the context of real-world situations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ChatGPT for Accountants: 50+ Use Cases
-
Online
2.00 Credits
This course will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to clients. 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.
Microsoft Teams for CPAs: Unlocking Its Full Potential
-
Online
2.00 Credits
Microsoft Teams is designed to be the foundation of your Microsoft 365 ecosystem deployment. When deployed effectively, Teams can serve as a powerful platform for communication, collaboration, and knowledge sharing across your firm or business. Unfortunately, most organizations are substantially underutilizing the capabilities of Teams. This course provides a review and demonstration of the key features of Microsoft Teams that you can harness to optimize the return on your Microsoft 365 investment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.