CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
ACPEN: K2’s Mastering Advanced Excel Functions
-
Online
4.00 Credits
With approximately 500 functions now available in Excel, some newer and more powerful tools are easily overlooked. But if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel's more advanced features-some new and some legacy-to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel's FORECAST.ETS function. Regardless of your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel. Presented by: Thomas StephensType: Live Webcast Replay
Executive Presence, Personal Brand: Structure Your Narrative
-
Online
1.00 Credits
Professional credibility is communicated, not assumed. In this 1-CPE session (Professional Development), participants examine structured approaches to articulating their professional identity. Drawing directly from the course framework, the session covers development of an elevator pitch, a professional value proposition, and a concise executive biography. Participants will analyze how credibility is established through clarity, relevance, and alignment with audience needs. The course emphasizes service-centered communication rather than self-promotion and provides structured guidance for refining professional messaging in leadership and client-facing contexts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Staff Retention Keep the Best People
-
Online
3.00 Credits
The COVID pandemic changed the way many people worked, yet others have had remote teams for decades and little changed. Many organizations trying to bring people back to the office have experienced significant turnover. Some practices have changed forever while some principles will always remain the same. Keeping your people happy equals keeping your best people. Learn the changes you should make now and the things you should do forever! Presented by: John DalyType: Live Webcast Replay
Volume to Value: A New Era of Precision Hiring in Accounting
-
Online
1.00 Credits
Volume to Value: A New Era of Precision Hiring in Accounting examines how accounting firms are shifting from high-volume recruiting models to "precision hiring" as AI adoption accelerates and talent scarcity continues. Participants will explore why traditional hiring processes often overemphasize technical accounting knowledge while under-assessing the competencies that most impact performance-critical thinking, professional communication, and AI ethics awareness. The course explains how AI-enabled recruiting tools can support candidate screening, assessment, and retention forecasting, and why firms that do not modernize their hiring approach may struggle to compete for top talent. Participants will leave with practical approaches to competency-based assessment, ethical guardrails for AI use in hiring, and a high-level implementation roadmap with metrics to evaluate quality of hire, performance, and retention. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Analytical Procedures: Practical Applications and Standards
-
Online
2.00 Credits
This session explores the nature of analytical procedures, with significant emphasis placed upon professional standards involving the use of analytical procedures in audit and review engagements. Practical examples to illustrate the application process will also be given. Presented by: Dr. Chris HarperType: Live Webcast Replay
ACPEN: Common Sense CFO: Dealing with Ever Changing Accounting Standards and Strategy Demands
-
Online
2.00 Credits
GAAP is changing at an increasing rate. Every successful organization has a sound strategy. Financial leaders are faced with the dual challenge of navigating evolving accounting standards while strategically guiding their organizations toward sustainable growth and profitability. What are the newer accounting changes that will impact professional accounting? This seminar will equip finance professionals with the critical skills and practical insights needed to effectively manage the complexities of ever-changing accounting standards and upgrade your essential strategic planning skills. Strategic skills are mandatory today. Strategies that do not keep pace with the market are doomed to fail. If we do not keep up, our successor will. Presented by: Bob MimsType: Live Webcast Replay
ACPEN: K2’s Taking Another Look At Power BI
-
Online
2.00 Credits
Although Power BI has been available for ten years, most business professionals don't fully appreciate all it can do and its easy use. Further, many are intimidated by the platform and continue to use less efficient and effective reporting practices. If this describes you, invest some time in this session to learn how to work with Power BI almost immediately. In this session, you will learn how to use Power BI to create compelling dashboard reports. You will also learn how to optimize these reports to enhance their effectiveness. If you want to improve financial and operational reporting processes, this session is for you! Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: Five Amazing Business Books in 100 Minutes
-
Online
2.00 Credits
If you are efficient and want to learn lessons from the best in a short time, this seminar is for you. Popular speaker Don Minges will review the key lessons from five fantastic business books that will help you become more effective. The topics are; leadership, how to create a valuable business, how to turnaround a business, how to make terrific presentations and how do humans think? These lessons are valuable for every business leader. Presented by: Don MingesType: Live Webcast Replay
ACPEN: Ethical Practices and Responsibilities Under Circular 230
-
Online
2.00 Credits
The IRS has recently issued proposed regulations to update the Circular 230 rules for all tax practitioners, amending these rules in various ways to reflect changes in the law. This session will review these new rules and discuss their impact on your tax practice. The course also covers in detail major provisions of Circular 230 and analyses them using factual situations. *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Handouts Tab and submit to kori.herrera@acpen.com Presented by: Steven DilleyType: Live Webcast Replay
ACPEN: Drive Results with Metrics
-
Online
2.00 Credits
Many organizations struggle to keep budgets current in an ever-changing business climate. Twenty-first century performance metrics focus on determining what budgets should be rather than what they were in the past. Using performance metrics effectively reduces work, reduces politics, provides flexibility and substantially improves the performance management process. This session will show you powerful techniques to drive your organization’s performance. Presented by: John DalyType: Live Webcast Replay
Becoming Conflict Competent
-
Online
2.00 Credits
Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles, and build constructive behaviors to manage conflict. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Navigating IRS Collections: The Collection Process
-
Online
2.00 Credits
This course is designed for tax professionals seeking to understand and navigate the IRS collection process effectively. Participants will gain indepth knowledge of the various collection methods employed by the IRS, including liens, levies and wage garnishments. Additionall, participants will leand strategies to avoid or halt collection actions and the implications of the statute of limitations on tax collection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Controls to Secure the Growing Digital Footprint
-
Online
4.00 Credits
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.
ACPEN: Federal Tax Update – Individuals (Form 1040)
-
Online
8.00 Credits
With the increasing complexity and ever-changing nature of tax laws and issues, today’s accountant needs a one-day update course focusing on individual income tax issues with an emphasis of newly enacted income tax legislation. This comprehensive class will not only review the current Federal individual income tax laws but will also update tax return preparers of new tax forms, changes to existing tax forms, as well as tax planning opportunities and pitfalls. This is a “must-attend” course for all tax practitioners who want to be up to speed quickly and have a successful Federal individual income tax filing season. *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 Presented by: J. Patrick GarverickType: Live Webcast Replay
ACPEN: K2’s Excel Essentials For Staff Accountants
-
Online
8.00 Credits
Staff accountants often face unique challenges when working with Excel, and their existing knowledge might not always meet their needs. This comprehensive eight-hour session is designed to bridge that gap and empower you with the essential skills to maximize efficiency and accuracy. Participate in this dynamic and engaging session, and you will learn how to: • Summarize data quickly and accurately • Generate stunning, professional reports • Create essential accounting calculations for depreciation, amortization, and interest We start with a quick overview of Excel best practices and dive into advanced topics like PivotTables, sophisticated formulas, Tables, formatting, and working with dates. Our course is packed with accounting-centric examples to reinforce key learning points. Plus, you'll enjoy a "laptop-friendly" environment with access to all demonstration files. This seminar is a must for all staff accountants eager to enhance their Excel skills and transform their workflow. Don't miss out on this opportunity to elevate your Excel expertise and take the first step towards mastering Excel today! Presented by: Thomas StephensType: Live Webcast Replay
Surgent's Advanced Audits of 401(k) Plans: Best Practices and Current Developments
-
Online
8.00 Credits
Looking to improve the quality of your 401(k) benefit plan audits? This is the course for you. Based on recent data from the U.S. Department of Labor and peer reviews on employee benefit plan audits, we know auditors need to up their game to meet stakeholder demands and provide the best possible audit services. In this advanced course, we will discuss the audit and reporting requirements in accordance with auditing standards. We will also discuss laws and regulations (such as ERISA) that are unique to employee benefit plans and provide practical guidance on their application. Course topics will focus on the most common compliance issues identified in 401(k) audits by the Department of Labor and peer reviews, as well as recommended corrections. Auditors will identify best practices for auditing areas such as payroll and compensation, participant loans, hardship distributions, investments, and plan mergers and acquisitions.
Untying the Knot: Taxes & Divorce
-
Online
8.00 Credits
Description: Divorce brings emotional and financial challenges and navigating the tax implications can be one of the most complex aspects. This in-depth, 8-credit webinar, Untying the Knot: Taxes and Divorce, is designed to equip tax professionals with the knowledge and strategies needed to guide clients through the intricate tax issues that arise during and after divorce. What You'll Learn: This comprehensive session will cover critical topics, including: - Filing Status: Determining the correct filing status during and after divorce. - Qualified Domestic Relations Orders (QDROs): Tax implications of dividing retirement accounts. - Back Taxes: Strategies for addressing unpaid tax liabilities during and after divorce. - Offers-in-Compromise & Installment Agreements: Resolving tax debts with the IRS. - Currently-Not-Collectible Status: Understanding when and how to use this option. - Innocent Spouse & Injured Spouse Relief: Protecting clients from unfair tax liabilities. - Lien Discharges & Subordinations: Managing IRS liens on property during divorce. - Reasonable Compensation: Evaluating fair compensation in divorce-related business valuations. - Case Studies: Explore unusual and complex tax issues in divorce through real-world examples. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Forgotten Managerial Accounting Tools for CPAs
-
Online
2.00 Credits
This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Power Skills: Professionalism and Client Interactions
-
Online
2.00 Credits
Client interactions and professionalism are at the core of what we do as accountants. However, communication with clients is not always as straightforward as it may seem. Sometimes there will be difficult conversations and disagreements that can be tough to navigate. During this course, we will discuss best practices when communicating with the client and also walk through complicated scenarios to practice what we learn. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
What's Changing in A&A for Governmental Entities (2026/27)
-
Online
4.00 Credits
This comprehensive course provides a timely update on key accounting and auditing developments affecting governmental entities, bringing together recent standard-setting, auditing, and compliance changes into a single, cohesive learning experience. Participants will begin with an update on major pronouncements issued by the Governmental Accounting Standards Board, including GASB Statements No. 103, 104, and 105, along with a high-level overview of active GASB exposure drafts and ongoing projects. Emphasis is placed on understanding how these changes affect governmental financial reporting, disclosures, and communication with stakeholders. The course then shifts to auditing developments, covering significant updates to the Yellow Book issued by the U.S. Government Accountability Office, including changes related to quality management, effective dates, and recent updates to the Green Book. Participants will also gain insight into the GAO's implementation delay and its implications for audit planning. Finally, the course addresses recent changes affecting Single Audits, including the 2024 Uniform Guidance overhaul, updates to Appendix B of the AICPA GAS/Single Audit Guide, recent Office of Management and Budget (OMB) memoranda, and reporting changes related to SAM.gov. Designed for auditors, preparers, and financial leaders working with governmental entities, this course helps participants understand how recent accounting and auditing changes intersect-and what to watch for as expectations continue to evolve. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.