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.
PowerPoint: Tips & Tricks for Today's Accountant (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
PowerPoint is a widely available resource that is potentially underutilized by accountants because many accountants do not stray beyond Excel and Word in the Microsoft Office suite. You will learn how to create and edit a professional PowerPoint slide deck. This session places particular emphasis on efficiency tips and tricks that will allow you to develop creative, professional visual aids while minimizing time and effort. The course’s author will share personal insights he has cultivated throughout more than two decades of public speaking. Although the session will focus on creating and editing slides, we will illustrate best practices for presentation delivery. We will also explain how PowerPoint can be used for purposes other than delivering presentations.
More Dates
Critical Technical Skills for CFOs and Controllers (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Accounting and finance managers and executives must demonstrate sound technical and analytical necessary for personal growth and organizational success. This course will provide insights into the most critical technical and analytical skills needed by CFOs and Controllers - or those that want to be!
More Dates
10 Best Practices in QBO (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
Use QuickBooks Online more effectively! You'll learn how to avoid (and fix) common mistakes in QBO bank feeds, how to properly classify transactions, and best practices for recordkeeping. After working with hundreds of business owners and bookkeeping professionals, Alicia has seen all kinds of crazy bookkeeping. She's managed to distill those bad habits down into the top 10 mistakes people make in QuickBooks Online. She wants to make sure you don't make them, too! This hour and a half long course highlights the Top 10 best practices that you'll want to get right, saving yourself wasted time and money. We'll start with words of wisdom about setting up your account, and dialing in your chart of accounts and products & services. Then we'll look at recordkeeping, from receipts to understanding what qualifies as a tax-deductible expense. We'll finish up by taking a look at some of QBO's "quirks" so you know proper use of the software. It's important to implement these best practices right at the beginning of your QuickBooks file. It's a lot more expensive and time consuming to fix a file than it is to get trained to do it right in the first place! 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
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
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
Critical Thinking and Skepticism in AI-Augmented CPA Work (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of critical thinking and professional skepticism in AI-augmented CPA work. As artificial intelligence increasingly performs drafting, analysis, calculation, research, and other preparation tasks, CPAs are shifting toward higher-value roles involving review, verification, challenge, and professional judgment. Participants will examine professional standards, human cognitive biases, AI failure modes, evidence requirements, questioning techniques, vendor claims, documentation practices, and firm-level controls. The course emphasizes a central principle: AI output should be treated as an unverified claim requiring appropriate human challenge before professional reliance. 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 Accountability and Action (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $159
See more dates
Good managers know how to delegate, but it can be a challenge to manage employees who are more interested in passing the buck than being responsible. Lack of ownership and responsibility can bog down processes and shut down projects. This workshop will help you create a game plan for building a culture of accountability with your team.
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
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.
More Dates
Excel for Accounting Professionals Session 7: Date-Driven Workbooks and Concatenation (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Realistic Excel training for skill development Shifting from manual inputs to automated formulas in Excel can help enhance data efficiency. Understanding that Excel can handle date and text values broadens the potential to improve efficiency when managing data in Excel. This webcast will focus on the following essential functions: EOMONTH MONTH and YEAR DATE CONCAT SUMIFS with CONCAT Practical hands-on Excel learning exercises taught by a highly engaging expert In this webcast, you'll develop your skills and implement Excel techniques that will boost the effectiveness of conditional summing functions using comparison operators. Additionally, you'll gain in-depth knowledge of the following: Adding helper columns Distinguishing key function differences Combining values *Session 7 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 8: Dynamic headers, mapping tables and error check] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-8--dynamic-headers-mapping-tables-and-error-check) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Leveraging ChatGPT for Innovative Business Advisory Services (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
In this cutting-edge course, participants will gain a deep understanding of how to leverage ChatGPT, OpenAI's powerful language model, to innovate and enhance business advisory services in the accounting sector. The course integrates theory and practice, demonstrating how various enterprise evaluation methodologies can be applied in conjunction with ChatGPT for increased business analysis efficiency, profitability, and growth. It also provides hands-on training for implementing these techniques 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
Excel for Accounting Professionals Session 4: Conditional Summing and Lookups (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Boosting productivity with Excel For those unfamiliar with conditional summing, you're in for a revelation —it's an impactful technique that improves productivity in creating reports. You'll learn how to optimize Excel efficiency by managing duplicates, selecting appropriate shortcuts, and performing lookups. Practical hands-on Excel learning exercises taught by highly engaging expert in the field You'll also deepen your skills and tackle real-world Excel workbooks that address the following: Benefits of using lookup functions over direct cell referencing A comprehensive exploration of the popular VLOOKUP function Techniques for removing duplicates to create a distinct set of report labels *Session 4 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 5: Error Trapping and Improving Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-5--error-trapping-and-improving-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Surgent's Privacy, Data Security, and AI: Reasonable Precautions in an Unreasonable World (2 hours)
-
Online
2.0 Credits
Member Price: $119
See more dates
This presentation explores modern confidentiality, data security, and AI-related professional obligations in an increasingly hostile and deceptive threat environment. It explains how evolving risks such as AI-generated phishing, account takeovers, deepfakes, and inadvertent data sharing intersect with long-standing ethical duties, emphasizing that competence today includes understanding both the benefits and risks of technology. Through real-world examples and practical guidance, the session reinforces core principles like the strategic pause, high-confidence verification, responsible use of generative AI, proper data storage, and personal accountability, concluding that reasonable precautions remain both expected and achievable even as tactics and technologies change.
More Dates
Surgent's Managing People Through Motivation (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $159
See more dates
Whether your employees report in every day to the floor or from an off-site network, the success of your organization depends a great deal on the motivation they bring to the job. This program helps identify specific methods you can use to improve employee motivation. You'll learn how to use observation tools to find out what motivates your employees and you'll study classic motivational theories. The results will help you influence the behaviors of others and tweak your own behavior to improve your bottom line.
More Dates
Surgent's More Money at the End of the Month: Strategic Ways to Improve Cash Flow (2 hours)
-
Online
2.0 Credits
Member Price: $99
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.
More Dates
Reconciling in QBO (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Reconciliation is how you confirm that your QuickBooks Online checking accounts, savings account, credit cards, loan balances, and liabilities are correct. If you don't reconcile correctly every month, your reports will be wrong! Even if you use the QuickBooks Online banking feed, it's not a guarantee that your bank balances are correct. And when you have extra or missing transactions, your Profit & Loss and Balance Sheet are wrong! Reconciliation is the monthly step to confirm your checkbook balance, credit cards, liabilities, and loans have been entered correctly. The problem is that most businesses reconcile the transactions that ARE on the statement, but ignore the ones that are not. That's not Reconciling, that's "reconciling," and the result is that you may be paying your taxes wrong! In this class, not only will Alicia show you how to reconcile properly, but she'll show you how to trick out the interface to finish in seconds instead of hours. Even better, learn how to identify errors in your accounting data by how they appear in your Reconciliation window. Use reconciling as a troubleshooting tool for duplicated entries, misclassified categories, transactions coded to the wrong funding source, and receipt captures that didn't match the banking feed. 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
Rewards & Recognition Strategies for Leaders (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
Whether you are responsible for managing 1 employee or 20, your leadership can make or break your team. Learn practical leadership strategies that you can implement when you return to your office. In today’s competitive market, it’s more imperative than ever that as leaders we are inspiring and motivating our teams to success.
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
Business Transformation: Critical Skills for CFOs and Controllers (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $139
See more dates
Mastering business transformation with key skills and strategies relevant to modern businesses You'll learn tools that will help you manage day-to-day business operations as well as manage changes, including: Budgeting and forecasting approaches Strategic planning and risk management frameworks Technologies that can improve productivity. Optimizing your business model and identify value drivers You'll also understand how to identify and innovate your business model and how to incorporate intangible value drivers into your capital asset strategy by Using hands-on strategies to define your business model and capital structure Learning techniques and models that will guide business model innovation Understanding the role of technology in innovation Leading your team effectively and ethically Additionally, you'll evaluate how to build a successful team and maintain an ethical tone at the top by discovering how to: Attract and retain top talent Adapt leadership styles to different situations Formulate strategies that promote an ethical culture
More Dates
