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.
Advanced Excel: Hidden Secrets and Gems (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level. 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
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
The Leadership Skills of Tomorrow: Delegate and Listen (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Mastering two leadership skills will decrease your stress, and give you room to enjoy your career. Delegating and listening are key essential skills to hone to elevate your career. You were born with two ears and one mouth. And yet, good listeners aren't born. World-class listeners deliberately practice this skill, even when their audience is challenging. This is a skill which can be learned. Participants will gain awareness into their blind spots to listening, strategies to regain focus, how to stop interrupting, and demonstrate to their audience they are listening. How often have you said, "It would just be easier if I did this myself?" or "Nobody can do this task as well as I can, so I'll just do it myself." If this sounds like you, then it's time to start working on your delegation skills. Delegation is not only important as a means to save you time, but it is also about developing the next generation of leaders. 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
Internal Controls for Small and Medium-Sized Entities (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
This session explores the importance of internal controls with an emphasis on best practices for small- and medium-sized entities. We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed.
More Dates
Current Cybersecurity Risk Management Trends (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
One of the top concerns of any organization's leadership is how to mitigate the risk of cybersecurity threats, along with the prevention and detection of fraud. This course will focus on the most common cybersecurity vulnerabilities and fraud trends, and best practices for managing them. 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 AI Fits into the Accounting World (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This session is designed as a primer to introduce artificial intelligence (AI) and to discuss how it will impact accountants as they work. The material will briefly explain what AI is and then focus on ways that it is already serving those in the accounting realm. It will close with a look at future AI-centric developments that will have great potential to positively impact the accounting profession. Those wishing to gain an understanding of what artificial intelligence is and how it will be used by accountants should consider attending this session. 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 Communicating Financial Results to Stakeholders: A Guide for Client Advisory Services (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
One of the most difficult things for any Client Advisory Services (CAS) professional to learn is how to communicate financial information to non-financial people. To be successful, it's crucial to master this skill, as we frequently explain accounting jargon to those unfamiliar with the field. In this course, we will explore how to properly communicate with stakeholders, including investors, clients, boards of directors, and even other departments. We will explore biases that people have when viewing financial information and even how to make sure we keep our message on point. If you are looking to move up in the financial services world, this course is a must for you.
More Dates
Surgent's Depreciation Rules for Bonus and Section 179 Expensing (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
The Tax Cuts and Jobs Act of 2017 has had a tremendous impact on commercial real estate, including liberalizing the depreciation provisions. The Coronavirus Aid, Relief, and Economic Security Act (CARES Act) included several provisions that allow taxpayers to revisit projects completed in earlier, more profitable years, and generate even more value. In this course, we will explore the impact of these important laws on commercial real estate owners and delve into what Accounting and Financial Professionals need to know. We'll also examine these opportunities to "turn back the clock," including the retroactive correction of QIP's recovery period and the option to revoke electing-out of the business interest limitation. Finally, we will review other strategies that are crucial parts of a comprehensive tax plan this year and will discuss a strategic hierarchy for employing those strategies most successfully. Relevant Rev. Procs. and multiple real-life case studies will be reviewed. 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
Managerial Accounting: Your Prescription for Better Decision Making (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
This session revisits useful, but potentially underutilized, managerial accounting techniques. You will appreciate a fresh look at concepts you may not have considered since your college days. We will illustrate practical ways you can immediately implement managerial accounting analysis in your professional endeavors.
More Dates
The One Big Beautiful Bill: 2025 tax legislation (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
The President signed on July 4, 2025, one of most consequential tax legislation in recent years. The well-informed tax practitioner will want to stay abreast of these developments! This course will start with a short background of this legislation as it made its way through Congress and to the President's desk. We will then review the final provisions that was approved by the Senate and passed by the House. 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: How to Give and Receive Criticism the Right Way (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
How well do you accept criticism? How might it enrich your business - and you - if you did a better job of it? This distinctive webinar will show you why it is in your best interest to accept criticism with gratitude. It's even better to welcome criticism. It's also a good idea to learn how to give criticism the right way. A related topic is the art of giving and receiving apologies, and we'll do a deep dive into this area as well. You'll leave with clear guidelines for how to criticize others, accept criticism from them, give meaningful apologies, and accept apologies with grace and ethical intelligence. The result will be a stronger CPA practice and a better you. 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 Coaching Skills for Managers and Supervisors (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $159
See more dates
This one-day course will teach effective skills for coaching and training employees. You'll learn how to identify the characteristics of effective coaches and develop coaching strategies to support and assist your team, with the goal of helping them improve morale, productivity and quality. And, you'll learn a five-step approach for giving constructive criticism while managing defensive reactions.
More Dates
Surgent's The Most Critical Challenges in Not-for-Profit Accounting Today (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
In recent years, not-for-profits have applied critical new standards related to contributions of nonfinancial assets, leases, and more. However, with all the focus on the new stuff, have we forgotten any of the old stuff? FASB ASC 958 has a great deal to say about various accounting and reporting issues in the form of its implementation guidance and illustrations. Not knowing this guidance can result in lost time and erroneous applications of GAAP. In this course, we will review some of the most critical illustrative not-for-profit guidance issued by the FASB.
More Dates
The SECURE Act 2.0 - Planning Opportunities for Employers (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
The Secure Act 2.0 was passed in a flurry of year-end legislation. This one hour program will cover the important changes that employers need to know about company retirement plans. 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. **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
Internal Control Frameworks for Single Audit (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
The Uniform Guidance identifies COSO and the Green Book as best practices for internal controls in governmental audits. This course provides a comprehensive review of the COSO framework, including its 2013 update, and explores its application to the Green Book. Attendees will learn to recall the five components and 17 principles of internal control, understand the benefits of adopting internal control frameworks, and recognize the rationale behind the COSO 2013 update and its impact on auditing practices. Additionally, the course will cover how to leverage Part 6 of the Compliance Supplement to effectively document internal controls.
More Dates
Forensic Accounting: When The Office Is A Crime Scene (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
Embezzlement happens often to many small businesses. Unfortunately, the lack of internal controls allow the embezzlement to remain undetected for years. But when it is discovered, the small business owner will most likely contact their CPA for advice. What should you do when your client contacts you about their employee embezzling money from their business? What options should you present to your client? How can your client protect themselves, while investigating the embezzlement? What steps need to be taken about preserving any documents, emails, texts, or phone calls? This course teaches how to engage the client, properly identify the evidence needed to prove the crime, how to write the report for civil and criminal trial, and best practices in preserving electronic and paper evidence. 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
2025 Annual Update for Governmental Accountants & Auditors (6 hours)
-
Online
6.0 Credits
Member Price: $189
See more dates
This comprehensive course provides the critical updates governmental accountants and auditors need to stay informed. We'll begin with a review of recent GASB standards, including compensated absences, asset disclosures, risk and uncertainty disclosures, and financial reporting model improvements. Participants will also gain insights into GASB's current projects, exposure drafts, and agenda progress to ensure they are up to date on what's ahead. For auditors, we'll cover key changes to governmental auditing standards, including the 2024 Yellow Book updates, the transition from quality control to quality management, and implementation timelines, with early adoption options. Single Audit updates will include the 2024 Uniform Guidance changes, the 2025 Compliance Supplement, GAO reports on improper payments and government fraud, the Financial Data Transparency Act (FDTA), and recent Department of Education guidance on related parties.
More Dates
Compilation, Preparation and Review Basics and Peer Reviews (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Cover the basic requirements for performing preparation, compilation, and review engagements under Statements on Standards for Accounting and Review Services (SSARS), including the new SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions. Review common issues found on SSARS engagements in connection with peer reviews and the impact of various findings on the results of a peer review. Identify key issues to consider during SSARS engagements, and determine how to incorporate quality control recommendations and tips for performing high-quality SSARS engagements. 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
Beyond the Basics: Financial Ratios You Might Be Overlooking (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
Overview: Understanding your company's financial health requires more than just traditional metrics. This webinar is designed to reveal deeper insights through advanced, underutilized financial ratios. In this session, accounting and finance professionals will explore metrics such as operating leverage, free cash flow yield, and margin of safety-tools that go beyond standard ratios to deliver nuanced perspectives on profitability, risk exposure, and operational efficiency. 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
Getting the Most When Selling a Business: Little Details to Get Top Value (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
Every business will be sold eventually. When you have built a great business and decide to move on – you want the most you can get for that terrific organization! What are the steps to take to maximize the value realized? What do buyers really want? What are the three levers to achieve maximum value? If you want top dollar, preparing to sell takes years of planning. This seminar helps CEOs, entrepreneurs, CFOs, Board members, controllers, and their advisors prepare for a successful sale of the organization to maximize shareholder value. We will outline the process to get the most bang for the buck. Proper exit planning demands planning and time.
More Dates
