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.
Business Intelligence (BI) and Business Analytics (BA) (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $79
See more dates
Volatility and complexity are the new normal. Most organizations are drowning in data, but starving for information. The finance and accounting function has the opportunity to leverage Big Data and the continuum of analytics – descriptive, diagnostic, predictive, and prescriptive. All are useful for better decision making. Collecting, validating, and reporting data is not the same thing as analyzing information where we can glean valuable, actionable insights. In some ways the finance function is many years behind other disciplines such as marketing, sales, and supply chain managers, in applying analytics. How can the CFO’s function catch up?
More Dates
Behind the Curtain: Exploring IRS Audit Technique Guides (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Have you ever considered a tax audit from the perspective of an IRS examiner? This session explains how you can use IRS Audit Technique Guides (ATGs) to enhance tax compliance. You will obtain a glimpse of the audit process from the viewpoint of an IRS agent as we explore insights that the IRS provides to its own examiners. 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 IT Systems and Data Management (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
Explore the critical intersections between information technology (IT) systems and data management through this specialized CPE course for accounting professionals. This session covers business resiliency and disaster recovery strategies, change management processes, and much more. Through interactive discussions and hands-on activities, participants will learn how to enhance their organization's IT framework while ensuring robust data collection and storage. Equip yourself to oversee IT systems with confidence and reinforce data integrity and system availability.
More Dates
Preparing and Reviewing Workpapers for Higher Quality Audits (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
This course will focus on preparing financial statement audit documentation critical for high quality audits that can pass peer review.
More Dates
Business Consulting for CPAs (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
Does your firm have interest in expanding its’ services beyond traditional CPA services? Do you have staff with the expertise to compete against non-CPA firms? Welcome to a course that will lead you through the maze of creating a successful Consulting Business Practice for your CPA firm. The course will help you understand: where consulting business opportunities exist, what are the firm’s professional responsibilities and most importantly how to recognize the needs of the client.
More Dates
LLC's & S Corps -- A Comparative Analysis (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
This course provides an in-depth comparative analysis of Limited Liability Companies (LLCs) and S Corporations, focusing on their tax implications, compliance requirements, and operational structures. Participants will explore key aspects of entity formation, tax treatment, and compliance with corporate formalities. Topics include electing Subchapter S status, mechanics of Form 2553, and relief options for late filings under Rev. Proc. 2022-19. The course also highlights entity-specific tax forms, accountable plans, taxable fringe benefits, officer reasonable compensation, estate planning, business continuation planning, and audit strategies. Additionally, participants will review Schedules K-1, K-2, K-3, and effectively connected income for both entity types. *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
SECURE Act 2.0 and Updates (2025) (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
After a false start in 2022 when it failed to pass through Congress, the Secure Act 2.0 was passed in a flurry of year-end legislation. This two hour program will cover the important changes in savings and distributions of retirement plans that impact individuals. Employers will also need to consider how Secure Act 2.0 will the administration of existing plans or the creation of new ones. This course will provide a concise look at these hot topics. 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
Digging Deep with Excel Pivot Tables (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
This session focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables.
More Dates
Individual Tax Update: Recent Developments (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
This course addresses the most recent legislative developments impacting individual taxpayers, with a focus on important provisions, rules and concepts to apply when preparing client returns. *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
Ethics without Fear for Accounting and Finance Professionals (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $125
See more dates
Finance and accounting professionals are on a pedestal and are often held to a higher standard. Keeping your ethical skills sharpened is crucial to reducing your fear and raising your courage as you solve tough decisions in real-time. This fast-paced and interactive presentation will help you practice exactly that. What will you gain? The ability to choose the most effective path in daily situations, so that when a significant crisis hits you are comfortable in your actions. Be ready, be courageous, be fair, and be consistent.
More Dates
Excel for Accounting Professionals Session 1: Tables and Named References (2 hours)
-
Online
2.0 Credits
Member Price: $125
See more dates
Transforming how you use Excel with engaging and expert-led instruction Designed for you to work alongside an expert and complete the same exercises, you'll dig deeper into topics, including: Benefits of using named references for faster navigation Increased versatility and efficiency withing your Excel workbooks Excel Tables special properties and Error reduction for greater productivity. Mastering Excel functions Excel mastery involves understanding how to create functional and efficient workbooks. The instructor will guide you through Tables, named references, and more as you build on basic Excel skills and use critical functions, such as: Excel conventions Critical shortcuts Efficient navigation techniques Automatic formula updating *Session 1 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 2: Data Validation and Conditional Formatting] (https:// https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-2--data-validation-and-conditional-formatting) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Supporting Mental Wellness to Thrive in Work and Life (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
In today's fast-paced world, maintaining a healthy work-life balance is essential for mental wellness. This course is designed to provide practical tools and strategies to help you create a balanced, fulfilling life. You'll learn actionable techniques for improving sleep hygiene, incorporating proper nutrition, fostering open communication, and managing stress. Whether you're struggling with burnout, seeking better work-life harmony, or simply looking to improve your overall well-being, this course offers valuable insights and tools to help you thrive. Designed to fit into your busy schedule, it delivers the guidance you need to make practical, sustainable changes in your life, starting today. 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 Applying ASC 820: The Basics of Fair Value Accounting (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
While once thought just to apply to banking and financial institutions, entities now need to apply fair value accounting under ASC 820 across a variety of transactions. Whether you are assessing financial instruments, leases, business combination accounting, or impairment measurement, GAAP either requires or allows the use of fair value measures in an expanding number of circumstances. Now is the time for you to get up-to-speed on the basics of the fair value approach. In this course, we will review when fair value accounting is required and when an entity can select to use it. Then we will review the basics of the ASC 820 model, including the concept of "exit price," the various approaches that an entity may follow when using a fair value approach, and the different levels of inputs that an entity may consider when determining fair value. Lastly, the course will provide examples of when and how to apply this complex accounting guidance.
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
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
Surgent's Basics of Employment Law for Non-HR Professionals (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
Learn the basics of employment law and how they affect best practices to help control the interview and discover hidden talents of applicants.
More Dates
Tax Procedure (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
This seminar will introduce the process from filing a tax return to the IRS audit, IRS Appeals, Collections and litigation at courts of original jurisdiction. We will discuss the options taxpayers have at any point in the process with reference to real-life stories from the trenches. **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
Surgent's Hiring New Workers and Payroll Taxes (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
When a new employee is hired, there are a lot of things the employer needs to take care of. Aside from getting employment contracts signed, training lined up, and the new hire breakfast planned, employers are tasked with making sure all of the payroll forms are filled out. For many small business owners, this can be a source of anxiety. They often wonder if they have everything they need. They also hear horror stories about potential IRS penalties for not having all of the boxes checked. In this course, we will explore the payroll compliance side of hiring new employees. From the alphabet soup of forms that need to be filled out to the initial payroll tax forms, we have you covered if you are a new practitioner or new business owner. We will even discuss the surprisingly difficult-to-navigate world of unemployment insurance. 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
Surgent's Successfully Completing a Gift Tax Return -- Form 709 (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
Since the early 2000s, the estate tax burden on taxpayers has gradually decreased along with the number of practitioners specializing in the field. Nevertheless, some of your most wealthy clients will have a taxable estate. For these select clients, making large gifts before death can be extremely tax efficient for the client and profitable for the practitioner filing the gift tax return. Learning how to file a basic gift tax return can help you attract and retain clients, increase your value-add, and generate revenue. 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
ChatGPT Bootcamp for CPAs with John Higgins (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
ChatGPT is the fastest growing application in the history of technology with over 100 million users adopting it in within two months. It is a revolutionary technology that boosts the quality and efficiency of business processes in every industry. As "knowledge workers", CPAs and CFOs are positioned to be prime beneficiaries of this technology. This half day hands-on course will get you well on your way to becoming a ChatGPT expert. John Higgins, a nationally recognized advisor and educator on CPA technology, will guide you through the process of accessing ChatGPT and applying it to a variety of practical accounting, finance and tax scenarios. This course will catapult you to the top of the pyramid of CPAs who are knowledgeable in ChatGPT and you will be ready to put it to use in your day-to-day tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.