CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
The 10 Must Know Excel Features
-
Online
2.00 Credits
Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Deep Dive Into Common Auditing Deficiencies
-
Online
4.00 Credits
This course will review common deficiencies identified by the AICPA and state boards of accountancy. It features discussion on a variety of topics, including analytical procedures, sampling, group audits and risk assessment. We will review the areas of concern and how you can overcome them by employing best practices. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Enact Retaliation Abatement and Monitoring Measures
-
Online
1.00 Credits
Once an employee decides to report an issue, the risk for retaliation must be minimized. Metrics matter. As such, capturing and reviewing employee data for indicators of possible retaliation are key to protecting those who report. The more subtle forms of retaliation, though, require a focused communication plan to address. This course offers recommendations for implementing specific retaliation monitoring protocols. Presented by: Robin RohmerType: Live Webcast Replay
ACPEN: It Is Legal, But Is It Really Ethical?, featuring Rob Berry and Bob Mims
-
Online
1.00 Credits
This discussion outlines situations where ‘legal’ and ‘ethical’ are not necessarily in alignment. How should you handle these issues? We will detail a better thought process to help you avoid ‘crossing the line.’ Presented by: Rob Berry, Bob MimsType: Live Webcast Replay
ACPEN: Conducting Human Resource Investigations
-
Online
1.00 Credits
Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session explores these differences and provides best practices for planning, executing, documenting, and reporting the results of an HR investigation. Attendees will end the session with takeaways to immediately implement in future HR investigations. Presented by: Daniel PorterType: Live Webcast Replay
ACPEN: The Controllership Series: The Controller's Role in Debt Management
-
Online
1.50 Credits
Debt Management: Debt management often involves administering loan agreements and ensuring bank compliance. Compliance: Controllers help ensure compliance with federal and local laws, provisions, and financial regulations. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: PowerPoint: Tips & Tricks for Today's Accountant
-
Online
2.00 Credits
PowerPoint is a widely available resource that is potentially underutilized by accountants because many accountants do not stray beyond Excel and Word in the Microsoft Office suite. You will learn how to create and edit a professional PowerPoint slide deck. This session places particular emphasis on efficiency tips and tricks that will allow you to develop creative, professional visual aids while minimizing time and effort. The course’s author will share personal insights he has cultivated throughout more than two decades of public speaking. Although the session will focus on creating and editing slides, we will illustrate best practices for presentation delivery. We will also explain how PowerPoint can be used for purposes other than delivering presentations. Presented by: Dr. Chris HarperType: Live Webcast Replay
ACPEN: Yellow Book Ethics
-
Online
2.00 Credits
The Yellow Book outlines essential ethical principles for governmental auditors, including serving the public interest, maintaining integrity, objectivity, and professional behavior. This course provides a focused review of these key concepts and their practical application in governmental auditing. Participants will also explore the independence standards, gaining insights on maintaining objectivity and avoiding conflicts of interest to ensure unbiased and professional audits. Presented by: Alex RomeroType: Live Webcast Replay
ACPEN: Mission-Critical Leadership: How Smart Managers Lead Well in All Directions
-
Online
2.00 Credits
Most leadership development focuses on a single direction within the organizational hierarchy: downstream to subordinates. While it is important to be a good boss, leadership is much more than that. The best leaders learn to lead well in all directions. They lead upward to superiors and across among peers throughout the organization. And it all starts with self-leadership. This often overlooked or misunderstood leadership principle is essential to build a thriving and productive culture. This topic is based on Jon’s book, Mission-Critical Leadership: How Smart Managers Lead Well in All Directions. Presented by: Jon LokhorstType: Live Webcast Replay
ACPEN: IFRS vs. US GAAP - Major Accounting Differences
-
Online
2.00 Credits
Whether a financial statement preparer or user is more familiar with IFRS or U.S. GAAP, it is important to be familiar with the important differences between the two financial reporting frameworks. This course will highlight some of the more significant differences between the standards. Presented by: Jennifer LouisType: Live Webcast Replay
ACPEN: K2’s Eight Awesome PivotTable Features
-
Online
2.00 Credits
Unlock the full potential of Excel's most powerful feature-PivotTables! While many users rely on them daily, few tap into the advanced capabilities that can transform data into dynamic insights. Join us for an eye-opening session where you'll discover eight game-changing PivotTable techniques that go far beyond the basics. From custom calculations and KPI integration to multi-source consolidation and advanced reporting tricks, we'll show you how to elevate your analytics and impress stakeholders. Whether you're a seasoned Excel user or just getting started, this session will equip you with the tools to turn ordinary PivotTables into extraordinary decision-making engines. Don't just use PivotTables-master them! Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: Failure to Detect Fraud and the Reasons Why
-
Online
2.00 Credits
SAS 122, AU 240, Consideration of Fraud in A Financial Audit state that auditors fail to detect fraud for two reasons. One, they haven’t been trained to look for it and two, they don’t know what it looks like. I would like to add a third reason: they don’t want to find fraud because it causes problems for the audit. This session is designed to familiarize auditors with the many faces of fraud; where and how to look for them and what to do if you think you have found fraud. Not everyone is able to recognize fraud. During this program, the attributes a fraud auditor (frauditor) will be discussed. In order to recognize fraud, an auditor must understand their client’s operation. What is an indicator in one client’s operation may be business as usual in another, and you have to know the difference. After viewing this program, chances are you will never look at your client the same way! Presented by: Dennis DycusType: Live Webcast Replay
ACPEN: Introduction to Governmental Accounting 103
-
Online
2.00 Credits
Intro to Governmental Accounting 103 is the natural follow up course to the first two Intro to Governmental Accounting courses, 101 and 102, and will take a dive into more complex issues surrounding the reporting of capital assets and long-term debt, investment accounting, and a little introduction to grant accounting and reporting. Presented by: Frank Crawford, Christopher PembrookType: Live Webcast Replay
Surgent's Starting a Small Business: What Every Trusted Advisor and Entrepreneur Needs To Know
-
Online
2.00 Credits
Starting and owning a small business remains one of the most powerful ways to build long-term wealth, alongside investing and real estate ownership. But today's business environment is fundamentally different than it was even a few years ago. Entrepreneurs must navigate rapid technological change, artificial intelligence, shifting workforce expectations, evolving regulatory frameworks, fluctuating capital markets, and increased federal and state scrutiny in areas such as non-compete agreements, data privacy, and employment law. Every large business begins as a small business, yet the risks and complexities of launching and scaling a company have increased. Owners and their advisors must address critical issues including selecting the proper entity, liability protection, financing, intellectual property protection, employment contracts, noncompete, insurance coverage, operations, and technology adoption. Decisions made at formation can materially affect a company's long-term value and ability to grow and ultimately sell. This course provides a practical, up-to-date overview of the legal, financial, and strategic considerations that business owners and their professional advisors must evaluate in today's environment. Drawing on current research, regulatory developments, and real-world trends, the program focuses on helping entrepreneurs build resilient, compliant, and scalable businesses in a rapidly changing economy.
Surgent's Top Individual Tax Planning Strategies
-
Online
2.00 Credits
Individual tax planning strategies for 2026 and beyond will take their cue from the many tax advantageous tax law changes enacted in the One Big Beautiful Bill Act (OBBBA). Many of the OBBBA changes are very favorable to individual taxpayers. Taxpayers and their clients now have the opportunity to utilize these new planning strategies. Tax practitioners must know about these new changes and the planning strategies associated with them to maximize the advantages to their clients. This program will cover tax changes from 2025 that impact individuals and provide individuals with significant tax reduction opportunities for 2026.
Viewing A&A Through the Eyes of a Tax Practitioner
-
Online
2.00 Credits
This session offers insight for tax practitioners beyond merely checking a box to satisfy accounting and auditing requirements for license renewal. We devote significant attention to extracting utility from financial statements to support decision needs of both external financial statement users and internal stakeholders. We explore best practices for cross-functional support within firms that perform tax, accounting solutions, financial statement, and consulting services. We also highlight similarities and differences between U.S. GAAP and tax-basis accounting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Year-End Tax Planning: Thinking Outside the Box
-
Online
4.00 Credits
Tax planning is more than an estimated tax calculation, it's a process. Where are we now and what can we change? This timely program will highlight significant 2022-23 tax developments and discuss key tax planning ideas for your clients as you prepare for the upcoming tax season. Don’t wait until late December to start planning for your 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 kori.herrera@acpen.com. Presented by: Doug Van Der AaType: Live Webcast Replay
ACPEN: Proper Financial Accounting for Partnerships and LLCs
-
Online
4.00 Credits
Although they are the most common entities for small and mid-sized business, financial (book) accounting for partnerships and LLCs are rarely discussed. This course examines the proper financial accounting for these tax-driven entities. Presented by: Doug Van Der AaType: Live Webcast Replay
ACPEN: S Corporation Preparation, Basis Calculations & Distributions – Form 1120S Schedule K & K-1 Analysis
-
Online
8.00 Credits
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 Presented by: J. Patrick GarverickType: Live Webcast Replay
ACPEN Signature 2026: Single Audit and Uniform Guidance Issues Update
-
Online
8.00 Credits
If you thought applying one set of audit standards is tough enough, how about applying three different sets of audit standards in one “single” audit? That’s exactly what happens when the auditor applies GAAS, the Yellow Book and the OMB requirements in a Single Audit. This session will start with a single audit “nuts and bolts” overview before delving into unique aspects and audit issues of the “soon to be closed out” era of pandemic-related funding, and of course update any recent changes to the funding programs and compliance supplement issues. Recent changes now effective to the Single Audit and Uniform Guidance rules will also be covered. Join our expert panel of federal, state and local auditors and practitioners to learn what you need to know if you are performing audits under these audit standards and the Uniform Guidance for Federal Awards. Presented by: David Cotton, Frank CrawfordType: Live Webcast Replay