CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
ACPEN: K2’s Advanced Excel
-
Online
8.00 Credits
Elevate your Excel expertise with K2's Advanced Excel program! This laptop-friendly course is designed for experienced Excel users who are ready to take their skills to the next level. In this session, you will master critical advanced Excel skills in six key areas: 1. Collaborating seamlessly with other users and securing your workbooks 2. Utilizing tables to analyze and report data efficiently 3. Integrating and manipulating data from external sources with ease 4. Creating and auditing complex formulas 5. Harnessing advanced data analysis tools for deeper insights 6. Employing visualization techniques to communicate information effectively Drawing from over thirty years of experience in delivering Excel training to accountants and business professionals, this program is packed with relevant, real-world examples that reinforce the topics presented. Don't miss this opportunity to become more efficient and proficient in Microsoft Excel, the go-to tool for accounting and financial professionals. This course covers advanced Excel topics that are essential for business success. Participate in this session to elevate and transform your Excel skills! Presented by: Thomas StephensType: Live Webcast Replay
Spring Tax Update with Steve Dilley
-
Online
8.00 Credits
This program provides an update on the latest tax developments, rules and regulations impacting individual and business taxpayers, including a review and integration of the most recent legislation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Microsoft Teams for CPAs: Unlocking Its Full Potential
-
Online
2.00 Credits
Microsoft Teams is designed to be the foundation of your Microsoft 365 ecosystem deployment. When deployed effectively, Teams can serve as a powerful platform for communication, collaboration, and knowledge sharing across your firm or business. Unfortunately, most organizations are substantially underutilizing the capabilities of Teams. This course provides a review and demonstration of the key features of Microsoft Teams that you can harness to optimize the return on your Microsoft 365 investment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Al Capone to Cybercrime: The Journey of IRS Special Agents
-
Online
4.00 Credits
Since 1919, the Internal Revenue Service had a civil and criminal function in the United States tax system. Little do people know, the IRS has an elite criminal function that started with five United States Postal Inspectors. From its early days in taking down Al Capone to now solving cybercrimes, the IRS special agents are tasked with investigating tax fraud, money laundering, and other white collar crimes. This presentation will show you the importance of this law enforcement function, the training, techniques, expertise, and actions that cause them to be known as the "world's finest financial investigators." This presentation has been prepared by a 20 year veteran with the IRS-Criminal Investigation. The presenter investigated crimes, and trained and mentored other special agents. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Ethics Is Everyone’s Business: The Cost of Looking the Other Way
-
Online
1.00 Credits
As responsible, licensed professionals, we cannot ‘look the other way.’ We have a duty to the public, and that responsibility is crystal clear. "All that is necessary for evil to triumph is for good men to do nothing" is attributed to Edmund Burke. We must take appropriate actions and stand for what is right. Looking the other way has a cost, and that cost is high. Sometimes doing the right thing is difficult, but not doing the right thing has an even higher penalty. What can we do to remain ethical? Ethics is not a single event, being ethical is the best and only way we should live. We must proactively engage in society to combat evil and promote good. Presented by: Don Minges, Bob MimsType: Live Webcast Replay
ACPEN: Performance Management
-
Online
1.00 Credits
The tools for managing performance and addressing misconduct are not identical. The failure to point this out to leaders has often resulted in the use of the wrong tool. Reinforcing good performance and securing improvements in performance requires skill in coaching employees, making effective requests, and providing effective feedback. This course provides practical knowledge and scripts for setting, communicating, and enforcing performance expectations, such that personal and employer liability is avoided. Presented by: Mike MirarchiType: Live Webcast Replay
ACPEN: AI Risk Fundamentals: Understanding Emerging Tech Threats
-
Online
1.00 Credits
Navigate the rapidly evolving AI landscape and its emerging risks. Understand fundamental AI technologies including large language models, computer vision, and robotic process automation. Learn to identify AI-related security vulnerabilities, privacy concerns, and operational risks in emerging tech implementations. Explore basic AI risk mitigation strategies, technology assessment frameworks, and vendor evaluation criteria. Gain confidence in discussing AI capabilities, limitations, and risk implications with technical teams and stakeholders to make informed technology adoption decisions. Presented by: Lisa CookType: Live Webcast Replay
ACPEN: Creating A Culture of Trust
-
Online
1.00 Credits
It is the role of a leader to build and maintain a great culture in the organization. The culture is the driving force that shapes the attitudes and behaviors of everyone in the organization. A relationship driven organization is built on trust and is the most effective way to improve productivity, engagement, and the bottom line. Understand the components that enable trust to be created and maintained throughout teams and organizations. Presented by: Michelle Tillis LedermanType: Live Webcast Replay
ACPEN: Powerful Public Speaking
-
Online
1.50 Credits
How you say what you say is more important than what you say. According to a UCLA study, 93% of a communicators effectiveness is based on non-verbal cues. This foundational program include a focus on the verbal, vocal and visual delivery techniques appropriate for the business environment, which can improve a speakers credibility, influence and impact. Depending on the course length other topics include; managing fear, organizing your presentation, increasing attention and interaction, handling questions, infusing humor, creating impactful visuals, and more. Presented by: Michelle Tillis LedermanType: 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
ACPEN: Tax Practice Standards
-
Online
2.00 Credits
Please join us for a comprehensive discussion on standards that professionals must adhere to as tax practitioners. We will be covering the major governing rules, such as Treasury Circular 230, the AICPA Statements on Standards for Tax Services (SSTS), the Internal Revenue Code (IRC) and common law. Also included will be case studies illustrating dilemmas faced by tax practitioners. **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
ACPEN: Navigating IRS : Responding to IRS Notices & Letters
-
Online
2.00 Credits
This 2-hour course gives tax professionals the tools to understand, interpret, and respond appropriately to IRS correspondence. Whether the letter involves audits, collection notices, missing information, or discrepancies, participants will walk away with practical tips for communication, compliance, and resolution. Using real-world examples, the session covers common notices like CP2000, CP14, CP75, CP504, and audit letters, as well as IRS timelines and what they expect in a reply. We’ll also talk about avoiding missed deadlines, maintaining documentation, and using AI tools where appropriate to manage responses efficiently and accurately. *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: Mary Jane HouraniType: Live Webcast Replay
Surgent's Bankruptcy Basics: Understanding the Reorganization and Liquidation Process in These Uncertain Economic Times
-
Online
2.00 Credits
Consumers and businesses file for bankruptcy to seek protection from creditors and to reorganize or liquidate debts. Bankruptcy filings rise and fall with the economy. Surveys show that loss of income is the leading cause of consumer bankruptcies, followed by medical expenses and foreclosure. Corporate bankruptcies, on the other hand, are often the result of several factors, including excessive debt, decreased demand, increased costs, lawsuits or poor accounting practices. It is no secret bankruptcy filings will see a tremendous uptick in the wake of the Covid-19 pandemic. As an accountant, CFP, attorney or other professional, you need to be able to discuss the process and different available courses of action with your clients. Both landlords and tenants will be influenced tremendously. Individuals will look to your advice for a discharge and new start. Businesses will do the same and will also need to advise loyal employees. Creditors will receive proofs of claim and look to you for your expertise. Take this course and make sure you can speak fluently to both creditors and debtors. As trusted advisors, then, professionals should have a basic understanding of the bankruptcy process. This course provides a thorough review of the consumer and corporate bankruptcy practice. Participants in this course will gain an understanding of how consumer and corporate bankruptcy proceedings begin and end, as well as learn about key issues that affect debtor and creditor rights during bankruptcy. This course provides information from the perspective of both debtor and creditor. Although bankruptcy concerns the debts of the debtor, the Bankruptcy Code provides substantial protections to creditors. Creditor rights, however, vary widely depending on the status afforded the creditor under the Bankruptcy Code. Do yourself, your clients and your profit margin a favor and sign up for this invaluable program.
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Online
2.00 Credits
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.
Will Your Ethics Be Burned by Burnout?
-
Online
2.00 Credits
Ethical behavior is not a destination it is a journey with twists, turns, and bumps in the road. We are faced with ethical dilemmas every day. Do I speed to make it to a meeting? Do I call in sick because I need a break? When does "helping my child with their homework" become "doing it for them"? CPAs are ethical most of the time, but staying ethical is hard. It gets harder when we are under stress. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Global Internal Audit Standards (GIAS) Domain IV - Part 1
-
Online
2.20 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 Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Public Speaking Secrets That Wow Audiences
-
Online
4.00 Credits
In this course, you'll learn why being able to do public speaking well is a major advantage in becoming successful in your career. You'll learn how to write a good talk, how to present it well, and how to use your new found ability to get more clients and/or a promotion. In addition, you'll learn how to overcome your nervousness, and how to overcome stress in less than a minute. Presented by: Jonathan RobinsonType: Live Webcast Replay
2026/27 Annual Update for Accountants & Auditors
-
Online
4.00 Credits
This comprehensive annual update brings together key accounting and auditing developments affecting accountants and auditors across industries. The course combines recent standard-setting activity issued by the Financial Accounting Standards Board with major audit and attestation updates from the AICPA, providing a well-rounded view of changes impacting financial reporting and engagement performance. Participants will begin with an overview of recently issued and upcoming Accounting Standards Updates (ASUs), including standards effective for December 31, 2026 year-ends for public companies, private entities, and not-for-profit organizations. The course also highlights issued ASUs with future effective dates and provides high-level insight into recent exposure drafts to support implementation planning. The course then shifts to auditing and attestation developments, including the next phase of quality management with a focus on monitoring and remediation requirements. Participants will also review recent and proposed standards affecting audit, attestation, and consulting engagements, including SSAE No. 24, SSARS No. 26, exposure drafts related to confirmations and fraud, and SAS No. 149 addressing group audits. Designed for preparers, auditors, and firm professionals, this course helps participants understand how recent accounting and auditing changes intersect-and what to watch for as standards and expectations continue to evolve. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: 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. Presented by: Bernie SmithType: Live Webcast Replay
ACPEN: K2’s Business Intelligence, Featuring Microsoft’s Power BI Tools
-
Online
8.00 Credits
In today's fast-paced business world, staying ahead of the competition means leveraging every advantage. Business Intelligence (BI) is the game-changer that can transform your organization. Imagine uncovering hidden insights and gaining a competitive edge with data that was once out of reach. With tools ranging from Excel add-ins to the revolutionary Power BI, you can now harness your existing skills to create dynamic, interactive dashboards and analyses that were unimaginable just a few years ago. This program will empower you with the skills to implement "yourself business intelligence" using a variety of techniques and tools. You'll start by mastering advanced Excel data query and summarization features to create stunning Excel-based dashboards. Then, you'll take your knowledge to the next level by building even more powerful BI objects using Microsoft's Power BI tools. If you're passionate about gaining better insights into your data to make smarter decisions, this fast-paced program is for you. Presented by: Thomas StephensType: Live Webcast Replay