CPE Catalog & Events
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Online
2.00 Credits
Member Price: $99
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. Delivery Method: Individual webcastCPE Credit: 2Program Level: IntermediateThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
How to Get a Better Return on Yellow Book and Single Audits - Avoiding the Most Misapplied Audit Concepts
-
Online
8.00 Credits
Member Price: $250
Yellow Book and Single Audit reporting entities have complex and unique financial statement audit, compliance and reporting issues. Deficiencies in these types of audit engagements are common. This course will reduce the likelihood of noncompliance with relevant professional and regulatory auditing and reporting standards. Delivery Method: Individual webcast CPE Credit: 8Program Level: Basic
Multi Year Failure to File: Getting into Compliance
-
Online
8.00 Credits
Member Price: $239
This comprehensive program equips CPAs with the knowledge and practical tools to handle clients who have failed to file tax returns for multiple years. The course covers every stage of the process-from client onboarding and transcript analysis to risk assessment, ethical considerations, and resolution strategies. Participants will learn how to manage cases involving individuals, married couples, businesses, payroll taxes, and S corporations, including situations with missing records and potential criminal exposure. Real-world examples, IRS references, and best practices are integrated throughout to ensure confidence and compliance. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
The Controllership Series - The Future Role of the Controller Part 2
-
Online
1.50 Credits
Member Price: $79
This is a two-part series that discuss new trends and concepts the financial controller should begin to execute in order to truly become a valued member of the senior leadership team. The rapid pace of the evolving technological landscape has promoted changes in how accountants and financial professionals focus attention on strategy and modernize their roles to leverage digital technology. There is increased demand for enhancing flexibility into finance cycles and initiating real-time reporting and insights. These are the core attributes that will assist in transforming the work that controllership function performs. Is the financial controllership prepared to meet future business demands? The IMA® (Institute of Management Accountants) and Deloitte’s Center for Controllership aimed to better understand the current state of controllership and expectations of future demands for controllers and accounting professionals. They conducted a survey in late 2022 and identified several trends. The survey takes a look at how prepared controllership is to meet future business demands. It also highlights some insights for leaders to consider that may increase their preparedness. It also identified areas of additional insight and questions to answer on the controllership transformation journey. In this segment, we will go through numerous concepts in detail. Delivery Method: Individual webcast CPE Credit: 1.5Program Level: Basic
K2’s Top Ten Productivity Booster Apps In Microsoft 365
-
Online
2.00 Credits
Member Price: $89
Are you ready to take your productivity to the next level? Join our exclusive two-hour CPE course designed for accounting professionals and technology enthusiasts. Discover how to harness the power of Microsoft 365's versatile applications to streamline your workflows and enhance collaboration. In this course, you'll explore ten essential apps, including Shared Mailboxes, Planner, Lists, To Do, Stream, Viva Learning, Forms, Bookings, Approvals, and Places. Discover how to effectively integrate these tools into your daily tasks and experience immediate improvements in your efficiency. Don't miss out on this opportunity to unlock the full potential of Microsoft 365 and transform the way you work. Sign up now and take the first step towards a more productive and collaborative work environment! Delivery Method: Individual webcast CPE Credit: 2Program Level: Overview
AI & Accounting in Manufacturing
-
Online
2.00 Credits
Member Price: $89
This course provides a concise overview of how artificial intelligence (AI) is reshaping financial oversight in the global manufacturing sector. With factories evolving into digital ecosystems powered by intelligent automation, predictive analytics, and edge computing, the role of accounting and finance professionals is rapidly transforming. Participants will explore how AI technologies intersect with core financial functions-cost accounting, audit, tax compliance, and financial planning-while enabling real-time reporting, fraud detection, and predictive decision-making. Drawing on current global trends and real-world case studies, the course offers actionable insights into integrating AI into financial operations, elevating the strategic role of accounting in manufacturing enterprises. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Monthly Federal Tax Updates - April 2027
-
Online
2.00 Credits
Member Price: $89
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.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Surgent's Purchase and Sale of a Residence: Critical Tax Issues
-
Online
2.00 Credits
Member Price: $99
Many clients end up selling one or more residences during their lifetimes. Accounting and finance professionals must be aware of the tax rules that relate to such sales in order to assist their clients regarding these sales. This program provides accounting and finance professionals with the tax rules they need to know to help their clients when they sell a personal residence. This program is a comprehensive survey of the various tax issues associated with the sale of a residence.Delivery Method: Individual webcastCPE Credit: 2Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
The Preparation of Form 706 - Line-by-Line
-
Online
3.00 Credits
Member Price: $109
Preparing Form 706 requires a detailed understanding of estate taxation, valuation rules, and compliance requirements. This course provides a step-by-step breakdown of Form 706, helping tax professionals accurately report estate taxes while ensuring compliance with IRS regulations. Participants will explore key components, including gross estate calculations, deductions, tax computation, and portability elections. With real-world examples and practical guidance, attendees will gain confidence in preparing Form 706, even in complex scenarios. This course will also cover any recent legislative changes introduced by the new administration and their impact on estate tax planning and compliance. *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com Delivery Method: Individual webcast CPE Credit: 3Program Level: Basic
Mastering Partnership Basis: Inside and Outside Basis
-
Online
2.00 Credits
Member Price: $89
This course will provide a detailed analysis of how to determine a partner's tax basis for a partnership interest, with an explanation of the use of both "inside" and "outside" basis determination. An illustrated example with filled in forms will demonstrate how the process works and the potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Understanding the Tax Implications of Retirement Plan Distributions
-
Online
1.00 Credits
Member Price: $39
This session will address the complex rules of retirement distributions, review key provisions of the SECURE Act 2.0, and provide practical strategies of maximizing tax benefits for your client. **Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Written Information Security Plans
-
Online
1.00 Credits
Member Price: $55
Thsi course provides a comprehensive overview of Written Information Security Plans (WISP), focusing on their purpose, requirements, and implentation. All PTIN holders must certify they have a WISP prior to renewal, along with certifying the training of employees, staff and contractors as necessary. Participants will explore the history and legal foundation of WISP under the Gramm-Leach-Bliley Act, and how compliances is enforsed through IRS Circular 230, AICPA Statments of Standards, The American Bar Associations and the Federal Trade Commission (FTC). This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
The Controllership Series - The Controllers Role in Financial Forecasting
-
Online
1.50 Credits
Member Price: $79
Financial forecasting is an important part of any successful business. It enables businesses to plan for the future and anticipate scenarios based on strategy. The controller helps forecast financials by calculating future revenue and income streams. In recent years, corporate finance has undergone many dramatic changes due to the growth of a number of high-tech tools. The responsibilities/competencies of the Financial Controller position (FC) has changed in recent years To maximize performance, Controllers must be aware of how the FC position is changing, and how they must adjust to these changes. There are many types and methods of financial forecasting. This course will review the most prevalent forecasts and relative methods being used. Delivery Method: Individual webcast CPE Credit: 1.5Program Level: Basic
Develop Your Emotional Intelligence to Be More Successful in Life and Leadership
-
Online
2.00 Credits
Member Price: $89
The difference between star performers and average ones in leadership roles is attributable largely to emotional intelligence (EQ). It’s surprising, then, that EQ is underrated as an essential ingredient for success in life and leadership. This presentation highlights the importance of EQ and provides participants with actionable tools to develop better relationships within and outside of the workplace, build healthy teams, and navigate constant change. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Businesses Receiving Government Assistance
-
Online
2.00 Credits
Member Price: $89
Many for-profit entities receive government assistance or are required to have financial statement or compliance audits due to law or regulation. This course will discuss the requirements under Generally Accepted Auditing Standards relevant to for-profit entity audits. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Common Financial Statement Disclosures
-
Online
2.00 Credits
Member Price: $89
Financial statement disclosures are important to provide the information necessary for financial statement users to make economic decisions. Disclosures further explain and clarify information provided in the basic financial statements, but also provide critical information about subsequent events, litigation risk, and other concerns. This course focuses on the most common financial statement disclosures for small- or medium-sized nonpublic entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Excel for Accounting Professionals Session 4: Conditional Summing and Lookups
-
Online
2.00 Credits
Member Price: $319
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.*
2026/27 Not-for-Profit GAAP Update
-
Online
1.00 Credits
Member Price: $55
Stay current on the latest accounting developments affecting not-for-profit organizations with this timely GAAP update. This course reviews recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline. The course also introduces the International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025. Participants will gain perspective on the purpose and structure of INPAS and how it compares conceptually to U.S. GAAP requirements for NFPs. This course is designed to help practitioners, financial leaders, and auditors of not-for-profit organizations understand both current GAAP requirements and emerging global developments shaping the future of nonprofit financial reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
2026 Business Tax Credits
-
Online
1.00 Credits
Member Price: $55
Tax credit and incentive programs offer significant but rarely utilized savings. This presentation will introduce the most important federal and California tax credits and incentives available to business taxpayers. Attendees will hear an overview of these benefits and learn how to identify these opportunities for their clients.Delivery Method: Individual webcastCPE Credit: 1Program Level: Overview
The Controller Function - Inventory Part 1
-
Online
1.80 Credits
Member Price: $79
This course is one of the courses dedicated to our Controllership series. This series of courses is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we will discuss the area of inventory. This specific segment in the first part of a two-part series on inventory. We explore how the controller can move these responsibilities into more of a strategic role. This course takes a look at some of the typical concepts and duties involved in the inventory function that is sometimes viewed as operational roles. We explore how these areas are strongly tied to the importance of the controllership role and how the controller can add value in each area. Delivery Method: Individual webcast CPE Credit: 1.8Program Level: Basic