CPE Catalog & Events
Digging Deep with Excel Pivot Tables
-
Online
1.00 Credits
Member Price: $39
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. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Can You Really Do That With AI?
-
Online
1.00 Credits
Member Price: $39
Artificial Intelligence has taken the world by storm. In just three short years, AI platforms such as ChatGPT, Gemini, and Copilot have revolutionized how business professionals approach everyday tasks. In this session, you will learn how you can use AI to help you solve specific problems and work more efficiently, effectively, and accurately. Throughout this session, we will focus on real-world scenarios and how AI can help you realize better results in less time. This is a must-see session for all who want to improve efficiency and effectiveness. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
2026/27 Governmental Auditing Update: Yellow Book & Uniform Guidance
-
Online
2.00 Credits
Member Price: $89
This comprehensive course provides a focused update on key auditing developments affecting governmental and Single Audit engagements. The course integrates recent changes to the Yellow Book issued by the U.S. Government Accountability Office with major updates to Uniform Guidance and related Single Audit requirements. Participants will begin with an overview of significant revisions to the 2024 Yellow Book, including changes related to quality management, key audit roles, and effective dates. The course also addresses the GAO's implementation delay and its implications for audit planning, along with recent updates to the Green Book that may affect internal control considerations for governmental entities and Single Audits. The course then shifts to recent developments affecting Single Audits, including the 2024 Uniform Guidance overhaul, updates to Appendix B of the AICPA GAS/Single Audit Guide, and guidance issued through the Office of Management and Budget (OMB). Reporting-related changes, including the transition to SAM.gov-based reporting, are also discussed. Designed for auditors working with governmental entities and federal awards, this course helps participants understand how recent auditing and compliance changes intersect-and what to monitor as expectations continue to evolve. Delivery Method: Individual webcast CPE Credit: 2Program Level: Update
Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting
-
Online
2.00 Credits
Member Price: $319
Which Excel function is your go-to? This session invites you to actively engage and practice with the instructor, exploring exercises demonstrated. In doing so, you'll gain a firmer grasp of common Excel functionalities, including: Data validation Conditional formatting Enhanced summing options Skinny rows Achieving proficiency in Excel features Gaining proficiency in Excel means learning to design workbooks that are both functional and streamlined. The facilitator will lead you through an array of formatting skills, formula functions, and beyond as we expand upon foundational Excel knowledge with topics such as: Managing data input for individual cells Using conditional formatting to prevent errors Enhancing productivity via the Subtotal feature Ensuring total formulas refresh automatically *Session 2 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 3: Workbook Design Principles and Organization] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-3--workbook-design-principles-and-organization) to further prepare to tackle real-world issues and build powerful workbooks.*
Surgent's Establishing State Residency and Saving Your Clients Money
-
Online
2.00 Credits
Member Price: $99
Many of our clients are moving to one of the seven states with no personal income tax, particularly Florida and Texas. Others may maintain multiple homes with an eye toward eventually establishing residency in a state with no income tax. This course will give you practical tips for your clients seeking to establish residency in a new jurisdiction. Cash-strapped states are increasingly attempting to assess taxpayers who have declared domicile and residency elsewhere, for example in Florida, to maintain their diminishing tax base. Arm your clients with the tools needed to save money by successfully establishing domicile and residency. As a practitioner, you can't afford to be unaware of the latest issues affecting so many relocating baby boomers and others. Avoid that state audit with the information provided in this entertaining webinar.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.
Surgent's Introduction to AI in Accounting
-
Online
2.00 Credits
Member Price: $119
This course introduces the foundational concepts of artificial intelligence (AI) and AI's relevance to accounting. Participants will explore various AI applications and understand the benefits, challenges, and future trends associated with AI integration in accounting. Case studies of successful AI implementation in accounting firms are included to enhance learning.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 Commonsense Approach to Auditing for Fraud
-
Online
3.00 Credits
Member Price: $89
As reported by the Association of Certified Fraud Examiners 2024 Report to the Nations on Occupational Fraud and Abuse, organizations lose an average of 5% of their revenues to fraud. Yet, the report disclosed that only 3% of all frauds are detected by the external auditor. However, the thing that management depends on the detect fraud is the external audit. To detect fraud an auditor must: Know what fraud looks like; be able to think like a thief; always maintain healthy professional skepticism; be able to recognize the risk of fraud; and build your audit program to look for fraud. Auditing For Fraud addresses each of these areas as well as several others. During this presentation, I will discuss how to distinguish between an error and a fraud; how to recognize the indicators of fraud; develop and refine a hypothec as to how a fraud was committed; who steals (the basic honest person) and why and lastly; how to prove intent. If you cannot prove intent, all you have is a dumb mistake! Chances are that after this presentation, you will never look at an audit the same way you do now. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Introduction to Amplified Management Practice (AMP)
-
Online
2.50 Credits
Member Price: $99
Introduction to Amplified Management Practice (AMP) is a high-impact, 120-minute crash course designed for leaders tired of juggling chaos, burnout, and broken systems. Whether you're an HR professional, executive, or manager, this session equips you with a practical, repeatable framework to lead with clarity, align your team with purpose, and build momentum without losing your mind, through the core AMP mindsets—Respect, Curiosity, Transparency, and Stewardship—and its three pillars—Vitalizing, Conducting, and Reinforcing—you’ll learn how to connect customer needs, strategy, and operations while inspiring innovation and meaningful change. Perfect for busy professionals, this course delivers quick wins and lasting impact, helping you lead smarter, not harder. Delivery Method: Individual webcast CPE Credit: 2.5Program Level: Basic
Key Tax Issues Facing Business & Industry
-
Online
4.00 Credits
Member Price: $149
This course focuses on the key federal tax issues affecting business from the internal accountant's point of view, with a focus on the major ramifications of the TCJA and other recent tax legislation and developments. Planning alternatives and the potential risks associated with those strategies will also be discussed. *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 terri.storer@acpen.com Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
The Big Beautiful Bill: Tax Reform 2025 and What's Ahead
-
Online
4.00 Credits
Member Price: $129
What The Big Beautiful Bill Means for You and Your Clients: Breaking Down Key Tax Provisions The “Big Beautiful Bill” is the most significant tax law package since the TCJA, and it’s now law. With dozens of TCJA provisions made permanent and plenty of new rules introduced, this session is packed with critical content for tax professionals. You’ll walk away understanding what’s changed, what’s new, and what to prepare for across individual, business, and estate taxation. Art Werner breaks down key topics like bonus depreciation, enhanced 199A deductions, Trump accounts, SALT cap changes, estate planning, charitable limits, 1099-K thresholds, and much more. He’ll also examine areas with future sunsets, business incentives, and international tax provisions that could impact clients at all income levels. *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: Update
Seeing Beyond the Numbers: Analysis for CFOs & Controllers
-
Online
4.00 Credits
Member Price: $149
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.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.
S Corporation Preparation, Basis Calculations & Distributions – Form 1120S Schedule K & K-1 Analysis
-
Online
8.00 Credits
Member Price: $300
This comprehensive training is designed to get the accountant up to speed quickly with S corporation formation and preparation issues as well as a complete understanding of calculating a shareholder’s stock and debt basis. The cornerstone of this course is the in-depth line-by-line analysis of the Form 1120S Schedule K and K-1 and how these items affect the shareholder’s Federal individual income tax return. *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 terri.storer@acpen.com Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate
A&A Update for Nonprofits and Single Audit - 2026
-
Online
8.00 Credits
Member Price: $239
This course provides a high-level overview of the most important accounting, financial reporting, compliance and audit issues facing nonprofit entities and their accountants. The focus is on explaining the basis behind major issues and trends in executive summary (yet practical) form, enabling professionals to understand the most important aspects of relevant standards, and the basis for any potential changes on the horizon. 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.
ACPEN Signature 2026: Partnership and LLCs Update
-
Online
8.00 Credits
Member Price: $250
LLCs and partnerships continue to present some of the greatest challenges for return preparers and advisors. This program addresses the latest developments affecting these entities, including new IRS audit initiatives, updates on self-employment tax for LLCs and partnerships, disregarded entity rules and transactions, and common allocation issues. Participants will also review how to properly identify various types of partnership debt for basis purposes, understand the use of the §754 election in the sale of interests and at death, and explore reporting requirements for LLC and partnership interests on gift and estate tax returns, including valuation considerations for closely held businesses and minority interests. The session also examines the impact of the recent Sirius Solutions decision. Join us for the course! And as with all ACPEN courses, your questions to the panelists are encouraged. 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 terri.storer@acpen.com Delivery Method: Individual webcast CPE Credit: 8Program Level: Update
Supervised AI Agents as Internal Audit Team Members
-
Online
1.00 Credits
Member Price: $39
How should internal auditors and finance team leaders use Agentic AI? What are the dos and do nots? When deployed properly AI is wonderful. Can AI help with SOX testing? We review how to avoid the common mistakes that eliminate the benefits that AI can provide. Join us to learn about those expensive lessons. Agentic AI (‘Artificial Intelligence’) is rapidly being deployed by leading audit, compliance, and finance teams. While AI agents are not yet replacing all of today’s knowledge workers like auditors, accountants, and IT security professionals, the knowledge workers that effectively use Agentic AI may soon be replacing those knowledge workers who do not use these tools to drive high quality business growth and scale. AI is moving beyond automation to become a true teammate, especially in the governance, risk, and compliance processes. This session will show how supervised AI agents can work alongside accountants, auditors and IT security professionals to enhance efficiency, consistency, and assurance quality. Of critical importance is training and supervision so that the AI agents accomplish their testing to mee the intended quality standards. Attendees will leave with a practical view of how AI-powered testing can be applied to both internal and external assurance. Be prepared and learn from others. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Mining Your Firm Client Database for Revenue
-
Online
1.00 Credits
Member Price: $55
Your client database is more than a record of past engagements-it's a goldmine of untapped opportunity. In this practical and forward-thinking session, accounting professionals will learn how to strategically analyze and segment their existing client data to uncover new service opportunities, deepen relationships, and drive sustainable revenue growth. From identifying cross-selling potential to leveraging automation tools for proactive outreach, this webinar will equip firm leaders and client managers with actionable strategies to turn dormant data into dynamic business development. Whether you're a solo practitioner or part of a larger firm, you'll walk away with a roadmap for transforming your client list into a revenue-generating engine. 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.
Sustaining Wellness: Essential Skills for Preventing Burnout in High-Stress Professions
-
Online
1.20 Credits
Member Price: $39
In today's demanding work environment, professionals in high-stress roles often struggle to maintain their well-being, leading to burnout, fatigue, and decreased productivity. This interactive workshop provides practical strategies to build resilience, manage stress, and create sustainable wellness habits. Participants will engage in hands-on exercises, including mindfulness techniques, stress mapping, boundary-setting, and energy management strategies. Delivery Method: Individual webcast CPE Credit: 1.2Program Level: Basic
The Controllership Series: The Controllers Role in Compliance
-
Online
1.40 Credits
Member Price: $79
The controller has several broad areas to stay up to date on regarding compliance initiatives: Financial compliance Regulatory compliance Operational Compliance IT Compliance Delivery Method: Individual webcast CPE Credit: 1.4Program Level: Basic
Topic 842: FASB's Lease Accounting Standard Update
-
Online
2.00 Credits
Member Price: $89
It's a whole new world for lessees under ASC topic 842. Soon nearly all leases will need to be disclosed as a liability on the balance sheet - from buildings right down to autos and copiers. Although the greatest impact will be on large entities, this will affect the financial statements of small and mid-size entities as well. This program will dive into the new standard on leases, effective dates, and address what you need to know now. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Beyond the Numbers: Success Strategies for Female CPAs
-
Online
2.00 Credits
Member Price: $89
Women finance leaders face challenges that traditional corporate training and mentoring rarely prepare them to overcome. For example, you've demonstrated yourself as an excellent tactician, you know how to get the job done, and do it very well on your own. Yet, what got you to your current level of success won't get you to the next level. It's time to change the way you think and operate in your role. You need to move from doer to leader. You're familiar with the saying that if you want to go fast, go alone, if you want to go far, go together. In this workshop, you'll learn key strategies that are unique and critical to women to be successful in their careers. These strategies will help you grow, expand and elevate yourself professionally. 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.