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
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
Strategic CFO Series - Big Picture Skills
-
Online
8.0 Credits
Member Price: $250
See more dates
Strategic CFO is a four-part series that answers the “why” and “direction” our companies take and our role in thinking about this big picture to infuse into our everyday lives. Strategic CFO – Strategic Financial Communications 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. Strategic CFO – Strategic Cash Management Cash is the lifeblood of every organization, yet many leaders struggle to explain, manage, and plan for it effectively. This session focuses on strategic cash management, capital structure decisions, and financing options available to organizations at different stages of growth. Participants will explore how CFOs balance today's cash needs with long-term strategy, evaluate debt and equity decisions, and communicate cash flow concepts to non-financial stakeholders. The session emphasizes practical frameworks, real-world examples, and modeling approaches that support better cash decisions. A few negotiation videos will be displayed to bring humor and effectiveness to the key points. Strategic CFO – Strategic Risk Management Risk management is no longer a compliance exercise-it is a core strategic responsibility of today's CFO and CPA. This session demystifies Enterprise Risk Management (ERM) by walking through the COSO framework in clear, practical terms. Participants will learn how risk integrates with strategy and performance, how organizations identify and assess risk, and how leaders respond to uncertainty in a disciplined way. Using examples, polling, and case discussions, this session equips financial professionals to communicate risk effectively and help organizations protect and create value. Some funny video clips will be used to focus on the learning material. Strategic CFO – Developing Strategy and the Why 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
Integrate ChatGPT into Your Client Advisory Services-Updated (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Two of the hottest topics in the CPA profession today are CAS (client advisory services) and ChatGPT. This course will explain how to bring these two worlds together by integrating ChatGPT and other generative AI applications into your client advisory services. John Higgins, a leading advisor to the profession on ChatGPT and a seasoned client advisor on technology based solutions, will show you how you can position your firm and yourself as a "go to" advisor on how to embrace this technology in virtually any type of business. John will address how to use this technology as a research and writing assistant in your client services and how to advise your clients on this revolutionary technology and all benefits and "gotchas" that come with it. If you want to step up your advisory game, this course is a "must take." 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
Applying AI in A&A: Creating Effective Prompts (1 hour)
-
Online
1.0 Credits
Member Price: $49
See more dates
When you ask someone in accounting and finance how often they use generative AI, it's no longer a "sometimes" -- it's usually daily. Effective use of the AI tools may vary, though. This webcast can help improve both efficiency and effectiveness for accounting and assurance professionals by unlocking the key to well-structured AI prompts.Examples of effectively written prompts will illustrate how to craft prompts that improve AI outputs and create even more efficiency in your work.
More Dates
Best-In-Class Recruiting Strategies (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
With over 4.3 employees leaving their jobs as of early 2022, The Great Resignation presents a huge challenge for companies as they attract and retain talent. During this course, you'll learn practical strategies you can implement immediately to ensure you have the right tools in your toolbox to win the war on talent.
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
Surgent's Governing Agentic AI: Cybersecurity, Data, and Risk (2 hours)
-
Online
2.0 Credits
Member Price: $119
See more dates
As accounting firms and financial institutions deploy agentic AI, they face significant governance challenges. This course focuses on cybersecurity, data governance, and risk management practices essential for the safe and effective use of autonomous systems. Participants will examine frameworks such as NIST AI RMF and the CSA's red-teaming guidelines, as well as case studies on AI-powered cyber incidents. The course equips professionals to assess agentic system vulnerabilities, implement controls, and integrate risk insights into enterprise compliance strategies. This course equips CPAs to fulfill their oversight responsibilities in safeguarding financial data and ensuring the reliability of autonomous systems within the enterprise's control environment.
More Dates
Surgent's Improving Your Profits: Identifying Cost Cutting Opportunities (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
Part of one's duty as a CPA working in industry is to safeguard the assets of the organization. Cost cutting is one way to preserve assets and maintain a company's competitive position in the industry. However, what keeps us from ridding our organizations of unnecessary costs? In this course, we will look at the factors that prevent our companies from being as streamlined as they could be. By using statistics and survey data, we will attempt to show how to better negotiate and navigate budgeting and contracting decisions. We will also discuss financial statement analysis techniques, benchmarking, and cash flow management in an effort to better cut costs and maintain the long-run viability of an organization.
More Dates
Surgent's The AI-augmented Professional: Practical Tools, Real Risks, and Immediate Use Cases (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
Artificial Intelligence is no longer a future concept; it is a current necessity. This session provides a practical roadmap for practitioners to leverage AI safely and effectively. We move from a survey of available tools (from free apps to specialized software) to a deep dive into the ethical guardrails required to protect client data and maintain professional standards. Participants will leave with a playbook of real-world use cases that can be implemented immediately.
More Dates
Creating A Coaching Leadership Style (3 hours) [NT]
-
Online
3.0 Credits
Member Price: $109
See more dates
This course explores the leadership and coaching principles, concepts, frameworks, techniques, and competencies that will lead to a Coaching Leadership Style. While it is often said that effective leadership is situational, the leadership style that is employed in the everyday workplace is typically the dominant style of the leader. The leadership style that emphasizes coaching in lieu of others that are more autocratic, affiliative, or even more participative can be more fulfilling for the leader, employee, and team. The course illustrates how a Coaching Leadership Style leads to a highly desirable organization culture. This course takes the attendee through a coaching process and discovery that can be applied to various situations. Results one can expect from the Coaching Leadership Style are covered as are measurements depicting the success of this leadership style. The attendee will walk away with the knowledge and skills necessary to begin leading their company towards a coaching culture that will leave employees motivated, transformed and driven to higher levels of innovation and performance from the empowerment of the Coaching Leadership Style.
More Dates
Surgent's Artificial Intelligence for Accounting and Finance Professionals (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
Artificial intelligence (AI) is transforming the accounting and finance profession at an unprecedented pace. What began as automation of repetitive tasks has evolved into systems capable of complex data analysis, natural language processing, and predictive modeling. Modern AI tools — such as generative AI, machine learning, and intelligent automation — are reshaping how professionals audit, forecast, analyze risk, and deliver client insights. This course provides accounting and finance professionals with a comprehensive understanding of how AI is reshaping workflows, client services, and decision-making. Participants will explore current applications of AI within firms and corporate finance, assess risks and governance considerations, and learn strategies for adapting professional roles in an increasingly automated landscape. The program also examines the emerging ethical, regulatory, and data privacy challenges associated with AI adoption.
More Dates
Surgent's Six Common Barriers to Investment Success (2 hours)
-
Online
2.0 Credits
Member Price: $99
Many of us expect to use logic when it comes to how we allocate our investments. The adage of "buy low, sell high" is a saying that makes logical sense. So, why do we always seem to do the opposite? Every day we are faced with decisions, and we are often influenced by two seemingly opposing voices that come from two different parts of our brain. The frontal cortex processes lots of information to help us make logical and informed choices. But there's also a small part of the brain, known as the reflexive brain, that is responsible for emotions and survival instincts. Often, this reflexive brain can have a detrimental effect on the way we handle our investments. This course will discuss some behavioral biases that affect our financial decisions. As humans, we need to be aware of how our reflexive behavior impacts our investment decision-making ability. By uncovering and understanding these biases, we may have a better chance of meeting our long-term financial goals.
NotebookLM Use Cases for Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of how accountants can use Google NotebookLM (powered by Gemini) as a practical research, synthesis, and knowledge-management companion for high-trust work. You'll learn how to convert static financial statements, audit workpapers, client documents, and regulatory guidance into a structured, conversational knowledge base-so you can query, summarize, compare, and cross-reference sources with greater speed and clarity. This course emphasizes disciplined workflows such as source control, evidence-grounded outputs, and professional judgment so NotebookLM strengthens your analysis instead of replacing it. 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 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
Performance Management - Hiring to Retiring (1.2 hours) [NT]
-
Online
1.2 Credits
Member Price: $39
See more dates
How you onboard a new employee is critical in ensuring they understand your company culture and are immersed properly in your organization. On the flipside, in the event you are dealing with an employee termination, this too is critical in handling with care and sensitivity.
More Dates
Navigating Mergers & Acquisitions with AI: The Future of Deals (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Mergers and acquisitions can be complex, risky, and filled with unexpected challenges—but they don’t have to be overwhelming. This course provides a clear and practical overview of the M&A process, helping professionals understand the critical stages of evaluating opportunities, structuring deals, conducting due diligence, and navigating post-transaction integration. Participants will learn practical techniques that help organizations avoid the common traps that derail many transactions while improving the likelihood of successful outcomes. The session also explores how emerging AI tools are beginning to enhance deal analysis, uncover deeper insights, and support better decision-making throughout the M&A process.
More Dates
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
Calculating the Retirement Need (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
For most people, funding their own retirement is the largest expense they will ever have. Due to advances in medical technology and overall healthier lifestyles, it is not unusual for someone to live 30 years or more in retirement. In this course, we will discuss how to quantify and calculate the retirement needs of the client. We will talk about time value of money concepts, how to help clients quantify their retirement goals, and even how to address risk perceptions. By doing this, we will allow practitioners to be able to better address client questions and frame trade-offs when necessary. 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
Forensic Accounting and Evidence Preservation in QuickBooks (4 hours) - 2 Tech & 2 [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
By the time a client calls you about suspected fraud, the clock is already running: records can be altered, evidence can vanish, and every day of delay weakens your case. If your practice touches QuickBooks Online, you need to know how to move fast and correctly. This course walks you through exactly that, from scoping the engagement and preserving the file before anything changes, to gaining access when someone tries to block you. You'll master the Audit Log to recover deleted and voided transactions, examine reconciliation history and bank feeds for tampering, and use Reclass to isolate suspicious activity - the same techniques a trained investigator relies on. You'll also learn to cross-match vendors and employees for shell-vendor and ghost-employee schemes, trace lapping on the revenue side, and spot the AP red flags that confirm what you suspected all along 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
Money Laundering 101 for CPAs (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
CPAs spend most of their working lives reviewing bank statements and books and records of businesses. They are experts in understanding how to prepare financial statements according to GAAP. But would a CPA know a possible money laundering transaction if they saw it? Would they know about a money laundering business? Money laundering is a subject of many action and thriller movies, but rarely understood. This presentation will educate the CPA in understanding the basics of money laundering and how to identify money laundering. This presentation will help the CPA know the truth about money laundering, how to identify it, the statutes that define it, and the court cases that interpret it. 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
