CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Microsoft Excel: Moving Beyond the Basics
-
Online
2.00 Credits
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.
Cash Conversion Cycle: Tool and Techniques
-
Online
2.00 Credits
How well do you understand your organization’s cash flow? Good cash management techniques can provide a competitive advantage! This session shows you how to effectively measure and manage your cash conversion cycle. With a more complete understanding of how cash flows through your organization, you can eliminate impediments. Better cash management lowers your borrowing costs, reduces financing needs, and creates financial flexibility in your organization.
Monthly Federal Tax Updates - September 2025
-
Online
2.00 Credits
Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Schedules K-2 and K-3: Filing Requirements
-
Online
2.00 Credits
Many partnerships and S corporations are now required to complete the voluminous Schedules K-2 and K-3 to report foreign-related tax information. Updated for the 2024 tax year, this course is an essential guide for tax preparers on how to identify which entities need to complete these schedules and how to identify which parts are applicable to a given taxpayer. The filing requirements are broad and often not very intuitive, catching many practitioners unaware that more schedules and parts are applicable to more taxpayers than anticipated. This course includes a deep dive into the domestic filing exception, a discussion of filing requirements of each part of Schedule K-2, and numerous examples of common taxpayer scenarios. Please note: Surgent also offers a companion course, "Schedules K-2 and K-3: Preparation of Forms" (KPF2).This course qualifies for IRS credit.
Using Psychology Secrets to Love your life and Get More Done
-
Online
4.00 Credits
The new field of Positive Psychology offers many methods and ideas for helping people be happier, healthier, and better at what they do. Nowadays, the ability to be at your best and get clients to enjoy working with you is critical to growing your business or getting ahead. Studies show that happy people make $750,000 more over the course of their life than unhappy people, have half the number of sick days, and live 9 years longer. In this fun and fascinating seminar, you’ll learn how to not only be happier, but help your clients be happier in working with you.
Microsoft Teams - Everything You Need to Know from A to Z
-
Online
4.00 Credits
Microsoft Teams is one of the most popular tools for communication, collaboration, and knowledge sharing. If you use Microsoft Teams in your practice or business, this is a "must attend" course. You will learn everything you need to know to optimize the features of Teams and maximize your productivity. We will cover everything from how to effectively design your teams and channels configuration. How to utilize all the Teams features for posting conversations and working with your Office documents, PDF files and more. You will leave this course with the skills to master all the features of Teams! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's Excel Best Practices
-
Online
8.00 Credits
As spreadsheets evolve, so must your practices for creating, editing, and auditing them. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today’s best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this “must-see” CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel to its fullest potential.
Ethical Performance Management
-
Online
2.00 Credits
Today, more than ever, effective performance management is critical to the well-being of an organization, as well as the engagement and satisfaction of staff. Unfortunately, performance management is also often one of the most dreaded responsibilities managers face. This session will provide insight into what performance management is, how to prepare and conduct performance appraisals, how to coach the marginal employee, legal considerations to be aware of when conducting an appraisal, and ways to engage and motivate staff. In addition to providing tools to conduct effective appraisals, we will also look at the ethical implications of employee reviews. When done well, performance management has the power to improve communication between managers and their staff as well as help foster stronger career paths and routes for growth. It can motivate, re-engage, and energize everyone involved. Ethical values such as fairness, accountability, respect, intellectual honesty, and trust will be incorporated into 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.
The Ethics Hour: Deceit and the Whys Behind the Lies: Understanding Ethics
-
Online
1.00 Credits
Our guidance on ethics comes from the AICPA and other groups, but it does not fully address the “why” behind ethics. Understanding what motivates people and understanding those people are key to both solving ethical dilemmas and workplace issues that can lead to greater job satisfaction and efficiency. To correct an issue, you need to delve into the root cause – the why?
Digging Deep with Excel Pivot Tables
-
Online
1.00 Credits
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.
How Prevalent Is Retaliation Within Your Culture?
-
Online
1.00 Credits
Does your organization encourage timely reporting? Does your organization provide substantive protection for those who report? Organizations should be aware of characteristics indicative of a retaliatory culture - one in which bad actors are provided ample opportunity and cover to retaliate.
Responding To Retaliation Concerns and Capturing Key Retaliation Case Metrics
-
Online
1.00 Credits
Individuals may cite retaliatory concerns when weighing their decision to report an issue; during an investigation; or, after an investigation’s conclusion. No matter the timing, when an individual raises a retaliation concern, their claims should be taken seriously and fully reviewed. Does your organization analyze retaliation allegations and investigate outcomes as part of their cultural assessment? Most organizations track retaliation matters at a general, non-specific level. The type of retaliation and the perceived cause of the retaliatory act are not delineated. When a retaliation matter requires investigation, an organization should gather key data points for trending purposes and to fine tune future training and policy initiatives. This course offers recommendations for (1) framing responses to retaliation allegations (2) capturing key data points (3) developing specific metrics for retaliation matters
Data Extraction, Transformation, Validation the Right Data Sources for Analysis
-
Online
2.00 Credits
In this course, we will explore the various types of data - both structured and unstructured - used in conducting fraud risk investigations and proactive monitoring. We will explore the various tools available on the market and techniques to confirm completeness and accuracy of the data before the analysis begins. The course will cover the process for selecting the right data sources to align with the various risks as well as pitfalls to avoid when preparing the data for analysis.
How SAS Nos. 134-145 Improve Risk-Based Audits
-
Online
4.00 Credits
Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in SAS Nos. 134-145. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Current and Upcoming FASB Issues
-
Online
1.00 Credits
You'll learn about current and upcoming requirements in accounting standards (except financial instruments and leases) and understand how to apply the guidance in practice.
Everyday Ethics at Work: Don't be the Next News Story!
-
Online
2.00 Credits
When asked, most people would say they are an ethical person. So why is it that every month there are reports of ethical breaches at major companies? The concept of ethics is easy to understand, easy to talk about, but incredibly hard to implement on a consistent basis. In this course, we will discuss current ethical issues, and walk-through a nine-step ethical decision-making model. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Business Partnerships: Managing Supplier Relationships
-
Online
1.00 Credits
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.
Revenue Recognition Determine the Transaction Price Part 2
-
Online
1.00 Credits
The new revenue recognition standard outlines five steps for proper compliance. At the surface, these steps seem simplistic. However, there are many considerations that should be considered within each step based on your process and industry. Previous courses in this series have covered the standard at a high level and evaluated step one and two of the standard. They are: Understanding the Revenue Recognition Standard Revenue Recognition: Identify the Contract - Part One Revenue Recognition: Identify the Contract - Part Two Revenue Recognition: Identify Performance Obligations – Part One Revenue Recognition: Identify Performance Obligations – Part Two Revenue Recognition: Determine Transaction Price - Part 1 Revenue Recognition: Determine Transaction Price - Part 2 Revenue Recognition: Allocate the Transaction Price Revenue Recognition: Recognize Revenue This segment is designed to evaluate Step Three of the new model dealing with Determining the Transaction Price.
Learning to Teach "Tax" as a Second Language
-
Online
1.00 Credits
Sometimes the vernacular of accounting seems more challenging than technical aspects. This session offers suggestions for translating the foreign language of taxation into tangible terms for non-accountants. We explore techniques for simplifying the complexity of taxation terminology. This course will equip you with tools for demystifying tax technicalities so you can help clients and other non-tax professionals grasp fundamental concepts.
The Controllership Series - Sales, Collections and Customer Credit
-
Online
1.50 Credits
Why do for profit organizations exist??? To make money!!!!! What a great concept. But if the organization does not have the proper collections and credit procedures in place, they may not be able to access that money. Hence the importance of the credit and collection process.Credit and collections are critical areas for the financial statement controllers. Customer credit is a form of payment that allows small business customers to purchase a product or service before paying for it in full. The process works similarly to the way a credit card does - you procure something and pay it back later. Collections is a term used by a business when referring to money owed to that business by a customer. When a customer does not pay within the terms specified, the amount of the bill becomes past due and is sometimes submitted to a collection agency. The sales and collection process includes business activities related to selling products and services, maintaining customer records, billing customers, and recording payments from customers. It also includes activities necessary to manage accounts receivable, such as aging accounts and authorizing credit. This course delves into the topics that impact the sales, credit and collections process for management. We discuss strategic steps management can take to ensure their processes are efficient and that they are able to actually collect their revenue.