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 Tables and Conditional Summing (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.
More Dates
Corporate Finance Technology Selection: Practical Frameworks (1 hour)
Online
1.0 Credits
Member Price: $55
See more dates
Finance technology decisions (ERP, FP&A, AP/expense automation, close/consolidation, bank integrations, and AI-enabled tools) can dramatically improve close speed, forecasting, and control execution-but vendor demos and "AI" marketing often hide integration complexity, data readiness gaps, governance risk, and long-term total cost. This course provides a practical, vendor-neutral approach for CPAs and finance leaders to evaluate and implement corporate finance technology with an audit-ready mindset. Participants learn how to cut through AI claims using an AI capability framework, apply a weighted vendor evaluation scorecard focused on controls and assurance, build a five-year total cost model that captures hidden and ongoing costs, and follow an implementation roadmap with checkpoints and red flags to reduce failure risk and improve ROI realization. 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
Safety Synergy: Uniting Elements for a Secure Workplace (1.2 hours) [NT]
Online
1.2 Credits
Member Price: $39
See more dates
Creating a culture of safety in a workplace requires attention in many different areas. We will bring these areas into focus and provide attendees with information on how to make their individual workplaces safer for everyone.
More Dates
HR Investigations – Episode 2 – Interview Techniques (2 hours) [NT]
Online
2.0 Credits
Member Price: $89
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 provides best practices for interviewing to gather accurate information, such as creating and asking open ended questions, effective listening, and understanding verbal and non-verbal communication. Attendees will end the session with takeaways to immediately implement in future HR investigations. Two of three Episodes in the series.
More Dates
Complete Guide to Analyze Data with Excel PivotTables (4 hours) [NT]
Online
4.0 Credits
Member Price: $149
See more dates
Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. 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
Google Gemini AI for Accountants (2 hours)
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of Gemini AI, Google's advanced multimodal artificial intelligence model. It explains how Gemini is integrated into different Google products, including Gmail, Docs, Sheets, Slides, and as a stand-alone chatbot. Participants will learn how Gemini enhances productivity by summarizing email threads, suggesting responses, drafting emails, generating formulas, creating tables, and more. By the end of the course, students will have a solid foundation in understanding Gemini AI's role in the evolving landscape of artificial intelligence. 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
Client Advisory Services Risk Management for CPAs 2026 (1 hour) [NT]
Online
1.0 Credits
Client advisory services offer CPAs an opportunity to strengthen client relationships and provide broader business guidance. As firms expand these services, clear communication about roles, responsibilities, expectations, and boundaries becomes increasingly important. This presentation will explore common risk management considerations that arise when providing advisory and related services. Participants will learn how thoughtful planning, documentation, and client communication can help reduce misunderstandings and support effective client service. The session is designed to help CPAs provide valuable advisory services while managing professional liability exposure and maintaining appropriate professional boundaries.
HR Investigations – Episode 3 – Gathering-Analyzing-Reporting (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 provides best practices for gathering and analyzing evidence and reporting the investigation results. Attendees will end the session with takeaways to immediately implement in future HR investigations. Three of three Episodes in the series.
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
Microsoft 365 Application Lightning Round Review-Updated (1 hour) [NT]
Online
1.0 Credits
Member Price: $55
See more dates
Do you use Microsoft (Office) 365? Are you satisfied that you are getting the most that you can from it? If you answered yes then no, this course will provide a really high return on your investment of time and money in this application suite. John Higgins, one of the profession's leading experts on the integration of Microsoft 365 into business, will explain and demonstrate the depth and breadth of the Microsoft 365 ecosystem. The course is designed to raise your awareness of all that you can do with Microsoft 365 and substantially increase your monthly subscription ROI. 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
ChatGPT Deep-Dive Hands-on Bootcamp for CPAs (2 hours) [NT]
Online
2.0 Credits
Member Price: $89
See more dates
ChatGPT has grown its user base to over 800 million active users per week. As a leader in the generative market, it a tool that every CPA should have a basic understanding of how to use and apply in business. This course will provide a comprehensive review and demonstration of how to put ChatGPT to work for you and your clients. It is designed as a "hands-on" course that facilitates following along with the presenter to apply the features of ChatGPT on your computer. Practice files will be provided so you don't have to expose your confidential data. 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
Create Measures in Power BI that Define Your Metrics (4 hours) [NT]
Online
4.0 Credits
Member Price: $149
See more dates
Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. 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 Predicting Future Financial Issues Facing the Financial Executive - 4 Tech & 4 [NT]
Online
8.0 Credits
Member Price: $279
See more dates
Our financial and economic series is designed to take key topics for financial executives and explore them in detail such that the CFO/controller/financial executive can take away useful and practical recommendations dealing with the topic at hand. The program explores the current economic trends and analyze their impact on you as the financial executive in areas professional skepticism, medical care costs, social security viability, the dollar as a world currency, the national infrastructure and the "fate of the states" as well as the AICPA's top 10 trends and technologies. Specific recommendations and insights will be offered to you to deal with the challenges.
More Dates
Mental Illness & Depression: Understanding & Supporting Employees Under the ADA (1 hour) [NT]
Online
1.0 Credits
Member Price: $39
See more dates
This webinar aims to provide HR professionals with a comprehensive understanding of mental illness and depression under the Americans with Disabilities Act (ADA). It will cover key aspects of the law, provide practical advice, and address common challenges.
More Dates
Financial Acumen for Today's HR Leader (2 hours) [NT]
Online
2.0 Credits
Member Price: $89
See more dates
Financial Acumen for the HR Professional is a part of the series "The HR Professional's Guide to Evolving Business Strategy, Finance and Development." This course identifies how HR Professionals can increase their financial understanding to participate more effectively with management as well as understand the financial results and implications for the business.
More Dates
Surgent's Controllership Skills Update: Risk Management (2 hours) - 1 Tech & 1 [NT]
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
Surgent's Incident Response and Case Studies in AI-powered Cybersecurity (2 hours)
Online
2.0 Credits
Member Price: $119
See more dates
This course emphasizes the practical application of incident response frameworks through case studies of AI-related cyber incidents. It focuses on preparing financial professionals to effectively manage and learn from cybersecurity crises.
More Dates
More Money: Strategic Ways to Improve Cash Flow (4 hours)
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
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
Employees Today and Tomorrow: Understanding and Improving The Employee Life Cycle (2 hours) [NT]
Online
2.0 Credits
Member Price: $89
See more dates
Many organizations have a process documented for their employment life cycle but do not look at it wholistically. Having a longer view of the employee life cycle can provide more value to your company that you might think. Join us for an interactive discussion around the entire life cycle of employees with best practices discussed on continuous improvement for your organization. This session will provide an overview of each of the steps in the timeline from multiple perspectives, to provide keen insights on actionable ideas to take back to your workplace and implement today.