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.
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
Seeing Beyond the Numbers: Analysis for CFOs & Controllers (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
Financial statements are a window into what is going on in the day-to-day operations of the company. They help us see what the company's strengths and weaknesses are. However, financial statements can often have different messages depending on the user. 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
Shortcuts that Excel Users Love (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take this session! 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
Neurodiversity & Productivity. Include More Minds to Make the Most of Your Time (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
Being neuro-inclusive is not only kind, but can also help your team get the right things done in less time. This course will be about what neurodiversity is, give an overview of brain science, and show you tactical tips and techniques you can use to help your company get more of the right things done in less time with a strategy designed with more brains in mind.
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
Behavioral Finance Biases (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
If you have been a practitioner for any length of time, you know that there is often a difference between what clients should do and what they actually do. Have you ever wondered why that is? In this course, we will explore how we make decisions with less-than-perfect information. Through real-life examples and case studies, we will examine common behavioral biases and how to deal with them. 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 Series: Performance by Design: Drivers of Productivity (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
Productivity is rarely a matter of working harder. The highest-performing individuals and teams consistently produce better results because their work is intentionally designed to drive focus and improve decision-making, accountability, and sustainable performance. To get more, the system must be designed to deliver more. We explore how leadership behaviors, workplace culture, communication, role clarity, decision fatigue, interruptions, and employee engagement influence both individual and organizational performance. We focus on creating systems and environments where people can consistently perform at their best. Learn how to identify the barriers that quietly reduce productivity.
Becoming an AI-Savvy Controller/CFO: Mastering Tools and Technologies (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Ready to elevate your career as an Accountant, Controller, or CFO? This course helps you build the core competencies needed to excel in these roles—focusing on technical expertise, business acumen, leadership, people skills, and the integration of AI tools. Learn how to go beyond tracking financial results to analyze business dynamics, uncover insights, and drive strategic decisions with AI-driven analysis. Develop the vision and strategy to lead organizational growth, while honing leadership skills to inspire teams and navigate change. Strengthen your ability to communicate effectively, collaborate across departments, and influence key stakeholders, with a focus on using AI to enhance decision-making and operational efficiency. With a practical, real-world approach, this course empowers you to master the skills that make you a successful leader in finance.
More Dates
Become a Data Analysis Expert (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
In today's rapidly evolving business landscape, accounting professionals are expected to be more than just number crunchers, they are expected to be insightful interpreters of data. In an era where data is king, this course is your gateway to becoming a savvy data analyst, giving you a competitive edge in your field. We will guide you through the intricacies of making complex data analysis approachable and engaging. You will learn the all important Data Analysis Process Flow that will take you from collecting data all the way to making insightful decisions based upon your data. We will explore the basics of data modeling that will allow you to access data from multiple sources and use sophisticated calculations to create our data metrics. You will learn how to create interactive dashboards, perform sophisticated reporting, and uncover deep insights from your data. Whether you're looking to streamline your reporting process, enhance your data visualization skills, or make more data-driven decisions, this course is tailored to meet those needs. It's not just about learning a tool; it's about enhancing your professional identity as a forward-thinking accounting professional. 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: The AI-Powered Expert and Investigator (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Artificial intelligence is revolutionizing forensic accounting, giving professionals powerful new ways to trace funds, uncover fraud, and analyze massive volumes of financial data in minutes instead of weeks. In this engaging course, you'll discover how AI can enhance financial investigations, strengthen expert witness reports, and support litigation and discovery efforts. Learn where AI can create strategic advantages in the courtroom, as well as the disclosure, reliability, and admissibility challenges that every expert must understand. Through practical examples and real-world applications, you'll see how AI can uncover hidden patterns, identify critical evidence, and generate actionable insights. Whether you investigate fraud, support litigation, or serve as an expert witness, this course will help you harness AI with confidence, credibility, and defensible results. 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
Financial Planning: Auto & Homeowners Insurance (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
While many financial services professionals advise their clients on tax, investment, and life insurance issues, far fewer venture to help in the area of property and casualty insurance. Auto and homeowners policies are mandatory products that everyone generally needs - yet they are also complex products. This complexity raises questions in clients' minds: Are all my belongings covered under my policy? Do I have to adjust my policy if I want to let my neighbor borrow my car? Do I need an additional policy if I want to work as a rideshare driver? And will my premium go up when I move? In this course, we will cover the fundamentals of auto and homeowners' policies. We will touch on these questions, explore basic coverages, and offer some guidance on what practitioners should cover with their clients in this area, so you can offer guidance and give them the peace of mind they need. 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 IRS Taxation Law Research (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
The course provides a concise overview of how to use ChatGPT to more effectively and efficiently research IRS taxation law. It delves into techniques for extracting precise information from complex tax legislation, interpreting IRS guidelines with AI assistance, and utilizing ChatGPT's advanced language models for nuanced legal analysis. Participants will learn how to streamline their research process, identify relevant tax law precedents, and apply AI insights to real-world tax scenarios, enhancing their professional proficiency in navigating the intricate world of IRS taxation. 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 fieldYou'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 Marijuana: A Generalized Business Viewpoint (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
Each year, more states legalize cannabis (i.e., marijuana) for medical or recreational purposes. As legalization grows, so too does the cannabis industry. While some financial professionals have stayed away from this growing sector of the economy, others have embraced the opportunities the cannabis industry has to offer. The legalization of cannabis brings with it a complex regulatory landscape, which includes strict compliance with federal and state regulations. However, the complexity of this emerging market provides opportunities for accountants and other financial professionals. Behind the cannabis dispensaries are scores of related business sectors including food production, retail, farming, and chemical production, as well as facilities, design, and construction. Simply stated, the commercialization of marijuana offers financial professionals an opportunity to participate in an industry expected to reach $73 billion worldwide within six years.
More Dates
Effective Governance for Nonprofit Success (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
Effective governance is the cornerstone of any nonprofit organization. This course delves into the foundational elements of nonprofit governance, emphasizing fiduciary duties, board responsibilities, and best practices for board operations. Participants will explore key compliance requirements, risk management strategies, policy development, and regulatory obligations. By the end of the session, you'll be equipped with practical tools and insights to confidently navigate the complexities of nonprofit governance. YELLOW BOOK: Qualifies for Yellow Book CPE based on your unique audited entity.
More Dates
Working Through Grief and Loss - How to Build a Supportive Workplace (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
Now more than ever, navigating loss, grief and crisis in the workplace is a skillset that leaders must possess. Keeping the heart in human resources is so important, especially in this post-pandemic state we are living in. We will explore ways that you can show empathy to your employees while also balancing your business needs.
More Dates
Retirement Planning: Next Stage for You or Your Client (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
If you or your clients are facing that stage of life where careers are passing into the background, and a new "to be determined" life is emerging, then you are entering what is called "retirement". Some people are excited, some are scared, and most are both. There are many issues and questions people face at this time - what to do with time, financial, relationships, health, identity and more. This program summarizes the key research studies, provides stories from those who have made this work, and offers thoughtful, practical exercises from my award winning book NEXT STAGE. It will help you (or your clients) address key issues and develop a Master Plan for the transition. If not now, when? 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
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
