CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
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: Introduction to Governmental Accounting
-
Online
2.00 Credits
Governmental accounting differs significantly from other forms of accounting and requires a distinct approach to financial reporting. This course introduces the foundational principles of governmental accounting, including fund accounting concepts and the modified accrual basis of accounting. Participants will explore the structure and purpose of governmental fund financial statements and government-wide financial statements, gaining clarity on their objectives, layouts, and key elements. The course also addresses essential topics such as component units, the role and structure of Management's Discussion and Analysis (MD&A), and the preparation and significance of the Annual Comprehensive Financial Report (ACFR). Designed for those new to governmental accounting—or those seeking a refresher-this course provides a solid foundation for understanding and applying governmental financial reporting principles. The course has been updated to reflect recent guidance issued by the Governmental Accounting Standards Board, including GASB Statements 101-105. Presented by: Melisa GalassoType: Live Webcast Replay
ACPEN: The Many Faces of Fraud
-
Online
2.00 Credits
What does fraud look like? It depends. What may appear to be an indicator of fraud in one client’s operation could be normal in another, making it critical to understand your client and the transactions you expect to see. Look for what should be present but isn’t—and for what is present but shouldn’t be. This course emphasizes the importance of professional skepticism, which has no on/off switch—it must be applied continuously. As auditors, our role is to independently verify, yet too often we rely on client representations without sufficient validation, increasing the risk of missing fraud. Many auditors recognize, in hindsight, that they have encountered fraud indicators but failed to identify them at the time. This session will provide you with the tools to recognize those indicators and strengthen your ability to detect fraud—so you are better prepared for what you may find. Presented by: Dennis DycusType: Live Webcast Replay
Ethics Based Leadership for Women
-
Online
2.00 Credits
Glantz and Associates is pleased to offer "Ethics Based Leadership for Women," a webinar designed to empower any woman who wishes to consider the privileges, responsibilities and challenges of holding leadership positions. We believe that leadership and ethics are intrinsically connected and will explore women in leadership through an ethics-based lens. The reality is, despite women representing approximately half of our world's population, they are significantly underrepresented in the workforce and most notably in leadership positions. In fact, not only do women have to cross more hurdles to advance into leadership positions, but when they do, they are burning out at a much faster rate than their male counterparts. In this course, we will discuss both the external societal barriers as well as the internal barriers that sabotage women from moving into leadership positions. We will examine common believes ("I should be nice," "I am an imposter", etc.) as well as behaviors that can hold women back and then offer suggestions for moving forward. We will provide tools to enhance one's self-awareness, create openings for self-reflection as well as provide opportunities to take on new perspectives. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Estate and Financial Planning for the Older Client
-
Online
8.00 Credits
Enter the complex world of elder planning with this comprehensive course tailored for financial professionals. Gain invaluable insights into estate and financial strategies designed specifically for older clients, equipping you with the knowledge and skills to address their unique needs and challenges. Throughout the course, participants will explore a wide range of topics, from understanding the complexities of Medicare and various life insurance types to navigating Social Security considerations and exploring Medicaid planning details. With a focus on practical application, attendees will learn to customize estate planning strategies, explore housing and care alternatives, and address gifting complexities relevant to older clients. By the end of the program, you'll develop expertise in executing specialized planning requirements for mature clients, ensuring you're well-prepared to provide informed counsel and support in this important aspect of financial practice. Join us and enhance your knowledge in estate and financial planning for the older client today. *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Handouts Tab and submit to kori.herrera@acpen.com Presented by: Arthur WernerType: Live Webcast Replay
Become a Data Analysis Expert
-
Online
2.00 Credits
In today's rapidly evolving business landscape, accounting professionals are expected to be more than just number crunchers, they are expected to be insightful interpreters of data. In an era where data is king, this course is your gateway to becoming a savvy data analyst, giving you a competitive edge in your field. We will guide you through the intricacies of making complex data analysis approachable and engaging. You will learn the all important Data Analysis Process Flow that will take you from collecting data all the way to making insightful decisions based upon your data. We will explore the basics of data modeling that will allow you to access data from multiple sources and use sophisticated calculations to create our data metrics. You will learn how to create interactive dashboards, perform sophisticated reporting, and uncover deep insights from your data. Whether you're looking to streamline your reporting process, enhance your data visualization skills, or make more data-driven decisions, this course is tailored to meet those needs. It's not just about learning a tool; it's about enhancing your professional identity as a forward-thinking accounting professional. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Financial Planning: Auto & Homeowners Insurance
-
Online
1.00 Credits
While many financial services professionals advise their clients on tax, investment, and life insurance issues, far fewer venture to help in the area of property and casualty insurance. Auto and homeowners policies are mandatory products that everyone generally needs - yet they are also complex products. This complexity raises questions in clients' minds: Are all my belongings covered under my policy? Do I have to adjust my policy if I want to let my neighbor borrow my car? Do I need an additional policy if I want to work as a rideshare driver? And will my premium go up when I move? In this course, we will cover the fundamentals of auto and homeowners' policies. We will touch on these questions, explore basic coverages, and offer some guidance on what practitioners should cover with their clients in this area, so you can offer guidance and give them the peace of mind they need. 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 Risk Management Practices in a Dynamic Risk Environment - Part 2
-
Online
1.20 Credits
In Session One we evaluated: • Examine Governance Organizational Framework (Strategy & Risk) • Determine how to identify risks • Understand how to Assess Risk - Risk Assessment impact and likelihood • Steps towards performing a comprehensive Risk Assessment and Prioritization This session goes deeper into the process of risk management and risk assessment. This session also includes a case scenario for evaluating risk management risks. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Ethics for CPAs: The Practical and the Possible
-
Online
2.00 Credits
Award winning discussion leader, former AICPA Council Member, and former state accountancy board member Mark Hugh will review the AICPA Code of Professional Conduct and its interpretations; discuss new developments in regulation at the national and state level; and discuss examples of best practices, case studies, and disciplinary actions. Presented by: Mark HughType: Live Webcast Replay
ACPEN: The Role of Internal Audit in SOX Compliance
-
Online
2.00 Credits
The Sarbanes Oxley Act (SOX) continues to pose challenges with compliance. Companies must continue to evaluate whether they have designed and implemented an adequate system of internal controls over financial reporting (ICFR). This course will address the best practices that ensure an effective and efficient approach to SOX compliance. Presented by: Jennifer LouisType: Live Webcast Replay
ACPEN: K2’s Office Scripts – The New Macros
-
Online
2.00 Credits
Discover the power of Office Scripts, the game-changing feature that lets you automate tasks in Excel and other Office applications effortlessly. Unlike VBA, which is limited to Windows, Office Scripts run on any platform and device that supports Office on the web. With its modern and intuitive interface, you can easily create, edit, and share your scripts, all stored securely in the Cloud. Office Scripts seamlessly integrate with Office Online apps and Power Automate, enabling you to streamline processes and boost productivity like never before. Say goodbye to repetitive tasks and hello to efficiency with Office Scripts in Excel and beyond! Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: The CFO Series-Artificial Intelligence: A Practical Guide for Financial Leaders and CFOs
-
Online
2.00 Credits
In today's world, AI hype bombards us from every direction. Every system seems to boast magical AI capabilities, leading to confusion and overwhelming information. This course cuts through the noise to reveal the true, practical applications of AI for your business today. Our goal is to give you real world examples of using AI on a day-to-day basis, with a clear understanding of its particular strengths and limitations. Presented by: Tracy CooperType: Live Webcast Replay
ACPEN: Upholding Independence While Holding Your Client's Hand
-
Online
2.00 Credits
Many entities look to their CPA as a trusted advisor when tackling complex accounting topics. This is more relevant now than ever. The FASB's big three accounting pronouncements involving revenue recognition, leasing and credit losses have placed a magnifying glass on this reality. Practitioners need to exercise caution to ensure they maintain independence as they assist their review and audit clients with such matters, as well as with compilation engagements. This course addresses these issues and explores best practices and guidance provided by the AICPA's Code of Professional Conduct. Presented by: Dr. Chris HarperType: Live Webcast Replay
Financial Decisions that Led Two Businessmen to Prison
-
Online
2.00 Credits
Two college graduates built impressive careers: One worked in sales, the other in technology and investing. Both of those people made decisions in the course of their business that led to government investigations. They had to hire attorneys, go through judicial processes, face charges, and plead guilty. Each of those people are on their way to prison. Learn from the lessons they offer. We interview both financial professionals, and they tell us more about how their decisions influenced the consequences that followed. 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 Taking Advantage of Like-Kind Exchanges
-
Online
2.00 Credits
When real property is sold for a gain, we always try to find ways to defer recognizing income so that it won't be necessary to send a check to Uncle Sam. There is a provision within the Internal Revenue Code that allows the taxpayer to defer recognition of immediate taxable gain in the year of sale known as a "like-kind exchange." Knowing how and when to utilize this provision makes the Accounting and Finance Professionals very valuable to either their client or the entity they work for. We will also discuss recent proposals that could impact the future of this provision. Please Note: due to overlap with the ISL4 course, customers should not take both.
All About Fraud - Examples, Prevention and Auditing
-
Online
4.00 Credits
Fraud continues to make headlines, underscoring the importance of understanding how fraud occurs, how it can be prevented, and how auditors are expected to respond. This course begins with an overview of common fraud schemes identified in the 2026 Report to the Nations issued by the Association of Certified Fraud Examiners, along with key characteristics commonly observed among fraud perpetrators. The course then explores practical approaches organizations use to prevent and deter fraud, highlighting controls, policies, and cultural factors that can reduce fraud risk. Participants will also review recent fraud cases reported in the news to reinforce how these schemes manifest in real-world settings. The course concludes with a discussion of the auditor's responsibilities related to fraud under AU-C 240, including an overview of proposed changes to the fraud standards and what they may mean for future 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.
AHI: Accounting Data Analytics
-
Online
2.00 Credits
This course introduces how data analytics can be used to improve engagement quality and efficiency. Participants explore the use of data analytics to assess risk, support financial statement assertions, assess internal controls and uncover fraud. Apply the ADA IDEAS© approach to using data analytics on engagements to ensure compliance with audit and review standards and to provide value-added services to clients. All of AHI's multi-day courses rely on live participant engagement. For this 2-hr. course, we encourage you to have a working webcam and microphone to take advantage of a live discussion leader and participant interaction.
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: Mastering Form 7217: A Guide to Partnership Property Distribution
-
Online
1.00 Credits
This program will address the complex rules for partnership distribution of property with a focus on liquidation of a partner’s interest, Section 751, and how to complete the Form 7217. OBBBA of 2025 update for property distributions is included. *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
Retaining Top Talent: Strategies for CPA Firms
-
Online
1.00 Credits
In today's challenging talent market, accounting firms face unprecedented pressure to retain their best performers. This course provides actionable, research-backed strategies to help firms keep their top talent from leaving. Based on comprehensive surveys of both current accounting professionals and those who have recently left the profession, participants will learn the real reasons employees stay or go-and what firms can do about it. The course goes beyond simple solutions like "pay more, expect less" to explore comprehensive retention strategies including whole-person compensation, work-life balance improvements, career development pathways, and necessary business model transformations. Participants will discover why 73% of surveyed professionals want to stay with their current firm, yet many still leave-and how to bridge that gap. Key topics include understanding the true cost of turnover versus retention, implementing flexible work arrangements that actually work, creating meaningful career paths for non-partner track professionals, and transforming firm operations to support both profitability and employee satisfaction. Special attention is given to retaining diverse talent and adapting to the expectations of younger professionals who will comprise 27% of the workforce by 2025. Whether you're a firm leader, HR professional, or manager responsible for team retention, this course provides the insights and tools needed to build a sustainable talent strategy in an evolving profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.