CPE + Events Catalog

Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.

When putting together a financial plan, it is important to remember that the tax situation of the business and the individual are often intertwined. Therefore, decisions about entity type are vitally important. Practitioners need to understand not only how different entities are taxed, but also which taxes will have the greatest impact on the individual owner. In this course, we will explore when self-employment taxes apply to business income, as well as some of the lesser-known taxes that apply to flow-through entities. We will even explore when a PTE election could be helpful to a small business owner. 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.

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.

This comprehensive course provides the essential updates for professionals working with governments and not-for-profit organizations. We'll begin with an in-depth review of recent GASB standards, including compensated absences, certain asset disclosures, risk and uncertainty disclosures, and financial reporting model improvements. For each standard, we'll cover its background, potential impact, and practical strategies for implementation to ensure you're fully prepared. Next, we'll shift focus to the FASB and its implications for nonprofit organizations. While there haven't been recent nonprofit-specific standards, several Accounting Standard Updates (ASUs) significantly impact NFPs. We'll explore these ASUs, evaluate changes to programmatic investments, and discuss their interplay with the CECL standard. Additionally, we'll highlight the movement in IFR4NPO, a global initiative to develop universal financial reporting standards for nonprofits, offering insights into its potential worldwide impact. In the second half, we'll turn to governmental auditing. Key topics include the 2024 Yellow Book updates, the transition from quality control to quality management, and the implementation timelines. For Single Audits, we'll cover the 2024 Uniform Guidance changes, the 2025 Compliance Supplement, GAO reports on improper payments and fraud, the Financial Data Transparency Act (FDTA), and recent Department of Education guidance on related parties.  

With the increasing complexity and ever-changing nature of tax laws and issues, today’s accountant needs a one-day update course focusing on business income tax issues with an emphasis of newly enacted income tax legislation. This comprehensive class will not only review the current Federal business income tax laws but will also update tax return preparers of new tax forms, changes to existing tax forms, as well as tax planning opportunities and pitfalls. This is a “must-attend” course for all tax practitioners who want to be up to speed quickly and have a successful Federal business income tax filing season. **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

Looking to stay ahead in tax matters? Join our Individual Tax Update course for an essential deep dive into Form 1040 essentials. Designed for tax pros eager to sharpen their skills, this course unpacks recent tax code changes and equips you with the know-how to navigate them effortlessly. From mastering IRS Form 1040 to leveraging new tax benefits, you'll emerge ready to optimize returns for your clients while staying compliant with the latest regulations. Don't miss out on this opportunity to boost your expertise and ensure financial success for both you and your clients! **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.

The issue of civility, or lack thereof, has garnered much attention from leaders, Human Resource professionals and employees at large. The cost of incivility is high not only to the bottom line but to the human spirit. This webinar, based on ethical principles and values, is designed to look at the fundamental relationship skills that foster workplace civility. Understanding that workplace civility is far more than manners, we will dive into behaviors that help promote a workplace where each individual feels respected and valued. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

We all know that Fraud Happens. But, why? Why do people we think we can trust let us down? This session will explore the minds of white-collar criminals and examine some recent high-profile fraud cases. Why did they do it? How did they do it? What were the warning signs? If you think that fraud cannot happen to your organization, this session might give you pause.

This course will serve as an introduction to conducting effective walkthroughs to gain an understanding of the client's transaction processes as well as identifying internal controls within each process. This course will review the procedures, questions to ask, and documentation requirements of walkthroughs. It will also include real-world examples of the red flags that may arise while executing a walkthrough. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

With the TCJA expiring in 2026, there is a lot of buzz and rules of thumb about Roth strategies, but very little discussion on what the fiduciary-level analysis methodology should be. This course will provide insights on creating and evaluating an analysis and recommendations with targeted vetting questions. Rules of thumb can sometimes be detrimental, causing families to pay much more in taxes over their lifetimes than necessary. A very significant portion of the population is prevented from executing a straight-forward Roth Contribution due to the income restrictions. What was once a risky way to thwart that rule has now become accepted, and many clients can benefit. These contributions should typically take precedence to saving to a brokerage/taxable account, but there are some steps that need to be addressed to prevent unwanted taxation. In addition, you'll learn about the mega-backdoor Roth. SECURE 2.0 includes many new rules, and some of them address Roth IRA/401k. We'll cover these and how they can help your clients.

Enterprise Risk Management for SMEs

This program provides an update to the latest tax developments, rules and regulations impacting business taxpayers, with a review and integration of the numerous 2021/22 legislation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This CPE course explains Yellow Book independence including the general requirements, requirements for auditors providing non-audit services and documentation requirements. This course also explains the basic elements of a Uniform Guidance compliance audit, including an overview of requirements, major program determination with examples, an understanding of compliance requirements and related internal control over compliance, sampling, and single audit reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Join the Team from Hodgen Law for a monthly LIVE International tax-based presentation. Be sure to register for them all. April 2025 - Form 8858: When to File, What to Report May 2025 - Form 5472: When to File, What To Report June 2025 - Life After Expiration: Common Tax Issues July 2025 - Form 5471: The Section 962 Election August 2025 - Form 5471: Previously-Taxed Earnings & Profits (Schedules J, P) September 2025 - Form 3520: When to File, What to Report October 2025 - Form 3520-A: When to File, What to Report November 2025 - Pre-Expatriation Tax Planning to Minimize Exit Tax January 2026 - Pre-Residency Tax Planning February 2026 - Foreign Retirement Plans: Employees' Trusts, Grantor Trusts, or What? March 2026 - Portfolio Interest Loans for Real Estate Investments

Strong analytical procedures are critical for evaluating the fair presentation of financial statements. In addition, Financial statements are only as good as the information and trends that they produce for operational, strategic, or compliance purposes. This course will provide insights into how to determine the strength and efficiency of nonprofits in achieving objectives and knowledge to improve the analysis of the fair presentation of a nonprofit's financial statements.  

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.

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.

Each course in the Fraud Stories Series will examine a fraud case in detail. What factors lead the company to go astray? What could have prevented the fraud? What lesson can be learned? Be sure to register for each course in this series. A new case presented Live at every session! Fraud Stories Series September 2025 Fraud Stories Series November 2025 Fraud Stories Series January 2026 Fraud Stories Series March 2026

The well-informed tax practitioner will want to attend this two hour program in order to stay current on recent updates on partnership tax! Content includes recent court decisions on partnership tax issues as well as current IRS procedural updates for passthroughs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.