CPE + Events Catalog

2026-27 OSCPA-Select™ CPE - 2 catalog options:
Browse CPE by Field of Study, and use the Format/Type filter to narrow by In-Person, Webcast, Bundles or On-Demand.
This will generate a PDF of the current filtered catalog
Surgent's Tax Update for Client Advisory Services (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
Client advisory services (CAS) professionals are becoming a more integral part of the operations of any CPA firm. As such, they must stay on top of changing tax law. In this course, we will explore tax changes in areas CAS professionals are involved with — information reporting, payroll tax issues, and tax credit and deduction documentation. We will also discuss relevant changes to individual and business tax returns so that CAS professionals can better assist clients with tax needs in the upcoming year.
More Dates
Yellow Book: Application of GAGAS Principles (6 hours)
Online
6.0 Credits
Member Price: $239
See more dates
Building a strong foundation by knowing the essentials By reviewing chapters 1-5 of *Government Auditing Standards*, 2024 Revision, you'll learn the fundamentals of performing engagements in accordance with generally accepted government auditing standards (GAGAS). Your new knowledge will help you build an excellent foundation of the principles of GAGAS as you work to understand Yellow Book requirements and application guidance. Topics covered include: Foundational principles General requirements Standards for financial audits YELLOW BOOK: Qualifies for Yellow Book CPE based on your unique audited entity.
More Dates
Preparation, Compilations and Reviews-A Practical Workshop 26-27
Online
8.0 Credits
Member Price: $329
See more dates
Participants will go over the changes on preparation, compilation and review engagements using SSARS rules, followed by a general overview of how to perform these services. This interactive workshop is designed for practitioners in small and medium-sized CPA firms and will include a lecture with generous time for questions and case studies.
More Dates
IFRS Update (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
Companies reporting under International Financial Reporting Standards (IFRS) continue to face a steady flow of new standards and interpretations. The resulting changes range from significant amendments of fundamental principles to some minor changes from the annual improvements process. The changes will affect different areas of accounting, such as recognition, measurement, presentation and disclosure. It can be time-consuming and confusing to keep up-to-date on the resulting impact on financial statements and disclosures. This course will provide an executive summary of recent IFRS updates with current and upcoming effective dates.
More Dates
Surgent's A Complete Guide to Reporting Form 1099-DA (2 hours)
Online
2.0 Credits
Member Price: $119
See more dates
For each digital asset sale that a broker has affected for a customer in 2025, the broker must complete Form 1099-DA. A broker includes any person who, in the ordinary course of a trade or business, stands ready to affect sales of digital assets to be made by others. This program covers the required rules for reporting digital asset transactions on Form 1099-DA.
More Dates
Surgent's Contract Law for Accounting and Finance Professionals (2 hours)
Online
2.0 Credits
Member Price: $99
See more dates
Accounting and finance professionals routinely encounter a broad range of legal issues while advising clients or performing routine job functions. Contract law tops the list as the most frequent issue that intersects with the accounting and finance professions. As trusted advisors, it is wise to understand the fundamentals of contract law for both personal and professional benefit. This course provides a broad overview of contract law basics geared specifically toward the accounting and finance professions. From contract formation to enforceability, this course offers an interesting look at how contract law intersects with accounting and finance. Participants should walk away with a better understanding of common issues that arise when reviewing contracts.
More Dates
Surgent's Controllership Skills Update - Budgeting, Forecasting, and Big Data (2 hours) - 1 Tech & 1 [NT]
Online
2.0 Credits
Member Price: $99
See more dates
Budgets are the vehicle for allocating resources, measuring activities, and identifying needed changes and improvements. An organization's strategy is the primary driver of costs. To be effective, the budget must be linked to strategy and long-term plans. Numerous organizations have achieved a series of short-term targets (budgets) but failed longer term, demonstrating the lack of this necessary linkage. Forecasting, a critical part of any successful budgeting process, can be flawed by technical errors, organizational structure, or emotional forces. The establishment of a system to collect, process, and analyze big data can provide significant insights into the budgeting and forecasting process. An efficient system of incorporating big data and analytics into normal activities will improve management's decision-making. This brief program offers specific actions to improve your forecasting and budgeting activities. In addition, more advanced techniques are identified for the participant's further review, which can be applied throughout an organization. Good budgets effectively allocate resources, provide information for decision-making and serve as an early warning system for unforeseen events. A poor budgeting process fosters a false sense of security, provides inappropriate or inaccurate data, and reinforces the status quo. Budgets are about the organization's story, not just the raw numbers!
More Dates
Surgent's Excel: Mastering PivotTables (2 hours) [NT]
Online
2.0 Credits
Member Price: $99
See more dates
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.
More Dates
Excel for Accounting Professionals Session 3: Workbook Design Principles and Organization (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
Enhancing Excel workbook productivity This workshop covers organizing and managing worksheet information, offering hands-on participation alongside the instructor. Through the practical tasks, you will gain a comprehensive grasp of commonly utilized Excel functions such as: Hiding worksheets Inputting cells styles for users Organizing workbooks Mastering Excel capabilities Becoming proficient in Excel entails developing workbooks that are efficient and well-organized. The facilitator will guide you through mastering complex functions, selecting cells and objects, and organizing principles of workbook design. You'll enhance your basic understanding of Excel with topics including: Creating complex formulas with nested functions Applying techniques for group selection *Session 3 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 4: Conditional Summing and Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-4--conditional-summing-and-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Excel for Accounting Professionals Session 6: List Comparisons and Indenting (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
Major benefits of detailed Excel workbooks Understanding list comparisons in Excel is vital for improved workbook efficiency. In this webcast, the facilitator will walk you through comprehensive learning exercises that provide an overview of the following topics: Performing list comparisons Building multicolumn list comparisons Using lookups Indenting commands In-depth training for Excel upskilling This webcast is crafted to enable active participation as you follow the demonstrations. It will navigate you through the intricacies associated with working Excel columns, helping you to apply key functions effectively for significant improvements through the following: ISERROR COUNTIFS SUMIFS *Session 6 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 7: Data- Driven Workbooks and Concatenation] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-7--date-driven-workbooks-and-concatenation) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Strategic CFO – Strategic Financial Communications (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
Financial professionals are expected to do more than report numbers-they must explain them in ways others understand and trust. This session focuses on improving financial communication by addressing financial literacy gaps, simplifying complex accounting concepts, and building compelling narratives around data. Participants will learn how to use stories, visuals, and language effectively to communicate strategy, performance, and risk. Through examples and interactive discussion, this session helps CPAs and CFOs become clearer, more confident communicators in both live and virtual environments. Also, some video clips will be used to add to the learning materials and research. Don't worry, they are pretty entertaining.
More Dates
Accounting and Tax Ethics: Standards, Issues, & Case Studies 26-27 (4 hours)
Online
4.0 Credits
Member Price: $175
See more dates
In recent history, even the most prestigious CPA firms have had ethical lapses and oversights that have cost them both financially and, at that moment, clouded their brand. This course will review the AICPA code of ethics for both accounting and tax practitioners and encourage you to examine your firm's policies and choices relative to those standards and common sense through thought-provoking and sometimes humorous Q&A and case studies.
More Dates
Audits Under Uniform Guidance-Single Audit & NPOs 26-27 (4 hours)
Online
4.0 Credits
Member Price: $175
See more dates
Audits conducted under the Uniform Guidance for Federal Awards continue to be among the most challenging audit engagements as the number of federally funded programs for not-for-profit organizations continues to increase. This course will provide you with what you need to know to prepare for Single Audits conducted during 2026, including performing the compliance audit and auditor reporting responsibilities.
More Dates
Preparation, Compilation & Review Services 26-27 (4 hours)
Online
4.0 Credits
Member Price: $175
See more dates
SSARS 21 significantly changed the way CPA services are being offered. There is still confusion about CPA responsibilities and procedures. The course will discuss differences between bookkeeping, preparation and compilation engagements and how they differ. It will also discuss financial statement frameworks and how they influence the engagement as well as analytical procedures in review engagements.
More Dates
Shorten Month-End - Closing Best Practices (4 hours)
Online
4.0 Credits
Member Price: $149
See more dates
Surveys show that the average North American company completes its monthly financial statement closing in six (6) days. However, some companies can close their books in one day or less. You don't have to sacrifice accuracy for speed. This session will show you how to close month-end faster, better and cheaper. Yes, to all three.
More Dates
Preparation, Compilations and Reviews-A Practical Workshop 26-27
Online
8.0 Credits
Member Price: $329
See more dates
Participants will go over the changes on preparation, compilation and review engagements using SSARS rules, followed by a general overview of how to perform these services. This interactive workshop is designed for practitioners in small and medium-sized CPA firms and will include a lecture with generous time for questions and case studies.
More Dates
IFRS SMES vs IFRS (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
Both IFRS and IFRS for SMEs are self-contained standards designed to meet the needs of specific financial statement users. This course is designed to explain the differences between the two standards, including disclosure requirements and recognition and measurement principles.
More Dates
Viewing A&A Through the Eyes of a Tax Practitioner (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
This session offers insight for tax practitioners beyond merely checking a box to satisfy accounting and auditing requirements for license renewal. We devote significant attention to extracting utility from financial statements to support decision needs of both external financial statement users and internal stakeholders. We explore best practices for cross-functional support within firms that perform tax, accounting solutions, financial statement, and consulting services. We also highlight similarities and differences between U.S. GAAP and tax-basis accounting.
More Dates
Tax Practice Standards (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
Please join us for a comprehensive discussion on standards that professionals must adhere to as tax practitioners. We will be covering the major governing rules, such as Treasury Circular 230, the AICPA Statements on Standards for Tax Services (SSTS), the Internal Revenue Code (IRC) and common law. Also included will be case studies illustrating dilemmas faced by tax practitioners. **Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com
More Dates
Surgent's Use the Data Model to Build More Powerful PivotTables (2 hours) [NT]
Online
2.0 Credits
Member Price: $99
See more dates
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.