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.
Clean, Transform & Load Data in Power BI (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. 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 Microsoft 365 Copilot for CPAs (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Discover how Microsoft 365 Copilot can revolutionize your daily tasks as a CPA. Dive into the specific features and functionalities of this AI-powered assistant. Learn how to leverage Copilot to enhance productivity, automate routine tasks, and improve collaboration within your team. 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 Integrated Planning, Forecasting, and Budgeting for Organizational Success (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
Planning may be one of the most important assignments of the finance professional; however, it is often accomplished in a way that can harm the organization. In many cases, huge sums are spent only to have a planning document developed that does not serve to bring the company together, but rather causes internal division. In some situations the budget can actually harm both productivity and alignment. This course is designed to bring planning, budgeting, and forecasting together into one fully aligned process that is easier, more efficient, and fully engages all parts of the organization. Rather than the plan being owned by the finance department, it is owned and followed by everyone from the CEO to the entry-level employee.
More Dates
Surgent's Update on Recent AICPA Standard Setting: Staying Current in a Changing Environment (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
Professional standards are changing with the times and the desire of the AICPA to move the profession into a new era where use of technology will play a key role in an audit and professional skepticism, independence, and quality are emphasized. We are seeing changes already as the AICPA has issued 15 new standards since 2019. This program will discuss SASs 134 through 149.
More Dates
Yellow Book Ethics (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
The Yellow Book outlines essential ethical principles for governmental auditors, including serving the public interest, maintaining integrity, objectivity, and professional behavior. This course provides a focused review of these key concepts and their practical application in governmental auditing. Participants will also explore the independence standards, gaining insights on maintaining objectivity and avoiding conflicts of interest to ensure unbiased and professional audits.
More Dates
Mastering Partnership Basis: Inside and Outside Basis (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course will provide a detailed analysis of how to determine a partner's tax basis for a partnership interest, with an explanation of the use of both "inside" and "outside" basis determination. An illustrated example with filled in forms will demonstrate how the process works and the potential pitfalls. 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
More Money: Strategic Ways to Improve Cash Flow (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Cash flow management is often the most important task of any CFO or financial leader. Regardless of whether one works in start-ups or established companies, non-profit or for-profit entities, cash flow makes our organizations run. Have you ever wondered whether you are optimizing your company's cash flow? In this course, we will explore how to improve your company's cash flow using analysis and financial theories in the context of real-world situations. 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 and Technology for CPAs (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Explore the ethical principles included in the Code of Professional Conduct that address the emerging practice issues created by new technologies. Consider how technologies may impact audit quality and the integrity of the financial systems, and whether they create a need for CPAs to adjust their skill sets to address those challenges. Look at the potential ethical challenges created by the data related to privacy, security, and its application. Discuss the changes being proposed to address emerging ethics challenges. 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
Generative AI Strategy for Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course empowers accountants with the knowledge and skills needed to strategically implement generative AI within their firms, positioning them at the forefront of innovation and operational efficiency. As generative AI platforms like ChatGPT, Claude, and Gemini transform business practices, accountants will learn to harness these tools to drive value, streamline processes, and enhance decision-making. Through examination of the current AI landscape, practical frameworks, and real-world applications, participants will learn how to leverage AI technologies to enhance accounting operations while maintaining professional standards and ethical considerations. The course emphasizes a balanced approach to AI adoption that focuses on augmenting human capabilities rather than replacement. 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
Financial & Tax Accounting for Partnerships & LLCs (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
This program compares and contrasts the financial accounting for partnerships and LLCs, as well as discusses the tax accounting for these entities, with a thorough discussion of the important differences between financial accounting for partnership capital accounts and the tax accounting for partnership capital accounts. Financial accounting for operations of a partnership will also be addressed. This course does not qualify for IRS credit.
More Dates
Ethics of AI: A CPA's Guide (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
The practical application of artificial intelligence (AI) in the accounting profession is spreading like wildfire with the release of powerful applications such as ChatGPT. A byproduct of this evolution is the origination of new ethical dilemmas for CPAs on how to address the use of this technology in the delivery of their services. This course, presented by John Higgins, CPA, a nationally recognized technology advisor to the profession, will provide CPAs with a practical framework for addressing the various ethical issues that can arise with the application of AI in their work. 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
Introduction to Not-for-Profit Accounting (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
Not-for-profit organizations encounter distinct accounting complexities. This course provides an introduction to the financial statements and specialized accounting principles relevant to nonprofits. Attendees will explore key topics such as net assets, agency transactions, contributions, and endowments, focusing on the unique transactions and account balances that define not-for-profit accounting.
More Dates
The Ethic of Teamwork (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
"No one cares how much you know until they know how much you care." To be a part of a team, a team that truly cares for its people, is to be granted an opportunity for growth and inclusion and a sense of belonging. It doesn't get better than that! This ethics-based webinar examines the essence of what constitutes teams that are high functioning and highly collaborative. One essential component is the balance between content (getting the job done!) and process (how we get things done...how we treat each other). This webinar will offer concrete practical suggestions for teams both for content and process effectiveness. It will also offer opportunities for self-reflection and actions to take to enhance team performance. 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 Art of Marketing for CPAs (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $129
See more dates
To make more money in less time, all accountants need to learn to market themselves effectively to their clients or their firm. For better or worse, promotions and more money go to those who are the best marketers, rather than the most competent accountants. In this fascinating and fun workshop, participants will learn seven key ways to get more clients and/or promotions through the art of marketing.
More Dates
Tactics to Find Work Life Balance in a Complex World (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
This session will explore key aspects of getting more satisfaction out of the work you choose to do and how to find greater balance between the demands of work and other lifestyle choices in an ever more complex and changing world. 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
Data Analytics: Practical Insights for Today's Accountant (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
This session explores tools and techniques that can enhance the efficiency and effectiveness of client engagements and business processes using data analysis tools. We will introduce some of today's popular and software tools and examine the AICPA's Five-step approach to incorporating data analytics into public accounting engagements.
More Dates
Financial & Tax Accounting for S Corporations (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
This program addresses the many complex financial and tax accounting issues that are common in S corporation transactions, with discussion of common pitfalls and the AICPA "small" GAAP accounting standards. This course does not qualify for IRS credit.
More Dates
A Guide to Sampling - Part 2 (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
Building on Part 1, this course will review the application of sampling in financial statement audits with a focus on sampling for tests of controls. We'll also review the requirements for sampling in Single Audits with a focus on tests of controls and tests of compliance.
More Dates
Nonprofit Internal Control - Practical Insights into Mitigating Financial Reporting, Compliance and Other Risks (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
There is simply no denying that a sufficiently designed and effectively operating system of internal controls over reliable financial reporting is more important than ever. The primary objective of this course is to give participants "hands-on" practice in designing, evaluating, and communicating conclusions related to design and operating effectiveness of internal controls over reliable financial reporting and other risks for nonprofit environments.
More Dates
Private Company Simplified GAAP Alternatives (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
The FASB formed the Private Company Council to provide certain alternatives in U.S. GAAP that are only available to nonpublic business entities, with limited exceptions for certain nonprofits. This course will provide insight into when adopting the accounting and financial reporting alternatives would be to the advantage of private companies.
More Dates
