CPE + Events Catalog
Download the 2025-26 OSCPA-Select Calendars - .pdf
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.
More Dates
Finding Errors in Excel Spreadsheets (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. 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
Monthly Federal Tax Updates - April 2026 (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. 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
Accounting and Tax Ethics: Standards, Issues, & Case Studies 25-26 (4 hours)
-
Online
4.0 Credits
Member Price: $175
See more dates
In recent history, even the most prestigious CPA firms have had ethical lapses and oversights that have cost them both financially and, at that moment, clouded their brand. This course will review the AICPA code of ethics for both accounting and tax practitioners and encourage you to examine your firm?s policies and choices relative to those standards and common sense through thought-provoking and sometimes humorous Q&A and case studies. This course fulfills the four-hour ethics education requirement.
More Dates
Fraud, Controls & Ethics: Best Practices & Case Studies (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This course explores actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters from achieving their nefarious acts. Then we will switch gears to an interactive, case-based discussion that asks participants to reach their own conclusions by analyzing facts in concert with the AICPA Code of Professional Conduct and other sources of ethical guidance. This course ultimately provides practical, action-oriented insight that can be implemented by accounting professionals in both public practice and industry. This event may be a rebroadcast of a live event and the instructor will be available for questions during the event.
More Dates
OCBOA Case Studies 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
Understanding the advantages and disadvantages of alternatives to Generally Accepted Accounting Principles (GAAP) financial statement presentations is vital to making proper client choices. For example, practitioners may seek to use the Other Comprehensive Basis of Accounting (OCBOA) financial statement presentations, as GAAP will increase complexity and the cost of compliance. Here, we'll explore compliance with the preparation, presentation, disclosure and reporting nuances of cash- and tax-basis financial statements. We'll also discuss the AICPA's Financial Reporting Framework for Small- and Medium-Sized Entities (FRF for SMEs). This course meets the specific OCBOA requirements that CPAs must meet for the re-issuance of their license.
More Dates
The Ethics of Care in the Workplace (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Ethics involve relationship to self, others, and the world in which we live. In the busyness of our world we often act out of habit without realizing that what we do truly matters. We matter! This session explores ethical values and principles as they apply to creating an Ethic of Care in the workplace with specific emphasis on compassion, accountability and respect. 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
Integrate ChatGPT into Your Client Advisory Services-Updated (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Two of the hottest topics in the CPA profession today are CAS (client advisory services) and ChatGPT. This course will explain how to bring these two worlds together by integrating ChatGPT and other generative AI applications into your client advisory services. John Higgins, a leading advisor to the profession on ChatGPT and a seasoned client advisor on technology based solutions, will show you how you can position your firm and yourself as a "go to" advisor on how to embrace this technology in virtually any type of business. John will address how to use this technology as a research and writing assistant in your client services and how to advise your clients on this revolutionary technology and all benefits and "gotchas" that come with it. If you want to step up your advisory game, this course is a "must take." 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
COSO's Internal Control Framework Essentials (3.5 hours)
-
Online
3.5 Credits
Member Price: $175
See more dates
COSO framework overview Gain an overview of COSO's internal control framework comprising five components and their related principles. Learn how to evaluate the control environment, risk assessment, control activities, information and communication, and monitoring activities at your or your client's entity. Through real-life examples, enhance your understanding of how to apply the framework as it relates to financial reporting whether you are an auditor or entity management.
More Dates
Comprehensive Accounting and Financial Reporting Update (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This course covers recently issued accounting and financial statement reporting standards from the Financial Accounting Standards Board. Key implementation challenges and experiences from public company filings will be identified. 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
Coaching the Next Generation of CPAs (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Attracting and retaining staff is critical to an organization's success, especially in the age of the millennial worker who will change jobs multiple times in the course of a career. This course will focus on best practices for nurturing the human element of your organization, especially millennial workers who comprise a growing percentage or the workforce. 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
A Working Parent's Guide to Prioritizing Mental Wellness (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Balancing the demands of a career and family life is a challenge faced by many working parents. The pressure to excel at work while being fully present at home can leave little room for self-care, often leading to burnout and mental fatigue. This course is designed to address these challenges head-on by providing actionable strategies to prioritize your mental health and overall well-being. The course emphasizes practical, easy-to-implement techniques tailored for busy working parents. From setting boundaries to prioritizing sleep and physical activity, you'll learn how to create sustainable habits that enhance your well-being. You'll also explore how to recognize the signs that additional support -whether from friends, family, therapy, or other resources- is necessary, and how to seek help without guilt or hesitation. Ultimately, this course will help you regain a sense of balance and control in your life by equipping you with tools to manage stress, build resilience, and rediscover joy in both your professional and personal roles. 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
Navigating Tax Court for Non-Lawyers 25-26 (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
The final step in a tax controversy is Tax Court. Over 70% of all Tax Court cases are filed by taxpayers representing themselves. Most of these "pro se" taxpayers have a non-lawyer assisting them. There can be significant advantages to filing a Tax Court case to resolve a dispute. This class will explore these strategic uses of the Tax Court process and provide a basic understanding of navigating your client through the case.
More Dates
Surgent's Use the Data Model to Build More Powerful PivotTables (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.
More Dates
Everyday Ethics at Work: Don't be the Next News Story! (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
When asked, most people would say they are an ethical person. So why is it that every month there are reports of ethical breaches at major companies? The concept of ethics is easy to understand, easy to talk about, but incredibly hard to implement on a consistent basis. In this course, we will discuss current ethical issues, and walk-through a nine-step ethical decision-making model. 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
Navigating IRS Authorizations: Form 2848 & Form 8821 (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Providing a practical overview of the IRS Power of Attorney, Form 2848, and IRS Tax Information Authorization, Form 8821. Participants will explore the differences between these forms, understand when each is required, and how to comply with IRS requirements for representing clients and accessing their tax information. The course will cover practical issues, ethical considerations, and best practices for managing client authorizations through the IRS Centralized Authorization File (CAF) system. 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 Social Security: Dispelling Common Myths with Essential Truths (2 hours)
-
Online
2.0 Credits
Member Price: $119
See more dates
For roughly 90% of American retirees, Social Security income will be the foundation of their retirement income. Yet, many are ill-prepared and lack understanding of the critical aspects of making an informed claiming decision. Further challenged to separate fact from fiction, consumers crave accurate information from knowledgeable professionals to make the most out of these coveted monthly benefits. This course dispels common myths about Social Security that lead to confusion and replaces them with the truth to an empowered retirement. Help your clients navigate their claiming age decisions with greater confidence, equipped with the essential truths they should consider before pushing the Social Security "on" button.
More Dates
Surgent's Advising a Client Regarding the Tax Consequences Associated with Buying or Selling a Business (3 hours)
-
Online
3.0 Credits
Member Price: $149
See more dates
Buying and selling a business can be a complex transaction with many tax issues. These issues include whether the transaction is or should be a stock or an asset sale when the business involved is a corporation, as well as the tax consequences associated with the sale of a partnership or a C or S corporation. Tax practitioners who advise clients who are buying or selling a business primarily focus on the tax issues that apply. This program explains and analyzes the tax issues practitioners must address in order to properly advise clients who are either buyers or sellers of businesses.
More Dates
Disrupt to Dominate: Mastering Change Leadership (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
In an era defined by rapid change and uncertainty, effective leadership requires more than just managing teams; it demands the courage to disrupt and innovate. This course is your blueprint for transforming potential chaos into a strategic advantage and is designed for leaders at all levels-whether you're a seasoned CEO, an ambitious small business owner, or an individual contributor aspiring to influence greater change. You'll gain the insights and tools needed to not only adapt to change but to lead it effectively and confidently. 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
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.