CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Streamlined Excel Reporting Series Session 4: External Data and PivotCharts
-
Online
2.00 Credits
Extracting data for richer insights You'll gain meaningful analysis techniques while working alongside an industry expert and knowledgeable instructor. This session begins with the GETPIVOTDATA function to enable report customization. It's a great starting point before moving on to more advanced techniques. Power Query introduction With its user-friendly interface, Power Query empowers Excel users to take the next step by enabling seamless data import and transformation. With Power Query, you will explore features, including: Getting and transforming data Loading data Managing columns Data source settings Layouts and parameters Visualizing with PivotCharts A well-designed chart can effectively illustrate data trends and comparisons. You'll learn how to create and customize PivotCharts to elevate your reports and make the data more accessible to others. *Session 4 is one of four individual sessions. Each session builds on the previous one, so consider watching all the sessions [Streamlined Excel Reporting Series](https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series) to tackle real-world issues and create powerful workbooks.*
ACPEN: S Corporation Checkup: Tax Issues & Forms Reporting
-
Online
4.00 Credits
A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination, as well as an update on Schedules K-2 and K-3. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. *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: Steven DilleyType: Live Webcast Replay
ACPEN: Ethical Leadership: Power, Influence, Integrity, and Trust
-
Online
2.00 Credits
Leaders naturally wield power and influence. But, to avoid the temptation of abusing power, leaders must apply ethical behaviors for themselves and others. Words, actions and deeds which demonstrate integrity and trust yield the credibility that make others want to follow ethical leaders. Betraying trust can destroy careers, whole organizations, and lives. This is why trust is a top prerequisite for principled and ethical leadership. Positive (and negative) influence is derived from the credibility trust brings. Ethical leaders who continually work to earn and keep trust reap enormous payback in all aspects of business including superior economic, competitive, and strategic performance. Presented by: Richard KarwicType: Live Webcast Replay
Business Tax Update: OBBA and Recent Developments
-
Online
2.00 Credits
A discussion of the latest tax developments impacting business taxpayers, with a focus on important provisions, rules and concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Tricks and Treats to Avoid Litigation
-
Online
1.00 Credits
This session provides HR Professionals and leaders with scripts for handling employee relations situations with sensitivity, good judgment, and high confidence. Topics include balancing employee & employer rights, key concepts of effective employe relations, handling employee complaints, personality & attitude problems, addressing misconduct due to mental conditions. Presented by: Mike MirarchiType: Live Webcast Replay
Workforce Transformation and Talent Management in 2025
-
Online
1.00 Credits
The accounting profession faces unprecedented workforce challenges that demand a fundamental rethinking of traditional firm structures. This course examines why the century-old pyramid practice model is becoming obsolete and presents the inverted pentagon framework as a sustainable alternative. Based on comprehensive research showing that 52% of firms expect to shrink by 20% or more in the next five years, participants will learn how to restructure their firms to thrive with fewer entry-level staff while expanding specialized expertise. The course explores the "6 Ps of Business Model Transformation" - Precision Hiring, Proactive Retention, Practical Technology Implementation, Pricing Expertise, Practice Area Expansion/Focus, and People Acceleration. Drawing from success stories in manufacturing, healthcare, and technology industries, attendees will discover proven strategies for accelerating staff development, implementing effective knowledge transfer programs, and building sustainable talent pipelines in an era of technological disruption and demographic shifts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: How to Audit Prepaid Expenses
-
Online
2.00 Credits
Understanding how to effectively audit prepaid expenses is a key skill for audit staff. This course provides a comprehensive overview of the fundamentals, including the applicable audit assertions and common risks and threats associated with the prepaid expense balance. Participants will learn how to perform substantive auditing procedures to ensure accuracy and reliability, with guidance on applying these techniques to real-world scenarios. Designed to enhance practical knowledge, this session equips auditors with the tools and confidence needed to navigate prepaid expense audits with proficiency. Presented by: Jaclyn VenoType: Live Webcast Replay
ACPEN: Emerging Risks and Resilience - How Accounting and Finance are Leading the Way - Part 4: Managing Supply Chain Risks, Data Analytics, and
-
Online
2.00 Credits
This is Part 4 in our 5 part series on Emerging Risk and Resilience - How Accounting and Finance is Leading the Way The rapid evolution of technology, globalization, and regulatory frameworks has introduced a range of emerging risks that are transforming the fields of accounting, finance, and auditing. Innovations such as artificial intelligence, blockchain, and big data analytics are redefining traditional business models while creating new challenges related to data integrity, cybersecurity, and ethical decision-making. In accounting and finance, the growing reliance on automated systems raises concerns about vulnerabilities, algorithmic bias, and the potential for misinformation. Auditors face heightened expectations for real-time assurance, transparency, and adaptability to new reporting standards, including sustainability and ESG disclosures. Geopolitical instability, economic volatility, and evolving regulatory pressures add layers of uncertainty to financial reporting and audit quality. This four-part seminar series explores these emerging risks, analyzes their implications for professionals and organizations, and highlights proactive strategies for risk management, continuous learning, and technological competency. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Internal Controls That May Have Prevented Fraud
-
Online
2.00 Credits
This course examines 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' ability to accomplish their nefarious acts. Presented by: Dr. Chris HarperType: Live Webcast Replay
ACPEN: Mergers and Acquisitions: Complete Guide to Relevant Issues
-
Online
2.00 Credits
Arthur Werner will provide financial professionals with the information their teams will need to successfully plan and execute mergers and acquisitions. For major topics covered, see below. This course may be customized or tailored based on the needs of your organization. *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: Arthur WernerType: Live Webcast Replay
ACPEN: K2's AI: Real Tools, Real Results
-
Online
2.00 Credits
This session teaches professionals how to move beyond theory and start using AI to work smarter, faster, and more accurately. This hands-on session explores how public accounting and industry finance teams can use AI tools for tasks like reporting, forecasting, audit analytics, and client service. Participants will see real-world examples of automation, gain practical implementation tips, and learn how to balance innovation with professional responsibility. Discover how to measure your AI ROI, enhance productivity, and position your firm or department for success in the AI-driven accounting era. Presented by: Randolph (Randy) JohnstonType: Live Webcast Replay
ACPEN: K2's Tech Tuneup Tips
-
Online
2.00 Credits
Technology issues rarely come from major failures-they come from small inefficiencies that compound over time. This practical session focuses on high-impact, low-effort technology tuneups that accounting professionals can apply immediately. Participants will learn proven tips for improving workstation performance, tightening security, streamlining workflows, reducing digital friction, and extending the life and value of existing technology investments. The emphasis is on practical configuration changes, overlooked features, and operational habits that deliver measurable productivity gains without requiring major system replacements. Presented by: Randolph (Randy) JohnstonType: 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.
Surgent's Exploring Business Valuation Fundamentals
-
Online
2.00 Credits
What makes a business valuable? Who determines value? What are the key factors that make businesses valuable? In this course, we explore the different ways to value a business. We will apply foundational valuation and corporate finance concepts to real world examples in an effort to see what makes up an investment's price.
ACPEN: Taxation of Judgements and Settlements
-
Online
2.40 Credits
In the course of legal actions, payments may be made pursuant to a final disposition of a court case or a mutually agreed-upon settlement. This course will cover the tax implications for payments made for personal injury, emotional distress, lost wages, punitive awards, pre- and post-judgement interest, contract claims, among other damages. **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: Allison McLeodType: Live Webcast Replay
Comprehensive Accounting and Financial Reporting Update
-
Online
4.00 Credits
This course covers recently issued accounting and financial statement reporting standards from the Financial Accounting Standards Board. Key implementation challenges and experiences from public company filings will be identified. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Beyond the Basics of SSARS and Nonattest Services: Are You Certain You Are in Compliance?
-
Online
8.00 Credits
Practitioners that provide non-audit services must strike the right balance between complying with relevant professional and regulatory standards, providing value-added client service, and mitigating litigation and other practice management risks. This course contains many case studies to reinforce best practices for managing the accounting, reporting, and performance issues associated with the attest services of compilations and reviews where reports are issued, as well as the SSARS preparation of financial statements service and other nonattest engagements. Presented by: Jennifer LouisType: Live Webcast Replay
An Ethical Approach to Mental Health Issues at Work
-
Online
2.00 Credits
In the past talking about mental issues in the workplace was taboo. Not anymore!!! So many of us suffer with mental health issues at some point in our lives. Poor mental health impacts, from a work perspective, productivity, absenteeism, retention and more. On a personal level it often causes personal distress and hopelessness. The Society of Human Resource Management (SHRM) is addressing mental illness as a critical factor for the wellbeing of organizations. Additionally, the EEOC is cracking down on mental health discrimination. It is a very important topic for any functional business! This ethics-based webinar will bring awareness to this issue and offer suggestions on managing mental health issues in ethical, compassionate and healthy ways. It will offer suggestions on managing mental health issues for leaders, managers and all staff to create and environment of safety and belonging. This webinar will also address the topic of suicide talking about warning signs and resources. 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 Real Estate Taxation: Critical Considerations
-
Online
4.00 Credits
This course is a 'deep dive' into many aspects involving the taxation of real estate for the mid-level practitioner moving into this complex area. You will deepen your understanding of the complex considerations and strategies that individuals must navigate in acquiring, operating, and selling real estate. You will leave the course able to navigate critical issues associated with the relevant returns and plan strategically for your company or clients. We will discuss in detail the impact that recent tax changes have had on the real estate industry, as well as new credits that are available after the Inflation Reduction Act of 2022.
ACPEN: Supervised AI Agents as Internal Audit Team Members
-
Online
1.00 Credits
How should internal auditors and finance team leaders use Agentic AI? What are the dos and do nots? When deployed properly AI is wonderful. Can AI help with SOX testing? We review how to avoid the common mistakes that eliminate the benefits that AI can provide. Join us to learn about those expensive lessons. Agentic AI (‘Artificial Intelligence’) is rapidly being deployed by leading audit, compliance, and finance teams. While AI agents are not yet replacing all of today’s knowledge workers like auditors, accountants, and IT security professionals, the knowledge workers that effectively use Agentic AI may soon be replacing those knowledge workers who do not use these tools to drive high quality business growth and scale. AI is moving beyond automation to become a true teammate, especially in the governance, risk, and compliance processes. This session will show how supervised AI agents can work alongside accountants, auditors and IT security professionals to enhance efficiency, consistency, and assurance quality. Of critical importance is training and supervision so that the AI agents accomplish their testing to mee the intended quality standards. Attendees will leave with a practical view of how AI-powered testing can be applied to both internal and external assurance. Be prepared and learn from others. Presented by: Joe OringelType: Live Webcast Replay