CPE Catalog & Events
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Online
2.00 Credits
Member Price: $99
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
See more dates
How AI Is Automating Internal Control
Online
4.00 Credits
Member Price: $149
The term "artificial intelligence" (AI) has become mainstream and while most have a layperson's understanding of AI, few know the depth and breadth of this technology's capability. AI is affecting just about everything in business and in people's personal lives. The operation of an internal control system is also changing because of this incredible advancement. This session explains what AI is and how it works and then goes into detail about how it can be applied to a system of internal control. The material speaks about changes occurring in today's world as well as what's coming in the not-too-distant future. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Introduction to Yellow Book: 8-Credit Boot Camp
Online
8.00 Credits
Member Price: $239
This course is designed for accountants in public practice and industry who focus on nonprofit and governmental entities. We will cover the basics needed to understand what makes nonprofit and governmental accounting & auditing unique. The course starts with the key financial reporting differences for governmental and nonprofit entities and then switches focus to review the fundamentals of Yellow Book and Uniform Guidance audits. This foundational course is perfect for those getting started in the nonprofit and governmental arena and those looking for a refresher. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Accounting (governmental), Auditing (governmental)Program Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Analyzing Financial Statements
Online
2.00 Credits
Member Price: $89
This course provides tools and insights into financial statement analysis - both quantitative and qualitative. We'll look not only at the three main financial statements but also dive into the MD&A and footnotes. We'll also discuss the affect of industry nuances on comparability of different analysis tools. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
See more dates
An In-Depth Understanding of the Generation Skipping Transfer Tax
Online
2.00 Credits
Member Price: $79
This course provides a focused and practical overview of the Generation Skipping Transfer (GST) Tax, designed specifically for professionals involved in estate and gift tax planning. As Part 4 of the Form 706 and 709 series, this session zeroes in on the rules, definitions, and application of GST tax, including the mechanics of calculating the inclusion ratio and how the GST exemption operates in real-world planning scenarios. Participants will gain clarity on how to identify skip persons, the types of transfers subject to the GST tax, and the proper treatment of direct skips, taxable terminations, and taxable distributions. Through clear examples and practical instruction, this course walks participants through voluntary, timely, late, and retroactive GST exemption allocations. With increasing regulatory complexity and heightened exemption limits, understanding the GST tax is critical for practitioners assisting clients in multigenerational wealth transfers. This course supports more accurate return preparation and strategic allocation of exemptions to minimize tax exposure. *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 webcastCPE Credit: TaxesProgram Level: Basic
Criminal Tax: How CPAs Bring Value to Defense Attorneys
Online
2.00 Credits
Member Price: $89
CPAs can be requested to assist attorneys in litigation support in criminal proceedings. For criminal tax cases, the IRS has recommended prosecution. However, the rules and stakes are different than a simple civil audit. This presentation will focus on how to assist defense attorneys in calculating tax loss, asking the right questions, and probe possible weaknesses in criminal tax investigations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
See more dates
Auditing Standards Update & Best Practices 25-26
Online
4.00 Credits
Member Price: $175
In every audit, the auditor must identify and assess the risks of material misstatement in the financial statements, whether due to fraud or error. This process includes understanding the entity and its environment, including its internal control, thereby providing a basis for designing and implementing responses to the assessed risks of material misstatement. This program explores efficient ways to conduct audits (primarily for private companies), including discussing the applicable standards and their requirements.Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Overview
See more dates
The One Big Beautiful Bill: 2025 tax legislation
Online
4.00 Credits
Member Price: $149
The President signed on July 4, 2025, one of most consequential tax legislation in recent years. The well-informed tax practitioner will want to stay abreast of these developments! This course will start with a short background of this legislation as it made its way through Congress and to the President's desk. We will then review the final provisions that was approved by the Senate and passed by the House. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: OverviewThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
See more dates
Disrupt to Dominate: Mastering Change Leadership
Online
4.00 Credits
Member Price: $149
In an era defined by rapid change and uncertainty, effective leadership requires more than just managing teams; it demands the courage to disrupt and innovate. This course is your blueprint for transforming potential chaos into a strategic advantage and is designed for leaders at all levels-whether you're a seasoned CEO, an ambitious small business owner, or an individual contributor aspiring to influence greater change. You'll gain the insights and tools needed to not only adapt to change but to lead it effectively and confidently. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Business management & organizationProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Taxation of the Cannabis Industry
Online
2.00 Credits
Member Price: $89
This course offers a comprehensive exploration of the cannabis industry, delving into essential topics such as cannabis regulations, business models, financial management, and ethical considerations. A key focus is on distinguishing between Marijuana and Industrial Hemp, including their respective tax treatments. Participants will gain a thorough understanding of the unique challenges and opportunities within the cannabis sector, covering federal and state tax implications, licensing requirements, and market trends. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
The Crucial Connection - Why You Should Care About Your Client's System of Internal Control
Online
1.50 Credits
Member Price: $99
Conduct risk assessment the right way Regardless of the size of your client or audit budget, there are specific requirements in accounting standards and generally accepted auditing principles (GAAP) related to auditing internal control for risk assessment purposes. Take a deep dive into understanding your audit client's system of internal control to perform a more effective and efficient audit.Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by AICPA.
Risk Assessment Under SAS No. 145: The Key to Audit Quality?
Online
2.00 Credits
Member Price: $89
The AICPA has identified risk assessment as an area of focus for its Enhancing Audit Quality Initiative as deficiencies in auditor's risk assessment procedures continue to be a common issue identified in peer review. SAS No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was written to improve the quality of risk-based audits. While key concepts do not fundamentally change, the standard works to clarify and enhance certain aspects of the identification and assessment of the risks of material misstatement to drive better risk assessments and hopefully overall enhance audit quality. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Surgent's Employee Stock Options: What Financial Professionals Should Know When Advising Their Clients
Online
2.00 Credits
Member Price: $99
Companies often offer stock options as an additional form of compensation to attract and retain the best talent. Used appropriately, stock options can generate significant wealth, yet many employees are unfamiliar with how stock options work and why options serve as a valuable opportunity for employees to establish and grow their wealth. Unfortunately, employees who receive stock options are often unaware of their inherent risks. Research has shown that over 76% of employees have never exercised their stock options. Almost half of these individuals (48%), say they held off on selling their options due to fear of making a mistake. This course provides accounting and finance professionals with a broad overview of employee stock options. The webinar is designed to help participants better understand the fundamentals behind these investments and, in turn, better advise their clients.Delivery Method: Individual webcastCPE Credit: Specialized knowledge, TaxesProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Excel: Mastering PivotTables
Online
2.00 Credits
Member Price: $99
PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
See more dates
OBBA of 2025: Individual Overview
Online
2.00 Credits
Member Price: $79
THE ONE BIG BEAUTIFUL BILL IS NOW THE ONE BIG BEAUTIFUL ACT!!! (Signed into law on July 4, 2025!). This program provides a summary of the major individual provisions of the OBBA of 2025 (H.R. 1), with a focus on the extended provisions, provisions made permanent without changes and those major changes, and new provisions for 2025 and beyond. *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 webcastCPE Credit: TaxesProgram Level: Intermediate
How AI Fits into the Accounting World
Online
2.00 Credits
Member Price: $89
This session is designed as a primer to introduce artificial intelligence (AI) and to discuss how it will impact accountants as they work. The material will briefly explain what AI is and then focus on ways that it is already serving those in the accounting realm. It will close with a look at future AI-centric developments that will have great potential to positively impact the accounting profession. Those wishing to gain an understanding of what artificial intelligence is and how it will be used by accountants should consider attending 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.Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
See more dates
Controls to Secure the Growing Digital Footprint
Online
4.00 Credits
Member Price: $149
The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they, and their companies secure digital information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
AI Lessons Learned for Accountants
Online
2.00 Credits
Member Price: $89
This course provides accountants with the leading AI insights and strategies drawn from real-world experience, empirical studies, countless CPA case studies, and social media commentary. It goes beyond theory, offering practical lessons learned from the front lines of AI implementation in the business world and accounting industry. Participants will gain actionable knowledge on bridging the theory-application gap, navigating exponential technological changes, and creating secure, adaptive AI policies. By the end of the session, accountants will be equipped to leverage AI responsibly and innovatively in their roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Take Command of your Time
Online
2.00 Credits
Member Price: $89
Manage distractions, decrease stress and improve productivity. This training is designed to help business professionals improve their productivity and work performance by learning how to prioritize time, decrease distractions and lower stress. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Personal developmentProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
See more dates
Partnership Tax Updates (2025)
Online
2.00 Credits
Member Price: $89
The well-informed tax practitioner will want to attend this two hour program in order to stay current on recent updates on partnership tax! Content includes recent court decisions on partnership tax issues as well as current IRS procedural updates for passthroughs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.