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
Surgent's Use the Data Model to Build More Powerful PivotTables (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.
More Dates
Unlock the Power of AI with Copilot in Excel (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
In the ever-evolving world of data analytics and business intelligence, Microsoft Excel continues to be an indispensable tool for professionals across industries. With the introduction of Copilot, Microsoft has integrated the power of artificial intelligence directly into Excel, revolutionizing how users work with data. This 2-hour interactive course, Unlock the Power of AI with Copilot in Excel, provides a comprehensive overview of how Copilot transforms traditional Excel workflows into dynamic, AI-driven processes, enabling users to accomplish tasks faster, more accurately, and with less manual effort. During this course, you'll discover how Copilot leverages AI to enhance productivity and streamline operations. Whether you're a seasoned Excel user or just beginning your journey, this course will guide you through practical applications and best practices to make the most of Copilot's capabilities. Through hands-on demonstrations and real-world examples, you'll see how Copilot can save time, improve decision-making, and elevate your analytical skills to new heights. This course not only focuses on the technical aspects of Copilot but also highlights its potential to transform your day-to-day work, from automating repetitive tasks to uncovering trends and insights you might otherwise overlook. By the end of the session, you'll be equipped with the knowledge and confidence to integrate Copilot into your workflows and unlock its full potential in Microsoft Excel. 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
Conflict Resolution and Effective Communication Training (1.2 hours) [NT]
-
Online
1.2 Credits
Member Price: $39
See more dates
Strong teams communicate openly, listen actively, and handle conflict with respect. This engaging session helps participants recognize different communication styles, manage misunderstandings, and turn tough conversations into opportunities for collaboration. Through discussions and practical tools, team members will build confidence in addressing challenges while strengthening trust and connection in the workplace.
More Dates
Steps to Stop External Fraud (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Until recently, a percentage of organizations discounted the risk related to external fraud attempts. Most were only concerned with protecting physical assets such as inventory or fixed assets. However, because of the many highly publicized corporate hacking events, such as the ones that affected the Colonial Pipeline and JBS Meats, more attention is being paid to external fraud risk of all types. In this session, we look at what is included in a definition of external fraud and then delve into specific control issues that can give rise to increased risk. We then discuss measures that organizations can employ to help reduce exposure to external attacks. 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
Volume to Value: A New Era of Precision Hiring in Accounting (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
Volume to Value: A New Era of Precision Hiring in Accounting examines how accounting firms are shifting from high-volume recruiting models to "precision hiring" as AI adoption accelerates and talent scarcity continues. Participants will explore why traditional hiring processes often overemphasize technical accounting knowledge while under-assessing the competencies that most impact performance-critical thinking, professional communication, and AI ethics awareness. The course explains how AI-enabled recruiting tools can support candidate screening, assessment, and retention forecasting, and why firms that do not modernize their hiring approach may struggle to compete for top talent. Participants will leave with practical approaches to competency-based assessment, ethical guardrails for AI use in hiring, and a high-level implementation roadmap with metrics to evaluate quality of hire, performance, and retention. 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 Audit Prepaid Expenses (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Understanding how to effectively audit prepaid expenses is a key skill for audit staff. This course provides a comprehensive overview of the fundamentals, including the applicable audit assertions and common risks and threats associated with the prepaid expense balance. Participants will learn how to perform substantive auditing procedures to ensure accuracy and reliability, with guidance on applying these techniques to real-world scenarios. Designed to enhance practical knowledge, this session equips auditors with the tools and confidence needed to navigate prepaid expense audits with proficiency. YELLOW BOOK: Qualifies for Yellow Book CPE based on your unique audited entity.
More Dates
Internal Controls That May Have Prevented Fraud (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.
More Dates
Ethics and Technology for CPAs (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Explore the ethical principles included in the Code of Professional Conduct that address the emerging practice issues created by new technologies. Consider how technologies may impact audit quality and the integrity of the financial systems, and whether they create a need for CPAs to adjust their skill sets to address those challenges. Look at the potential ethical challenges created by the data related to privacy, security, and its application. Discuss the changes being proposed to address emerging ethics challenges. 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
Practical Accounting Update 26-27 (4 hours)
-
Online
4.0 Credits
Member Price: $175
See more dates
In this dynamic course, we'll delve into essential updates and equip you with the practical knowledge to navigate the latest changes in the field. Need insights on how the shift from the Statements on Quality Control Standards (SQCSs) to the Statement on Quality Management Standards (SQMSs) will affect your practice" We have you covered. Questions about cybersecurity requirements for CPAs" Arm yourself with practical strategies to protect your clients and firm in an increasingly digital world. From the newest accounting rules to mastering new audit standards, we'll explore the newest developments to help you navigate the changes.
More Dates
SSARS Practice Issues and Standards Update 26-27 (4 hours)
-
Online
4.0 Credits
Member Price: $175
See more dates
Statements on Standards for Accounting and Review Services (SSARS) No. 21 was a game-changer for practitioners. Effective for periods ending on or after December 15, 2015, it codified and clarified all prior SSARS guidance into one streamlined standard. It overhauled the framework for engagements and introduced a new non-attest service: the Preparation of Financial Statements. This standard redefined the boundaries between attest and non-attest services, set clear expectations around engagement letters, required procedures and documentation, and updated reporting requirements for each service level—Compilation, Review, and now, Preparation. It also resolved several long-standing practice gaps from earlier SSARS and aligned with evolving client needs and firm workflows. Updates to SAS No. 21 were also included to maintain consistency across standards. For CPAs, SSARS No. 21 isn't just compliance'it's clarity. It's a practical framework that reflects how we work today.
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
Auditing Standards: A Comprehensive Review 26-27 (16 hours)
-
Online
16.0 Credits
Member Price: $589
See more dates
From understanding fraud requirements to improving risk assessment procedures and from testing to meeting auditing standards, discover ways to audit more effectively and efficiently. Engage in discussions that cover reducing risk and effective planning, research and documentation. Review various case studies, real-life examples and sample documentation will reinforce ideas. This course meets the specific California Board of Accountancy requirements that CPAs are required to meet for re-issuance of their license.
More Dates
AI Lessons Learned for Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides accountants with the leading AI insights and strategies drawn from real-world experience, empirical studies, countless CPA case studies, and social media commentary. It goes beyond theory, offering practical lessons learned from the front lines of AI implementation in the business world and accounting industry. Participants will gain actionable knowledge on bridging the theory-application gap, navigating exponential technological changes, and creating secure, adaptive AI policies. By the end of the session, accountants will be equipped to leverage AI responsibly and innovatively in their 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
Tax Depreciation: Review and Update (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
A discussion of recent law changes that impact capitalization, depreciation, and disposition of assets. 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, AI, and Music: What Every CPA Must Know (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
You may be surprised to learn how artificial intelligence is transforming the music you love. For example, what happens when AI creates songs based on other people's work without credit or payment? How should musicians disclose the role of AI in their recordings? The challenges that AI poses for music, such as threats to intellectual property, confidentiality, fairness, and professional reputations, are also front and center in accounting. This one-hour ethics course invites you to explore one of your favorite subjects outside of work. You'll discover how the five principles of ethical intelligence can help you listen to music in ways you never considered before. You'll also see how these same principles guide you in making the best decisions in your accounting practice. 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 Audit: Property, Plant, & Equipment (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Property, Plant, & Equipment is often one of the largest balances on the financial statements. This course will cover the foundation of auditing PP&E, including the related audit assertions, risks, & threats to the PP&E balance. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through some real-world examples. 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 Seven High Quality Questions that Lead to Success & Solutions (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
“How will I EVER get this all done?" It’s a question I often hear from clients and on a particularly stressful day, I can hear myself saying these words! Instead of helping us focus, it's a question that leads to stress, anxiety and overwhelm! Regardless of where we are in business and in life, we will run into challenges and problems as we navigate business growth, leadership, work life balance and our quest for success and happiness. This workshop will explore the 7 HIGH QUALITY questions that lead to relief, enthusiasm and success. It will be an interactive exploration that will leave you with a game plan to use right away, as well as an opportunity to practice the mindset that the most successful and happiest people use daily. This program is for both the entrepreneur who wants to be more effective in their day as well as team leaders who want to stand out in their organization. For the business owner or staff member you can expect a new way to work with your day so that it's profitable, productive and happier. For leaders, you will learn new up- leveled skills to increase your efficiency, communication and productivity. You and your team will shine. Your staff will feel appreciated and connected to their value as well as the company's goals. Albert Einstein said 'we can't solve our problems with the same thinking we used when we created them'. The quality of your question will impact the quality of your solution. Learn the 7 questions that take you from confused and frustrated to creative and focused.
More Dates
Federal Tax Update for Individuals with Doug Van Der Aa (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This program will address recent legislation, rulings and developments affecting individual taxpayers and provide practitioners with a comprehensive update for the upcoming tax season. *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
What You Can Learn From the Statement of Cash Flows (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course allows you to get reacquainted with the statement of cash flows. We will refresh your skills regarding both the preparation and utilization of the statement of cash flows. Significant emphasis will be placed on the informational role of the statement of cash flows and insights that can be obtained using the statement of cash flows in concert with the other elements of a company's accrual-basis financial statements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.