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.
Smart Formula Selection in Excel: What to Use When (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Excel gives you multiple ways to solve the same problem - but which formula is the right one? This course teaches a decision-based approach to function selection, helping you confidently choose between similar and competing functions. Through real-world examples and side-by-side comparisons, you'll learn when IFS or SWITCH is cleaner than nested IFs, how SUMPRODUCT can help with complex summarizing data, how to use LET in place of defined names, and much more. Ideal for professionals who want to make smarter, faster formula choices that are easier to maintain and audit. 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
Smarter Tax Services with Artificial Intelligence (AI) Tools (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
There has never been a greater opportunity to leverage technology tools to automate your tax services. This course will provide specific examples of how you can use AI (artificial intelligence) based tools to complement your tax planning, research and compliance services. You will learn how to leverage AI to automate the collection and organization of client data, the engagement management process, tax research, and enhance client advisory services with AI too 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
10 Keys to Outstanding Service and More Referrals (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
In a competitive economy, CPA's and their firms need a way to stand out. The best way to do this is to give outstanding service to your clients. In this experiential workshop, you’ll learn skills that lead to dramatic client satisfaction. In addition, you'll learn several specific ways to guarantee you'll get a lot of word of mouth referrals that will lead to a dramatic increase in your number of clients.
More Dates
Recognizing Lies: How to Detect and Prevent (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Trust is the glue that binds all relationships. Regardless, humans tell lies, a cruel fact. Every lie undermines trust and damages productivity. What signals indicate lies? How are the cues properly interpreted? How can you protect yourself from lies? Learn how to discern lies effectively. Do not be taken advantage of. Learn an established and proven process to uncover the truth.
More Dates
Surgent's Cybersecurity Risk Management for Financial Professionals: Policies, Controls, and Emerging Threats (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
This course focuses on implementing cybersecurity policies, controls, and risk management strategies tailored to financial environments. It emphasizes practical applications to mitigate threats and highlights global compliance standards, particularly their relevance and applicability to U.S. organizations.
More Dates
ChatGPT Vision for Financial Analysis (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course offers an in-depth exploration of the "vision" capabilities of ChatGPT specifically tailored for accountants. The session demonstrates how artificial intelligence can interpret and analyze visual content to revolutionize financial management. The curriculum covers a wide range of applications, from understanding GPT Vision and its unique benefits to leveraging aerial and street view imagery for comprehensive financial analysis. Through detailed case studies, participants will learn how to access and utilize GPT Vision effectively, incorporating it into tasks like data visualization, text and object recognition from images, and the use of descriptive, diagnostic, predictive, and prescriptive (DDPP) analysis methods to enhance decision-making processes. 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
CFO & Controller Critical Skills: Budgeting & Forecasting (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
The budget and the forecast are two common tools used by controllers and CFOs across almost every industry. However, are we really getting the most out of these tools? Or are we merely replicating whatever was done last year? In this course, we will use examples and illustrations to demonstrate various budgeting and forecasting techniques. We will discuss traditional approaches, as well as newer approaches such as flexible budgeting, in an effort to show how companies can gain more value. 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
Eliminating Busy Season: Transforming Your Practice to Year- Round Advisory Services
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides tax and accounting professionals with a comprehensive framework for transitioning from a compliance-driven busy season model to a sustainable, year-round advisory practice. Participants will explore strategies for expanding services into tax, financial, and estate planning. The course addresses both transitioning existing clients and attracting new, higher-value clients while improving efficiency, client value, and revenue stability.
More Dates
Surgent's The Americans with Disabilities Act and the Family and Medical Leave Act (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
The Family and Medical Leave Act (FMLA) and the Americans with Disabilities Act (ADA) were implemented to improve the lives of employees. FMLA allows eligible employees to take job-protected leave for their own serious health conditions or to care for sick family members. The ADA was intended to ensure "equality of opportunity" and "economic self-sufficiency" for individuals with disabilities. Yet both laws have proven challenging for employers. These laws are complex with rules that can be confusing and often misunderstood. This webinar is designed to provide information, guidelines, and examples of the key concepts under both laws.
More Dates
You Don't Know What You Don't Know About Microsoft Excel [NT]
-
Online
8.0 Credits
Member Price: $239
See more dates
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. 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 for CPAs: Unlocking Hidden Productivity Tools (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Microsoft 365 is likely the most underutilized software investment in your firm or business. This course will show how to tap in to many of the lesser known features of the Microsoft 365 ecosystem of apps to maximize your productivity and produce better outputs. Through a series of practical case study demonstrations you will learn how to leverage the full potential of Microsoft 365 in your organization. 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
Emotional Intelligence for Professionals: Mastering the Human Side of Success (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
Technical expertise may get you in the door—but emotional intelligence (EQ) is what builds trust, earns loyalty, and sustains lasting success. For CPAs, attorneys, financial professionals, bankers, and insurance agents, your ability to navigate emotions—your own and others'—is often the difference between a good client interaction and a great one, between a team that functions and a team that thrives. This interactive course goes beyond theory and dives into real-world application. You’ll uncover what emotional intelligence really is, why it matters more than ever in today’s professional world, and how to strengthen your EQ to improve performance, strengthen relationships, and manage stress with confidence. You’ll walk away with tools you can use immediately to transform how you lead meetings, manage conflict, build client trust, and drive results—while also enriching your personal life. Whether you're looking to become a better leader, communicate with more clarity, or create meaningful client connections, this course gives you the insight and strategies to make it happen.
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
Executive Presence, Personal Brand: Structure Your Narrative (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
Professional credibility is communicated, not assumed. In this 1-CPE session (Professional Development), participants examine structured approaches to articulating their professional identity. Drawing directly from the course framework, the session covers development of an elevator pitch, a professional value proposition, and a concise executive biography. Participants will analyze how credibility is established through clarity, relevance, and alignment with audience needs. The course emphasizes service-centered communication rather than self-promotion and provides structured guidance for refining professional messaging in leadership and client-facing contexts. 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
Understanding the 4 W's in Budgeting: Who, What, When, and Which? (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This session introduces a structured approach to government budgeting using the four W’s: Who, What, When, and Which. Participants will explore WHO should be involved in the budgeting process, including internal teams and external stakeholders, while learning effective communication strategies to foster collaboration. The session examines WHAT the budgeting process entails, covering essential phases, components, legal requirements, and common challenges. Attendees will also learn WHEN to engage the public through strategic planning, workshops, and outreach initiatives. Finally, the session highlights WHICH departments play key roles, from financial planning to managing capital projects. By the end of this session, participants will have a comprehensive understanding of government budgeting and how to align financial planning with community priorities. YELLOW BOOK: Qualifies for Yellow Book CPE based on your unique audited entity.
More Dates
Microsoft Excel: Moving Beyond the Basics (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information.
More Dates
Streamlined Excel Reporting Series Session 4: External Data and PivotCharts (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Extracting data for richer insightsYou'll gain meaningful analysis techniques while working alongside an industry expert and knowledgeable instructor. This session begins with the GETPIVOTDATA function to enable report customization. It's a great starting point before moving on to more advanced techniques. Power Query introduction With its user-friendly interface, Power Query empowers Excel users to take the next step by enabling seamless data import and transformation. With Power Query, you will explore features, including: Getting and transforming data Loading data Managing columns Data source settings Layouts and parameters Visualizing with PivotChartsA well-designed chart can effectively illustrate data trends and comparisons. You'll learn how to create and customize PivotCharts to elevate your reports and make the data more accessible to others. *Session 4 is one of four individual sessions. Each session builds on the previous one, so consider watching all the sessions [Streamlined Excel Reporting Series](https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series) to tackle real-world issues and create powerful workbooks.*
More Dates
Surgent's Controllership Skills Update - Budgeting, Forecasting, and Big Data (2 hours) - 1 Tech & 1 [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
Budgets are the vehicle for allocating resources, measuring activities, and identifying needed changes and improvements. An organization's strategy is the primary driver of costs. To be effective, the budget must be linked to strategy and long-term plans. Numerous organizations have achieved a series of short-term targets (budgets) but failed longer term, demonstrating the lack of this necessary linkage. Forecasting, a critical part of any successful budgeting process, can be flawed by technical errors, organizational structure, or emotional forces. The establishment of a system to collect, process, and analyze big data can provide significant insights into the budgeting and forecasting process. An efficient system of incorporating big data and analytics into normal activities will improve management's decision-making. This brief program offers specific actions to improve your forecasting and budgeting activities. In addition, more advanced techniques are identified for the participant's further review, which can be applied throughout an organization. Good budgets effectively allocate resources, provide information for decision-making and serve as an early warning system for unforeseen events. A poor budgeting process fosters a false sense of security, provides inappropriate or inaccurate data, and reinforces the status quo. Budgets are about the organization's story, not just the raw numbers!
More Dates
