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.
The Essential A&A Update with Renee Rampulla (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This course is essential and designed to assist those who need to remain up to date on recently issued and effective guidance impacting the accounting and auditing of private companies. Learn about the accounting requirements involving crypto assets, income taxes, joint ventures, governmental grants, interim reporting, and hedging. Understand the American Institute of Certified Public Accountants' (AICPA) recently issued Statements on Auditing Standards (SASs) and Statements on Standards for Accounting and Review Services (SSARSs).
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
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.
More Dates
Surgent's Key Partnership and S Corporation Tax Planning Strategies (4 hours)
Online
4.0 Credits
Member Price: $159
See more dates
Many of our clients are pass-through entities for which many of the general business strategies are subject to additional limitations. To provide the tax planning strategies for closely held business clients that will bring more revenue, this course focuses on the special concerns and techniques the practitioner needs to thrive in this market.
More Dates
Fraud and Financial Distortion: What May Be Hiding Behind the Numbers (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
Financial statements are intended to communicate the financial condition of an organization, but the numbers themselves are only a translation of underlying business operations. When financial professionals focus solely on the accounting presentation without understanding the operational realities behind those numbers, significant risks, distortions, or even fraud can go undetected. This course explores how CPAs, auditors, controllers, and financial analysts can apply operational thinking when reviewing financial information. Participants will learn how to translate financial results back into operational language and evaluate whether a business model is plausible. Through practical examples and real-world case studies, the program highlights warning signs that may indicate financial distortion or misrepresentation. The session equips participants with practical questions and analytical tools to help identify what may be hiding behind seemingly reasonable financial statements.
More Dates
Google Gemini AI for Accountants (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of Gemini AI, Google's advanced multimodal artificial intelligence model. It explains how Gemini is integrated into different Google products, including Gmail, Docs, Sheets, Slides, and as a stand-alone chatbot. Participants will learn how Gemini enhances productivity by summarizing email threads, suggesting responses, drafting emails, generating formulas, creating tables, and more. By the end of the course, students will have a solid foundation in understanding Gemini AI's role in the evolving landscape of artificial intelligence. 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
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
The Role of Internal Control in the Risk-Based Audit (4 hours)
Online
4.0 Credits
Member Price: $149
See more dates
This program explores the role of client internal controls for balancing efficiency and effectiveness in a risk-based audit. We offer practical insights regarding an auditor's assessment of the risk of material misstatement when auditing financial statements of non-issuers, with particular emphasis on internal controls of small-to-medium clients.
More Dates
Accounting for the Gig Economy (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
Freelance work and other non-permanent employment arrangements are becoming increasingly popular ways for people to earn a living. Although these non-traditional activities offer novel, flexible ways to earn income from diverse sources, they also introduce nuanced recordkeeping, reporting, and attestation issues. We investigate characteristics of the gig economy, employee-versus-contractor considerations, bookkeeping, regulatory compliance, and external reporting considerations. We also explore best practices for CPAs who fulfill the role of trusted advisor for gig economy 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
HR Investigations – Episode 3 – Gathering-Analyzing-Reporting (1 hour) [NT]
Online
1.0 Credits
Member Price: $39
See more dates
Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session provides best practices for gathering and analyzing evidence and reporting the investigation results. Attendees will end the session with takeaways to immediately implement in future HR investigations. Three of three Episodes in the series.
More Dates
The Controllership Series: The Controller's Role in Artificial Intelligence (1.4 hours)
Online
1.4 Credits
Member Price: $39
See more dates
Here's a more detailed look at the controller's role in AI: 1. Data Integrity and Quality: • Controllers are responsible for ensuring the quality and integrity of data used to train and inform AI models. • They work to establish data governance frameworks, implement data quality initiatives, and ensure data lineage (tracking data from source to downstream systems). 2. Risk Management: • Controllers assess potential risks associated with AI implementation, including inaccuracies, vulnerabilities, and ethical considerations. • They help define and implement risk management frameworks for AI, ensuring that AI systems are used responsibly and ethically. 3. Compliance: • Controllers stay informed about relevant regulations and ensure AI systems are compliant with those regulations. • They monitor AI systems to ensure they are not violating any laws or policies. 4. Transparency and Auditability: • Controllers work to ensure that AI decisions are transparent and auditable. • They establish processes to review AI decisions and identify potential biases or errors. 5. Collaboration and Training: • Controllers work with IT and business teams to understand AI's capabilities and limitations. • They provide training to teams on how to use and manage AI tools effectively. 6. Value Creation: • Controllers can leverage AI to identify areas for automation, improve efficiency, and gain real-time insights into financial operations. • They can use AI to make more informed decisions and create more strategic recommendations for action. 7. Emerging Role: • The role of the controller is evolving with the rise of AI, with controllers becoming more hands-on throughout the implementation process. • They are increasingly seen as catalysts for AI-enabled transformation, helping to identify potential use cases and build confidence in the technology This course will explore many of these topics.
More Dates
Mastering the Excel Lookup Functions (2 hours) [NT]
Online
2.0 Credits
Member Price: $89
See more dates
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. 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
Sub-Recipient Monitoring 2026: Understanding the Pass-Through Requirements for Managing and Monitoring Your Sub-Awards (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
The Uniform Guidance requirements for subrecipient monitoring and management were updated effective October 1, 2024, introducing new expectations for pass through entities overseeing federal awards. This session will provide practical guidance on implementing compliant subaward agreements, performing risk based monitoring, and managing subrecipient financial performance in accordance with 2 CFR SS200.331-200.333. Attendees will also gain insight into indirect cost rate requirements, fixed amount, and subaward agreements to strengthen oversight and prepare for federal agency or Single Audit reviews. Using fixed amount awards to solve an out-of-the-box solution. YELLOW BOOK: Qualifies for Yellow Book CPE based on your unique audited entity.
More Dates
Overcoming Tech Adoption Challenges in CPA Firms (1 hour)
Online
1.0 Credits
Member Price: $55
See more dates
The accounting profession stands at a critical inflection point where artificial intelligence and emerging technologies are reshaping how firms operate, serve clients, and compete in the marketplace. This course, based on the 2025 CPA Firm Tech Report, provides expert guidance on overcoming the five key challenges that prevent firms from successfully adopting transformative technologies: decision paralysis from overwhelming choices, leadership resistance to change, difficulty proving ROI, growing cybersecurity risks, and critical skills gaps. Through real-world case studies and insights from industry leaders, participants will learn practical strategies for evaluating AI solutions, implementing change management frameworks, and building a technology-forward culture that enhances both efficiency and client value. Participants will explore the CPA Firm Digital Maturity Model to assess their firm's readiness for transformation, examine the evolving AI ecosystem specifically designed for accounting applications, and discover how leading firms are leveraging AI to move beyond traditional compliance work toward high-value advisory services. The course addresses critical considerations for firms of all sizes, from solo practitioners to large regional firms, providing actionable frameworks for prioritizing technology investments, measuring success beyond traditional ROI metrics, and developing the hybrid talent needed to thrive in an AI-enhanced future. Whether you're a firm leader hesitant about technology adoption or a forward-thinking professional ready to champion change, this course equips you with the knowledge and tools needed to navigate the technology revolution transforming the accounting 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
Advanced Cost Accounting: Eliminate Calculation Distortions (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
Organizations that use primitive costing methods make predictable mistakes, allocating too much cost to easy, high-volume "gravy" products and too little cost to difficult, low-volume "dog" jobs, putting an organization with inferior information at a significant competitive disadvantage. The secret to being the “smart competitor” is learning how to deal with overhead. This session will show you how to assign 16 key overhead categories. Whether you work in a wholesale, retail, healthcare, service or manufacturing business, you will find this session invaluable. Get your cost right, and you will be able to give the "dogs" to your competitors and keep the "gravy" for yourself.
More Dates
Microsoft 365 Application Lightning Round Review-Updated (1 hour) [NT]
Online
1.0 Credits
Member Price: $55
See more dates
Do you use Microsoft (Office) 365? Are you satisfied that you are getting the most that you can from it? If you answered yes then no, this course will provide a really high return on your investment of time and money in this application suite. John Higgins, one of the profession's leading experts on the integration of Microsoft 365 into business, will explain and demonstrate the depth and breadth of the Microsoft 365 ecosystem. The course is designed to raise your awareness of all that you can do with Microsoft 365 and substantially increase your monthly subscription ROI. 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
Budget Mastery: Process, Problems, and Solutions (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
The budgeting process can be a mundane one for accountants. Let’s be realistic and agree that even the word “budget” does not bring excitement to you and your departmental colleagues. The constraints and pressures can lead to poor decisions in both the technical and human components. This session is the first part of a four part series and will cover the big picture of keeping the process fresh, pragmatic and useful. We discuss these keys in an engaging manner by discussing both our flaws and strengths, including how to build on these characteristics towards an enjoyable solutions-based method that should deliver effective results for your organization.
More Dates
ChatGPT Deep-Dive Hands-on Bootcamp for CPAs (2 hours) [NT]
Online
2.0 Credits
Member Price: $89
See more dates
ChatGPT has grown its user base to over 800 million active users per week. As a leader in the generative market, it a tool that every CPA should have a basic understanding of how to use and apply in business. This course will provide a comprehensive review and demonstration of how to put ChatGPT to work for you and your clients. It is designed as a "hands-on" course that facilitates following along with the presenter to apply the features of ChatGPT on your computer. Practice files will be provided so you don't have to expose your confidential data. 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 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
Avoiding Legal Liability and Peer Review Deficiencies in Nonaudit rvices, Including Bookkeeping and Preparing Financial Statements (4 hours)
Online
4.0 Credits
Member Price: $149
See more dates
The majority of peer review deficiencies and malpractice claims result from nonaudit services. This course will provide best practices for avoiding legal liability and quality control concerns.
More Dates