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
Surgent's Excel Shortcuts for Accountants (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.
More Dates
Surgent's Basics of Employment Law for Non-HR Professionals (4 hours)
Online
4.0 Credits
Member Price: $159
See more dates
Learn the basics of employment law and how they affect best practices to help control the interview and discover hidden talents of applicants.
More Dates
Tactical Data Management – Turning Data into Actionable Information (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
Organizations collect massive amounts of data, but far less information that actually improves decisions. This session focuses on how CFOs and CPAs can tactically manage data to generate insight, improve performance, and reduce risk. Participants will explore financial and non-financial data, data organization, and the role of analytics in understanding customers, operations, and employees. The session emphasizes clarity, simplicity, and storytelling so data supports better decisions rather than overwhelming stakeholders.
More Dates
Expand Your Analytical Toolbox More Tools for Success (4 hours) [NT]
Online
4.0 Credits
Member Price: $149
See more dates
Valuation techniques and cash management activities are two other tool categories that can round out your analytical toolbox. In this course we will initially discuss how to turn your financial plan into a powerful valuation engine. We then will discuss the formation of an efficient cash management program based on solid banker relationships. Finally, we will review Ten Steps for keeping your financial toolbox full.
More Dates
How to Build a Custom AI Chatbot and GPT in Plain English (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
Participants will learn to create customized AI chatbots that can enhance client interaction and internal operations-all without coding experience. This course provides a concise overview of specialized, task-oriented AI chatbots and GPT builders, focusing on how these technologies are revolutionizing professional workflows. Through hands-on exploration of platforms like AgentGPT, Claude Projects, Gemini Gems, and NotebookLM, participants will learn to design, deploy, and manage custom AI assistants tailored to their specific needs. The course emphasizes creating advanced AI apps that can understand context and solve complex problems autonomously. 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 Revolution in 2026: What CPAs Should Know (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
AI is reshaping accounting, tax, and finance. This update surveys the state of AI technology in 2026: core concepts, software tools, risks/controls, and practical CPA use cases. You will leave with an expanded AI vocabulary, a current view of the AI landscape, and actionable talking points for staff, clients, and service providers. 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
Resistance to Resilience: Strive for Tech Change Acceptance (1 hour)
Online
1.0 Credits
Member Price: $55
See more dates
Technology adoption often comes with resistance, but it's possible to transform this challenge into an opportunity for growth. This course explores the journey from resistance to resilience in embracing new technologies, focusing on overcoming barriers and ensuring successful implementation. Participants will examine cutting-edge audit technologies, including AI, data analytics, and automation, and learn how to align these innovations with both organizational and personal goals. Through case studies, insights into the Technology Acceptance Model (TAM), and practical discussions, participants will gain the tools and strategies to foster acceptance, driving seamless integration of new technology into both individual tasks and team workflows. 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
Cash Management: Strategies for Long-Term Success (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
Many finance departments spend considerable time managing cash, particularly if the organization is highly leveraged or cash rich. Many opportunities exist to reduce your financing costs or increase short-term cash returns if you manage cash effectively. This session will cover a wide variety of day-to-day cash management tools.
More Dates
Numbers to Narrative: Storytelling in Business Communication (1 hour) [NT]
Online
1.0 Credits
Member Price: $55
See more dates
Information becomes influential when it is structured. In this 1-CPE session (Professional Development), participants explore narrative frameworks presented in the course materials, including situation-complication-resolution and hero-based narrative arcs. Using business-oriented examples, the session demonstrates how structured storytelling enhances clarity and impact without sacrificing rigor. Participants will examine how to define context, introduce tension, present evidence, and guide audiences toward resolution. The emphasis is on logical flow and disciplined narrative construction rather than dramatization. The course concludes with application of a structured storytelling model to a professional scenario. 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 5: Error Trapping and Improving Lookups (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
Practical hands-on Excel learning exercises taught by a highly engaging expert in the fieldYou'll develop your expertise with real-world Excel workbooks. Despite the popularity of VLOOKUP, it has its drawbacks. This session will address these drawbacks while offering alternatives. You'll walk through the VLOOKUP and IFERROR functions, and explore the following topics: Improving the use of VLOOKUP with VALUE/TEXT Improving the use of VLOOKUP with MATCH. Moving beyond VLOOKUP with INDEX Trapping errors with IFERROR Moving beyond basic Excel functions Grasping the limitations and possible enhancements for the VLOOKUP feature, along with methods to handle errors can elevate your proficiency in Excel. You'll also partake in hands-on Excel activities that showcase the integration of functions and their use in crafting spreadsheets, encompassing: Combining functions to enhance flexibility Utilizing functions for atypical data categories Perfecting sophisticated lookup functions *Session 5 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 6: List Comparisons and Indenting] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-6--list-comparisons-and-indenting) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Preparing for & Conducting Discharge Meetings (1 hour) [NT]
Online
1.0 Credits
Member Price: $39
See more dates
Over 80% of all employment-related lawsuits relate to termination. Every termination should be treated as a potential lawsuit. The facts supporting a leader's recommendation of discharge must be fully investigated. The discharge of an employee requires prior review and approval. Narrow self-interest, spite, or personal animosity must not play a part in making termination decisions. This course provides practical knowledge and scripts for handling discharges with good judgment such that personal and employer liability is avoided.
More Dates
Introduction to Governmental Budgeting (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
The introduction to governmental budgeting course is an overview of the typical timeline and process a government uses when creating their annual budget. Topics covered include the basics of governmental budgeting, establishing priorities for the budget, the common steps and timeline of the budget process, what, when and how we should be monitoring the budget throughout the year, and how long-term budgets fit in with the annual budget process. 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 Engaging and Managing Young Professionals (2 hours) [NT]
Online
2.0 Credits
Member Price: $99
See more dates
Younger professionals comprise a significant part of the accounting and finance workforce. Whether you are an owner of a small accounting practice or a manager in a multinational accounting firm, it is important to understand the characteristics and expectations of this large segment of the workforce. Research reveals that many of the common stereotypes surrounding young professionals are unfounded and counterproductive. This course provides an understanding of who young professionals are in comparison to their predecessors, the Gen-Xers and baby boomers. Equally important, the presentation will look at common myths regarding young professionals and why understanding this class of employees provides opportunities for your organization to grow and succeed.
More Dates
Take Command of your Time (2 hours) [NT]
Online
2.0 Credits
Member Price: $89
See more dates
Manage distractions, decrease stress and improve productivity. This training is designed to help business professionals improve their productivity and work performance by learning how to prioritize time, decrease distractions and lower stress. 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 the Excel Lookup Functions (2 hours) [NT]
Online
2.0 Credits
Member Price: $89
See more dates
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. 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 Partnerships: Managing Supplier Relationships (1 hour)
Online
1.0 Credits
Member Price: $55
See more dates
As financial leaders, CPAs are often tasked with managing organizational risk. In this respect, the supplier relationship can be a tricky one. It is often one of the more familiar and comfortable business relationships we have, yet it may also be the one that presents the most significant risk to our company. In this course, we will explore how to manage the supplier relationship from onboarding to termination. Through case studies and best practices, we will discuss how to continue being a good partner to our suppliers while also understanding where potential risks exist. 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
Workforce Transformation and Talent Management in 2025 (1 hour) [NT]
Online
1.0 Credits
Member Price: $55
See more dates
The accounting profession faces unprecedented workforce challenges that demand a fundamental rethinking of traditional firm structures. This course examines why the century-old pyramid practice model is becoming obsolete and presents the inverted pentagon framework as a sustainable alternative. Based on comprehensive research showing that 52% of firms expect to shrink by 20% or more in the next five years, participants will learn how to restructure their firms to thrive with fewer entry-level staff while expanding specialized expertise. The course explores the "6 Ps of Business Model Transformation" - Precision Hiring, Proactive Retention, Practical Technology Implementation, Pricing Expertise, Practice Area Expansion/Focus, and People Acceleration. Drawing from success stories in manufacturing, healthcare, and technology industries, attendees will discover proven strategies for accelerating staff development, implementing effective knowledge transfer programs, and building sustainable talent pipelines in an era of technological disruption and demographic shifts. 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
Public Procurement Basics: Protecting the People's Money (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
Procurement is a critical component of successful government operations. While there are challenges in public procurement, there are a number of guidelines and requirements that will help lead you to success. This course will offer guidance on how governments can meet complicated procurement needs and develop best practices that protect public and Federal funds. 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 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
Surgent's Starting a Small Business: What Every Trusted Advisor and Entrepreneur Needs To Know (2 hours) [NT]
Online
2.0 Credits
Member Price: $99
See more dates
Starting and owning a small business remains one of the most powerful ways to build long-term wealth, alongside investing and real estate ownership. But today's business environment is fundamentally different than it was even a few years ago. Entrepreneurs must navigate rapid technological change, artificial intelligence, shifting workforce expectations, evolving regulatory frameworks, fluctuating capital markets, and increased federal and state scrutiny in areas such as non-compete agreements, data privacy, and employment law. Every large business begins as a small business, yet the risks and complexities of launching and scaling a company have increased. Owners and their advisors must address critical issues including selecting the proper entity, liability protection, financing, intellectual property protection, employment contracts, noncompete, insurance coverage, operations, and technology adoption. Decisions made at formation can materially affect a company's long-term value and ability to grow and ultimately sell. This course provides a practical, up-to-date overview of the legal, financial, and strategic considerations that business owners and their professional advisors must evaluate in today's environment. Drawing on current research, regulatory developments, and real-world trends, the program focuses on helping entrepreneurs build resilient, compliant, and scalable businesses in a rapidly changing economy.