CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
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.
Revenue Recognition in an Environment of Uncertainty
-
Online
2.00 Credits
Applying Topic 606 in an environment of uncertainty can be especially challenging. This course will discuss the proper application of the revenue recognition model when facts and circumstances are changing.
Let's Meet at the Intersection of Fraud and Ethics
-
Online
4.00 Credits
This course explores actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters from achieving their nefarious acts. Then we will switch gears to an interactive, case-based discussion that asks participants to reach their own conclusions by analyzing facts in concert with the AICPA Code of Professional Conduct and other sources of ethical guidance. This course provides practical, action-oriented insight that can be implemented by accounting professionals in both public practice and industry.
Achieving Balance in Work and Life - Part 1
-
Online
4.00 Credits
Due to the constant stress of a fast paced life, overwork, and family demands, it’s easy to feel one’s life is out of balance. When this happens, all areas of your life can suffer. By learning key methods for setting priorities and goals, overcoming stress, and deciding what’s most important to you, you can achieve new levels of balance and greater results. Having more balance in your life will allow you to do less of what you don’t want and more of what is truly important to you.
Are You Up For the Challenge? Test Your Skills as a Quality Control Reviewer
-
Online
4.00 Credits
Have you ever wanted to reduce the number of financial statement review points you receive? Are you curious about a reviewer's thought process? This hands-on session will answer these questions by helping you understand the role of an engagement quality control reviewer. Not only will you develop an appreciation for the role of an engagement quality control reviewer, but this interactive session will allow you to step into the reviewer's shoes by performing a quality control review during the class session. You will leave with an understanding of best practices for minimizing your exposure to critique by reviewers.
Dashboard and Report Design Principles Using Excel
-
Online
4.00 Credits
Transform your data presentation skills with our comprehensive course on creating impactful dashboards and reports using Excel. This workshop is tailored for professionals who: Regularly produce or update dashboards and reports Struggle with confusing or overly complex reporting tools Seek to streamline varied reporting styles across their organization Aim to establish a consistent, replicable "house style" for reporting Want to impress stakeholders with clear, user-friendly data presentations Through a combination of theory and hands-on practice, you'll learn the fundamental principles that make reports and dashboards easy to understand. We'll distill these concepts into a set of practical rules and guide you through their application in Excel.
The Controllership Series - The Controller's Skillset
-
Online
1.00 Credits
This another course in our series on the controllership function. The controller's role encompasses many traditional responsibilities. The breadth and depth of the controller skill set has expanded and will continue to expand as the business world evolves. The controller position will typically lead teams of financial and accounting experts. Recognizing that leadership and team management skills are must-haves; they need to be able to command their team's respect, inspire them to act, and ensure that such actions are aligned with your organization's overall vision. These skills, along with tactical knowledge will ensure the controller's success.
Resistance to Resiliency: Striving for Technology Change Acceptance
-
Online
1.00 Credits
Technology adoption often comes with resistance, but it's possible to transform this challenge into an opportunity for growth. This course explores the journey from resistance to resilience in embracing new technologies, focusing on overcoming barriers and ensuring successful implementation. Participants will examine cutting-edge audit technologies, including AI, data analytics, and automation, and learn how to align these innovations with both organizational and personal goals. Through case studies, insights into the Technology Acceptance Model (TAM), and practical discussions, participants will gain the tools and strategies to foster acceptance, driving seamless integration of new technology into both individual tasks and team workflows.
The Controllership Series - The Controllers Role in Financial Forecasting
-
Online
1.50 Credits
Financial forecasting is an important part of any successful business. It enables businesses to plan for the future and anticipate scenarios based on strategy. The controller helps forecast financials by calculating future revenue and income streams. In recent years, corporate finance has undergone many dramatic changes due to the growth of a number of high-tech tools. The responsibilities/competencies of the Financial Controller position (FC) has changed in recent years To maximize performance, Controllers must be aware of how the FC position is changing, and how they must adjust to these changes. There are many types and methods of financial forecasting. This course will review the most prevalent forecasts and relative methods being used.
Everything You Need to Know About the Pass-Through Entity Rules: IRC 199A The Code and Regulations
-
Online
4.00 Credits
As part of the Tax Cuts and Jobs Act (TCJA), IRC § 199A was added. This Internal Revenue Code section allows certain pass-through entities the ability to has made it deduct up to 20% of their qualified business. Although practitioners have had over three years of “experience” utilizing IRC § 100A, many practitioners still do not feel comfortable with this part of the Internal Revenue Code. The purpose of this presentation is to provide the practitioner with an understanding of the rules of IRC § 199A as well as an understanding of the IRC § 199A regulations. **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.
Not Just Your Everyday FASB Update
-
Online
4.00 Credits
This course highlights significant updates that affect financial reporting and related attestation services. We will explore novel FASB pronouncements while examining the enduring impact of lease accounting and revenue recognition standards. This course will provide reminders regarding both GAAP and non-GAAP financial reporting alternatives for closely held entities. We will also explore selected guidance regarding audit, review, and compilation engagements.
Spring Tax Update for Individuals with Steve Dilley
-
Online
4.00 Credits
This program provides an update to the latest tax developments, rules and regulations impacting and individual taxpayers, with a review and integration of 2024/25 legislation. *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
Governmental Accounting 101
-
Online
2.00 Credits
Governmental Accounting 101, is a 2 hour webcast that takes the participant of a whirlwind tour of governmental accounting basics, focusing on wetting the participant’s appetite for more. This session will be the first of a series of webcasts, with each subsequent webcast delving deeper and deeper into the governmental accounting basics.
2025 AICPA Regulatory Ethics Update (VBOA Approved)
-
Online
2.00 Credits
Stay ahead of the curve with this VBOA-approved ethics course designed to meet Virginia's ethics requirements while keeping you informed on the latest developments at the AICPA. The Professional Ethics Executive Committee (PEEC) has been active recently, issuing new guidance and updating existing rules. In this session, we'll explore the most impactful changes, including updates on fees, recruiting, CPE, and NOCLAR (noncompliance with laws and regulations). CPAs in both industry and public accounting will gain the insights needed to stay compliant in an evolving regulatory environment. We'll also provide a sneak peek at key projects PEEC is expected to finalize soon, ensuring you're prepared for what's next.
Businesses Receiving Government Assistance
-
Online
2.00 Credits
Many for-profit entities receive government assistance or are required to have financial statement or compliance audits due to law or regulation. This course will discuss the requirements under Generally Accepted Auditing Standards relevant to for-profit entity audits.
Fraud Case Studies: Professional Misbehavior in the 21st Century
-
Online
4.00 Credits
Savvy accountants pay attention to fraud trends so they can implement preventive and/or detective controls. This course examines novel frauds to explore potential mitigation measures. Participants will see how selected frauds were accomplished so they can consider internal controls that could have foiled the fraudsters' nefarious efforts. We examine broad ethical considerations and specific provisions of the AICPA Code of Professional Conduct. Along the way, we consider dramatic details of several fraud cases to illustrate practical applications that accountants can apply in their professional endeavors.
Spring Tax Update for Business with Steve Dilley
-
Online
4.00 Credits
This program provides an update to the latest tax developments, rules and regulations impacting and business taxpayers, with a review and integration of 2024/25 legislation. *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
KPI Bootcamp for Small Businesses
-
Online
5.00 Credits
Running or advising a small business? The KPI Bootcamp can help you rapidly identify and implement the right KPIs to achieve your or your client's goals. Delivered by Bernie Smith, KPI specialist and seasoned entrepreneur, this course will guide you through selecting a powerful set of measures tailored to your business. The structured approach helps you refine your objectives and choose KPIs that drive growth and profitability. The program includes access to over 400 pre-defined KPIs, each with a clear, jargon-free definition, business benefits, real-world examples, and practical implementation tips.
Preparing to be a Forensic Accountant - Focus on Digital Forensics
-
Online
1.80 Credits
Forensic accounting, forensic accountancy or financial forensics is the specialty practice area of accounting that investigates whether firms engage in financial reporting misconduct. Forensic accountants apply a range of skills and methods to determine whether there has been financial reporting misconduct. Financial forensic engagements may fall into several categories. For example: Economic damages calculations, whether suffered through tort or breach of contract. Post-acquisition disputes such as earnouts or breaches of warranties Bankruptcy, insolvency and reorganization Securities and tax fraud Money laundering Business valuation Computer forensics/e-discovery This session is designed to delve into further investigative procedures used including digital forensics. Future sessions will focus on computer forensics, network forensics and mobile forensics.
Global Internal Audit Standards (GIAS) Domain V - Part 1
-
Online
2.00 Credits
The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service