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
Using ChatGPT with Excel (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. 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
Overcome Your Obstacles to Abundance (4 hours) 1 Tech & 3 [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Getting rich requires many things. First, you need to know how to overcome previous limitations you may have had about making a lot of money. Second, you need to know and use the best financial strategies for becoming wealthy--including the latest investment and marketing strategies. And third, you need to be able to enjoy your lifestyle, and look at what obstacles get in the way of you being rich and fully contented. By exploring the latest methods for achieving financial and personal success, you'll be able to make a lot more money and have a great time doing it.
More Dates
Sticky Ethical Choices, featuring Bob Mims and Don Minges (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
If ethics were easy, then why do so many professionals have a Code of Conduct? Some Ethical decisions are easy, others are not. We will discuss several thorny ethical issues and the ramifications. What are the considerations and evaluation criteria to use? The need to carefully deliberate alternatives – is paramount. Be aware.
More Dates
Data Analytics: Practical Insights for Today's Accountant (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This session explores tools and techniques that can enhance the efficiency and effectiveness of client engagements and business processes using data analysis tools. We will introduce some of today's popular and software tools and examine the AICPA's Five-step approach to incorporating data analytics into public accounting engagements.
More Dates
Mastering Partnership Basis: Inside and Outside Basis (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course will provide a detailed analysis of how to determine a partner's tax basis for a partnership interest, with an explanation of the use of both "inside" and "outside" basis determination. An illustrated example with filled in forms will demonstrate how the process works and the potential pitfalls. 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 Excel Lookups: Moving Beyond VLOOKUP Limitations (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.
More Dates
Surgent's Liquidation of Flow-Through Entities for LLCs and Partnerships (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
Part of the technical competence of most experienced accounting and finance professionals is the ability to advise owners of S corporations and partnerships or multiple-member LLCs treated as partnerships regarding the tax rules that apply when these entities liquidate. Entity liquidations do not occur every day; but they do occur, and often at very critical times in the business life of the entity and its owners. All accounting and finance professionals should be able to advise their clients about the tax issues associated with client businesses that go out of existence and liquidate. This program explains the tax consequences associated with liquidating S corporations, partnerships, and multiple-member limited liability companies treated as partnerships.
More Dates
Surgent's Taxation of the Mobile Workforce (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
Today's workforce looks a lot different than it used to. With more people working from home and across state lines, employers must examine withholding and unemployment laws in a new light. In this course, we will examine tried and true rules in this area and examine statutes that are still developing. Using real-life examples and discussion, we will examine state laws on reciprocity and residency requirements. We will also look at what to do when state laws are silent or conflict on a particular issue so you can keep your clients in compliance and be well-prepared for the questions that will come your way in these ever-changing times.
More Dates
Employee Theft: Understanding the Why and Preventing the Loss with Terry Shulman (2.4 hours) [NT]
-
Online
2.4 Credits
Member Price: $99
See more dates
Employee theft is a growing problem, costing businesses billions of dollars annually. In this compelling session, Terry Shulman provides an in-depth look at the psychological, social, and organizational factors that drive employees to steal. As both a legal and behavioral expert, Shulman blends real-world case studies with psychological insights to explore why good employees make bad choices—and what businesses can do to prevent it.
More Dates
The Essential SSARS Update with Renee Rampulla (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This update is essential and designed to assist you in the application of Statements on Standards for Accounting and Review Services (SSARSs) issued by the American Institute of Certified Public Accountants (AICPA). Learn about recently issued SSARS Nos. 26 and 27, identify common accounting and reporting issues, and hear about other recent developments.
More Dates
2026 Spring Tax Update for Business with Steve Dilley (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This comprehensive spring tax update provides an in-depth analysis of the business tax provisions enacted under the One Big Beautiful Bill Act (OBBBA). Participants will examine statutory changes affecting corporate, pass-through, and individual business taxation, including modifications to depreciation, credits, deductions, compliance requirements, and planning strategies. *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
Business Ethics: Cases from the Real World (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Being consistently ethical is a challenge. Most of us have had to make tough choices. This session will discuss real world cases involving thorny ethical dilemmas and how to resolve them. Being ethical is not the same as complying with the law and ethical issues are not always black and white. This session will review different professional ethical standards. What does integrity mean in the office? If you want to learn lessons from the best in a short time, this session is for you. Participate in engaging dialogue about how to prepare for the inevitable ethical situations. These lessons are valuable for every business leader.
More Dates
The One Big Beautiful Bill: 2025 tax legislation (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
The President signed on July 4, 2025, one of most consequential tax legislation in recent years. The well-informed tax practitioner will want to stay abreast of these developments! This course will start with a short background of this legislation as it made its way through Congress and to the President's desk. We will then review the final provisions that was approved by the Senate and passed by the House. 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
An Exhaustive Look At Fraud and Ways To Control It
-
Online
8.0 Credits
Member Price: $239
See more dates
Fraud activities can be executed from within an organization, by parties outside an entity, or by both. Importantly, as the business world becomes more technological, the way fraud is carried out is changing. There must be an increased focus on understanding where new fraud vulnerabilities exist. In this session, we delve into the reasons that both internal and external intentional defalcations take place. The material discusses the new ways fraud is being actuated and looks at the factors driving those that undertake fraud. We spend time examining measures that can be implemented in order to stop fraud via the deployment of added security across the enterprise. 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
Exploring Internal Controls That Could Have Prevented Frauds (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course examines actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters' ability to accomplish their nefarious acts. 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 Not-for-Profit GAAP Update (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
Stay current on the latest accounting developments affecting not-for-profit organizations with this timely GAAP update. This course reviews recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline. The course also introduces the International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025. Participants will gain perspective on the purpose and structure of INPAS and how it compares conceptually to U.S. GAAP requirements for NFPs. This course is designed to help practitioners, financial leaders, and auditors of not-for-profit organizations understand both current GAAP requirements and emerging global developments shaping the future of nonprofit financial 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
How to Choose the Right Business Entity for Your Client (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Tax rates, personal liability, operations - these are all factors to be weighed when advising clients about their choice of entity decision. This session provides a comparison of the multiple entity choices to start the discussion with clients and selecting the best tax efficient option for them. *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
Advanced ChatGPT for Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course concisely explains the latest "see, hear, speak" multi-modal updates to ChatGPT and how they can be used in an accounting context. New features include vision processing, voice conversation, image generation, real-time Internet access, advanced data analysis, plugins and more. Discover how this technology can be used in mind-blowing ways to analyze financial data, optimize processes, and solve problems in the accounting domain. Through the lens of ChatGPT, practitioners can explore innovative solutions, automate routine tasks, and generate deeper insights and value to their clients and organizations in previously unimaginable workflows. You'll walk away with scores of advanced ChatGPT strategies and tips that can be immediately applied and deliver instant results to elevate the efficiency and effectiveness of your accounting projects and tasks. 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 Essentials: Review & Update (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This course examines the critical issues and special opportunities facing partnerships and their partners, as well as the relationship between limited liability companies and partnerships, with a focus on reporting tax basis capital accounts. *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
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.