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.
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
Building Personal Leadership Skills (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
People skills are the most significant skills that professionals need to develop and yet are often the last skills perfected. This course will help participants understand personality types and the successful interactions with clients, peers and family. In addition, participants will learn Neuro-linguistic programming and develop the ability to better understand nonverbal language, which is key to communication. Participants will also learn techniques to enhance memory and to improve the ability to recall key facts.
More Dates
Gamed: Why Performance Targets and Incentives Fail and How to Fix Them (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Targets can be a powerful catalyst for remarkable achievements - from landing humans on the moon to eradicating smallpox and repairing the ozone layer. However, poorly designed targets can have severe consequences, potentially leading to executive imprisonment, corporate collapse, or even loss of life. This course uses real-world examples and case studies to guide you through a practical, step-by-step process for crafting robust, effective, and credible targets for your organization. You'll learn how to harness the positive potential of targets whilst avoiding the pitfalls that can derail even the most well-intentioned performance initiatives.
More Dates
Tricks and Treats to Avoid Litigation (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
This session provides HR Professionals and leaders with scripts for handling employee relations situations with sensitivity, good judgment, and high confidence. Topics include balancing employee & employer rights, key concepts of effective employe relations, handling employee complaints, personality & attitude problems, addressing misconduct due to mental conditions.
More Dates
Strategic CFO – Strategic Financial Communications (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Financial professionals are expected to do more than report numbers-they must explain them in ways others understand and trust. This session focuses on improving financial communication by addressing financial literacy gaps, simplifying complex accounting concepts, and building compelling narratives around data. Participants will learn how to use stories, visuals, and language effectively to communicate strategy, performance, and risk. Through examples and interactive discussion, this session helps CPAs and CFOs become clearer, more confident communicators in both live and virtual environments. Also, some video clips will be used to add to the learning materials and research. Don't worry, they are pretty entertaining.
More Dates
Leverage PowerBI.com to Create Data Analysis for Others (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Unlock the full potential of data analytics with our specialized course, "Leverage PowerBI.com to Create Data Analysis for Others". This two-hour, intensive training is specifically designed to empower professionals in harnessing the powerful features of Microsoft PowerBI.com. Whether you're a data analyst, business intelligence professional, or someone keen on mastering data visualization and report creation, this course is your gateway to becoming a proficient Power BI user. Dive into the dynamic world of data analytics and learn to transform raw data into visually compelling stories that drive decision-making. Our expertly crafted program offers a deep dive into the essentials of PowerBI.com, starting with a comprehensive tour of its interface and core concepts. You'll gain experience in connecting to diverse data sources, creating stunning visualizations, and building interactive dashboards that communicate insights effectively. The course also covers the innovative Q&A feature of PowerBI.com, allowing you to explore data with natural language queries. By mastering the art of sharing datasets, reports, and dashboards, and creating comprehensive apps, you'll be equipped to deliver top-tier data analysis solutions to colleagues and clients alike. Through this course, attendees will gain a deep understanding of how to leverage the PowerBI.com platform to disseminate datasets, reports, and dashboards, catering to the specific needs of their audience. Our course is tailored for those who aspire to lead in the data-driven landscape, offering not just theoretical knowledge but real-world applications. Upon completion, participants will not only have a thorough understanding of PowerBI.com but also the confidence to apply this tool in creating impactful data analysis for diverse audiences. Join us to elevate your professional skillset, make data-driven decisions with ease, and add a valuable credential to your portfolio. 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
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
Don't Be Spooked: Mastering Conflict Resolution (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
In an age where our workplaces have seen a rise in incivility and we are dealing with rising conflict, it's important for HR professionals to know when to recognize conflict before it explodes and how to resolve it moving forward. This presentation will address the root causes of conflict in the workplace, how to spot it, and how best to address it in a way that keeps your workplace a place where employees want to be.
More Dates
Strategic CFO – Developing Strategy and the Why (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Effective CFOs and CPAs play a critical role in shaping and executing organizational strategy. This session focuses on how strategy is developed, why many strategic plans fail, and how finance leaders can help organizations create focus in an increasingly complex and fast-changing environment. Participants will explore competitive advantage, the use of financial and non-financial metrics, and the importance of aligning strategy with mission, culture, and resources. Through discussion and real-world case examples, attendees will gain practical tools to evaluate, measure, and support successful strategies across for-profit and nonprofit organizations. Use of some video reels will add levity to some of the key points.
More Dates
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
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.