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.
Taking Advantage of Array Formulas in Excel (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. 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
SEC Case Studies: Ethical Dilemmas in Finance and Accounting (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Overview: Ethical challenges in finance and accounting can be complex and far-reaching, impacting not only individual careers but also entire organizations and the public trust. This webinar will provide a practical exploration of the ethical considerations professionals face in today's financial landscape. Through real-world case studies, participants will examine common ethical issues, learn to navigate conflicts between financial performance and ethical integrity, and gain tools for making sound decisions under pressure. 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
Learning to Teach "Tax" as a Second Language (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
Sometimes the vernacular of accounting seems more challenging than technical aspects. This session offers suggestions for translating the foreign language of taxation into tangible terms for non-accountants. We explore techniques for simplifying the complexity of taxation terminology. This course will equip you with tools for demystifying tax technicalities so you can help clients and other non-tax professionals grasp fundamental concepts. 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
Partnership Property Distributions and the New Form 7217 (1 hour)
-
Online
1.0 Credits
Member Price: $29
See more dates
This program will address the complex rules for partnership distribution of property with a focus on liquidating of a partner's interest, Section 751 and how to complete the new Form 7217.
More Dates
The Controller Function - Elevating the Role (1.5 hours)
-
Online
1.5 Credits
Member Price: $59
See more dates
This is the beginning of a series that will cover major aspects of the Controllership function. Controllers are essential to the day-to-day accounting for organizations. Yet, the role is not often readily understood. In today’s world of acronyms such as CFO, CEO, COO, CAO, etc., the Controller function may get lost in the shuffle. However, they are a critical group of professionals who ensure the adequacy and transparency of accounting and financial reporting information. A Controller is an individual who has responsibility for all accounting-related activities including high-level accounting, managerial counting, and finance activities within a company. The duties of a Controller include assisting with the preparation of the operating budgets, overseeing financial reporting, and performing essential duties relating to payroll. However, in today’s evolving world, the Controller function can provide much more in-depth value to their organizations. This series is dedicated to exploring the traditional Controller role and stepping out of the box to identify areas where the Controller can add strategic value to their organizations. In this first course we focus on the typical Controller function and begin to identify ways to elevate the function.
More Dates
Accounting & Auditing for Cryptocurrency (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
Bitcoin and crypto have been in the news recently for a variety of reasons. This course will cover the basics of accounting and auditing for cryptocurrency, including recent standard setting by the FASB as well as a look at the AICPA's Accounting for and Auditing of Digital Assets practice aid.
More Dates
Yellow Book Ethics (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Government Auditing Standards (or Yellow Book) has a unique perspective on ethics and transparency due to accountability owed to taxpayers, oversight bodies, and others. This course will discuss the foundational principles in the Yellow Book relevant to professional conduct on related 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
Surgent's Business Law for Small Business Owners (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
One of the most intimidating aspects of going into business for yourself is compliance. Tax, employment, and regulatory laws are difficult to navigate, so it often falls on the CPA to know the basics in these areas to help their clients avoid costly litigation. In this course, we will cover basic compliance areas for small business owners. We will look at the main elements of a contract, taxation of entity types, worker classification, property law, and many of the other areas that are often overwhelming for small business owners. By being able to speak to these issues, practitioners will be able to add value and help their small business owner clients grow and thrive.
More Dates
Surgent's Ethical Considerations for the CPA (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
CPAs today face greater challenges than ever to maintain the high ethical standards of their profession. It is vitally important that all CPAs understand their professional responsibilities related to all aspects of their job. This course, which focuses on key components of the AICPA Code of Professional Conduct, reviews a history of the CPA profession and focuses on ethical requirements that CPAs must adhere to in their everyday practice, including practical examples of potential ethical dilemmas that practitioners may encounter, particularly those related to objectivity and independence. PLEASE NOTE: THIS COURSE COVERS GENERAL ETHICS AND IS APPLICABLE IN STATES IN WHICH STATE-SPECIFIC ETHICS IS NOT REQUIRED. This course does not qualify for IRS credit.
More Dates
Coping With the Growth of Online Fraud (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
Just about every company, no matter its size or the types of activities it undertakes, is at greater risk because of all the types of fraud that can be be carried out electronically. Potential perpetrators can be operating internally or externally and the scope of the damage that occurs is almost never limited to cyber-assets. While threat awareness is improving, there are still too many owners or top level executives that underestimate the scale of the issue. In this session, we delve into the types and the nature of many electronic defalcation schemes. The material then explores measures that organizations can implement to help stop these activities and add additional layers of security. 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 Audits of 401(k) Plans: New Developments and Critical Issues
-
Online
8.0 Credits
Member Price: $299
See more dates
One of the most favored employee benefit plans, the 401(k) plan, provides unique challenges for auditors. Through this course, auditors will obtain an understanding of the rules and regulations unique to employee benefit plans and obtain practical guidance on applying them. Auditors will enhance their knowledge of the performance and reporting requirements through real-world examples, best practices, and efficient audit techniques that can be utilized in various audit engagements. Make sure your audits don't trigger a DOL inspection by conforming to all applicable rules and regulations.
More Dates
Walter Haig's Personal Financial Health Checkup
-
Online
8.0 Credits
Member Price: $239
See more dates
This course has significantly changed for the better the lives of a significant number of practitioners and their clients. Participants will learn a step-by-step process for performing an annual personal financial health checkup for themselves, family members, employers, and, if in the practice of accounting, their clients. This course is loaded with practical aids to enable CPAs to help individuals get a "great" financial health checkup result! This course will enable practitioners to add a huge value to their tax preparation 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
Installment sales: Maximize Tax Benefits and Stay Compliant (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
This course explores the complex rules of installment sales, with a focus on their tax treatment and strategies to maximize the benefits. 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
Accountants and Malpractice: Can We Get Sued for This? (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This seminar reviews situations in which a CPA or accounting professional may be in danger of being sued. We cover common law causes of action, such as negligence, and the relevant standards and case law defining what constitutes reasonable practitioner behavior. This course is ideal for lawyers, CPAs, EAs, tax preparers, accountants and insurance personnel. 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
Fundamentals of Form 1040 -- Individual (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This course introduces professionals to the fundamentals of individual tax preparation. Participants will learn the essentials of Form 1040, including filing requirements, income reporting, and deductions. The session will also cover preparer responsibilities, due diligence, and taxpayer rights under Circular 230. By the end, attendees will have a solid understanding of the foundation of personal tax returns. 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 S Corporations & Partnerships
-
Online
8.0 Credits
Member Price: $239
See more dates
This program compares and contrasts the financial and tax accounting differences of partnerships, LLCs, and S corporations, as well as discuss the tax accounting for these entities. 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 AI Advantage: Leveraging AI for Efficiency and Impact (1.5 hours)
-
Online
1.5 Credits
Member Price: $99
See more dates
Artificial Intelligence is no longer a future concept-it's transforming the accounting and finance profession today. In this fast-paced session, discover how AI-driven tools and strategies are revolutionizing workflows, improving decision-making, and driving business impact.
More Dates
Surgent's Controllership Skills Update: Risk Management (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
The most recent recession and its fallout, weather (look at 2017), process and product failures, and unethical behavior have again highlighted failures by numerous organizations in identifying and managing risk. The size and reputation of organizations proved not to be the key to success. Again, we saw that failures can result in areas/industries thought to be "under control" through their policies, practices and/or regulations. A core activity of financial management is to effectively protect the assets of their organizations, without significantly reducing new ideas and growth. This brief program provides insights and approaches to identify risk and manage the above noted trade-off. The course is designed for financial managers looking to quickly build upon their existing knowledge and experience, as well as to help to start the less experienced individual. It offers ideas that can be used immediately, as well as longer term approaches. Updated to include new information particularly in the areas of disaster planning, business continuity, and ethics, as well as a sample group exercise to test your current risk management systems.
More Dates
Using e-Signature Software to Process Agreements-Updated (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Transforming your practice or business to a digital model is a journey, not a destination. There are some digital initiatives that require a great deal of time and money to deploy. There are also many "low hanging fruit" initiatives that are relatively easy and inexpensive to deploy. E-signature software is a perfect example of the latter. John Higgins, a nationally recognized leader in accounting technology, will guide you through the process of evaluating, selecting and implementing e-signature software to streamline a solution, and secure your document signing processes. You will be surprised to discover how easy it is to take your engagement letter and contract signing workflow digital. 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
Taxation of Business Entities (2.5 hours)
-
Online
2.5 Credits
Member Price: $79
See more dates
This course will introduce you the different types of business entities and the tax implications of contributions, distributions and earnings, among other 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
