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
Internal Control - Testing for Operating Effectiveness
-
Online
2.00 Credits
Properly designed and effectively operating internal control over financial reporting is critical for preventing, or detecting and correcting, material misstatement. This course describes how to satisfy the audit requirements related to taking a control reliance strategy by testing the operating effectiveness of internal controls, while promoting an effective and efficient financial statement audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: The Controller Function - Inventory Part 2 - Valuation, Inventory Methods and Inventory Fraud
-
Online
1.50 Credits
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 continue our discussion on inventory from segment one. This specific segment focuses on areas of inventory valuation, the types of physical inventory methods, and inventory fraud. These areas are critical for the controller to have a strong comprehension of and also participate in the development of policies and procedures. Presented by: Lynn FountainType: Live Webcast Replay
Finding Errors in Excel Spreadsheets
-
Online
2.00 Credits
This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Selected Ethics Topics 2025 - 2026
-
Online
2.00 Credits
This course will help you to stay current on recent changes to the AICPA Code of Professional Conduct, as well as keep you abreast of emerging trends in ethics standards and regulatory initiatives and their potential impact on your practice. We will also explore frequent practitioner ethics compliance challenges, including competence, due professional care, audit quality, and independence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethics, Spirituality, Love and Belonging in the Workplace
-
Online
2.00 Credits
This webinar invites participants to explore the powerful intersection of ethics, spirituality, love, and belonging in the workplace. By shifting from transactional interactions to values-driven communities, organizations can cultivate cultures that honor human dignity while enhancing productivity. This is a heart centered and practical webinar emphasizing how love, belonging and spirituality shape ethical choices. Through a blend of practical strategies for personal and organizational growth and research- based insights, the session demonstrates that these elements are not optional "nice-to-haves." Instead, they are essential drivers of organizational success; shaping environments where people feel valued, connected, and inspired to contribute their best. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Revenue Recognition Topic 606 Contract with Customers - Identify the Contract Part 2
-
Online
1.20 Credits
This course is a continuation of discussion over Step One in the revenue recognition process of Identify the Contract. Specifically, this session delves further into the considerations surrounding contract modifications, change orders, unpriced change orders, cancelations, non-finalized changes and accounting treatment when a contract does not exist. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Neurodiversity & Productivity. Include More Minds to Make the Most of Your Time
-
Online
1.00 Credits
Being neuro-inclusive is not only kind, but can also help your team get the right things done in less time. This course will be about what neurodiversity is, give an overview of brain science, and show you tactical tips and techniques you can use to help your company get more of the right things done in less time with a strategy designed with more brains in mind. Presented by: Christine WilsonType: Live Webcast Replay
ACPEN: The Controller Function - Elevating the Role
-
Online
1.50 Credits
This is the beginning of a series that will cover major aspects of the Controllership function. Controllers are essential to the day-to-day accounting for organizations. Yet, the role is not often readily understood. In today’s world of acronyms such as CFO, CEO, COO, CAO, etc., the Controller function may get lost in the shuffle. However, they are a critical group of professionals who ensure the adequacy and transparency of accounting and financial reporting information. A Controller is an individual who has responsibility for all accounting-related activities including high-level accounting, managerial counting, and finance activities within a company. The duties of a Controller include assisting with the preparation of the operating budgets, overseeing financial reporting, and performing essential duties relating to payroll. However, in today’s evolving world, the Controller function can provide much more in-depth value to their organizations. This series is dedicated to exploring the traditional Controller role and stepping out of the box to identify areas where the Controller can add strategic value to their organizations. In this first course we focus on the typical Controller function and begin to identify ways to elevate the function. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Leaders Eat Last. Why? The Characteristics of Great Leaders
-
Online
2.00 Credits
If a great leader is someone we are willing to sacrifice for – what do those leaders do that makes us want to do more? Many of us work in dysfunctional organizations that want followers, but have no leaders that lead. What makes a leader effective? True leaders sacrifice, they are trustworthy and they empathize. We discuss the steps to take so you can become a true leader: including, integrity, humility, communication, self-control and self-awareness. With diligence, you can become a better leader and we will discuss how. Presented by: Don MingesType: Live Webcast Replay
ACPEN: The Motives and Mystery of Ethics-Understanding the Why
-
Online
2.00 Credits
Our guidance on ethics comes from the AICPA and other groups, but it does not fully address the “why” behind ethics. This session will examine and define what ethics is and what it means to varying people in the workplace. 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? Presented by: Bob MimsType: Live Webcast Replay
ACPEN: Budget Mastery: Walkthroughs and Real World Calculations Towards Tying Budgets To Value
-
Online
2.00 Credits
This session takes a unique review of the fundamental budget issues faced by all and walks through a detailed modeling process intended to generate discussion and best practices to improve your organization’s financial modeling. From the beginning of the accounting process – ‘the chart of accounts’ to the end of the process – ‘the valuation of the company’, the budgeting cycle via a live case model to learn best practices common to successful companies. This course stands on its own but is part two of a four part budget mastery series. Presented by: Bob MimsType: Live Webcast Replay
ACPEN: K2’s Collaboration – Best Platforms And Practices
-
Online
2.00 Credits
Collaboration remains one of today's hottest topics. Technology has fueled today's collaboration options, and work-from anywhere environments virtually demand collaboration platforms. In this session, you will learn today's best tools and practices to facilitate more effective collaboration in your organization. In this session, you will learn about today's mainstream collaboration platforms & Microsoft 365, Google Workspace, and Zoho - and how these options are similar and differ. You will also learn about other collaboration options, including Slack, Zoom, and Webex, and you can incorporate these tools into your collaboration environments. Further, you will learn about some of the best practices and procedures that must be in place to optimize your collaborative environments and experiences. Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: Estimates, Contingencies and Going Concern
-
Online
2.00 Credits
This course covers a broad range of topics involving uncertainty in accounting and auditing. It addresses accounting standards related to going concern, contingencies, guarantees, and credit losses, along with auditing standards applicable to auditing accounting estimates and evaluating going concern. The course provides a practical overview of how these areas are addressed under current standards and how they impact financial reporting and audit procedures. Jeff presents the material in an engaging manner to reinforce key concepts and maintain focus. Presented by: Jeff SailorType: Live Webcast Replay
ACPEN: Rethinking Your Customers to Maximize Profitability: Identifying the Right Clients
-
Online
2.00 Credits
Some customers are unprofitable from an economic or time perspective – but many organizations do not differentiate or know the difference. When an organization has a unique, well-differentiated service or product, understanding value from the customer’s perspective becomes a crucial factor in profitable pricing. We must take the time to fully understand what our customers value - from the customer’s point of view. What is value? Why do brand, value, and customer focus matter? Developing a deep understanding of our customers is vital. Our most important customer might be someone we have not yet recognized. Understanding both external clients and internal stakeholders - including the evolving role of the finance department, is critical to long-term success. Using humorous video clips, memes, and vetted research, your understanding of customer bases will improve. Presented by: Bob MimsType: Live Webcast Replay
ChatGPT and Advanced Accounting Research
-
Online
2.00 Credits
This course provides a concise overview of how artificial intelligence, particularly ChatGPT and other AI tools, is transforming accounting research methodologies and practices. Students will explore the shift from traditional search engine-based research to AI-driven insights, learning how to leverage various AI platforms for enhanced financial analysis, regulatory compliance, and strategic decision-making. The course emphasizes practical applications of AI in accounting contexts while addressing critical considerations such as data verification, ethical usage, and professional judgment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
S Corporations: Calculating Shareholder Basis
-
Online
2.00 Credits
A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination. An illustrative example demonstrates how the process works, as well as the many 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.
ACPEN: Accounting for Leases
-
Online
2.60 Credits
In February 2016, FASB issued ASU 2016-02, Leases, which provides new guidelines that change the accounting for leasing arrangements. To be able to properly account for leases, financial professionals must understand ASU 2016-02 (also referred to as Topic 842). This guidance covers information on how leases should be accounted for. The previous leasing standard (ASC 840) had been in existence for almost 40 years. Under ASC Topic 842, lessors continue to classify leases as operating, direct financing, or sales-type. While lessees now classify leases as operating or financing leases. Previous guidance only required capital leases to be reflected on the BS. The new guidance requires all leases to be reflected on the BS. This is a major change for organizations and will cause their balance sheets to swell as leases must now be disclosed on the balance sheet. The standards original effective dates were prior to 2019. In April 2020, due to COVID-19, FASB voted to defer the effective date for ASC 842 for private companies and certain not-for-profit's for one year. For private companies and private not-for-profits, the leasing standard will be effective for fiscal years beginning after December 15, 2021, and interim periods within fiscal years beginning after December 15, 2022. For public companies the leasing standard is effective for fiscal years beginning after December 15, 2019, including interim periods within those fiscal years. The course covers elements of lease classification for both lessees and lessors. Also, numerous examples are incorporated as reference. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Key Tax Issues Facing Business & Industry
-
Online
4.00 Credits
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 Presented by: Doug Van Der AaType: Live Webcast Replay
ACPEN: Common Yellow Book & Single Audit Deficiencies
-
Online
4.00 Credits
Yellow Book and Single Audit engagements are routinely selected for peer review and continue to be areas of heightened scrutiny by peer reviewers and federal oversight agencies. This course examines common deficiencies identified in governmental and Single Audit engagements, with a focus on understanding why these issues arise and how they can be avoided. Participants will review frequent deficiencies related to Yellow Book requirements issued by the U.S. Government Accountability Office, including independence, CPE, and reporting considerations. The course also addresses common Single Audit deficiencies, including internal controls over compliance, compliance testing, and major program determination. Designed for auditors performing governmental and Single Audit engagements, this course helps participants recognize recurring problem areas and better understand the requirements that continue to drive peer review findings. Presented by: Melisa GalassoType: Live Webcast Replay