CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
ACPEN: Eliminating Busy Season: Transforming Your Practice to Year- Round Advisory Services
-
Online
2.00 Credits
This course provides tax and accounting professionals with a comprehensive framework for transitioning from a compliance-driven busy season model to a sustainable, year-round advisory practice. Participants will explore strategies for expanding services into tax, financial, and estate planning. The course addresses both transitioning existing clients and attracting new, higher-value clients while improving efficiency, client value, and revenue stability. Presented by: Arthur WernerType: Live Webcast Replay
You Don't Know What You Don't Know About Microsoft Excel
-
Online
8.00 Credits
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Excelling at Excel: The Magic of Power Query
-
Online
2.00 Credits
Elevate your data analysis capabilities with our focused course on Power Query. Tailored for financial professionals, this training will show you how to get started using Power Query and teach you some of the ways to take advantage of its ability to handle messy data and automate repetitive tasks. Harness the efficiency of Power Query to revolutionize the way you work with data. Learn how to "program" your tasks once and set them on repeat, eliminating the need for repetitive, robotic work. This automation not only saves time but also ensures consistency and accuracy in your data processes. Whether you're dealing with complex datasets or simply looking to streamline your reporting processes, this course will equip you with the tools and knowledge to make Excel work for you like never before. Presented by: Tracy CooperType: Live Webcast Replay
Microsoft 365 for CPAs: Unlocking Hidden Productivity Tools
-
Online
2.00 Credits
Microsoft 365 is likely the most underutilized software investment in your firm or business. This course will show how to tap in to many of the lesser known features of the Microsoft 365 ecosystem of apps to maximize your productivity and produce better outputs. Through a series of practical case study demonstrations you will learn how to leverage the full potential of Microsoft 365 in your organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2026/27 Yellow Book Update
-
Online
1.00 Credits
Stay current on key developments affecting governmental audits with this focused update on the 2024 revision of the Yellow Book. This course highlights significant changes related to quality management and updates affecting key audit roles, with an emphasis on how these revisions impact audit planning and execution. The course also addresses the GAO's implementation delay and its implications for 2026 audit planning. Participants will gain context around recent leadership changes at the U.S. Government Accountability Office and what those transitions may signal for future guidance and oversight priorities. In addition, the course includes an overview of recent updates to the Green Book, helping auditors understand changes to internal control guidance that may affect governmental entities and Single Audit engagements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Emotional Intelligence for Professionals: Mastering the Human Side of Success
-
Online
1.00 Credits
Technical expertise may get you in the door—but emotional intelligence (EQ) is what builds trust, earns loyalty, and sustains lasting success. For CPAs, attorneys, financial professionals, bankers, and insurance agents, your ability to navigate emotions—your own and others'—is often the difference between a good client interaction and a great one, between a team that functions and a team that thrives. This interactive course goes beyond theory and dives into real-world application. You’ll uncover what emotional intelligence really is, why it matters more than ever in today’s professional world, and how to strengthen your EQ to improve performance, strengthen relationships, and manage stress with confidence. You’ll walk away with tools you can use immediately to transform how you lead meetings, manage conflict, build client trust, and drive results—while also enriching your personal life. Whether you're looking to become a better leader, communicate with more clarity, or create meaningful client connections, this course gives you the insight and strategies to make it happen. Presented by: Roger WolkoffType: Live Webcast Replay
ACPEN: Behind the Rx: Demystifying Pharmacy Benefit Management and Creating Transparency
-
Online
2.00 Credits
Learn the history of PBMs and how they have developed into one of the leading drivers of health plan cost. Understand how drug prices are set and how PBMs control the flow of money (and not always to our benefit!). This course will also show you how rebates and sourcing programs are used to offset the cost of drugs in self funded plans while also learning how to protect the plan from unfavorable PBM practices. Presented by: William MinickType: Live Webcast Replay
ACPEN: Group Audits: Who is Responsible for What?
-
Online
2.00 Credits
Financial statement audits often involve audits of components of a larger entity. This course will focus on the responsibilities for both the group auditor and component auditor, including implementation of SAS No. 149 relate to group audits. Presented by: Jennifer LouisType: Live Webcast Replay
ACPEN: The New AICPA Statements on Standards for Tax Services
-
Online
2.00 Credits
The SSTS are tax standards that apply to all members who provide tax services and provide the framework for the AICPA ethical guidance for tax practitioners. This program explores the revised AICPA Statements on Standards for Tax Services, effective January 1, 2024. This program is not approved for IRS credit. Presented by: Doug Van Der AaType: Live Webcast Replay
Accounting & Attestation for ESG
-
Online
2.00 Credits
Environmental, Social, and Governance (ESG) reporting has become an increasingly important area of focus for standard setters, regulators, and stakeholders. This course provides an overview of how ESG considerations intersect with accounting and attestation services, with attention to developments affecting both preparers and assurance providers. Participants will review current ESG-related initiatives and projects underway at the Financial Accounting Standards Board, Governmental Accounting Standards Board, and the AICPA. The course also explores the types of services CPAs may provide in connection with ESG reporting, including advisory and attestation engagements, and discusses how these engagements differ in scope and responsibility. Designed for CPAs seeking to understand the evolving ESG landscape, this course helps participants recognize where ESG fits within existing professional standards and how CPAs can support organizations seeking credibility and assurance over ESG 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: Leading for Well-Being: Building Resilient Teams & Thriving Workplaces
-
Online
3.50 Credits
Leaders set the tone for workplace well-being. This program will equip leaders with the tools to build resilient teams. Creating a culture of mental wellness allows employees to feel safe, valued and heard. This will improve productivity, reduce burnout and absenteeism and ultimately, create a workplace where employees can thrive. Leaders will also learn the importance of nurturing their own self-care to prevent burnout for themselves in order to be the best leader possible. Presented by: Ivy WattsType: Live Webcast Replay
ACPEN: S Corporation Essentials: Review & Update
-
Online
4.00 Credits
This program addresses the critical issues and special opportunities facing S-corporations, with a focus on reporting shareholder basis and distributions. *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
Corporate Transparency Act Developments
-
Online
2.00 Credits
U.S. Department of Treasury's Financial Crimes Enforcement Network (FinCEN) imposed a new reporting requirement that went into effect on January 1, 2024. Millions of businesses may have to file a Beneficial Ownership Information (BOI) Report. In a surprise turn of events, the Federal District Court from the Northern District of Alabama ruled on March 1, 2024 in National Small Business United v. Yellen ("NSB") that the CTA is unconstitutional. This course will discuss the CTA's provisions and the court's decision in NSB. Also covered will be future implications for business entities and steps to consider given the recent ruling. We will also discuss recent proposed rulemaking by FinCen with respect to nonfinanced purchases of residential real estate and gratuitous transfers so that businesses can prepare for any additional reporting burdens that might arise. 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 Ethics Hour: Ethics is the Engine to Better Leadership: Taking Action, featuring Bob Mims and Don Minges
-
Online
1.00 Credits
Ethics is grounded in leadership and the finest leaders are always ethical. Every effective leader is ethical, in words and actions. The best leaders communicate effectively. Being trustworthy is more than being honest and fair. In today’s turbulent environment, leadership matters more than ever as the talented staff will readily move to ethical leaders. We must enhance our leadership skills to remain valuable. Simple stated - we all want to work for, and with, an ethical leader. Presented by: Don Minges, Bob MimsType: 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: The Controllership Series: The Controller's Role in Digital Transformation
-
Online
1.40 Credits
A controller's role in digital transformation is to act as a key facilitator in integrating new technologies within the finance function. This process moves beyond traditional accounting tasks to actively analyze data, provide insights based on financial information. This will ensure the smooth implementation of new systems that streamline financial operations, all while maintaining compliance and financial control within the organization. This course will introduce some of those topics and methods Controllers are beginning to turn to. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Understanding the 4 W's in Budgeting: Who, What, When, and Which?
-
Online
2.00 Credits
This session introduces a structured approach to government budgeting using the four W’s: Who, What, When, and Which. Participants will explore WHO should be involved in the budgeting process, including internal teams and external stakeholders, while learning effective communication strategies to foster collaboration. The session examines WHAT the budgeting process entails, covering essential phases, components, legal requirements, and common challenges. Attendees will also learn WHEN to engage the public through strategic planning, workshops, and outreach initiatives. Finally, the session highlights WHICH departments play key roles, from financial planning to managing capital projects. By the end of this session, participants will have a comprehensive understanding of government budgeting and how to align financial planning with community priorities. Presented by: Alex RomeroType: Live Webcast Replay
ACPEN: Excelling at Excel: Tips, Tricks and Updates
-
Online
2.00 Credits
Unlock the full potential of Excel with our comprehensive training on shortcuts and formulas. This course is designed for CPAs and financial professionals who want to enhance their efficiency and accuracy in Excel. Learn how to navigate and utilize different versions of Excel, discover powerful new functions, and master the art of creating effective tables and automations. With practical examples and hands-on exercises, you'll transform your Excel skills, making your daily tasks quicker and more precise. Plus, benefit from insider tips and tricks drawn from the instructor's extensive real-world experience. Whether it's mastering keyboard shortcuts that save you time or applying formulas that simplify complex calculations, you'll gain practical knowledge that you can immediately apply in your work. This course isn't just about learning Excel; it's about learning to excel at Excel. Presented by: Tracy CooperType: Live Webcast Replay
ACPEN: Microsoft Excel: Moving Beyond the Basics
-
Online
2.00 Credits
This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information. Presented by: Dr. Chris HarperType: Live Webcast Replay
ACPEN: The Three Million Dollar Ribbon
-
Online
2.00 Credits
Two conmen used lies and falsified documents to convince the State of Tennessee to give them a $3,000,000 economic development grant to create 1,000 jobs by purchasing and rehabilitating a vacant factory in rural Tennessee. Instead, they spent most of the money on an extravagant lifestyle and invested over $1M in a scheme to defraud the U.S. Federal Emergency Management Agency (FEMA) out of over $30,000,000 pursuant to a contract to provide the tarps for areas such as Puerto Rico, affected by hurricanes. This session provides a detailed case study of how the investigators accumulated, organized, and analyzed hundreds of documents, identified the falsifications and misrepresentations, conducted multiple interviews, and ultimately convicted the conmen. This case study provides multiple takeaways for detecting and investigating grant fraud, which is especially relevant in light of the numerous federal stimulus programs in recent years. Presented by: Daniel PorterType: Live Webcast Replay