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.
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 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
You Don't Know What You Don't Know About Microsoft Excel [NT]
-
Online
8.0 Credits
Member Price: $239
See more dates
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. 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
About the TIGTA: Who Watches the IRS? (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course will provide an overview of the work and impact of the Treasury Inspector General for Tax Administration (TIGTA) on the US tax system, regulatory ethics, and accounting profession. TIGTA is an independent organization that provides oversight of the Internal Revenue Service (IRS) and conducts audits, investigations, and inspections and evaluations to promote integrity, economy, and efficiency in the administration of the nation's tax system. The course will explore the role of TIGTA in improving the efficiency and effectiveness of the IRS, identifying opportunities to improve the administration of tax laws, and upholding ethical standards in 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
Adobe Acrobat Tips for Working with PDF Files (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
If you find yourself working with PDF files consistently throughout the day, this course will teach you how to review, annotate, format and organize PDF files more effectively and in less time. You will also learn how to use Adobe Acrobat for e-signatures to reduce document processing time significantly and enhance confidentiality. Adobe Acrobat has many features that you can take advantage of and this course will explain and demonstrate how to use 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
Mergers and Acquisitions: Complete Guide to Relevant Issues (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
Arthur Werner will provide financial professionals with the information their teams will need to successfully plan and execute mergers and acquisitions. For major topics covered, see below. This course may be customized or tailored based on the needs of your organization. *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 Section 754 Step-Up in Basis: Understanding the Tax Issues for Partnerships and LLCs (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
When a purchaser buys an existing partner's partnership interest or the interest of a member of a limited liability corporation (LLC) taxed as a partnership, the amount paid becomes the basis for the purchaser's partnership interest (outside basis). If the partnership's assets have appreciated sufficiently, the difference between the new partner's inside and outside basis can be substantial. This disparity can deprive the new partner of depreciation deductions and inflate his or her share of the gain from subsequent property dispositions unless a Section 754 election is in effect. The Section 754 election can also apply when a partnership makes a distribution of property and the basis of the distributed property to the partnership and the basis the partner/distributee will take in the distributed property are not equal. In this case, a partnership can recover basis it would otherwise lose if the 754 election were not in effect. 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 Strategies for Maximizing Social Security Benefits (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
As the population of the United States ages, tax practitioners will be asked to advise their individual clients with respect to when they should begin to take Social Security benefits. This program will provide you with the background to knowledgeably discuss the benefit options available to Social Security beneficiaries and the alternative payment options available to married couples, dependents, a surviving spouse, and a divorced individual.
More Dates
Advanced Cybersecurity - Beyond the Basics (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
A deeper dive into Cybersecurity topics specific to CPAs and Fintech Organizations, expanding on the fundamentals from Cybersecurity 101 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 Governments and Not-for-Profits (7 hours)
-
Online
7.0 Credits
Member Price: $209
See more dates
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.
More Dates
Federal Tax Update - C & S Corporations, Partnerships & LLCs (Forms 1120, 1120S & 1065)
-
Online
8.0 Credits
Member Price: $300
See more dates
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
More Dates
2025 Individual Federal Tax Update - Navigating the Current Tax Landscape
-
Online
8.0 Credits
Member Price: $225
See more dates
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.
More Dates
PPP Fraud and Financial Professionals (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Casey Crowther did not have a college education, but he had an outstanding work ethic. With little more than a pickup truck and some hand tools, he built a roofing company that grew. Over time, Casey's company employed more than 100 people and generated more than $20 million in annual revenues. With a company of that size, Casey relied upon advice from his bookkeeper when filling out financial documents. As a result of representations he made on bank statements and loan documents, authorities charged Casey with criminal behavior related to PPP loan fraud. What should an accounting professional learn from Casey's story? Stay tuned to find out! 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
Mastering IRS Form 7217: Partnership Property Distributions (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
The IRS recently released the new Form 7217 for 2024, designed for a partner to report distributions of property received from a partnership. This course dives into the complexity of the partnership distribution rules and their application to the new form, as well as discuss liquidating a partner's interest, Section 751 and the Section 754 election. 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 EBP Update: Standards, Compliance, and Best Practices (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
Stay ahead in the evolving landscape of employee benefit plan (EBP) audits with this essential 2025 update. This course covers key regulatory changes, including the SECURE 2.0 Act, newly effective accounting and auditing standards (SAS 145 and Quality Management Standards), and insights from the Department of Labor's latest findings on audit quality. We'll also dive into emerging hot topics shaping the EBP audit environment, equipping you with the knowledge to enhance compliance, mitigate risks, and deliver exceptional audit quality. Whether you're a seasoned professional or new to EBP audits, this session will provide actionable insights to keep you confident and prepared.
More Dates
CFO Series: Beyond Likes & Shares: Social Media at Work (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
In our social media world of scrolling, liking, sharing, and sometimes reporting, there is a dilemma that hits hard in the workplace. Should we use social media? How can we use social media responsibly? Can we separate our personal self from our professional self? We will discuss the numerous errors made when dealing with social media and the negative fallout. Social media often drives cultural trends and conversations. Even if someone isn't directly participating in these conversations online, they may still be exposed to them through mainstream media, conversations with others, or public events. We will review what is and is not acceptable for a professional to do. Your people ARE using social media, but are they using it to inadvertently damage the organization and the brand? Be prepared with a plan before another social media fiasco happens.
Master the Art of CPA Communication: Boost Your Influence! (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Discover the communication edge that will take your CPA career to the next level. This comprehensive course empowers CPAs with the tools to enhance clarity, build trust, and drive decisions. Learn to transform complex jargon into actionable insights and develop powerful persuasion techniques that resonate with clients and stakeholders. Join me to sharpen your communication skills and elevate your professional impact. 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
Advanced Cybersecurity - Beyond the Basics (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
A deeper dive into Cybersecurity topics specific to CPAs and Fintech Organizations, expanding on the fundamentals from Cybersecurity 101 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
International Tax Lunch Series February 2026 (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
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
More Dates
