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 Supercharging your Spreadsheet Collaboration (2 hours - afternoon) - Webcast
-
Online
2.0 Credits
Member Price: $95
Collaboration is a key to productivity and success. But remote work can make collaboration more challenging, including collaborating on spreadsheets. Fortunately, tools such as portals with check-in/check-out capabilities, version control, comment tracking, and co-authoring can enable online spreadsheet collaboration. Further, Excel's Inquire tool can facilitate spreadsheet collaboration in offline environments. Don't let remote work hamper your spreadsheet collaboration needs! Participate in this session to learn how to collaborate on spreadsheets effectively from anywhere using tools you already own or license.
K2’s Database Basics for Financial Professionals (4 hours - late morning) - Webcast
-
Online
4.0 Credits
Member Price: $195
See more dates
In today's digital age, databases have become the backbone of every business technology, application, platform, and service. Every system relies on databases to store and organize information, from financial records in Quickbooks and Xero to sales efforts in Salesforce and Hubspot. Popular reporting tools like Power BI and Excel utilize databases to create beautiful, insightful dashboards. Despite the widespread use and importance of databases, many financial professionals lack a basic understanding of how they operate. Traditionally, working with databases has been delegated to an organization's IT department, leaving the accounting team out of scope. However, in today's technology-driven environment, accountants need to have a basic understanding of how databases work and the ability to query data independently. Our database basics course focuses on the knowledge most helpful for financial professionals. Through hands-on learning, participants will develop the skills to query data from a database or cloud provider and use it to create insightful reports in Excel or Power BI. By the end of the course, participants will feel empowered to design their dashboards and work more effectively with cloud data. With our database basics course, gain the knowledge you need to succeed in today's digital age and enhance your value as a financial professional.
More Dates
Oregon & Washington Ethics 2026 (4 hours - morning) - Webcast
Online
4.0 Credits
Member Price: $185
See more dates
Award winning discussion leader Mark Hugh helps you meet the ethics requirements of two states, while learning about recent changes at the national and state level. This four-hour class satisfies the Oregon general ethics requirement and is approved by the Washington Board of Accountancy as meeting its four-hour ethics requirement.
More Dates
K2's Hands on with QuickBooks Online Accountant (QBOA) for Public Accounting (3 hours - late morning) - Webcast
Online
3.0 Credits
Member Price: $145
See more dates
We will take a deep look into setting up a QuickBooks Online Accountant (QBOA) account. We will examine all the various firm, staff, and client configuration options for getting this to work inside your organization. This class is going to specifically focus on the configuration options for this application. QBO is a big application and it is important to ensure you've properly set up your firm and client files. Additionally, we will look at the various import/export functionality for getting your data into or out of QBO. Participants will leave this class supercharged with the knowledge of how to set up their QBO accounts correctly for long-term success.
More Dates
K2's Next Generation Excel Reporting - Webcast
Online
8.0 Credits
Member Price: $315
New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel's "legacy" features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to format your spreadsheets quickly and efficiently to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.
K2's Business Intelligence, Featuring Microsoft's Power BI Tools - Webcast
Online
8.0 Credits
Member Price: $315
Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today's business climate. Increasingly, organizations of all sizes are seeking to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools - from Excel add-ins to dedicated solutions such as Power BI - now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyses unthinkable until recently. This program will teach you to implement "do-it-yourself business intelligence" using a variety of techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft's Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools.
Oregon Ethics and New Developments (4 hours - morning) - Webcast Replay
Online
4.0 Credits
Member Price: $185
See more dates
All the ethics you need to know! Award winning and entertaining discussion leader Mark Hugh will review the AICPA Code of Professional Conduct and key Oregon differences; discuss new developments at the national and state level in ethics in the last two years; best practices for CPAs in public accounting and industry; highlight emerging issues; and discuss Oregon administration and enforcement, including examples of recent disciplinary actions.NOTE: This course meets the Oregon Board of Accountancy's biennial four-hour ethics requirement.For the most current Oregon Administrative Rules (OARs), refer to the BOA website: https://tinyurl.com/OR-BOA-Rules.
More Dates
Cryptocurrency 15 Years Later - A Market Update (1 hour)
Online
1.0 Credits
Member Price: $55
Bitcoin, the original cryptocurrency, was released in 2009. After 15 years the cryptocurrency market consists of over 5,000 unique coins/tokens with a market capitalization of over 1.5 trillion as of 1/1/24. This course will provide an update on the cryptocurrency market and the blockchain technology that supports it. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Roles and Responsibilities in Risk Management (1 hour)
Online
1.0 Credits
Member Price: $75
Developing a Strong Risk Management Culture Successful leaders are anticipatory, understanding the potential effect and wider implications of risks. You can guide staff and correct behaviors with policies and procedures. But to fully actualize a risk management culture, leaders must convey integrity and must step up their commitment to enterprise risk management (ERM). Enterprise risk management means dealing with uncertainty. It requires leaders to make informed decisions managing people, processes and technology. In this webcast, you'll learn what it means to be an anticipatory leader, the five levels of defense in risk management and much more.
Self-Rental Real Estate: Passive Activity & Section 199A (2 hours)
Online
2.0 Credits
Member Price: $89
This program presents a detailed analysis of the self-rental passive activity rules, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Tax Planning for Rental Real Estate (4 hours)
Online
4.0 Credits
Member Price: $159
The taxation of real estate is tricky. Taxpayers can own real estate in a number of different ways, including direct and indirect investments. There are numerous exceptions to being classified as a rental activity. How do you know if someone is a real estate professional? In this course, we will explore all these issues and many more. Through real-world examples and discussion, this course will delve into exceptions to rental status, qualifications for material participation, and requirements for active status. Additionally, we will cover the QBI and Section 1237 safe harbors and touch on some planning ideas related to depreciation recapture. 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.
Seeing Beyond the Numbers: Analysis for CFOs & Controllers (4 hours)
Online
4.0 Credits
Member Price: $149
Financial statements are a window into what is going on in the day-to-day operations of the company. They help us see what the company's strengths and weaknesses are. However, financial statements can often have different messages depending on the user. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2025 Annual Update for Governments & Not-for-Profits
Online
8.0 Credits
Member Price: $239
We kick off this course with a look at the GASB standards that are effective this year including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We then move to the NFP side of the house with a look at the Accounting Standard Updates issued by the FASB that impacts nonprofit entities. Following that, we review the work of the Not-for-Profit Advisory Committee (NAC) and the projects they advise the FASB on. After the break, we will conduct a deeper dive into Yellow Book and Single Audit engagements. The course closes with a look at the significant changes in the 2024 Compliance Supplement, the changes to the Uniform Guidance and the common deficiencies identified by the federal agencies and peer reviewers. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ChatGPT and Advanced Financial Analysis for Accountants (2 hours)
Online
2.0 Credits
Member Price: $89
This course provides a concise overview of how to utilize ChatGPT for advanced financial analysis in accounting. The session reveals how to combine sophisticated evaluation and interpretation of financial data with the cutting-edge AI capabilities of ChatGPT. Aimed at enhancing the understanding of an entity's performance, predicting future financial health, and aiding in informed business decision-making, this course goes beyond basic financial statement analysis to include a wide array of techniques and tools. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Hot Topics Accounting Update (2 hours)
Online
2.0 Credits
Member Price: $89
Many accountants desire to have a quick overview of only the most current issues in accounting and financial reporting. This course will provide an executive summary of the most important changes in U.S. GAAP. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Mastering the Art of Conflict: CPA Transformative Strategies (4 hours) [NT]
Online
4.0 Credits
Member Price: $149
Unlock the secrets to transforming workplace and client conflicts into opportunities for growth and innovation. As accounting professionals play an increasingly influential role in organizational decision-making, the ability to transform conflict into opportunity is paramount. In this course, learn how to elevate your conflict resolution skills with methods grounded in "Crucial Conversations," "Fierce Conversations," and "Leading with Questions." Discover how to build stronger client and colleague relationships and model constructive communication behaviors. This class breaks down transformative strategies into actionable steps that every CPA can master. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Fraud & Embezzlement: Case Studies from the Trenches (2 hours)
Online
2.0 Credits
Member Price: $89
Governmental entities are the second largest victims of embezzlement. This seminar examines recent events involving theft of public money and circumstances that allowed the fraud to occur. Case studies we examine include the 2012 $54 million embezzlement from the City of Dixon by Rita Crundwell. The events that impacted the small Illinois town of 16,000 residents was the largest governmental fraud case to date, and spanned an astonishing 20 years. This remarkable story inspired an award-winning documentary, "All the Queen's Horses." We will also examine factors that led to scandals involving the Baptist Foundation of Arizona, World Com, Collin Street Bakery and the Ohio American Cancer Society, among others. This course is ideal for CPAs, government finance personnel, all Internal Auditors, lawyers, governance professionals, accountants and human resource personnel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Navigating IRS Collections: The Collection Process (2 hours)
Online
2.0 Credits
Member Price: $89
This course is designed for tax professionals seeking to understand and navigate the IRS collection process effectively. Participants will gain indepth knowledge of the various collection methods employed by the IRS, including liens, levies and wage garnishments. Additionall, participants will leand strategies to avoid or halt collection actions and the implications of the statute of limitations on tax collection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
AI & You (1 hour)
Online
1.0 Credits
Member Price: $39
See more dates
Every organization today is facing an onslaught of pressure to master Artificial Intelligence “AI” strategies across their enterprises. Never before have we witnessed such a steep expectation for how a “technology” can transform a business, and never before have we been expected to leverage a technology so quickly and so completely. There is no denying AI presents perhaps the opportunity of a lifetime to transform and improve operations, but to date few plans or roadmaps on how to unlock the promise of AI exist. In this class, Steve Cadigan, a globally renowned future of work expert, will present a practical plan for how you can build your own AI strategy, and how you can thrive in the AI revolution. Steve will show present a roadmap of how to build your confidence with AI to address this massive change management challenge.
More Dates
Benford's Law and Other Digital Analysis Techniques (1.8 hours)
Online
1.8 Credits
Member Price: $79
See more dates
Numbers and especially the digits within those numbers can conceal a lot of information. Benford's Law and other digital analysis techniques can be the keys to unlocking that information. This session will explain what Benford's Law is, how it works, and how it can be used to reveal bogus information and made-up data. Accountants and auditors should understand how to use this valuable audit tool as well as other digital analysis techniques. But, if you attend this session, you must promise not to reveal the secret behind these techniques to any fraud perpetrators.