CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Unlock the Power of AI with Copilot in Excel
-
Online
2.00 Credits
In the ever-evolving world of data analytics and business intelligence, Microsoft Excel continues to be an indispensable tool for professionals across industries. With the introduction of Copilot, Microsoft has integrated the power of artificial intelligence directly into Excel, revolutionizing how users work with data. This 2-hour interactive course, Unlock the Power of AI with Copilot in Excel, provides a comprehensive overview of how Copilot transforms traditional Excel workflows into dynamic, AI-driven processes, enabling users to accomplish tasks faster, more accurately, and with less manual effort. During this course, you'll discover how Copilot leverages AI to enhance productivity and streamline operations. Whether you're a seasoned Excel user or just beginning your journey, this course will guide you through practical applications and best practices to make the most of Copilot's capabilities. Through hands-on demonstrations and real-world examples, you'll see how Copilot can save time, improve decision-making, and elevate your analytical skills to new heights. This course not only focuses on the technical aspects of Copilot but also highlights its potential to transform your day-to-day work, from automating repetitive tasks to uncovering trends and insights you might otherwise overlook. By the end of the session, you'll be equipped with the knowledge and confidence to integrate Copilot into your workflows and unlock its full potential in Microsoft Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: An Exceptional Leader C.A.R.E.S.
-
Online
1.00 Credits
This session will teach leadership principles to transform a workplace into a healthy & supportive environment. By improving organizational culture, mental health conditions will improve, & burnout potential is minimized. An unhealthy workplace results in failure to attract and retain top talent. Leaders can be instruments of change. The C.A.R.E.S. approach offers leadership principles that will improve your workplace. Symptoms are hidden at work. Your employees are hurting, and you can help. If you care for your people from the bottom of your heart, you will be amazed at what it does to your bottom line. Presented by: Micheal TowersType: 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: 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
ACPEN: Strategic CFO – Strategic Financial Communications
-
Online
2.00 Credits
Financial professionals are expected to do more than report numbers-they must explain them in ways others understand and trust. This session focuses on improving financial communication by addressing financial literacy gaps, simplifying complex accounting concepts, and building compelling narratives around data. Participants will learn how to use stories, visuals, and language effectively to communicate strategy, performance, and risk. Through examples and interactive discussion, this session helps CPAs and CFOs become clearer, more confident communicators in both live and virtual environments. Also, some video clips will be used to add to the learning materials and research. Don't worry, they are pretty entertaining. Presented by: Bob MimsType: Live Webcast Replay
Excel for Accounting Professionals Session 3: Workbook Design Principles and Organization
-
Online
2.00 Credits
Enhancing Excel workbook productivity This workshop covers organizing and managing worksheet information, offering hands-on participation alongside the instructor. Through the practical tasks, you will gain a comprehensive grasp of commonly utilized Excel functions such as: Hiding worksheets Inputting cells styles for users Organizing workbooks Mastering Excel capabilities Becoming proficient in Excel entails developing workbooks that are efficient and well-organized. The facilitator will guide you through mastering complex functions, selecting cells and objects, and organizing principles of workbook design. You'll enhance your basic understanding of Excel with topics including: Creating complex formulas with nested functions Applying techniques for group selection *Session 3 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 4: Conditional Summing and Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-4--conditional-summing-and-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*
Self-Rental Real Estate: Passive Activity & Section 199A
-
Online
2.00 Credits
This program presents a detailed analysis of the self-rental passive activity rules, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: 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. Presented by: Bernie SmithType: Live Webcast Replay
ACPEN: Shorten Month-End - Closing Best Practices
-
Online
4.00 Credits
Surveys show that the average North American company completes its monthly financial statement closing in six (6) days. However, some companies can close their books in one day or less. You don't have to sacrifice accuracy for speed. This session will show you how to close month-end faster, better and cheaper. Yes, to all three. Presented by: Don Minges, Anita LaytonType: Live Webcast Replay
ACPEN: Gamed: Why Performance Targets and Incentives Fail and How to Fix Them
-
Online
4.00 Credits
Targets can be a powerful catalyst for remarkable achievements - from landing humans on the moon to eradicating smallpox and repairing the ozone layer. However, poorly designed targets can have severe consequences, potentially leading to executive imprisonment, corporate collapse, or even loss of life. This course uses real-world examples and case studies to guide you through a practical, step-by-step process for crafting robust, effective, and credible targets for your organization. You'll learn how to harness the positive potential of targets whilst avoiding the pitfalls that can derail even the most well-intentioned performance initiatives. Presented by: Bernie SmithType: Live Webcast Replay
ACPEN: Optimize Your Staff's Performance
-
Online
4.00 Credits
A chain is only as strong as its weakest link. The same theory applies to departmental performance—the overall result is only as strong as its weakest contributor. Leave our interactive and entertaining session with insight for developing and sustaining the best team you can possibly assemble. The four elements in this process are (1) development, (2) leadership, (3) hiring and (4) environment. Discuss how to effectively use these elements in your creation of an outstanding organization. Discover the power of the 10 Attributes for Leadership Success and the negative impact of Leadership’s Fatal 13. Above all, learn how to combine these four elements as a successful catalyst for sustained high-quality output and results. Presented by: William O’BrienType: Live Webcast Replay
ACPEN: Passive Activities & Rental Real Estate Income Tax Issues
-
Online
8.00 Credits
This comprehensive training is designed to get the accountant up to speed quickly with the complex passive activity loss (PAL) rules that apply to certain investments in trades or businesses and rental activities. The cornerstone of the course is the in-depth coverage of the detailed tax law and regulations applicable to passive activities under IRC §469 and how and when the 3.8% net investment income tax under §1411 applies. *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: Hands-On Tax Return Workshop – S Corporations (Form 1120S)
-
Online
8.00 Credits
This case-driven training is designed to get the inexperienced accountant up to speed quickly in the most common areas of S-corporation taxation. The cornerstone of this course is the preparation of the Form 1120S using a fairly complex trial balance common to most S corporation income tax returns. *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: Hands-On Tax Return Workshop – Partnerships & LLCs (Form 1065)
-
Online
8.00 Credits
This case-driven training is designed to get the inexperienced accountant up to speed quickly in the most common areas of partnership, limited liability company (LLC) and limited liability partnership (LLP) taxation. A cornerstone of this course is the preparation of the Form 1065 using a fairly complex trial balance common to most partnership, LLP and LLC income tax returns. *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: Shortcuts to Personal and Professional Success
-
Online
8.00 Credits
We all want to be successful and deeply fulfilled, but most of us have not learned what really leads to a life of abundance, happiness, purpose, and great relationships. In this seminar, you will learn the most effective methods for creating the life you really want. In his interviews with such people as Oprah, the Dalai Lama, Deepak Chopra, Tony Robbins, Ted Turner, and dozens of others, Jonathan has learned what really works and what does not. In this seminar you’ll learn the best personal and professional growth techniques he’s acquired over his career. Once you know these great ideas and methods, you'll be able to take your life and career to a whole new level. Presented by: Jonathan RobinsonType: Live Webcast Replay
Overcoming Tech Adoption Challenges in CPA Firms
-
Online
1.00 Credits
The accounting profession stands at a critical inflection point where artificial intelligence and emerging technologies are reshaping how firms operate, serve clients, and compete in the marketplace. This course, based on the 2025 CPA Firm Tech Report, provides expert guidance on overcoming the five key challenges that prevent firms from successfully adopting transformative technologies: decision paralysis from overwhelming choices, leadership resistance to change, difficulty proving ROI, growing cybersecurity risks, and critical skills gaps. Through real-world case studies and insights from industry leaders, participants will learn practical strategies for evaluating AI solutions, implementing change management frameworks, and building a technology-forward culture that enhances both efficiency and client value. Participants will explore the CPA Firm Digital Maturity Model to assess their firm's readiness for transformation, examine the evolving AI ecosystem specifically designed for accounting applications, and discover how leading firms are leveraging AI to move beyond traditional compliance work toward high-value advisory services. The course addresses critical considerations for firms of all sizes, from solo practitioners to large regional firms, providing actionable frameworks for prioritizing technology investments, measuring success beyond traditional ROI metrics, and developing the hybrid talent needed to thrive in an AI-enhanced future. Whether you're a firm leader hesitant about technology adoption or a forward-thinking professional ready to champion change, this course equips you with the knowledge and tools needed to navigate the technology revolution transforming the accounting profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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.
ACPEN: The Radar Phenomenon
-
Online
1.00 Credits
This session reviews the three elements of fraud, how fraudsters think, how proper internal controls can prevent and detect fraud, and the red flags to look for to identify fraud. It looks at Radar O'Reilly, one of the most beloved characters of the TV show M*A*S*H. He was trusted by his boss to run the administrative side of the US Army medical unit. Were there red flags all around Radar? Did he have the opportunity to steal? Was he a fraudster? We'll find out? Attendees learn to recognize the traits of this type fraudster that are present in many organization. Case studies of various Radars are included. Presented by: Daniel PorterType: Live Webcast Replay
ACPEN: IFRS SMES vs IFRS
-
Online
2.00 Credits
Both IFRS and IFRS for SMEs are self-contained standards designed to meet the needs of specific financial statement users. This course is designed to explain the differences between the two standards, including disclosure requirements and recognition and measurement principles. Presented by: Jennifer LouisType: Live Webcast Replay
ACPEN: 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. Presented by: Dr. Chris HarperType: Live Webcast Replay