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.
Real Estate Tax Issues: Passive Activity, Self-Rental and Section 199A (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
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. A detailed analysis of the self-rental passive activity rules will be given, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. *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
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
ChatGPT Vision for Financial Analysis (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course offers an in-depth exploration of the "vision" capabilities of ChatGPT specifically tailored for accountants. The session demonstrates how artificial intelligence can interpret and analyze visual content to revolutionize financial management. The curriculum covers a wide range of applications, from understanding GPT Vision and its unique benefits to leveraging aerial and street view imagery for comprehensive financial analysis. Through detailed case studies, participants will learn how to access and utilize GPT Vision effectively, incorporating it into tasks like data visualization, text and object recognition from images, and the use of descriptive, diagnostic, predictive, and prescriptive (DDPP) analysis methods to enhance decision-making processes. 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: Understanding Power of Attorney, Form 2848, and Form 8821 – 2 hrs (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This two-hour course provides a comprehensive overview of the IRS collection process, guiding tax professionals through each stage, from the initial notice to enforced collection actions. Participants will gain insights into taxpayer expectations during the collection process, as well as strategies for resolving tax debts. The course highlights when to use Form 433-A or 433-B, the documentation needed, and the criteria for submitting an Offer in Compromise (OIC) to settle tax debts for less than the full amount owed. Attendees will also learn about the various payment options available and practical approaches to advising clients. *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
Independence Requirements for CAAS Engagements (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Understanding independence is essential for CPAs providing Client Advisory and Accounting Services (CAAS) to attest clients. This course provides a comprehensive overview of the AICPA Code of Professional Conduct, focusing on the guidelines for maintaining independence while delivering CAAS. We'll review the overall independence process and its application to CAAS engagements, followed by an in-depth exploration of specific services, including reconciliations, accounting standard implementation, information system services, bookkeeping, hosting, and payroll services. Attendees will gain clarity on what services are permissible and how to navigate potential independence issues to remain compliant and uphold professional standards. YELLOW BOOK: Qualifies for Yellow Book CPE based on your unique audited entity.
More Dates
2026/27 AICPA Regulatory Ethics Update (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Stay informed and ahead of the curve with this timely update on ethics and independence developments from the AICPA Professional Ethics Executive Committee (PEEC). The pace of change in ethics regulation has accelerated, and PEEC has been especially active with new interpretations, revised guidance, and significant modernization initiatives. In this interactive course, we'll walk through the most important recent developments shaping ethical requirements for the profession, including updates affecting recruiting practices, CPE programs, and tax advisory services. Participants will gain practical clarity on how these changes impact both public practitioners and professionals in industry. The course also looks ahead to proposed and ongoing projects on PEEC's agenda, providing insight into potential future changes and what they may mean for compliance planning in an evolving ethical landscape. 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
Compilation, Preparation and Review Basics and Peer Reviews (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Cover the basic requirements for performing preparation, compilation, and review engagements under Statements on Standards for Accounting and Review Services (SSARS), including the new SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions. Review common issues found on SSARS engagements in connection with peer reviews and the impact of various findings on the results of a peer review. Identify key issues to consider during SSARS engagements, and determine how to incorporate quality control recommendations and tips for performing high-quality SSARS engagements. 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
Mergers & Acquisitions: Tips and Speed Bumps to Avoid (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Mergers, acquisitions and alliances have been and continue to be major avenues to organizational growth and increased competitive advantage. Despite the great initial promise of many mergers and alliances, few seem to yield the anticipated results. Numerous studies indicate that between 55% and 77% of mergers fail to accomplish their intended purpose. This course helps financial professionals, and their advisors identify, execute, and consummate mergers and acquisitions that create shareholder value while avoiding the many traps that can cause post-acquisition failure.
More Dates
Quality Management: Engagement Quality Reviews (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
SQMS No. 2, Engagement Quality Reviews, sets out requirements and guidance for firms to conduct an engagement quality (EQ) review. The standard also addresses the qualifications, eligibility, responsibilities, and appointment of an EQ reviewer.The predecessor standard, SQCS No. 8, combined quality control policies with the engagement quality control review. SQMS No. 2 was issued separately to highlight the importance of the EQ review within a firm's system of quality management.SQMS No. 2 formalizes and strengthens the review process through clarified guidance and enhanced documentation requirements. It also distinguishes the responsibilities of the firm from those of the EQR reviewer, ensuring greater accountability and transparency.
More Dates
Schedule K-1: What is it & What do I do with it? (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This seminar offers a practical and in-depth exploration of IRS Schedule K-1, a critical reporting document issued to taxpayers with interests in pass-through entities such as Partnerships, S Corporations, and Estates or Trusts. Participants will gain a clear understanding of how to interpret and accurately report Schedule K-1 data on Form 1040, with emphasis on common income, deduction, and credit items. The course also demystifies the Qualified Business Income (QBI) Deduction, including eligibility criteria, reporting mechanics, and integration with K-1 data. Key compliance topics-such as basis and loss limitations, material participation rules, and passive activity considerations-will be addressed through practical examples. In addition, attendees will be briefed on recent developments affecting Schedules K-2 and K-3, ensuring they are equipped to navigate evolving international reporting requirements. 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
Unlock the Power of AI with Copilot in Excel (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
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.
More Dates
Partnerships: How to Calculate Partner Basis (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This program provides a detailed analysis of the calculations related to determining tax basis for a partnership interest. Illustrated examples with filled in forms will demonstrate how the processes works and their 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
More Dates
Adobe Acrobat Tips for Working with PDF Files (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
If you find yourself working with PDF files consistently throughout the day, this course will teach you how to review, annotate, format and organize PDF files more effectively and in less time. You will also learn how to use Adobe Acrobat for e-signatures to reduce document processing time significantly and enhance confidentiality. Adobe Acrobat has many features that you can take advantage of and this course will explain and demonstrate how to use them. 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
Beyond the Basics: Financial Ratios You Might Be Overlooking (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
Overview: Understanding your company's financial health requires more than just traditional metrics. This webinar is designed to reveal deeper insights through advanced, underutilized financial ratios. In this session, accounting and finance professionals will explore metrics such as operating leverage, free cash flow yield, and margin of safety-tools that go beyond standard ratios to deliver nuanced perspectives on profitability, risk exposure, and operational efficiency. 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
2026/27 Yellow Book Update (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
Stay current on key developments affecting governmental audits with this focused update on the 2024 revision of the Yellow Book. This course highlights significant changes related to quality management and updates affecting key audit roles, with an emphasis on how these revisions impact audit planning and execution. The course also addresses the GAO's implementation delay and its implications for 2026 audit planning. Participants will gain context around recent leadership changes at the U.S. Government Accountability Office and what those transitions may signal for future guidance and oversight priorities. In addition, the course includes an overview of recent updates to the Green Book, helping auditors understand changes to internal control guidance that may affect governmental entities and Single Audit engagements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. YELLOW BOOK: Qualifies for Yellow Book CPE based on your unique audited entity.
More Dates
Design Flexible Work Options To Attract & Retain Your Workforce (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
With increasing competition for finding the best qualified candidates and retaining today’s workforce, it’s more important than ever to consider flexible work options in the workplace. We will review the most popular flexible work options your company could consider implementing: telecommuting, compressed work weeks, flexible hours, phased return from leave of absence, job sharing, early release days, and more! We’ll discuss the benefits of this talent management strategy, including increased productivity, decreased costs, better work-life “integration”, and increased employee engagement and satisfaction. You’ll learn how to propose flexible scheduling to your executive team, including how to logistically roll out this program. Whether you’re in a manufacturing plant, corporate headquarters, or retail industry, you can apply any of these flexible work options to your organization.
More Dates
Internal Control Changes for Remote Workers (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
For the past two decades the trend has been to move away from brick and mortar offices and have a greater number of people work or telecommute from home. Because of the upheaval caused by recent events, the rate of this move has been accelerated. This has and will continue to create control challenges and organizations must work to address these. Such things as moving from time based employee value to task completion based measurement and the ability to drive needed inter-company communication are just a sample of the issues with which entities must contend. This session looks at the benefits and pitfalls of workers that telecommute. It then discusses important risks and controls to consider as this trend continues and evolves in the business world. 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
Tax Depreciation: Review and Update (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
A discussion of recent law changes that impact capitalization, depreciation, and disposition of assets. 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
The 10 Must Know Excel Features (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. 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 Controller/CFO Update: Hot Topics Facing Today's Financial Professional (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
In today's rapidly changing world, finance professionals are required to wear many hats and are often the keys to the success of the organization. On one hand, they need to be abreast of the latest proven financial skills for making the best decisions, and on the other hand, they need the best skills to motivate, manage, and lead people. Being pigeonholed into one area or another is neither good for career building nor good for the organization. We'll cover the latest issues that all CFOs and controllers need to know about and provide how-to guidance to allow for immediate use in their organizations.