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.
K2's Mastering Advanced Excel Functions (4 hours - morning) - Webcast
-
Online
4.0 Credits
Member Price: $195
With approximately 500 functions now available in Excel, some newer and more powerful tools are easily overlooked. But if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel's more advanced features - some new and some legacy - to elevate your productivity to higher levels. In this session, you will learn about many of Excel's newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel's FORECAST.ETS function. Regardless of your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.
The Future of Audit: Technology, Talent & Transformation (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
The audit profession stands at a critical inflection point, facing unprecedented challenges from technological disruption, evolving regulatory landscapes, and workforce transformation. This comprehensive course, based on the Pennsylvania Institute of CPAs' groundbreaking research report "The Future of the Audit: Building Relevance and Sustaining Quality," provides auditors with essential insights and actionable strategies to navigate these seismic shifts. Through expert perspectives from industry leaders including PCAOB board members, Big Four executives, and audit committee chairs, participants will explore how artificial intelligence, blockchain, and data analytics are fundamentally reshaping audit practices while creating new opportunities for value creation and risk assessment. Beyond technology adoption, this course addresses the pressing talent crisis facing the profession and offers practical solutions for building a future-ready workforce. Participants will learn how to leverage emerging technologies to enhance audit quality, understand the implications of regulatory modernization including the concept of "regulatory sandboxes," and develop strategies for attracting and retaining top talent in an increasingly competitive market. Whether you're a partner in a small firm, a manager in a large organization, or an audit professional seeking to future-proof your career, this course provides the roadmap for maintaining relevance, ensuring quality, and thriving in the evolving audit landscape. You'll leave with concrete action steps for immediate implementation and a clear vision for transforming your audit practice to meet the demands of tomorrow's financial ecosystem. 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 Forms 7217 and 7203 (2 hours)
-
Online
2.0 Credits
Member Price: $119
See more dates
IRS Form 7217 is an IRS tax form required for partners receiving distributions of property from partnerships. Starting for tax years beginning in 2024, a partner who receives property from a partnership must file Form 7217 with his or her annual income tax return. Form 7217 is filed by any partner receiving a distribution of property from a partnership to report the basis of the distributed property, including any basis adjustment to such property as required by Section 732(a)(2) or (b). This new IRS form is part of the IRS's general concern regarding basis shifting in favor of high marginal tax rate related partners. Form 7217 is now required and details the types of property distributed, the aggregate basis, and the allocation of basis to the distributed property. Form 7203 is designed to assist in tracking an S corporation shareholder's stock and debt basis. Form 7203 is a significant improvement from the worksheets the IRS provided formerly and over time will serve to help partners and partnerships keep track of their stock and debt basis. The course covers the structure and organization of Form 7203 as well as how an S corporation shareholder's stock and debt basis are calculated.
More Dates
Surgent's Virtual Currency: Keeping Up with the Tax Code (2 hours)
-
Online
2.0 Credits
Member Price: $119
See more dates
Whether you are an experienced veteran or new to the industry, one of the toughest parts of being a tax practitioner is keeping up with all of the changes in tax legislation. This course takes a look at recent changes to tax law from a practitioner perspective. In this session, we will explore the nuances of virtual currency and the new Form 8300 reporting requirements.
More Dates
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
IT Controls & SOC Reporting in Financial Audits (3 hours)
-
Online
3.0 Credits
Member Price: $109
See more dates
This course provides a practical understanding of IT controls and SOC reporting within financial audits. Participants will learn how to interpret SOC reports, evaluate control effectiveness, and determine reliance strategies. Real-world examples will demonstrate how IT controls tie directly to relevant financial statement areas and alignment with Complementary User Entity Controls (CUECs).
More Dates
All About Fraud - Examples, Prevention and Auditing (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
Fraud continues to make headlines, underscoring the importance of understanding how fraud occurs, how it can be prevented, and how auditors are expected to respond. This course begins with an overview of common fraud schemes identified in the 2026 Report to the Nations issued by the Association of Certified Fraud Examiners, along with key characteristics commonly observed among fraud perpetrators. The course then explores practical approaches organizations use to prevent and deter fraud, highlighting controls, policies, and cultural factors that can reduce fraud risk. Participants will also review recent fraud cases reported in the news to reinforce how these schemes manifest in real-world settings. The course concludes with a discussion of the auditor's responsibilities related to fraud under AU-C 240, including an overview of proposed changes to the fraud standards and what they may mean for future 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.
More Dates
The AI Revolution in 2026: What CPAs Should Know (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
AI is reshaping accounting, tax, and finance. This update surveys the state of AI technology in 2026: core concepts, software tools, risks/controls, and practical CPA use cases. You will leave with an expanded AI vocabulary, a current view of the AI landscape, and actionable talking points for staff, clients, and service providers. 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 Best Practices in Not-for-Profit Accounting and Reporting (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
Don't just wing it when you can soar! To catch the eye of resource providers and fulfill the needs of leadership, it is essential that not-for-profits prepare financial statements which excel. This course will empower you with the knowledge of not-for-profit accounting and reporting to surpass the expectations of financial statement users. Over 20 focused exercises are included to illustrate and refine today's best practices in not-for-profit accounting and reporting. YELLOW BOOK: Qualifies for Yellow Book CPE based on your unique audited entity.
More Dates
Retaining Top Talent: Strategies for CPA Firms (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
In today's challenging talent market, accounting firms face unprecedented pressure to retain their best performers. This course provides actionable, research-backed strategies to help firms keep their top talent from leaving. Based on comprehensive surveys of both current accounting professionals and those who have recently left the profession, participants will learn the real reasons employees stay or go-and what firms can do about it. The course goes beyond simple solutions like "pay more, expect less" to explore comprehensive retention strategies including whole-person compensation, work-life balance improvements, career development pathways, and necessary business model transformations. Participants will discover why 73% of surveyed professionals want to stay with their current firm, yet many still leave-and how to bridge that gap. Key topics include understanding the true cost of turnover versus retention, implementing flexible work arrangements that actually work, creating meaningful career paths for non-partner track professionals, and transforming firm operations to support both profitability and employee satisfaction. Special attention is given to retaining diverse talent and adapting to the expectations of younger professionals who will comprise 27% of the workforce by 2025. Whether you're a firm leader, HR professional, or manager responsible for team retention, this course provides the insights and tools needed to build a sustainable talent strategy in an evolving profession. 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
Humanize Automation: Frameworks for Understanding AI and Your Strategy (1.2 hours) [NT]
-
Online
1.2 Credits
Member Price: $39
See more dates
By now you've heard of AI, and a lot about Generative AI (ChatGPT, Co-Pilot, etc.). And in experimenting with these tools, you've likely had some success and some disappointment. That's all part of the process! And it's also why we're bringing you this session, so that you can avoid the failures and accelerate the efficiencies. In this session you'll take a journey. From learning an effective method for prompting generative AI tools, to understanding the importance of data organization, to leveraging automations for strategic points in your customer experience, and to the ever-expanding area of building your own AI agents, this session will provide you with frameworks and processes to better understand AI and craft a strategy for your business.
More Dates
From Numbers to Narrative: Effectively Presenting Your Budget and Reporting (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Perhaps the most important element of the budget process is its communication. If management does not understand the budget – there is an issue. Knowing the right ways to communicate at all levels is essential to stakeholders laying an ownership claim to successful budgets. This session reveals several key guidelines in successful budget presentations and will identify key problems in how people often communicate financial plans. Presenting your budget and reporting is the final part of a four part series, but can easily stand on its own course that is intended to be fun, enjoyable and educational.
More Dates
Introverts Have Real Power, Why Quiet Leaders are So Successful (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Leaders were once chosen for their character, but today we live in an age where loudmouthed extroverts seem to take center stage in everything, including business, politics and entertainment. While the talkative, charismatic leader makes the front page of business magazines, recent research shows that successful business leaders tend to be more reserved, pensive and sometimes outright shy. Learn why your desire to spend significant time inside your own head may be your greatest asset. Whether you are introverted or not, you likely work with, manage or are a related to an introvert. We will discuss proven methods to better understand introverts, how to manage them, and how to get the most out of their amazing talents. If you want to enhance your leadership skills, this seminar is for you.
More Dates
Cash Flow Clarity: Effectively Communicate Cash Flows for your Board and C-Suite (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
The cash flow statement is one of the most confusing financial reports—yet it has the potential to deliver the essential keys to understand business performance. After all, cash is still both king and queen! This session explores how to present, interpret, and communicate cash flows effectively to help CEOs, boards, and decision makers drive smarter results. By using the Sources and Uses format, professionals can make the statement more intuitive and actionable. Learn how to simplify cash flow information and focus discussions on what matters most: how cash is generated and deployed? We will demonstrate how to confidently present this powerful financial statement to non-financial leaders. The cash flow statement is misunderstood, and we will show you how to fix that, and include some amusing videos to drive the points home. We will use the Apple Corporation as an example company in presenting.
More Dates
Individual Tax Update: OBBA and Recent Developments (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
A discussion of the latest tax developments impacting individual taxpayers, with a focus on important provisions, rules and concepts. 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
Enterprise-Wide Risk Management in Accounting and Finance (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
Organizations are challenged with identifying, evaluating, and responding to a wide variety of risks. This course will discuss tips and best practices for enterprise-wide risk management for accounting and finance professionals. 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
Estates & Trusts: Executor Duties and Tax Responsibilities in Estate Administration (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This course reviews the legal, fiduciary, and federal tax responsibilities of an executor or personal representative during the administration of a decedent’s estate. Participants will examine the executor’s duties from initial appointment through final distribution, including identifying and managing estate assets, settling creditor claims, and administering distributions to beneficiaries. The course also reviews filing requirements for the decedent’s final Form 1040, the estate’s Form 1041, and the federal estate tax return, Form 706, along with the treatment of income in respect of a decedent (IRD) and basis adjustments. Participants will also examine IRS procedural requirements, including obtaining an EIN for the estate, responding to IRS notices, and recognizing potential audit risks. Emphasis is placed on practical estate administration procedures, executor liability considerations, and maintaining proper estate accounting records and documentation to support compliance with federal tax requirements. *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
Will Your Ethics Be Burned by Burnout? (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Ethical behavior is not a destination it is a journey with twists, turns, and bumps in the road. We are faced with ethical dilemmas every day. Do I speed to make it to a meeting? Do I call in sick because I need a break? When does "helping my child with their homework" become "doing it for them"? CPAs are ethical most of the time, but staying ethical is hard. It gets harder when we are under stress. 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
Introduction to Governmental Budgeting (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
The introduction to governmental budgeting course is an overview of the typical timeline and process a government uses when creating their annual budget. Topics covered include the basics of governmental budgeting, establishing priorities for the budget, the common steps and timeline of the budget process, what, when and how we should be monitoring the budget throughout the year, and how long-term budgets fit in with the annual budget process. 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
Ethics, Tax Practice & Understanding Circular 230 (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a comprehensive overview of the ethical standards and principles governing tax practice, as outlined in IRS Circular 230. Participants will explore the importance of ethics in the tax preparation industry, review IRS rules, and examine common ethical violations and their associated penalties. The course emphasizes procedures that promote compliance with ethical guidelines, equipping tax practitioners to navigate complex ethical dilemmas confidently. Real-world scenarios will be used to demonstrate the application of ethical principles in tax preparation and representation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.