CPE + Events Catalog
2026-27 OSCPA-Select™ CPE - 2 catalog options:
Browse CPE by Field of Study, and use the Format/Type filter to narrow by In-Person, Webcast, Bundles or On-Demand.
This will generate a PDF of the current filtered catalog
Identify Leadership Gaps Before Busy Season (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
Leaders in CPA firms often spend time on work that sits below their highest and best use: meetings they do not need to attend, work delegated upward by their teams, client scope creep, administrative tasks, and avoided accountability conversations. Survey data cited in the course indicates that most leaders say yes to commitments they know they should decline, at a cost of hundreds of hours per year. This course introduces the distinction between hard work (time-bound), smart work (skills-based and intellectual), and uncomfortable work (emotional), and shows why avoided "Uncomfortable Work" is the common root of these low-value commitments. Participants complete a structured 32-item self-inventory across five categories: meetings and events, unrealistic expectations, strategies and opportunities, tasks and projects, and suboptimal performance. They then quantify the estimated annual hours lost to the commitments they identified, select one commitment to decline over the next month, and name the higher-value leadership activity (such as delegation, business development, project oversight, or performance management) that the reclaimed time will support. With the self-awareness and clarity gained through this program, you will know exactly which gaps need closing before work ramps back up. 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 Excel for Accountants: Using Excel to Cleanse and Prepare Data (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
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.
More Dates
Excel for Accounting Professionals Session 7: Date-Driven Workbooks and Concatenation (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Realistic Excel training for skill development Shifting from manual inputs to automated formulas in Excel can help enhance data efficiency. Understanding that Excel can handle date and text values broadens the potential to improve efficiency when managing data in Excel. This webcast will focus on the following essential functions: EOMONTH MONTH and YEAR DATE CONCAT SUMIFS with CONCAT Practical hands-on Excel learning exercises taught by a highly engaging expert In this webcast, you'll develop your skills and implement Excel techniques that will boost the effectiveness of conditional summing functions using comparison operators. Additionally, you'll gain in-depth knowledge of the following: Adding helper columns Distinguishing key function differences Combining values *Session 7 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 8: Dynamic headers, mapping tables and error check] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-8--dynamic-headers-mapping-tables-and-error-check) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Leveraging ChatGPT for Innovative Business Advisory Services (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
In this cutting-edge course, participants will gain a deep understanding of how to leverage ChatGPT, OpenAI's powerful language model, to innovate and enhance business advisory services in the accounting sector. The course integrates theory and practice, demonstrating how various enterprise evaluation methodologies can be applied in conjunction with ChatGPT for increased business analysis efficiency, profitability, and growth. It also provides hands-on training for implementing these techniques in real-world scenarios. 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
Excel for Accounting Professionals Session 4: Conditional Summing and Lookups (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Boosting productivity with Excel For those unfamiliar with conditional summing, you're in for a revelation —it's an impactful technique that improves productivity in creating reports. You'll learn how to optimize Excel efficiency by managing duplicates, selecting appropriate shortcuts, and performing lookups. Practical hands-on Excel learning exercises taught by highly engaging expert in the field You'll also deepen your skills and tackle real-world Excel workbooks that address the following: Benefits of using lookup functions over direct cell referencing A comprehensive exploration of the popular VLOOKUP function Techniques for removing duplicates to create a distinct set of report labels *Session 4 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 5: Error Trapping and Improving Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-5--error-trapping-and-improving-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Surgent's Privacy, Data Security, and AI: Reasonable Precautions in an Unreasonable World (2 hours)
-
Online
2.0 Credits
Member Price: $119
See more dates
This presentation explores modern confidentiality, data security, and AI-related professional obligations in an increasingly hostile and deceptive threat environment. It explains how evolving risks such as AI-generated phishing, account takeovers, deepfakes, and inadvertent data sharing intersect with long-standing ethical duties, emphasizing that competence today includes understanding both the benefits and risks of technology. Through real-world examples and practical guidance, the session reinforces core principles like the strategic pause, high-confidence verification, responsible use of generative AI, proper data storage, and personal accountability, concluding that reasonable precautions remain both expected and achievable even as tactics and technologies change.
More Dates
Surgent's Managing People Through Motivation (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $159
See more dates
Whether your employees report in every day to the floor or from an off-site network, the success of your organization depends a great deal on the motivation they bring to the job. This program helps identify specific methods you can use to improve employee motivation. You'll learn how to use observation tools to find out what motivates your employees and you'll study classic motivational theories. The results will help you influence the behaviors of others and tweak your own behavior to improve your bottom line.
More Dates
Surgent's More Money at the End of the Month: Strategic Ways to Improve Cash Flow (2 hours)
-
Online
2.0 Credits
Member Price: $99
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.
More Dates
Reconciling in QBO (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Reconciliation is how you confirm that your QuickBooks Online checking accounts, savings account, credit cards, loan balances, and liabilities are correct. If you don't reconcile correctly every month, your reports will be wrong! Even if you use the QuickBooks Online banking feed, it's not a guarantee that your bank balances are correct. And when you have extra or missing transactions, your Profit & Loss and Balance Sheet are wrong! Reconciliation is the monthly step to confirm your checkbook balance, credit cards, liabilities, and loans have been entered correctly. The problem is that most businesses reconcile the transactions that ARE on the statement, but ignore the ones that are not. That's not Reconciling, that's "reconciling," and the result is that you may be paying your taxes wrong! In this class, not only will Alicia show you how to reconcile properly, but she'll show you how to trick out the interface to finish in seconds instead of hours. Even better, learn how to identify errors in your accounting data by how they appear in your Reconciliation window. Use reconciling as a troubleshooting tool for duplicated entries, misclassified categories, transactions coded to the wrong funding source, and receipt captures that didn't match the banking feed. 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
Rewards & Recognition Strategies for Leaders (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
Whether you are responsible for managing 1 employee or 20, your leadership can make or break your team. Learn practical leadership strategies that you can implement when you return to your office. In today’s competitive market, it’s more imperative than ever that as leaders we are inspiring and motivating our teams to success.
More Dates
The 10 Must Know Excel Features (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. 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
Business Transformation: Critical Skills for CFOs and Controllers (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $139
See more dates
Mastering business transformation with key skills and strategies relevant to modern businesses You'll learn tools that will help you manage day-to-day business operations as well as manage changes, including: Budgeting and forecasting approaches Strategic planning and risk management frameworks Technologies that can improve productivity. Optimizing your business model and identify value drivers You'll also understand how to identify and innovate your business model and how to incorporate intangible value drivers into your capital asset strategy by Using hands-on strategies to define your business model and capital structure Learning techniques and models that will guide business model innovation Understanding the role of technology in innovation Leading your team effectively and ethically Additionally, you'll evaluate how to build a successful team and maintain an ethical tone at the top by discovering how to: Attract and retain top talent Adapt leadership styles to different situations Formulate strategies that promote an ethical culture
More Dates
Surgent's Employer's Handbook: Legal, Tax, and Health Care Issues
-
Online
8.0 Credits
Member Price: $279
See more dates
The employer-employee relationship strains both sides in uncertain times, and businesses need CPAs, controllers, and other advisors to provide understanding of the complex legal, tax, and health care issues associated with all aspects of employment. This course provides in-depth coverage of this critical area. It will be updated and supplemented throughout the year to cover breaking developments.
More Dates
Surgent's Handling Difficult People (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
This professional development course equips you with practical strategies to manage challenging interactions in the workplace. Although difficult individuals may represent a small segment of the workforce, their impact can be significant, often leading to time lost and decreased productivity. In this course, you will gain essential skills to address and navigate these situations effectively. Additionally, you'll identify specific challenges and develop a personalized action plan for implementing the strategies learned back in your workplace.
More Dates
Tactical Business Systems – Getting the Most from Information Systems and ERP (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
CFOs are increasingly accountable for the effectiveness of information systems, even if IT does not formally report to them. This session focuses on the tactical role finance leaders play in evaluating, selecting, implementing, and managing information systems. Participants will gain a practical framework for understanding IT, ERP systems, security, and emerging technologies such as AI. The session emphasizes asking the right questions, aligning systems with strategy, and avoiding common pitfalls that cause system implementations to fail.
More Dates
The Risks of Artificial Intelligence - Part 2 (1.8 hours)
-
Online
1.8 Credits
Member Price: $79
See more dates
As artificial intelligence (AI) becomes deeply integrated into business operations and decision-making, organizations must recognize that effective oversight extends beyond technical safeguards.The governance, risk and control (GRC) responsibilities of AI also carry a cultural dimension requiring alignment with corporate ethical values ethical principles and accountability structures.Cultural governance emphasizes leadership commitment, employee engagement and cross-function ownership of AI practices to ensure trust and transparency. AI-related risks – ranging from bias and ethical concerns to regulatory compliance, reputational exposure and operational vulnerabilities necessitate robust control frameworks and proactive mitigation strategies. These include governance structures, policies, risk assessments, transparency measures, and continuous monitoring. By embedding cultural governance and mitigation responsibilities into enterprise AI initiatives, organizations can responsibly harness innovation while safeguarding stakeholders, protecting reputation and ensuring sustainable long-term value. Note: This is Part 2 in a two-part series on the risks of AI
More Dates
Leading for Well-Being: Building Resilient Teams & Thriving Workplaces (3.5 hours) [NT]
-
Online
3.5 Credits
Member Price: $129
See more dates
Leaders set the tone for workplace well-being. This program will equip leaders with the tools to build resilient teams. Creating a culture of mental wellness allows employees to feel safe, valued and heard. This will improve productivity, reduce burnout and absenteeism and ultimately, create a workplace where employees can thrive. Leaders will also learn the importance of nurturing their own self-care to prevent burnout for themselves in order to be the best leader possible.
More Dates
HR Investigations – Episode 1 – Introduction-Assessing-Planning (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session is an introduction to these differences and provides best practices for assessing allegations of employee misconduct and planning the investigation. Attendees will end the session with takeaways to immediately implement in future HR investigations. Episodes 2 and 3 complete the series.
More Dates
Build Better Budgets: Fundamental Techniques (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This session provides insights for enhancing the preparation and utilization of budgets. Seasoned accountants will benefit from a refreshed awareness of popular techniques. Budding financial professionals will obtain novel insight regarding fundamental budgeting concepts. All participants will develop an appreciation for the holistic nature of budgeting as an integral tool for planning and control. 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
Business Dissolution & Ownership Changes [NT]
-
Online
8.0 Credits
Member Price: $239
See more dates
This advanced course examines the federal tax consequences of business dissolutions, ownership changes, and related restructuring transactions involving partnerships, S corporations, and closely held businesses. Using a cradle-to-grave framework, the program addresses planning, execution, valuation, reporting, and post-transaction compliance issues arising in sales, redemptions, liquidations, divorces, deaths, and internal restructurings. Participants will analyze inside and outside basis, debt basis, Section 754 adjustments, Section 302 redemption tests, Section 1041 transfers, F reorganizations, Section 751 hot assets, and the treatment of goodwill and other Section 197 intangibles. The course also incorporates practical guidance on NIIT, potential Section 1202 considerations, final-year return procedures, and selected state tax issues that commonly affect business exits and ownership transitions. 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
