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.
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
SSARS Essentials: Best Practices for Review, Compilation, and Preparation Engagements (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This course explores provisions of Statements on Standards for Accounting and Review Engagements (SSARS) that govern review, compilation, and preparation engagements. Participants will recall foundational concepts, examine recent updates, understand practitioner responsibilities, and apply best practices for engagement performance. Attendees will learn how to efficiently perform SSARS engagements while complying with professional requirements.
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
The Preparation of Form 706 and 709 – Understanding the Law (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Understanding the complexities of estate and gift taxation can be challenging for many financial professionals, especially those who lack direct experience in this area. In this comprehensive course, participants will gain a solid foundation in Federal estate and gift tax law, providing them with the necessary tools to confidently handle tax compliance issues related to Forms 706 and 709. By exploring the details of the Internal Revenue Code sections pertinent to estate and gift taxation, attendees will gain a thorough understanding of key concepts, including deductions, valuations, and tax credits. This practical knowledge will not only enhance their expertise but also empower them to provide effective tax planning strategies for their clients. Throughout the course, participants will investigate essential topics such as the valuation of assets, deductions for funeral and administrative expenses, charitable and marital deductions, and the calculation of tax credits. By mastering these critical areas, financial professionals will be better equipped to navigate the challenges of estate and gift taxation, ultimately enabling them to provide comprehensive and effective tax planning services for their clients. Whether you're looking to expand your expertise or deepen your understanding of tax compliance issues, this course offers invaluable insights and practical knowledge that can immediately be applied in your practice. **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
Better Forecasts: Be a Better Predictor (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Imagine being able to see into the future with confidence. The ability to be a great forecaster is not innate but learned. By examining great forecasters, we can learn to improve our ability to predict the future. We will examine best practices and current research to improve our ability to predict events that will affect our business.
More Dates
Ethical AI Practices for CPAs: Ensuring Responsible Use (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Explore the ethical implications of using generative AI. This course addresses potential risks and dilemmas, providing guidelines to ensure responsible and compliant integration. Learn how to balance innovation with ethical obligations to maintain trust and integrity. 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
Smarter Tax Services with Artificial Intelligence (AI) Tools (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
There has never been a greater opportunity to leverage technology tools to automate your tax services. This course will provide specific examples of how you can use AI (artificial intelligence) based tools to complement your tax planning, research and compliance services. You will learn how to leverage AI to automate the collection and organization of client data, the engagement management process, tax research, and enhance client advisory services with AI too 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
The Essential FASB Update with Renee Rampulla (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This course is essential and designed to assist those who want to remain up to date on guidance issued by the Financial Accounting Standards Board (FASB). Learn about the accounting requirements involving crypto assets, income taxes, joint ventures, governmental grants, interim reporting, and hedging. Hear about the results and findings of the FASB's post implementation review report involving the lease standard, and much more.
More Dates
Understanding the Tax Implications of Retirement Plan Distributions (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
This session will address the complex rules of retirement distributions, review key provisions of the SECURE Act 2.0, and provide practical strategies of maximizing tax benefits for your client. **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
Taxation of Non-fungible Tokens (NFTs) (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Non-fungible Tokens (NFTs), unique, identifiable digital assets based on blockchain technologies, have become a fast-growing industry. This course will provide a background on how NFTs came into the mainstream marketplace. These materials will assist the practitioner to understand the tax implications of the creation, purchase and sale of these assets. **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
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
Finding the Right Fit: An Exploration Financial Reporting Options for SMEs (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This course is designed for accounting and finance professionals who desire financial reporting flexibility for small- and medium-sized entities (SMEs). We examine special-purpose frameworks (SPFs) that may offer simplification while enhancing the usefulness of financial reporting for SMEs. Our discussion offers practical ways to align financial reporting with the decision-making needs of users and other stakeholders. Real-world examples and case discussions will help attendees confidently prepare, review, and interpret SMEs’ financial statements.
More Dates
Corporate Storytelling in Financial Reporting (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
Developments in the Management Commentary and MD&A Narrative reporting is entering a new era-one that moves beyond compliance checklists to focus on cohesive, decision-useful communication. This seminar examines the evolution of corporate narrative reporting through the revised 2025 IFRS Practice Statement 1: Management Commentary and the U.S. GAAP-based MD&A under SEC Regulation S-K, with key comparisons to help practitioners understand how each framework supports investor-focused disclosure. Using real-world examples and excerpts from the actual annual report of an IFRS reporting company, this seminar highlights how the revised Management Commentary guidance aims to improve the quality, relevance, and connectivity of narrative insights. Participants will explore its emphasis on strategy, risks, sustainability factors (ESG), key performance indicators (KPIs), and the integration of financial and non-financial information. The session also analyzes the modernization efforts in U.S. MD&A, including principles-based guidance, reduction of boilerplate disclosures, and expanded expectations for entity-specific analysis and trend-based insights. Through a comparative approach, participants learn how both frameworks are converging around common principles: enhanced connectivity, balanced presentation, entity-specific content, and alignment of strategy, performance, risk, and value creation. This practical seminar provides accounting, finance, and business professionals with the knowledge needed for better understanding the management commentary and MD&A. 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 Preparation of Form 709 – Line-by-Line (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Gift taxation is a critical component of estate planning, and Form 709 serves as the key reporting tool. This course provides a comprehensive line-by-line guide to preparing Form 709, ensuring accuracy and compliance. Participants will learn how to determine taxable gifts, apply exclusions, and utilize available deductions. Special attention will be given to valuation techniques, gift-splitting, and generation-skipping transfer tax (GSTT) considerations. Additionally, this course will examine any new legislative changes from the current administration and how they may impact gift tax planning and reporting. *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
Internal Control Frameworks for Single Audit (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
The Uniform Guidance identifies COSO and the Green Book as best practices for internal controls in governmental audits. This course provides a comprehensive review of the COSO framework, including its 2013 update, and explores its application to the Green Book. Attendees will learn to recall the five components and 17 principles of internal control, understand the benefits of adopting internal control frameworks, and recognize the rationale behind the COSO 2013 update and its impact on auditing practices. Additionally, the course will cover how to leverage Part 6 of the Compliance Supplement to effectively document internal controls. YELLOW BOOK: Qualifies for Yellow Book CPE based on your unique audited entity.
More Dates
Internal Controls for Small and Medium-Sized Entities (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
This session explores the importance of internal controls with an emphasis on best practices for small- and medium-sized entities. We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed.
More Dates
Microsoft 365 Application Lightning Round Review-Updated (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
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.
More Dates
Accountants and Malpractice: Can We Get Sued for This? (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This seminar reviews situations in which a CPA or accounting professional may be in danger of being sued. We cover common law causes of action, such as negligence, and the relevant standards and case law defining what constitutes reasonable practitioner behavior. This course is ideal for lawyers, CPAs, EAs, tax preparers, accountants and insurance personnel. 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
Communicate Financial Concepts to Non-Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Do you ever get blank looks when you present your company's financial statements? Does your board nod knowingly, during your presentation, but never seem to have any meaningful questions? It could be that they have no idea what you are talking about and are just pretending to understand! Learn how to connect with your CEO, board, fellow managers, and ordinary employees so they understand your message.