CPE + Events Catalog
2026-27 OSCPA-Select CPE Courses Now Available!
Browse CPE by Field of Study, and use the Format/Type filter to narrow by In-Person, Webcast, Bundles or On-Demand.
AI Prompt Engineering Masterclass for Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
An advanced guide to prompting techniques that maximize AI efficiency and precision in everyday business research, operational due diligence and accounting tasks. Designed for accountants with no prior AI knowledge, the session explores how simple language and strategic prompting can unlock powerful, layered responses from large language models (LLMs). Participants will learn to overcome the "lazy" defaults of AI, using specific techniques to enhance detail, accuracy, and contextual understanding in their queries. By understanding prompt engineering's role, attendees will discover how to guide AI to provide practical, relevant, and analytical insights suited to complex financial scenarios, without needing extensive technical expertise. 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
Introduction to Governmental Budgeting (2 hours)
-
Online
2.0 Credits
Member Price: $79
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.
More Dates
2025 Governmental Auditing Update: Yellow Book & Uniform Guidance (3 hours)
-
Online
3.0 Credits
Member Price: $99
See more dates
This course provides a concise update on key changes in governmental auditing. We'll review the 2024 Yellow Book updates, including the shift from quality control to quality management, key audit matters, and implementation timelines. For Single Audits, we'll cover the 2024 Uniform Guidance updates, the 2025 Compliance Supplement, GAO reports on improper payments and fraud, the Financial Data Transparency Act (FDTA), and recent Department of Education guidance on related parties. Stay informed on critical standards and updates to ensure compliance and audit quality.
More Dates
Excel for Accounting Professionals Session 5: Error Trapping and Improving Lookups (2 hours)
-
Online
2.0 Credits
Member Price: $125
See more dates
Practical hands-on Excel learning exercises taught by a highly engaging expert in the field You'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
Using ChatGPT with Excel (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. 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 Successful Communication (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $159
Technology has created numerous ways for us to communicate with each other - but it's also increased the number of ways in which the message can get garbled. Effective communications skills are crucial to successful management. Learn how to control your message with clear communications strategies. You'll learn to recognize communication barriers, assess styles and behaviors, and learn how to listen more effectively as well.
Enterprise-Wide Risk Management in Accounting and Finance (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Organizations are challenged with identifying, evaluating, and responding to a wide variety of risks. This course will discuss tips and best practices for enterprise-wide risk management for accounting and finance professionals. 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
Advanced Personal Financial Planning Update 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
New personal financial planning strategies are emerging due to evolving personal goals in rough economic and legal environments. Drawn from recent publications and government directives, this course reviews the latest financial strategies and planning changes from the past year in insurance, investments, tax, estate and retirement, including Social Security and Medicare. Additionally, Randy covers estate and tax planning strategies that enable practitioners to better serve clients by allowing them to take advantage of new opportunities.
More Dates
Internal Control Frameworks for Single Audit (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
The Uniform Guidance identifies COSO and the Green Book as best practices for internal controls in governmental audits. This course provides a comprehensive review of the COSO framework, including its 2013 update, and explores its application to the Green Book. Attendees will learn to recall the five components and 17 principles of internal control, understand the benefits of adopting internal control frameworks, and recognize the rationale behind the COSO 2013 update and its impact on auditing practices. Additionally, the course will cover how to leverage Part 6 of the Compliance Supplement to effectively document internal controls.
More Dates
ChatGPT: What Every CPA Should Know-Updated (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Don't look now, but ChatGPT is taking the business world, including the accounting profession, by storm. Every CPA, whether in public accounting or working in corporate, should have a fundamental understanding of ChatGPT and generative AI applications more broadly. This course will provide you with a foundation of knowledge about ChatGPT technology that will prepare you to have conversations with clients, customers, colleagues and service providers. More importantly, you will learn how to leverage ChatGPT to increase your personal productivity. If you feel your ChatGPT knowledge is lacking, that will not be the case after you attend this course, taught by John Higgins, one of the leading technology strategists and thought leaders for the accounting profession. 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
Guide Strategy, Attract Investments with Financial Forecasts (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Financial statement forecasting is essential for predicting a company's future financial health, guiding strategic decisions, and attracting investments. By analyzing historical data, market trends, and assumptions, businesses can anticipate risks and opportunities, enabling effective planning, resource allocation, and long-term stability and growth. - Forecasting Process: This involves projecting future income, expenses, and resources. By leveraging historical data and market insights, businesses can predict financial health, shaping strategic planning, investment decisions, and risk management. - Forecasting Profitability: Predicting future earnings informs strategic decisions, investment planning, and resource allocation. It facilitates effective budgeting, cash flow management, risk assessment, and enhances attractiveness to investors for sustainable growth. - Forecasting the Balance Sheet: Analysts forecast to predict a company's future financial position, assessing growth potential, solvency, and capital structure. This informs investment decisions, strategic planning, and risk management, ensuring financial stability and growth. Join our webinar to explore these concepts with a practical example, guiding you through the forecasting process and demonstrating its practical applications in real-world scenarios. 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
Digging Deep with Excel Pivot Tables (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
This session focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables.
More Dates
Excel for Accounting Professionals Session 6: List Comparisons and Indenting (2 hours)
-
Online
2.0 Credits
Member Price: $125
See more dates
Major benefits of detailed Excel workbooks Understanding list comparisons in Excel is vital for improved workbook efficiency. In this webcast, the facilitator will walk you through comprehensive learning exercises that provide an overview of the following topics: Performing list comparisons Building multicolumn list comparisons Using lookups Indenting commands In-depth training for Excel upskilling This webcast is crafted to enable active participation as you follow the demonstrations. It will navigate you through the intricacies associated with working Excel columns, helping you to apply key functions effectively for significant improvements through the following: ISERROR COUNTIFS SUMIFS *Session 6 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 7: Data- Driven Workbooks and Concatenation] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-7--date-driven-workbooks-and-concatenation) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Advanced Personal Financial Planning Update 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
New personal financial planning strategies are emerging due to evolving personal goals in rough economic and legal environments. Drawn from recent publications and government directives, this course reviews the latest financial strategies and planning changes from the past year in insurance, investments, tax, estate and retirement, including Social Security and Medicare. Additionally, Randy covers estate and tax planning strategies that enable practitioners to better serve clients by allowing them to take advantage of new opportunities.
More Dates
AI & Accounting in Construction (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of how artificial intelligence (AI) is revolutionizing the construction industry and reshaping financial oversight, accounting practices, and regulatory compliance. From autonomous equipment to predictive risk analytics, construction firms are increasingly adopting AI to enhance safety, efficiency, and profitability. As this transformation unfolds, accountants and financial professionals must evolve their roles-leveraging AI for smarter budgeting, automated compliance, and real-time auditing. The course highlights the top 20 macro-level AI trends in construction and explores how accounting professionals can align financial systems with operational AI, uphold audit integrity, and prepare for emerging tax and compliance challenges. 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 and Advanced Policy Manual Development for ACCTs (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of how to leverage ChatGPT and other AI tools to develop comprehensive, efficient, and compliant policy manuals for accounting firms. The revolutionary PRIME Method (Policy Refinement and Integration through AI-Managed Elaboration) empowers accounting professionals to create sophisticated policy documentation while maintaining human oversight and expertise. 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 Engagement and Client Retention Best Practices (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $119
See more dates
Positive client relationships require work. Miscommunication, unrealistic expectations, and differing personality styles may strain a client's relationship with professional advisors. Fortunately, there are tested strategies that foster and strengthen client relationships. Creating appropriate boundaries early on is one of many effective strategies that can help. This course explores actions accounting and finance professionals can take to create and grow their client relationships. This webinar provides actionable insights on how to engage new and old clients alike. Strained client relationships can harm both the client and the firm's profitability. Yet automation, for example, allows some firms to remain more engaged while others miss the mark. There is a science underlying client retention that involves understanding the client journey, ensuring consistent client interactions, and equipping employees with the tools needed to satisfy client needs. Understanding these skills should help you protect the relationships that sustain your business.
More Dates
Build Better Budgets: Fundamental Techniques (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
This session provides insights for enhancing the preparation and utilization of budgets. Seasoned accountants will benefit from a refreshed awareness of popular techniques. Budding financial professionals will obtain novel insight regarding fundamental budgeting concepts. All participants will develop an appreciation for the holistic nature of budgeting as an integral tool for planning and control.
More Dates
Mastering Microsoft 365 Copilot for CPAs (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Discover how Microsoft 365 Copilot can revolutionize your daily tasks as a CPA. Dive into the specific features and functionalities of this AI-powered assistant. Learn how to leverage Copilot to enhance productivity, automate routine tasks, and improve collaboration within your team. 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 Foundations of Cybersecurity for Financial Professionals (2 hours)
-
Online
2.0 Credits
Member Price: $119
This course introduces key cybersecurity concepts tailored for financial professionals. It emphasizes the CPA's role in cyber risk management, key terminology, and practical steps to foster a security mindset, integrating cybersecurity with financial reporting.
