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
Complete Guide to Analyze Data with Excel PivotTables (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
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.
More Dates
AI 101 for CPAs: Core Concepts and Practical Applications (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
New to AI? Start here. This beginner-friendly course explains how generative AI works, what terms like "LLM" and "agentic AI" really mean, and how CPAs can safely put these tools to use. You'll leave with a solid understanding of AI fundamentals and how they apply to accounting, tax, and finance. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Workforce Transformation and Talent Management in 2025 (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
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.
More Dates
Reasonable Compensation for S Corps (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
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.
More Dates
Surgent's Capital Assets: Basis and Taxation for Financial Professionals (2 hours)
-
Online
2.0 Credits
Member Price: $119
See more dates
This course provides a comprehensive understanding of capital assets taxation, basis determination, and related tax planning strategies. Participants will explore the fundamental classification of capital assets, the distinction between realization and recognition of gains and losses, and the complex rules governing disallowed losses. The course thoroughly examines the various types of capital gains and losses, including short-term, long-term, and special categories such as unrecaptured Section 1250 gains and collectibles. Attendees will learn the intricacies of netting capital gains and losses, calculating tax liabilities across different income types, and distinguishing between marginal and effective tax rates. The course also covers advanced topics including basis adjustments, wash sale rules, related-party transactions, and inherited property treatment. By the end of the course, participants will be equipped with the knowledge and tools to guide clients in implementing effective capital asset strategies that minimize tax liabilities while ensuring regulatory compliance.
More Dates
The FASB Conceptual Framework (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Accounting is a man-made science, built on principles that require a consistent framework to ensure comparability and reliability in practice. This course introduces participants to the FASB Conceptual Framework, which serves not only as the foundation for developing accounting standards but also as a guide for applying sound judgment in practice. Jeff Sailor will cover the key elements of the framework, focusing on recognition, measurement, qualitative characteristics, and disclosure requirements. The course will draw on all eight chapters of Statement of Financial Accounting Concepts (Concept 8), bringing clarity to how the framework supports financial reporting. Jeff’s signature video parodies will also be featured, offering memorable reinforcement of the material.
More Dates
Public Speaking Secrets That Wow Audiences (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
In this course, you'll learn why being able to do public speaking well is a major advantage in becoming successful in your career. You'll learn how to write a good talk, how to present it well, and how to use your new found ability to get more clients and/or a promotion. In addition, you'll learn how to overcome your nervousness, and how to overcome stress in less than a minute.
More Dates
Operations Level Internal Control (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
Many leaders in business organizations of all sizes view the system of Internal Control almost purely as a protective security measure. A well-designed internal control system can and will drive all entity objectives which includes successful operations. This session uses information gathered from years of creating internal control systems as well as concepts from well-respected authoritative pronouncements and frameworks to illustrate the power of a strong and well supported control system as well as actions that can help establish such a system. Those that work with internal controls who are tasked with developing ways to improve operation level capabilities should strongly consider 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.
More Dates
Leveraging ChatGPT for Innovative Business Advisory Services (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
In this cutting-edge course, participants will gain a deep understanding of how to leverage ChatGPT, OpenAI's powerful language model, to innovate and enhance business advisory services in the accounting sector. The course integrates theory and practice, demonstrating how various enterprise evaluation methodologies can be applied in conjunction with ChatGPT for increased business analysis efficiency, profitability, and growth. It also provides hands-on training for implementing these techniques in real-world scenarios. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Start From Trust: An Evidence-Based Approach to AI Adoption (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
AI is now built into software that CPA firms already use, and the pressure to have a position on it keeps rising. For most small and midsize firms the question is not whether these tools matter, but how to engage with them on terms that fit a practice built on trust, confidentiality, and professional judgment. This course makes an evidence-based case that professional skepticism is an asset in technology decisions, provided it is aimed at the right target. Drawing on research in trust calibration, human and AI decision making, cognitive offloading, and professional identity, it examines why experienced professionals discount sound algorithmic advice, what that discounting costs in accuracy, and where reasonable caution turns into accidental delay. Participants locate their firm on the AI Trust and Usage Quadrant, apply five trust questions to vendor claims, and review bounded first steps designed to protect independent judgment during a pilot. The course is vendor neutral and recommends no product. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Real Estate Professionals: Passive Activity, Sec. 199A and Investment Income Tax (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
When do they exist and how to report them? This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction. *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 terri.storer@acpen.com
More Dates
Eat, Drink & Maybe Deduct: Mastering IRC 274 (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This session provides a comprehensive analysis of meals and entertainment regulations under IRC 274 as amended by the Tax Cuts and Jobs Act. Participants will learn how to identify deductible vs. nondeductible expenditures, interpret the regulatory definitions surrounding "entertainment," "business associate," and reimbursement arrangements, and apply the numerous exceptions under IRC 274(e), including compensation, recreational activities, public availability, and goods or services sold to customers. Using examples from the final regulations, we will dissect key distinctions such as separately stated food and beverage costs, employer-provided meals, and the treatment of per diem reimbursements. This course equips practitioners with the technical precision required for compliance, documentation, and audit defense. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Hot Topics Audit & Attest Update - 2026 (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Many public accountants desire to have a quick overview of only the most current changes to professional and ethical requirements. This course will provide an executive summary of the major changes in audit and other attest requirements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Surgent's Foundations of Cybersecurity for Financial Professionals (2 hours)
-
Online
2.0 Credits
Member Price: $119
See more dates
This course introduces key cybersecurity concepts tailored for financial professionals. It emphasizes the CPA's role in cyber risk management, key terminology, and practical steps to foster a security mindset, integrating cybersecurity with financial reporting.
More Dates
Navigating Mergers & Acquisitions with AI: The Future of Deals (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Mergers and acquisitions can be complex, risky, and filled with unexpected challenges—but they don’t have to be overwhelming. This course provides a clear and practical overview of the M&A process, helping professionals understand the critical stages of evaluating opportunities, structuring deals, conducting due diligence, and navigating post-transaction integration. Participants will learn practical techniques that help organizations avoid the common traps that derail many transactions while improving the likelihood of successful outcomes. The session also explores how emerging AI tools are beginning to enhance deal analysis, uncover deeper insights, and support better decision-making throughout the M&A process.
More Dates
Become a Data Analysis Expert (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
In today's rapidly evolving business landscape, accounting professionals are expected to be more than just number crunchers, they are expected to be insightful interpreters of data. In an era where data is king, this course is your gateway to becoming a savvy data analyst, giving you a competitive edge in your field. We will guide you through the intricacies of making complex data analysis approachable and engaging. You will learn the all important Data Analysis Process Flow that will take you from collecting data all the way to making insightful decisions based upon your data. We will explore the basics of data modeling that will allow you to access data from multiple sources and use sophisticated calculations to create our data metrics. You will learn how to create interactive dashboards, perform sophisticated reporting, and uncover deep insights from your data. Whether you're looking to streamline your reporting process, enhance your data visualization skills, or make more data-driven decisions, this course is tailored to meet those needs. It's not just about learning a tool; it's about enhancing your professional identity as a forward-thinking accounting professional. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Accounting & Attestation for ESG (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
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.
More Dates
Forensic Accounting: The AI-Powered Expert and Investigator (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Artificial intelligence is revolutionizing forensic accounting, giving professionals powerful new ways to trace funds, uncover fraud, and analyze massive volumes of financial data in minutes instead of weeks. In this engaging course, you'll discover how AI can enhance financial investigations, strengthen expert witness reports, and support litigation and discovery efforts. Learn where AI can create strategic advantages in the courtroom, as well as the disclosure, reliability, and admissibility challenges that every expert must understand. Through practical examples and real-world applications, you'll see how AI can uncover hidden patterns, identify critical evidence, and generate actionable insights. Whether you investigate fraud, support litigation, or serve as an expert witness, this course will help you harness AI with confidence, credibility, and defensible results. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Navigating IRS Authorizations: Form 2848 & Form 8821 (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Providing a practical overview of the IRS Power of Attorney, Form 2848, and IRS Tax Information Authorization, Form 8821. Participants will explore the differences between these forms, understand when each is required, and how to comply with IRS requirements for representing clients and accessing their tax information. The course will cover practical issues, ethical considerations, and best practices for managing client authorizations through the IRS Centralized Authorization File (CAF) system. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
S Corporation Checkup: Tax Issues & Forms Reporting (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
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, as well as an update on Schedules K-2 and K-3. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. *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