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.
Taking Advantage of Array Formulas in Excel (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in 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
Avoiding Legal Liability and Peer Review Deficiencies in Nonaudit Services, Including Bookkeeping and Preparing Financial Statements (4 hour
-
Online
4.0 Credits
Member Price: $129
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
Build a Data Model for Analysis in Power BI (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. 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
AI Revolution: The Big Picture for CPAs (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Discover how artificial intelligence is transforming the accounting, tax and finance landscape. This course offers CPAs a comprehensive overview of AI technologies, with a special emphasis on generative AI tools such as ChatGPT and Google Gemini. Learn how these advancements are reshaping business operations and what they mean for your professional role. 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 Getting Ready for Busy Season: Key Changes Every Tax Practitioner Should Know (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
Getting ready for busy season involves not only knowing what's new for the current year, but also understanding how the changing limits, phaseouts and other rules apply to current-year returns. With major legislation enacted over the past few years, the present course will constitute a one-stop "shop" that brings you the essential individual tax information. In addition, this course provides an up-to-date review of important tax form changes, new tax forms, new limitations, key developments as they are reflected in the IRS forms, and IRS filing issues and deadlines that will be invaluable to attendees who prepare tax returns during busy season. 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
2024 Revision to Government Auditing Standards Impact (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This course will provide an update of Government Auditing Standards as a result of the GAO's issuance of the 2024 Revision to Government Auditing Standards. The course will focus on the Revisions impact on financial statement audits. The course will also focus on the impact of Quality Management Standards as well as clarify as to when the concept of reporting key audit matters might apply for financial audits. 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
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
Love it or Leave It: Engagement and Retention at Work (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
One of the biggest challenges, if not the most critical challenge in business, is attracting and keeping an engaged and productive workforce. Navigating the world of engagement and retention requires an understanding of human needs as well as deliberate and intentional actions to strengthen an employee's investment and connection to their place of work. For all the HGTV lovers out there, this session mirrors a television show where an individual/family must decide if they want to stay in their current home (after renovations and home improvements) or move to a new space. This webinar title seems apt in describing the current issues around engagement and retention. When an employee chooses to "love it" or stay with their current employer, it typically means they are engaged in their work and they feel seen, heard and valued- they are content. Conversely, the notion of "leaving it" typically symbolizes an employee who cannot wait to get out of their current job. These employees often have negative attitudes and/or behaviors at work. The purpose of this webinar is to recognize the significance of attracting and retaining employees, building your brand as an employer of choice and developing a culture where individual employees feel valued, cared for and ultimately engaged, all though an ethical lens. 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
What's Behind the Data? (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
We are bombarded with information continually. So how do we determine what is valid and what isn't? This course points out common pitfalls inherent in data interpretation and gives practical tips to overcome those pitfalls by using real life examples. The course incorporates information from key thought leaders including Adam Grant, Alex Edmans, and Hans Rosling. 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
SAS 145 - Risk Assessment (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
SAS 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was issued in October 2021. This audit standard amends AU-C 315, making many changes to address common audit deficiencies. This course will provide an overview of SAS 145 and its changes to AU-C 315.
More Dates
Forgotten Managerial Accounting Tools for CPAs (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! 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 Cash (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Cash is essential to every business, and is often one of the first accounts audit staff are exposed to. This course will cover the basics of auditing cash, including the related audit assertions, risks, & threats to the cash 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
Ethics: IRS Criminal Investigations: Key Lessons for Accountants (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of recent IRS criminal investigations and what practitioners can learn from these cases to help fight economic crime and even avoid personal criminal prosecution. While accountants are numbers people by training (not detectives per se with the exception of forensic accountants), practitioners are increasingly being called upon by governments and economic organizations at all levels to step up and help law enforcement battle financial impropriety. The stakes are huge. In the United States alone, the OECD estimates that 5% to 10% of the annual budget of the US health care programs, Medicare and Medicaid, is wasted as a result of corruption. Every dollar lost to monetary malfeasance has a crippling effect that ripples through countries, industries, companies, communities and individual lives. Government resources are wasted, public services are compromised, companies are financially destabilized, shareholders are cheated, employers are swindled, charities are undermined and much more. By increasing their awareness of what and how the IRS investigates and prosecutes, accountants can heighten their "spidey sense" of what doesn't look right in financial records. This includes honing skills to more readily notice -- and report -- ledger anomalies and irregularities, and even rethink a "silence is always safer" mindset. As technology disrupts and automates many fundamental accounting functions, practitioners can add value by more diligently scanning for "creative accounting" red flags on the frontlines. Prioritizing transparency and behaving ethically -- the core of the profession -- not only helps society and the economy as a whole, it can help accountants boost their reputation as highly trusted business advisors and even supercharge their bottom line. 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 Start a CFO Service (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
This Masterclass is a one-hour training to show accountants how they can grow their practice this year through CFO and business advisory services. 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
Revenue Recognition - Topic 606 Overview (1.5 hours)
-
Online
1.5 Credits
Member Price: $59
See more dates
This session is the beginning in a series on the new revenue recognition standard. The standard outlines five steps for proper compliance. At the surface, these steps seem simplistic. However, there are many considerations that should be considered within each step based on your process and industry. This course is designed to provide an overview of the technical guidance and outline the five steps involved in the revenue recognition model. We also explore some concepts to consider within each step and then evaluate some challenges that specific industry's may have when complying with the standard. Future courses will further delve into each step and provide example and scenarios that should be considered to properly apply the step.
More Dates
A Guide to Sampling - Part 1 (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
Sampling is often identified as a common audit deficiency in peer review. This course will review when is sampling applicable and basics of planning a sample. We'll then focus on the application of sampling in financial statement audits with a look at sampling for substantive procedures. We'll look at the use of monetary unit sampling and tools that can be leveraged to reduce bias in sampling.
More Dates
The Controllership Series - Managerial Accounting Basics and Costs (1.2 hours)
-
Online
1.2 Credits
Member Price: $39
See more dates
Managerial accounting provides economic and financial information for managers and other internal users. Managerial and Financial Accounting have similarities and differences. Each field of accounting deals with the economic events of a business. Both managerial and financial accounting require that a company’s economic events be quantified and communicated to interested parties. This another course in our series on the controller’s role. The controller’s role encompasses many traditional functions. Within this segment of our controllership series, we discuss the area of managerial accounting and the basic concepts that surround this discipline as it primarily relates to cost accounting issues.
More Dates
Build Better Budgets: Fundamental Techniques (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
This session provides insights for enhancing the preparation and utilization of budgets. Seasoned accountants will benefit from a refreshed awareness of popular techniques. Budding financial professionals will obtain novel insight regarding fundamental budgeting concepts. All participants will develop an appreciation for the holistic nature of budgeting as an integral tool for planning and control.
More Dates
Key Tax Issues Facing Business & Industry (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
This course focuses on the key federal tax issues affecting business from the internal accountant's point of view, with a focus on the major ramifications of the TCJA and other recent tax legislation and developments. Planning alternatives and the potential risks associated with those strategies will also be discussed. **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 kori.herrera@acpen.com.
More Dates
Partnership Essentials: Tax Basis Capital Accounts (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
This course examines the critical issues and special opportunities facing partnerships and their partners, with a focus on reporting tax basis capital accounts. **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 kori.herrera@acpen.com.