CPE + Events Catalog
Effective Oct. 1, 2025: Washington residents will be charged state & local sales tax on OSCPA live webcast events. For more information, visit the CPE FAQs. If your residence is no longer in Washington, please update your member profile here.
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 Understanding Partnership Taxation: Debt Allocations (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
How debt is allocated to the partners in a partnership is important. It dictates how much money may be taken tax-free as a distribution, the losses that flow down to the partners, and the gain or loss on the sale of a partnership interest. However, the allocation of debt can differ depending on the type of debt it is and the type of partner we are talking about. Furthermore, 704(c) can complicate things. And what in the world is a constructive liquidation scenario? In this course, we will tackle the concept of debt allocations - how you do it, what it means, and why you do it. NOTE: This course qualifies for IRS CE (PTIN) credit. To receive IRS CE credit, please email your PTIN to profdev@orcpa.org at the end of the course. Surgent will report credit at the end of each quarter.If you have questions, you can contact Professional Development at 503-641-7200, ext. 3 or email profdev@orcpa.org.
More Dates
Independence for Auditors - AICPA, PCAOB, GAO & DOL (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
This course will look at the various rules related to Independence and compare and contrast the requirements. This overview course will help auditors understand the nuances of independence and ensure they meet the requirements to perform attest services for their clients. We will review the requirements for the AICPA, GAO, DOL, and PCAOB.
More Dates
Nonprofit Accounting and Financial Reporting Explained
-
Online
8.0 Credits
Member Price: $225
See more dates
This course provides a high-level overview of the most important issues facing nonprofit entities and their auditors. The focus of this course is on explaining the theory behind major issues and trends, enabling professionals to understand the most important aspects of relevant professional and regulatory standards related to reliable financial reporting for nonprofit entities.
More Dates
Introduction to Yellow Book: 8-Credit Boot Camp
-
Online
8.0 Credits
Member Price: $239
See more dates
This course is designed for accountants in public practice and industry who focus on nonprofit and governmental entities. We will cover the basics needed to understand what makes nonprofit and governmental accounting & auditing unique. The course starts with the key financial reporting differences for governmental and nonprofit entities and then switches focus to review the fundamentals of Yellow Book and Uniform Guidance audits. This foundational course is perfect for those getting started in the nonprofit and governmental arena and those looking for a refresher. 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 Ethic of Recruitment and Selection (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Today, more than ever, it is essential that employers have an ethical and effective recruiting strategy and selection process that fosters an environment of diversity and inclusion. This webinar focuses on identifying recruiting strategies that help to increase talent pools and employment interviewing that maximizes hiring success. 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
A Guide to Sampling - Part 2 (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
Building on Part 1, this course will review the application of sampling in financial statement audits with a focus on sampling for tests of controls. We'll also review the requirements for sampling in Single Audits with a focus on tests of controls and tests of compliance.
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
Monthly Federal Tax Updates - November 2025 (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. 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
Streamlined Excel Reporting Series Session 4: External Data and PivotCharts (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $125
See more dates
Extracting data for richer insights You'll gain meaningful analysis techniques while working alongside an industry expert and knowledgeable instructor. This session begins with the GETPIVOTDATA function to enable report customization. It's a great starting point before moving on to more advanced techniques. Power Query introduction With its user-friendly interface, Power Query empowers Excel users to take the next step by enabling seamless data import and transformation. With Power Query, you will explore features, including: Getting and transforming data Loading data Managing columns Data source settings Layouts and parameters Visualizing with PivotCharts A well-designed chart can effectively illustrate data trends and comparisons. You'll learn how to create and customize PivotCharts to elevate your reports and make the data more accessible to others. *Session 4 is one of four individual sessions. Each session builds on the previous one, so consider watching all the sessions [Streamlined Excel Reporting Series](https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series) to tackle real-world issues and create powerful workbooks.*
More Dates
Common Yellow Book & Single Audit Deficiencies (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
Yellow Book and Single Audit engagements are considered must-select engagements for peer review. This course will review the common deficiencies noted by peer reviewers and federal agencies. We'll focus on the requirements of Yellow Book independence, CPE, and reporting. We will also review deficiencies related to internal controls over compliance, compliance testing, and major program determination for Single Audits. We'll close the course with a look at the deficiencies often identified in COVID-related funds.
More Dates
Professional Conduct & Ethics - AICPA and Oregon Board CPA 2025 Regulatory Update by Jim Rigos (4 hours - morning) - Beaverton
-
Beaverton
4.0 Credits
National Chair of the American Academy of Attorneys-CPAs Ethics Committee, instructor/author James Rigos, Attorney-CPA, will instruct on the topic areas that are required under the Board of Accountancy Administrative Rules for CPAs.NOTE: This course meets the Oregon Board of Accountancy's biennial four-hour general ethics requirement.For the most current Oregon Administrative Rules (OARs), refer to the BOA website: https://tinyurl.com/OR-BOA-Rules.
How Technology Controls Should Be Developed and Implemented 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
This course is an overview of control creation methods and strategies to implement policies and procedures successfully. Many organizations successfully create a system of internal controls. However, some fail to implement established measures correctly. Moreover, entities need to pay more attention to the critical process of testing, monitoring and updating control procedures, weakening the internal control structure. Receive an array of control maintenance checklists adaptable to your organization to improve policies and procedures. Grasp the need for dynamic, fluid controls that adapt to business tools and methods changes. Gain a strengthened ability to implement and maintain an internal control system.
More Dates
Real Estate Taxation 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
Examine significant real estate tax issues and concepts, including planning and compliance topics emphasizing tax elimination or deferral. Discuss the qualified business income deduction (Sec. 199A) as it relates to real estate investments; limited discussion of opportunity zones (Sec. 1400Z-2) relating to real estate; 1031 exchanges; home sale exclusion (IRC Sec. 121); passive activities loss rules; estate planning and gifting with real estate; and California property tax issues, updated for passage of Proposition 19 affecting parent-child transfers and transfer of assessments to a new principal residence.
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
Generation-Skipping Transfer Tax 25-26 (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
This advanced course is designed to complement the 4-part 706 Preparation Series and will discuss various aspects of the Generation-Skipping Transfer Tax.
More Dates
AI & Accounting in Manufacturing (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of how artificial intelligence (AI) is reshaping financial oversight in the global manufacturing sector. With factories evolving into digital ecosystems powered by intelligent automation, predictive analytics, and edge computing, the role of accounting and finance professionals is rapidly transforming. Participants will explore how AI technologies intersect with core financial functions-cost accounting, audit, tax compliance, and financial planning-while enabling real-time reporting, fraud detection, and predictive decision-making. Drawing on current global trends and real-world case studies, the course offers actionable insights into integrating AI into financial operations, elevating the strategic role of accounting in manufacturing enterprises. 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
PPP Fraud and Financial Professionals (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Casey Crowther did not have a college education, but he had an outstanding work ethic. With little more than a pickup truck and some hand tools, he built a roofing company that grew. Over time, Casey's company employed more than 100 people and generated more than $20 million in annual revenues. With a company of that size, Casey relied upon advice from his bookkeeper when filling out financial documents. As a result of representations he made on bank statements and loan documents, authorities charged Casey with criminal behavior related to PPP loan fraud. What should an accounting professional learn from Casey's story? Stay tuned to find out! 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
Determining Reasonable Compensation for Owner Employees (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
This session will expand on methodologies to employ when owner-employee compensation is at issue. The session will focus on determinations of reasonable replacement compensation for individuals who both provide services to a closely held business or professional practice and also have an ownership stake in the enterprise. Executive Compensation in the form of options and restricted stock will also be covered in the context of marital dissolution proceedings. 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
AICPA Town Hall Series (Rebroadcast of 11/6/2025) (1 hour)
-
Online
1.0 Credits
See more dates
OSCPA is pleased to partner with AICPA to offer the Town Hall Series. These webcasts are FREE to OSCPA members.Each event is a rebroadcast of the live Town Hall webcast from the previous week. The AICPA Town Hall Series delivers: Timely & Critical Information Interpretation & Analysis Firm and Business Strategies Practitioner Capabilities **Free for AICPA members Not an AICPA or CIMA member? Become one today.