CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Mastering the Excel Lookup Functions
-
Online
2.00 Credits
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Selected Ethics Topics 2025 - 2026
-
Online
2.00 Credits
This course will help you to stay current on recent changes to the AICPA Code of Professional Conduct, as well as keep you abreast of emerging trends in ethics standards and regulatory initiatives and their potential impact on your practice. We will also explore frequent practitioner ethics compliance challenges, including competence, due professional care, audit quality, and independence. 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 Agentic AI Foundations for Finance and Accounting
-
Online
2.00 Credits
This course introduces accounting, auditing, and finance professionals to the emerging field of agentic AI: autonomous, goal-driven systems capable of planning, acting, and learning with minimal human intervention. Participants will explore how agentic AI differs from traditional automation (RPA) and generative AI, and how these agents are being deployed in finance and accounting. The course emphasizes foundational concepts such as the Perceive-Reason-Act-Learn (PRAL) loop and ethical decision-making frameworks. To ground abstract ideas in practice, participants will experience a brief agent simulation using basic ChatGPT, showcasing how natural language prompts can emulate agentic behavior, such as goal setting, clarification loops, and structured task execution. The course also highlights real-world agent platforms (e.g., Microsoft Copilot, IBM watsonx, and UiPath) to provide context on enterprise adoption trends and discusses emerging global regulations such as the EU AI Act and the U.S. Executive Order on Safe AI.
No Tax on Overtime: Payroll Compliance
-
Online
2.00 Credits
This course provides tax and accounting professionals with a comprehensive overview of overtime requirements under the Fair Labor Standards Act (FLSA). Participants will explore the statutory definition of overtime, exemptions, and the calculation of the "regular rate of pay." Through practical examples and compliance-focused scenarios learners will gain the skills to identify risks, properly compute overtime pay, and advise clients or employers on best practices. The course emphasizes regulatory compliance, accurate application of rules, and strategies to avoid common pitfalls in wage and hour audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The AI Revolution in 2026: What CPAs Should Know
-
Online
2.00 Credits
AI is reshaping accounting, tax, and finance. This update surveys the state of AI technology in 2026: core concepts, software tools, risks/controls, and practical CPA use cases. You will leave with an expanded AI vocabulary, a current view of the AI landscape, and actionable talking points for staff, clients, and service providers. 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.
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.
S Corporations: Calculating Shareholder Basis
-
Online
2.00 Credits
A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Using ChatGPT with Excel
-
Online
2.00 Credits
In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. 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 U.S. Taxation of Foreign Corporations: A Case Study Approach
-
Online
3.00 Credits
This course is a case study designed to provide a comprehensive overview of U.S. taxation of a foreign corporation. Using a specific example, the course will walk through step-by-step mechanics on how to calculate the income inclusions and foreign tax credits under tested income (formerly known as global intangible low-taxed income or GILTI), Subpart F, and passive foreign investment company (PFIC) regimes. These computations have been updated to reflect changes enacted by the One Big Beautiful Bill Act (OBBBA). The case study will further evaluate the tax impact of subsequent distributions from the foreign corporation and sales of its stock. A compare-and-contrast approach will highlight the different outcomes of these regimes for individuals and for C corporations, empowering participants to advise their clients on the most tax-efficient way to structure their foreign investments.
How Recent Auditing Standards Improve Risk-Based Audits
-
Online
4.00 Credits
Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in the SASs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Multi Year Failure to File: Getting into Compliance
-
Online
8.00 Credits
This comprehensive program equips CPAs with the knowledge and practical tools to handle clients who have failed to file tax returns for multiple years. The course covers every stage of the process-from client onboarding and transcript analysis to risk assessment, ethical considerations, and resolution strategies. Participants will learn how to manage cases involving individuals, married couples, businesses, payroll taxes, and S corporations, including situations with missing records and potential criminal exposure. Real-world examples, IRS references, and best practices are integrated throughout to ensure confidence and compliance. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Best S Corporation, Limited Liability, and Partnership Update Course by Surgent
-
Online
8.00 Credits
This year practitioners need to keep abreast of tax changes affecting pass-through entities used by their business clients and employers, and this enlightening course delivers that information. You will learn invaluable strategies, techniques, innovative tax-planning concepts, income-generating ideas, and other planning opportunities available to S corporations, partnerships, LLCs, and LLPs. In addition, this course will discuss current trends and emerging issues, helping practitioners stay informed about relevant and significant topics that may impact their clients. Continually updated to reflect enacted legislation.
Noble Leadership: An Ethical Approach
-
Online
2.00 Credits
Research tells us that leaders, supervisors and managers have more impact on an employee than does a therapist and/or life partner. Being a leader is a huge opportunity and privilege and requires introspection and personal growth. This webinar is infused with values of fairness, compassion, respect and more and will be of most value to individuals who believe that everyone, regardless of circumstance, deserve "certain general conditions that are ...equally to everyone's advantage" (John Rawls). The Noble leader believes in people. The Noble leader is curious and humble and invites challenge and feedback into his/her/ world. The Noble leader is a true believer in seeing the good in others, helping them to be their best which in turn helps the Leader grow as well. The Noble leader does not shy away from confronting bad behavior/performance in a respectful and clear way while believing in the inherent dignity of each individual This workshop based on ethical principles offers a glimpse into what it takes to become a Noble Leader and how one can journey through for increased self awareness and skill development. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Controls to Secure the Growing Digital Footprint
-
Online
4.00 Credits
The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they, and their companies secure digital information. 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.
Surgent's Getting Ahead: The Art of Marketing for CPAs
-
Online
2.00 Credits
To many clients, CPA firms all look the same. While services and specialties may vary significantly from one firm to another, it is hard for the average person to see this by simply looking at the sign outside our office door. Is there any way to make us stand out more to the outside world? Through surveys, statistics, and examples, this course looks at how CPA firms can develop a marketing plan beyond just relying on referrals. We look at the pluses and minuses of various marketing channels, regulatory constraints, and how to measure success in the competitive financial services space.
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.
An Exhaustive Look At Fraud and Ways To Control It
-
Online
8.00 Credits
Fraud activities can be executed from within an organization, by parties outside an entity, or by both. Importantly, as the business world becomes more technological, the way fraud is carried out is changing. There must be an increased focus on understanding where new fraud vulnerabilities exist. In this session, we delve into the reasons that both internal and external intentional defalcations take place. The material discusses the new ways fraud is being actuated and looks at the factors driving those that undertake fraud. We spend time examining measures that can be implemented in order to stop fraud via the deployment of added security across the enterprise. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Generative AI Strategy for Accountants
-
Online
2.00 Credits
This course empowers accountants with the knowledge and skills needed to strategically implement generative AI within their firms, positioning them at the forefront of innovation and operational efficiency. As generative AI platforms like ChatGPT, Claude, and Gemini transform business practices, accountants will learn to harness these tools to drive value, streamline processes, and enhance decision-making. Through examination of the current AI landscape, practical frameworks, and real-world applications, participants will learn how to leverage AI technologies to enhance accounting operations while maintaining professional standards and ethical considerations. The course emphasizes a balanced approach to AI adoption that focuses on augmenting human capabilities rather than replacement. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.