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.
You Don't Know What You Don't Know About Microsoft Excel [NT]
-
Online
8.0 Credits
Member Price: $239
See more dates
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. 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
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
Self-Rental Real Estate: Passive Activity & Section 199A (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This program presents a detailed analysis of the self-rental passive activity rules, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. 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: Investigating Divorce Cases (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
With over 50% of marriages ending in divorce, forensic accountants are frequently used in uncovering hidden income and assets. It is not uncommon for one spouse to hide money from another, sometimes for nefarious reasons. As a CPA, your services are valued by high-net-worth individuals who hire attorneys in their divorce proceedings. In this course, you will learn the art of financial investigations and how to uncover the truth in divorce cases, whether from offshore accounts to lifestyle analysis. Step by step, the course will teach you the valuable skills necessary in finding, analyzing, evaluating, and presenting your findings to your client and if needed, ultimately in divorce court. 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
Business Valuation Fundamentals (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
This course provides a practical overview of business valuation, guiding participants through the key concepts, methodologies, and considerations involved. You will explore the types of valuation reports, the standards governing their preparation, and the step-by-step process of transforming raw data into actionable insights. The course also examines how the intended purpose of a report can influence its conclusions and offers strategies for valuing minority interests. By the end of the course, participants will gain a clear understanding of how to read, interpret, and apply business valuation reports effectively.
More Dates
The Controllership Series – The Controller’s Skillset (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
This another course in our series on the controllership function. The controller's role encompasses many traditional responsibilities. The breadth and depth of the controller skill set has expanded and will continue to expand as the business world evolves. The controller position will typically lead teams of financial and accounting experts. Recognizing that leadership and team management skills are must-haves; they need to be able to command their team's respect, inspire them to act, and ensure that such actions are aligned with your organization's overall vision. These skills, along with tactical knowledge will ensure the controller's success.
More Dates
Retirement Planning: Next Stage for You or Your Client (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
If you or your clients are facing that stage of life where careers are passing into the background, and a new "to be determined" life is emerging, then you are entering what is called "retirement". Some people are excited, some are scared, and most are both. There are many issues and questions people face at this time - what to do with time, financial, relationships, health, identity and more. This program summarizes the key research studies, provides stories from those who have made this work, and offers thoughtful, practical exercises from my award winning book NEXT STAGE. It will help you (or your clients) address key issues and develop a Master Plan for the transition. If not now, when? 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 Top 10 Celebrity Estate Mistakes and How to Avoid Them (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
This course uses the lives of the rich and famous as a template to better understand the realm of estate planning. With stories ripped from the headlines, we will examine pitfalls and best practices. Did you know that Prince died without a will, opening the door for 45 people claiming to be his beneficiaries? Or that Michael Jackson was not careful in properly funding his trust, leading to delays and legal battles in the administration of his estate? Even Abraham Lincoln, it turns out, did not have a will. In discussing an array of celebrities, from Jackie Kennedy, Joan Rivers, Jimi Hendrix, and Whitney Houston to Aretha Franklin, Barry White, Leona Helmsley, and Florence Griffith Joyner, the course is designed as an enjoyable learning experience with tips for all levels of expertise. We may not have their fame or fortune, but we can certainly walk the red carpet when it comes to estate planning.
More Dates
Partnership & S Corporations: How to Calculate Basis (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
The IRS has recently increased the pressure on how to calculate and report partner and shareholder basis. Changes in the forms reflect these developments. This program provides a detailed analysis of the calculations related to determining tax basis for a partnership interest and S corporation shareholder shares and loans. How to use the Form 1065, Schedule K-1 and Form 1120S, Schedule K-1 information for basis determination. Illustrated examples with filled in forms will demonstrate how the process 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
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
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.