CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Surgent's Excel: Mastering PivotTables
-
Online
2.00 Credits
PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.
Yellow Book Independence and Single Audit Fundamentals
-
Online
4.00 Credits
This CPE course explains Yellow Book independence including the general requirements, requirements for auditors providing non-audit services and documentation requirements. This course also explains the basic elements of a Uniform Guidance compliance audit, including an overview of requirements, major program determination with examples, an understanding of compliance requirements and related internal control over compliance, sampling, and single audit reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Financial & Tax Accounting for S Corporations & Partnerships
-
Online
8.00 Credits
This program compares and contrasts the financial and tax accounting differences of partnerships, LLCs, and S corporations, as well as discuss the tax accounting for these entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Unlock the Power of AI with Copilot in Excel
-
Online
2.00 Credits
In the ever-evolving world of data analytics and business intelligence, Microsoft Excel continues to be an indispensable tool for professionals across industries. With the introduction of Copilot, Microsoft has integrated the power of artificial intelligence directly into Excel, revolutionizing how users work with data. This 2-hour interactive course, Unlock the Power of AI with Copilot in Excel, provides a comprehensive overview of how Copilot transforms traditional Excel workflows into dynamic, AI-driven processes, enabling users to accomplish tasks faster, more accurately, and with less manual effort. During this course, you'll discover how Copilot leverages AI to enhance productivity and streamline operations. Whether you're a seasoned Excel user or just beginning your journey, this course will guide you through practical applications and best practices to make the most of Copilot's capabilities. Through hands-on demonstrations and real-world examples, you'll see how Copilot can save time, improve decision-making, and elevate your analytical skills to new heights. This course not only focuses on the technical aspects of Copilot but also highlights its potential to transform your day-to-day work, from automating repetitive tasks to uncovering trends and insights you might otherwise overlook. By the end of the session, you'll be equipped with the knowledge and confidence to integrate Copilot into your workflows and unlock its full potential in Microsoft Excel. 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.
Overcoming Tech Adoption Challenges in CPA Firms
-
Online
1.00 Credits
The accounting profession stands at a critical inflection point where artificial intelligence and emerging technologies are reshaping how firms operate, serve clients, and compete in the marketplace. This course, based on the 2025 CPA Firm Tech Report, provides expert guidance on overcoming the five key challenges that prevent firms from successfully adopting transformative technologies: decision paralysis from overwhelming choices, leadership resistance to change, difficulty proving ROI, growing cybersecurity risks, and critical skills gaps. Through real-world case studies and insights from industry leaders, participants will learn practical strategies for evaluating AI solutions, implementing change management frameworks, and building a technology-forward culture that enhances both efficiency and client value. Participants will explore the CPA Firm Digital Maturity Model to assess their firm's readiness for transformation, examine the evolving AI ecosystem specifically designed for accounting applications, and discover how leading firms are leveraging AI to move beyond traditional compliance work toward high-value advisory services. The course addresses critical considerations for firms of all sizes, from solo practitioners to large regional firms, providing actionable frameworks for prioritizing technology investments, measuring success beyond traditional ROI metrics, and developing the hybrid talent needed to thrive in an AI-enhanced future. Whether you're a firm leader hesitant about technology adoption or a forward-thinking professional ready to champion change, this course equips you with the knowledge and tools needed to navigate the technology revolution transforming the accounting profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Financial Decisions that Led Two Businessmen to Prison
-
Online
2.00 Credits
Two college graduates built impressive careers: One worked in sales, the other in technology and investing. Both of those people made decisions in the course of their business that led to government investigations. They had to hire attorneys, go through judicial processes, face charges, and plead guilty. Each of those people are on their way to prison. Learn from the lessons they offer. We interview both financial professionals, and they tell us more about how their decisions influenced the consequences that followed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Accounting & Attestation for ESG
-
Online
2.00 Credits
Environmental, Social, and Governance (ESG) reporting has become an increasingly important area of focus for standard setters, regulators, and stakeholders. This course provides an overview of how ESG considerations intersect with accounting and attestation services, with attention to developments affecting both preparers and assurance providers. Participants will review current ESG-related initiatives and projects underway at the Financial Accounting Standards Board, Governmental Accounting Standards Board, and the AICPA. The course also explores the types of services CPAs may provide in connection with ESG reporting, including advisory and attestation engagements, and discusses how these engagements differ in scope and responsibility. Designed for CPAs seeking to understand the evolving ESG landscape, this course helps participants recognize where ESG fits within existing professional standards and how CPAs can support organizations seeking credibility and assurance over ESG information. 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 Use the Data Model to Build More Powerful PivotTables
-
Online
2.00 Credits
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.
Smarter Tax Services with Artificial Intelligence (AI) Tools
-
Online
2.00 Credits
There has never been a greater opportunity to leverage technology tools to automate your tax services. This course will provide specific examples of how you can use AI (artificial intelligence) based tools to complement your tax planning, research and compliance services. You will learn how to leverage AI to automate the collection and organization of client data, the engagement management process, tax research, and enhance client advisory services with AI too This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The One Big Beautiful Bill: 2025 tax legislation
-
Online
4.00 Credits
The President signed on July 4, 2025, one of most consequential tax legislation in recent years. The well-informed tax practitioner will want to stay abreast of these developments! This course will start with a short background of this legislation as it made its way through Congress and to the President's desk. We will then review the final provisions that was approved by the Senate and passed by the House. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Basic Individual Taxation Course
-
Online
2.00 Credits
Please join us for an introductory course on the fundamentals of preparing and filing an individual federal income tax return. We will cover topics such as what the federal income tax is and how it is computed. 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 Trump Accounts Created by OBBBA: A Comprehensive Guide for Accounting and Finance Professionals
-
Online
2.00 Credits
Many clients are asking their advisors about Trump Accounts, one of the most anticipated yet misunderstood provisions of the One Big Beautiful Bill Act (OBBBA). This program will provide practitioners with the background to be able to advise their clients regarding how Trump Accounts operate. The course will also discuss the comparison between Trump Accounts and other accounts, such as 529 Plans and Roth IRAs. In addition, coverage will be provided on how the pilot program will function to give $1,000 to newborns.
Surgent's The One Big Beautiful Bill Act (OBBBA): What You Need To Know
-
Online
4.00 Credits
Many accounting and finance practitioners have had difficulty understanding and applying the One Big Beautiful Bill Act (OBBBA). Accounting and finance practitioners are still confused and challenged by many of the new and extended tax provisions that the OBBBA delivered. Mastering these crucial provisions requires multiple exposures to these challenging tax changes. This program is a four-hour review and analysis of the most important changes from the OBBBA that impact both individual and business taxpayers. This course affords accounting and finance practitioners an opportunity to gain a broader, deeper understanding of this wide-ranging set of new tax rules, to grasp what is new and what is a continuance of prior rules, and to develop deeper planning insights into the many changes that the OBBBA contains. To the extent that the Treasury has provided guidance relating to OBBBA changes, we will discuss that guidance. We will also point out areas where Treasury guidance would be useful and areas where guidance is expected.
A Culture of Regulatory Ethics: A Competitive Advantage
-
Online
4.00 Credits
In a competitive market, every company is looking for anyway to differentiate themselves from their competition. While we often look to new markets and data for a competitive advantage, ethics can be the factor that makes the biggest difference to customers, employees, and the public at large. Using surveys, research, case studies, and examples, this course will explore why the CPA credential and the AICPA Code of Professional Conduct is so different. We will discuss why CPA's are in a unique position of trust and how this can put their companies ahead. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Numbers to Narrative: Storytelling in Business Communication
-
Online
1.00 Credits
Information becomes influential when it is structured. In this 1-CPE session (Professional Development), participants explore narrative frameworks presented in the course materials, including situation-complication-resolution and hero-based narrative arcs. Using business-oriented examples, the session demonstrates how structured storytelling enhances clarity and impact without sacrificing rigor. Participants will examine how to define context, introduce tension, present evidence, and guide audiences toward resolution. The emphasis is on logical flow and disciplined narrative construction rather than dramatization. The course concludes with application of a structured storytelling model to a professional scenario. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Comprehensive Accounting and Financial Reporting Update
-
Online
4.00 Credits
This course covers recently issued accounting and financial statement reporting standards from the Financial Accounting Standards Board. Key implementation challenges and experiences from public company filings will be identified. 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 Reasonable Suspicion
-
Online
1.00 Credits
Given the opioid epidemic and the legalization of medical and recreational marijuana in a growing number of states, many employers are concerned about the impact drugs and alcohol may be having on the safety and security of their workplaces. Reasonable suspicion testing is among the best ways for employers to identify whether an employee is under the influence of drugs or alcohol while working. This webinar explores what managers and supervisors need to know to implement a Reasonable Suspicion Testing Policy.
Reasonable Compensation for S Corps
-
Online
2.00 Credits
Between 2010 and 2020 a parade of Court Cases, IRS Factsheets, Job Aids and Internal Memos, plus Heightened IRS scrutiny and Preparer Penalties has brought the issue of 'Reasonable Compensation for S Corp's out of the shadows and placed it forefront as a priority issue for CPA's, EA's, Tax and Financial advisors to cover with their clients. We will explore key court cases, IRS guidelines, preparer penalties and some of the obscure tools the IRS has put in place. We debunk common myths and fiction on how reasonable compensation should be calculated and replace it with facts and methodologies that the IRS relies on. 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 The AI-augmented Professional: Practical Tools, Real Risks, and Immediate Use Cases
-
Online
2.00 Credits
Artificial Intelligence is no longer a future concept; it is a current necessity. This session provides a practical roadmap for practitioners to leverage AI safely and effectively. We move from a survey of available tools (from free apps to specialized software) to a deep dive into the ethical guardrails required to protect client data and maintain professional standards. Participants will leave with a playbook of real-world use cases that can be implemented immediately.