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.
Ethics, Tax Practice & Understanding Circular 230
-
Online
2.00 Credits
This course provides a comprehensive overview of the ethical standards and principles governing tax practice, as outlined in IRS Circular 230. Participants will explore the importance of ethics in the tax preparation industry, review IRS rules, and examine common ethical violations and their associated penalties. The course emphasizes procedures that promote compliance with ethical guidelines, equipping tax practitioners to navigate complex ethical dilemmas confidently. Real-world scenarios will be used to demonstrate the application of ethical principles in tax preparation and representation. 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 Key Partnership and S Corporation Tax Planning Strategies
-
Online
4.00 Credits
Many of our clients are pass-through entities for which many of the general business strategies are subject to additional limitations. To provide the tax planning strategies for closely held business clients that will bring more revenue, this course focuses on the special concerns and techniques the practitioner needs to thrive in this market.
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.
Mastering Partnership Basis: Inside and Outside Basis
-
Online
2.00 Credits
This course will provide a detailed analysis of how to determine a partner's tax basis for a partnership interest, with an explanation of the use of both "inside" and "outside" basis determination. An illustrated example with filled in forms will demonstrate how the process works and the 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.
Accounting for the Gig Economy
-
Online
2.00 Credits
Freelance work and other non-permanent employment arrangements are becoming increasingly popular ways for people to earn a living. Although these non-traditional activities offer novel, flexible ways to earn income from diverse sources, they also introduce nuanced recordkeeping, reporting, and attestation issues. We investigate characteristics of the gig economy, employee-versus-contractor considerations, bookkeeping, regulatory compliance, and external reporting considerations. We also explore best practices for CPAs who fulfill the role of trusted advisor for gig economy clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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.
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.
Microsoft 365 Application Lightning Round Review-Updated
-
Online
1.00 Credits
Do you use Microsoft (Office) 365? Are you satisfied that you are getting the most that you can from it? If you answered yes then no, this course will provide a really high return on your investment of time and money in this application suite. John Higgins, one of the profession's leading experts on the integration of Microsoft 365 into business, will explain and demonstrate the depth and breadth of the Microsoft 365 ecosystem. The course is designed to raise your awareness of all that you can do with Microsoft 365 and substantially increase your monthly subscription ROI. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ChatGPT Deep-Dive Hands-on Bootcamp for CPAs
-
Online
2.00 Credits
ChatGPT has grown its user base to over 800 million active users per week. As a leader in the generative market, it a tool that every CPA should have a basic understanding of how to use and apply in business. This course will provide a comprehensive review and demonstration of how to put ChatGPT 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 ChatGPT on your computer. Practice files will be provided so 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.
Surgent's Liquidation of Flow-Through Entities for LLCs and Partnerships
-
Online
2.00 Credits
Part of the technical competence of most experienced accounting and finance professionals is the ability to advise owners of S corporations and partnerships or multiple-member LLCs treated as partnerships regarding the tax rules that apply when these entities liquidate. Entity liquidations do not occur every day; but they do occur, and often at very critical times in the business life of the entity and its owners. All accounting and finance professionals should be able to advise their clients about the tax issues associated with client businesses that go out of existence and liquidate. This program explains the tax consequences associated with liquidating S corporations, partnerships, and multiple-member limited liability companies treated as partnerships.
Create Measures in Power BI that Define Your Metrics
-
Online
4.00 Credits
Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Implementing and Maintaining an Internal Control System
-
Online
8.00 Credits
Many organizations are successful as they create a system of internal controls, however some fail to properly implement the measures that are established. Moreover, entities regularly neglect the important process of testing, monitoring, and updating control procedures, which weakens the entire internal control structure. This session provides an overview of control creation methods and discusses ways to successfully implement policies and procedures. Additionally, it includes an array of control maintenance checklists that participants can take and adapt to their organization as they work to improve policies and procedures. Finally, it provides an understanding of the need for dynamic, fluid controls that adapt to changes in business tools and methods. Participants that take this course will have a strengthened ability to implement and maintain an internal control system. 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 Annual Accounting and Auditing Update
-
Online
8.00 Credits
Designed as an all-you-need-to-know update for accounting, auditing, and attestation practitioners at all levels in public accounting and industry, this course provides a comprehensive review of recent standard-setting and rulemaking activities of the Financial Accounting Standards Board (FASB), American Institute of Certified Public Accountants (AICPA), Public Company Accounting Oversight Board (PCAOB), and Securities and Exchange Commission (SEC). On the financial accounting front, we will cover the FASB's Post-Implementation Review (PIR) report released in late 2025 for lease accounting under ASC 842 and discuss the best practices in applying the standard and identifying any ongoing issues practitioners are experiencing with applying the standard. We will also discuss the more than a dozen ASUs the FASB has issued since the beginning of 2024 and into 2026 covering government grants, derivatives and financial instruments, practical expedients for credit losses under ASC 326, and expense disaggregation on the income statement. Our focus on AICPA standards includes a detailed discussion of revamped AICPA quality management standards. The AICPA updated and modernized the standards by issuing Statement on Quality Management Standards 1, 2, and 3 (SQMS 1, SQMS 2, and SQMS 3, respectively), SSARS No. 26, and SAS 146, Quality Management for an Engagement Conducted in Accordance with Generally Accepted Auditing Standards (SAS 146). These standards, now effective as of December 15, 2025, modernize quality management standards to reflect an increased focus on risk assessment, technology use, and the presence of outside experts on engagements. We will also discuss AICPA's proposed SAS, The Auditor's Responsibilities Relating to Fraud in an Audit of Financial Statements, intended to supersede AU-C section 240. We will also cover new rules impacting public company audits and present case studies on recent fraudulent accounting stories and best practices for detecting and preventing such frauds. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.
Surgent's Predicting Future Financial Issues Facing the Financial Executive
-
Online
8.00 Credits
Our financial and economic series is designed to take key topics for financial executives and explore them in detail such that the CFO/controller/financial executive can take away useful and practical recommendations dealing with the topic at hand. The program explores the current economic trends and analyze their impact on you as the financial executive in areas professional skepticism, medical care costs, social security viability, the dollar as a world currency, the national infrastructure and the "fate of the states" as well as the AICPA's top 10 trends and technologies. Specific recommendations and insights will be offered to you to deal with the challenges.
Ethical Performance Management
-
Online
2.00 Credits
Today, more than ever, effective performance management is critical to the well-being of an organization, as well as the engagement and satisfaction of staff. Unfortunately, performance management is also often one of the most dreaded responsibilities managers face. This session will provide insight into what performance management is, how to prepare and conduct performance appraisals, how to coach the marginal employee, legal considerations to be aware of when conducting an appraisal, and ways to engage and motivate staff. In addition to providing tools to conduct effective appraisals, we will also look at the ethical implications of employee reviews. When done well, performance management has the power to improve communication between managers and their staff as well as help foster stronger career paths and routes for growth. It can motivate, re-engage, and energize everyone involved. Ethical values such as fairness, accountability, respect, intellectual honesty, and trust will be incorporated into this session. 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: Finding Hidden Treasure in Tax Returns
-
Online
4.00 Credits
Almost every business and individual has to file tax returns, which can be a great treasure trove of information for forensic accountants. Whether in a divorce, partnership dispute, recreating books and records, or bankruptcy proceeding, analyzing tax return information should be an initial step in uncovering income and assets. The IRS retains a large amount of information, both from taxpayers and 3rd parties who report financial transactions. This course will be your guide in gathering, analyzing, and evaluating tax return information, so that you have a full picture of the financial investigation. Your presenter is a 20 year veteran with IRS-Criminal Investigation, who used this information as a basis for his federal criminal investigations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
How to Audit Accounting Estimates
-
Online
2.00 Credits
When auditing management's accounting estimates, increased professional skepticism is necessary as there is always the potential for bias in areas of increased subjectivity & complexity. This course will demonstrate procedures to test the process used by management to develop estimates, as well as walk through common examples of accounting estimates that are included in the financial statements. It includes the updated requirements in SAS 143. 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 Controllership Skills Update: Risk Management
-
Online
2.00 Credits
The most recent recession and its fallout, weather (look at 2017), process and product failures, and unethical behavior have again highlighted failures by numerous organizations in identifying and managing risk. The size and reputation of organizations proved not to be the key to success. Again, we saw that failures can result in areas/industries thought to be "under control" through their policies, practices and/or regulations. A core activity of financial management is to effectively protect the assets of their organizations, without significantly reducing new ideas and growth. This brief program provides insights and approaches to identify risk and manage the above noted trade-off. The course is designed for financial managers looking to quickly build upon their existing knowledge and experience, as well as to help to start the less experienced individual. It offers ideas that can be used immediately, as well as longer term approaches. Updated to include new information particularly in the areas of disaster planning, business continuity, and ethics, as well as a sample group exercise to test your current risk management systems.
Surgent's Incident Response and Case Studies in AI-powered Cybersecurity
-
Online
2.00 Credits
This course emphasizes the practical application of incident response frameworks through case studies of AI-related cyber incidents. It focuses on preparing financial professionals to effectively manage and learn from cybersecurity crises.