CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Excel for Accounting Professionals Session 5: Error Trapping and Improving Lookups
-
Online
2.00 Credits
Practical hands-on Excel learning exercises taught by a highly engaging expert in the field You'll develop your expertise with real-world Excel workbooks. Despite the popularity of VLOOKUP, it has its drawbacks. This session will address these drawbacks while offering alternatives. You'll walk through the VLOOKUP and IFERROR functions, and explore the following topics: Improving the use of VLOOKUP with VALUE/TEXT Improving the use of VLOOKUP with MATCH. Moving beyond VLOOKUP with INDEX Trapping errors with IFERROR Moving beyond basic Excel functions Grasping the limitations and possible enhancements for the VLOOKUP feature, along with methods to handle errors can elevate your proficiency in Excel. You'll also partake in hands-on Excel activities that showcase the integration of functions and their use in crafting spreadsheets, encompassing: Combining functions to enhance flexibility Utilizing functions for atypical data categories Perfecting sophisticated lookup functions *Session 5 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 6: List Comparisons and Indenting] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-6--list-comparisons-and-indenting) to further prepare to tackle real-world issues and build powerful workbooks.*
How to Audit Inventory
-
Online
2.00 Credits
Inventory observations are often a right of passage for audit staff. This course will cover the basics of auditing inventory, including the related audit assertions, risks, & threats to inventory. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through how to conduct a physical inventory observation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Mastering Partnership Basis: Inside and Outside Basis
-
Online
2.00 Credits
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.
ACPEN: Managing Your Money in Retirement
-
Online
3.00 Credits
You spent your life building retirement savings. Now you want to make sure your savings last the rest of your life and perhaps pass some on to the next generation. Come hear a veteran financial educator talk about money management and planning issues for this phase of your life. Presented by: John DalyType: Live Webcast Replay
Surgent's Representing a Client in an IRS Audit
-
Online
3.00 Credits
The Inflation Reduction Act of 2022 called for delivering nearly $80 billion to the IRS over 10 years to allow the IRS to purchase new technology and hire employees. This funding would have provided the IRS with new equipment and new employees, possibly to handle more audits, many of them involving very complex tax issues. The Trump Administration has reversed this with prospects for a reduction in IRS employees and less money to fund the purchase and development of new software. This program discusses the current state of IRS audits. Trump administration changes will of course have enormous impacts on these audits going forward.
Surgent's Government and Nonprofit Frauds and Controls to Stop Them
-
Online
4.00 Credits
The cost of fraud, dearly paid by governments and nonprofits, is too severe to not learn from past experiences. This course examines real-world fraud cases to uncover the lessons they provide and translate them into practical, preventive controls. Using a highly illustrative and innovative format, the course engages participants with over 15 focused exercises designed to build a strong working knowledge of fraud risks and effective anti-fraud controls. Whether you are an auditor or an industry professional, you'll gain actionable strategies to strengthen oversight, reduce vulnerabilities, and safeguard your organization.
Surgent's Management Fundamentals
-
Online
4.00 Credits
In a recent Gallup study, 50% of respondents quit because of their manager, which makes your managers and supervisors your company's first line of defense against costly turnover. This program looks at management from a broad perspective and then drills down into key skills needed to manage effectively.
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: Shortcuts to Personal and Professional Success
-
Online
8.00 Credits
We all want to be successful and deeply fulfilled, but most of us have not learned what really leads to a life of abundance, happiness, purpose, and great relationships. In this seminar, you will learn the most effective methods for creating the life you really want. In his interviews with such people as Oprah, the Dalai Lama, Deepak Chopra, Tony Robbins, Ted Turner, and dozens of others, Jonathan has learned what really works and what does not. In this seminar you’ll learn the best personal and professional growth techniques he’s acquired over his career. Once you know these great ideas and methods, you'll be able to take your life and career to a whole new level. Presented by: Jonathan RobinsonType: Live Webcast Replay
Implementing and Maintaining an Internal Control System
-
Online
8.00 Credits
Many organizations are successful as they create a system of internal controls, however some fail to properly implement the measures that are established. Moreover, entities regularly neglect the important process of testing, monitoring, and updating control procedures, which weakens the entire internal control structure. This session provides an overview of control creation methods and discusses ways to successfully implement policies and procedures. Additionally, it includes an array of control maintenance checklists that participants can take and adapt to their organization as they work to improve policies and procedures. Finally, it provides an understanding of the need for dynamic, fluid controls that adapt to changes in business tools and methods. Participants that take this course will have a strengthened ability to implement and maintain an internal control system. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Perplexing Financial and Economic Issues for the CFO/Controller
-
Online
8.00 Credits
For CFOs and Controllers, the emergence of regulatory, fiscal, and monetary policy directly impacting their organizations' costs, competitiveness, and financing options, are causing them to understand the effect of shocks well outside of their control. The Dodd-Frank Act, health care reform, shortfalls in Social Security, unfunded pension liabilities, and deficit spending will all be explored relative to their impact on the CFO/Controller and your organization.
The Best Individual Income Tax Update Course by Surgent
-
Online
8.00 Credits
This highly informative course comprehensively covers all the latest tax law developments. The focus is on individual taxation and discussion of the planning opportunities practitioners need to understand to help clients respond effectively. You will come away from the course with the up-to-date knowledge to educate your individual tax clients and implement tax-saving ideas that will serve their ever-evolving needs. This course is continually updated to reflect enacted legislation. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BFTU.
AI & Accounting in Retail
-
Online
2.00 Credits
This course provides a concise overview of how artificial intelligence (AI) is transforming financial strategies, tax compliance, and audit practices in the global retail industry. As retailers deploy AI to personalize customer experiences, automate inventory, and optimize pricing, accounting professionals must adapt to new challenges in data integrity, regulatory compliance, and financial reporting. Drawing on real-world case studies from retail giants and small businesses alike, this course explores how AI technologies intersect with accounting workflows and outlines strategies to maintain accuracy, trust, and control in an AI-driven marketplace. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Hot Topics Accounting Update - 2026
-
Online
2.00 Credits
Many accountants desire to have a quick overview of only the most current issues in accounting and financial reporting. This course will provide an executive summary of the most important changes in U.S. GAAP. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Professional Skepticism for the Public Accountant
-
Online
1.00 Credits
Accountants are expected to demonstrate a questioning mindset. While such professional skepticism is an obvious requirement for assurance engagements, it is applicable elsewhere in the practice of public accounting. In fact, a skeptical mindset offers benefits to both public accountants and those who work in industry. This course provides specific examples of professional skepticism while suggesting best practices. Presented by: Dr. Chris HarperType: Live Webcast Replay
ACPEN: Relationship Networking: The Art Of Conversation
-
Online
1.00 Credits
In the fast moving world where everyone is communicating through email, text and instant messaging we have forgotten the power of face-to-face conversation. Communication and connection is the foundation for building a thriving network and business. During this talk, The Connector’s Advantage author, Michelle Tillis Lederman will inspire you to leverage the power of personal connection in the digital age while still incorporating the efficiency of virtual communication. Presented by: Michelle Tillis LedermanType: Live Webcast Replay
ACPEN: Federal Disasters - How to Deduct Personal Casualty Losses
-
Online
1.00 Credits
Literally thousands of individual taxpayers may have increased deductions or exclusions from gross income as a result of the Disaster Relief Act of 2023 and OBBBA of 2025. Casualty provisions are retroactive to December 19, 2019 through late 2025. Both low and high-income taxpayers may benefit from RETROACTIVE AND CURRENT deductions. There are also exclusions of payments received as compensation for wildfire damages — retroactive to 2014! This course will review these provisions which can bring substantial tax savings to clients. *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: Steven DilleyType: Live Webcast Replay
ACPEN: Coaching Leaders to Handle Sensitive Employee Relations Situations
-
Online
1.20 Credits
This session provides HR Professionals with scripts for and tactics for coaching leaders in handling an array of employee relations situations with sensitivity, good judgment, and high confidence. Topics include employee complaints, personality & attitude problems, performance counseling, personal hygiene problems, disability-related performance issues, misconduct due to mental conditions. You will learn how to use a unique process, “Reset the Clock,” that prevents attorneys from taking something leaders did wrong or did not do in the past and using it to support legal challenges in the future. Liability is replaced with credibility. Lawsuits are then avoided rather than won. Financial assets are protected, morale stays high, and bad publicity is averted. HR Professionals avoid hearing from senior leaders: “You should have anticipated this” after an avoidable legal claim. Presented by: Mike MirarchiType: Live Webcast Replay
ACPEN: Internal Audit in The Future
-
Online
2.00 Credits
As organizations face accelerating change—AI adoption, cyber threats, regulatory expansion,ESG scrutiny, geopolitical instability—the role of internal audit is evolving rapidly. The future of internal audit is not about doing more audits. It’s about delivering forward-looking insight, strategic alignment, and intelligent risk coverage. Organizations, their environments and ways of working have evolved rapidly and in ways that had not been previously envision. IA must look within to determine how to stay relevant and add value in this changing and emerging environment. Presented by: Lynn FountainType: Live Webcast Replay
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.