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
K2's Excel PivotTables for Accountants (4 hours - morning) - Webcast
-
Online
4.0 Credits
Member Price: $195
Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge of PivotTables, then plan to participate in this course. You will learn how to build PivotTables, group data inside PivotTables - including grouping options for fiscal periods - and create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques, including building PivotTables that consolidate data from multiple data ranges and PivotTables that connect dynamically to external databases and financial accounting systems. Additionally, you will learn to take advantage of other Excel features associated with PivotTables, including Slicers, Power Query, and Power Pivot. You will be a master of Excel PivotTables at the end of the day! This course is for you if you have been leery of working with PivotTables or have struggled to realize their many benefits. With some information, guidance, and coaching from your K2 instructor, you will be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.
Preparing and Reviewing Workpapers – Essential Tips for Avoiding Deficient Audit and Other Attest Engagements
-
Online
8.0 Credits
Member Price: $250
See more dates
Workpapers are the primary support for findings, conclusions and opinions on any audit or other attest engagement. This course will provide the essential tips and techniques for ensuring workpaper documentation is of a high quality, yet efficient, nature. YELLOW BOOK: Qualifies for Yellow Book CPE based on your unique audited entity.
More Dates
ACPEN Signature 2026: Partnership and LLCs Update
-
Online
8.0 Credits
Member Price: $250
See more dates
LLCs and partnerships continue to present some of the greatest challenges for return preparers and advisors. This program addresses the latest developments affecting these entities, including new IRS audit initiatives, updates on self-employment tax for LLCs and partnerships, disregarded entity rules and transactions, and common allocation issues. Participants will also review how to properly identify various types of partnership debt for basis purposes, understand the use of the §754 election in the sale of interests and at death, and explore reporting requirements for LLC and partnership interests on gift and estate tax returns, including valuation considerations for closely held businesses and minority interests. The session also examines the impact of the recent Sirius Solutions decision. Join us for the course! And as with all ACPEN courses, your questions to the panelists are encouraged. 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
LLC's & S Corporations: a Comparative Analysis
-
Online
8.0 Credits
Member Price: $239
See more dates
This course focuses on the most common aspects and tax implications of Limited Liability Companies and S Corporations. It will further compare forms of entities, along with corporate formalities compliance issues of each entity type. Electing Subchapter S status as well as reviewing the mechanics of electing Subchapter S status will be discussed. Highlights of entity specific tax forms will be discussed, as well as accountable plans, taxable fringe benefits, officer reasonable compensation, estate planning, business continuation planning and audit strategies. Schedules K-1, K-2, K-3, and effectively connected income will be reviewed in this course as well. 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 Compilations, Reviews, and Preparations: Engagement Performance and Annual Update
-
Online
8.0 Credits
Member Price: $299
See more dates
Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical, and technical requirements.
More Dates
Finding Errors in Excel Spreadsheets (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. 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
Bytes, Bias, and Balance: Data Ethics for Savvy Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course explores the transformative role of artificial intelligence (AI) in accounting and auditing, highlighting its vast potential while addressing the associated risks and ethical considerations. Participants will discover how to harness AI tools to enhance efficiency and innovation, while mitigating challenges such as overreliance, data security vulnerabilities, and ethical dilemmas. Through case studies and interactive discussions, you'll gain practical skills to navigate AI complexities, ensure trustworthy outputs, and uphold ethical standards in today's fast-paced digital environment. 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
Fiduciary Taxation Part 3: Complex Trusts & Charitable Deduction 26-27 (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
During part 3, of this 4-part series, we'll focus on the accounting and taxation of Complex Trusts. Using a series of calculations, determine whether the fiduciary or the beneficiary bears the burden of taxation and if the trust or estate is treated as a taxpaying entity or a conduit. The requirements and use of a charitable contribution deduction are also reviewed and its relationship with and difference from fiduciary accounting. Be sure to register for all courses in this series: Fiduciary Taxation Part 1: Introduction to Form 1041 Fiduciary Taxation Part 2: Fiduciary Accounting & Simple Trusts Fiduciary Taxation Part 3: Complex Trusts & Charitable Deduction Fiduciary Taxation Part 4: Miscellaneous Topics & AMT
More Dates
Tax Practice Conduct Standards: Circular 230 and AICPA Statements 26-27 (4 hours)
-
Online
4.0 Credits
Member Price: $175
See more dates
Meet the ethics requirement while addressing significant changes in the statutory and regulatory standards that govern tax practitioners. We'll explore rules that govern professional conduct in tax practice, including responsibilities to advise clients on tax positions and related penalty avoidance.
More Dates
The Generation-Skipping Transfer Tax and Dynasty Trusts 26-27 (4 hours)
-
Online
4.0 Credits
Member Price: $175
See more dates
Transfer taxes, such as the estate, gift, and generation-skipping transfer tax, create a drag on the accumulation of wealth over a family's generations. However, with the One Big Beautiful Bill's continuation of the high gift and estate tax exclusion amounts for the foreseeable future, advisers have the opportunity to create trusts that extend through the grandchildren's generation. This course examines the generation-skipping transfer (GST) tax and how it is designed to discourage avoidance of the estate and gift tax by families. Randy Gardner explores: GST tax terminology, how the GST tax is calculated, ways to avoid the GST tax, and how to design a dynasty trust to pass property from generation to generation.
More Dates
A&A Update for Closely Held Businesses 26-27 (6 hours)
-
Online
6.0 Credits
Member Price: $259
See more dates
This course is designed for the accounting and auditing professional who provides attestation services to closely held businesses. The course reviews recent standard-setting activities of the Financial Accounting Standards Board (FASB) and the AICPA, specifically focusing on those standards having the most significant impact on closely held non-public business entities. The course also discusses adopting the latest audit standards, including the new audit risk assessment requirements.
More Dates
Top 10 Things to Know About Estate Taxation & Planning 26-27
-
Online
8.0 Credits
Member Price: $329
See more dates
Clients believe that estate planning is only for the wealthy who will owe Federal estate tax. This isn't the case. Perhaps as a result of the 2020 pandemic, estate planning has a renewed focus. All practitioners should be familiar with the vernacular, acronyms and techniques. Estate planning involves personal issues that affect everyone, whether or not the estate tax will apply. Learn strategies to pass assets to future generations; provide education benefits; distribute retirement benefits, and provide a charitable legacy.
More Dates
Behavioral Finance Biases (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
If you have been a practitioner for any length of time, you know that there is often a difference between what clients should do and what they actually do. Have you ever wondered why that is? In this course, we will explore how we make decisions with less-than-perfect information. Through real-life examples and case studies, we will examine common behavioral biases and how to deal with 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
Partnership/LLC Taxation: Tax Basis Capital Accounts (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners "tax basis" capital accounts, now required for tax form reporting. 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
Preparing to be a Forensic Accountant - Focus on Digital Forensics (1.8 hours)
-
Online
1.8 Credits
Member Price: $79
See more dates
Forensic accounting, forensic accountancy or financial forensics is the specialty practice area of accounting that investigates whether firms engage in financial reporting misconduct. Forensic accountants apply a range of skills and methods to determine whether there has been financial reporting misconduct. Financial forensic engagements may fall into several categories. For example: Economic damages calculations, whether suffered through tort or breach of contract. Post-acquisition disputes such as earnouts or breaches of warranties Bankruptcy, insolvency and reorganization Securities and tax fraud Money laundering Business valuation Computer forensics/e-discovery This session is designed to delve into further investigative procedures used including digital forensics. Future sessions will focus on computer forensics, network forensics and mobile forensics.
More Dates
ChatGPT for Accountants: 50+ Use Cases (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to clients. 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
Preparing and Reviewing Workpapers for Higher Quality Audits (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This course will focus on preparing financial statement audit documentation critical for high quality audits that can pass peer review.
More Dates
CPA to CFO: Essential Competencies for Finance Leaders (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
The path from CPA to CFO has evolved dramatically in recent years, with only 43% of S&P 1000 CFOs holding CPA licenses in 2022, down from 55% a decade earlier. This comprehensive course, based on groundbreaking research from the Pennsylvania Institute of CPAs surveying over 320 CEOs and hiring executives, reveals what today's leaders truly seek in CFO candidates and provides a roadmap for CPAs to secure their seat at the executive table. Participants will discover the five critical competencies that distinguish successful CFO candidates: forward-looking financial acumen that goes beyond traditional reporting, strategic leadership skills including critical thinking and strategy creation, the evolving role of emotional intelligence, industry-specific expertise requirements, and the balance between technical proficiency and visionary leadership. Through practical frameworks, real-world examples, and actionable strategies, attendees will learn how to transform their CPA foundation into a comprehensive skill set that meets the dynamic demands of modern CFO roles, whether in high-growth companies, nonprofits, or traditional corporations. 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
Common Financial Statement Disclosures (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Financial statement disclosures are important to provide the information necessary for financial statement users to make economic decisions. Disclosures further explain and clarify information provided in the basic financial statements, but also provide critical information about subsequent events, litigation risk, and other concerns. This course focuses on the most common financial statement disclosures for small- or medium-sized nonpublic entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.