CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Advanced Excel for Staff - Build Reports and Analyze Data
-
Online
2.00 Credits
Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize, and structure data, apply calculations to derive key metrics, and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful, and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Leadership Skills of Tomorrow: Delegate and Listen
-
Online
2.00 Credits
Mastering two leadership skills will decrease your stress, and give you room to enjoy your career. Delegating and listening are key essential skills to hone to elevate your career. You were born with two ears and one mouth. And yet, good listeners aren't born. World-class listeners deliberately practice this skill, even when their audience is challenging. This is a skill which can be learned. Participants will gain awareness into their blind spots to listening, strategies to regain focus, how to stop interrupting, and demonstrate to their audience they are listening. How often have you said, "It would just be easier if I did this myself?" or "Nobody can do this task as well as I can, so I'll just do it myself." If this sounds like you, then it's time to start working on your delegation skills. Delegation is not only important as a means to save you time, but it is also about developing the next generation of leaders. 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 Essential Depreciation and Expensing Update
-
Online
4.00 Credits
This course offers a comprehensive analysis of the evolving rules surrounding depreciation, amortization, and property transactions, incorporating the latest inflation adjustments and technical corrections. It offers practical guidance through real-world examples and case studies to clarify complex rules and help professionals stay compliant and informed amid ongoing change.
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
Forensic Accounting: Court Approved Methods of Proof
-
Online
4.00 Credits
How does a forensic accountant calculate financial losses? Federal courts have approved various ways to calculate losses ranging from net worth method of proof to the expenditures method. Each method of proof depends on the available facts to the forensic accountant. This presentation will focus on the various court approved methods of proof, when to use them, and how to calculate the total loss. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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
LLC's & S Corporations: a Comparative Analysis
-
Online
8.00 Credits
This course focuses on the most common aspects and tax implications of Limited Liability Companies and S Corporations. It will further compare forms of entities, along with corporate formalities compliance issues of each entity type. Electing Subchapter S status as well as reviewing the mechanics of electing Subchapter S status will be discussed. Highlights of entity specific tax forms will be discussed, as well as accountable plans, taxable fringe benefits, officer reasonable compensation, estate planning, business continuation planning and audit strategies. Schedules K-1, K-2, K-3, and effectively connected income will be reviewed in this course as well. 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 Perplexing Financial and Economic Issues for the CFO/Controller
-
Online
8.00 Credits
For CFOs and Controllers, the emergence of regulatory, fiscal, and monetary policy directly impacting their organizations' costs, competitiveness, and financing options, are causing them to understand the effect of shocks well outside of their control. The Dodd-Frank Act, health care reform, shortfalls in Social Security, unfunded pension liabilities, and deficit spending will all be explored relative to their impact on the CFO/Controller and your organization.
The Best Federal Tax Update Course by Surgent
-
Online
8.00 Credits
In this continually revised course, tax advisors will be fully updated on the most recent enacted legislation and IRS guidance, as well as major trends on the horizon with a view toward planning considerations. This update course is designed for all practitioners, both those working in public accounting as well as those in private industry, who need the latest information on tax changes. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BITU.
Best Practices: Conducting Meaningful Walkthroughs
-
Online
2.00 Credits
This course will serve as an introduction to conducting effective walkthroughs to gain an understanding of the client's transaction processes as well as identifying internal controls within each process. This course will review the procedures, questions to ask, and documentation requirements of walkthroughs. It will also include real-world examples of the red flags that may arise while executing a walkthrough. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
A Culture of Regulatory Ethics: A Competitive Advantage
-
Online
4.00 Credits
In a competitive market, every company is looking for anyway to differentiate themselves from their competition. While we often look to new markets and data for a competitive advantage, ethics can be the factor that makes the biggest difference to customers, employees, and the public at large. Using surveys, research, case studies, and examples, this course will explore why the CPA credential and the AICPA Code of Professional Conduct is so different. We will discuss why CPA's are in a unique position of trust and how this can put their companies ahead. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
A&A Update for Nonprofits and Single Audit - 2026
-
Online
8.00 Credits
This course provides a high-level overview of the most important accounting, financial reporting, compliance and audit issues facing nonprofit entities and their accountants. The focus is on explaining the basis behind major issues and trends in executive summary (yet practical) form, enabling professionals to understand the most important aspects of relevant standards, and the basis for any potential changes on the horizon. 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 SECURE Act 2.0 – Planning Opportunities for Individuals
-
Online
1.20 Credits
The Secure Act 2.0 was passed in a flurry of year-end legislation. This one hour program will cover the important changes that individuals need to know about contributions to accounts and new ways of accessing these funds. This course will provide a concise look at these hot topics. **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: Identifying and Implementing the Proper Balance of Internal Controls
-
Online
2.00 Credits
Internal Controls (IC) are in place for a reason. They help maintain the control environment and establish efficient and effective processes. They also serve as a mitigation technique for identifying when processes have changed and when procedures need to be adjusted. In today’s business world, all personnel must understand the concept of internal control, how they should be utilized and their benefits. The purpose and value of internal controls are often misunderstood and misapplied by management. Internal controls should be viewed as a value-oriented activity that assists the organization in the effective execution of its objectives. Properly designed and executed controls are the key to ensuring this view. A previous course “The Manager’s Responsibility for Internal Control," addressed these concepts at a higher level. This course further explores the types of ICs, how they can be properly utilized and the cost benefit considerations for implementation. Internal control is a process designed to provide reasonable assurance regarding the achievement of objectives in the following areas: Effectiveness and efficiency of operations Reliability of financial reporting Compliance with applicable laws and regulations Safeguarding assets Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Accounting and Reporting Long-Term Debt
-
Online
2.00 Credits
Debt is typically a critical component of the financial statements, impacting the economic decisions of financial statement users. This course will address common issues that may impact the proper presentation and disclosure of debt, including debt covenant compliance and other issues that impact classification of the liability between current vs. noncurrent. Presented by: Jennifer LouisType: Live Webcast Replay
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
Online
2.00 Credits
This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners "tax basis" capital accounts, now required for tax form reporting. 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 Communicating Financial Results to Stakeholders: A Guide for Client Advisory Services
-
Online
2.00 Credits
One of the most difficult things for any Client Advisory Services (CAS) professional to learn is how to communicate financial information to non-financial people. To be successful, it's crucial to master this skill, as we frequently explain accounting jargon to those unfamiliar with the field. In this course, we will explore how to properly communicate with stakeholders, including investors, clients, boards of directors, and even other departments. We will explore biases that people have when viewing financial information and even how to make sure we keep our message on point. If you are looking to move up in the financial services world, this course is a must for you.
Surgent's Engaging and Managing Young Professionals
-
Online
2.00 Credits
Younger professionals comprise a significant part of the accounting and finance workforce. Whether you are an owner of a small accounting practice or a manager in a multinational accounting firm, it is important to understand the characteristics and expectations of this large segment of the workforce. Research reveals that many of the common stereotypes surrounding young professionals are unfounded and counterproductive. This course provides an understanding of who young professionals are in comparison to their predecessors, the Gen-Xers and baby boomers. Equally important, the presentation will look at common myths regarding young professionals and why understanding this class of employees provides opportunities for your organization to grow and succeed.
Surgent's Section 529 Plans: A Comprehensive Guide
-
Online
2.00 Credits
This course provides a thorough examination of qualified tuition programs (Section 529 plans), focusing on their tax treatment, planning applications, and recent legislative changes. Participants will learn how 529 plans operate, what qualifies as education expenses, and how contributions, distributions, and beneficiary changes are treated under federal law. The course explores practical planning strategies, including 529-to-Roth IRA rollovers, multigenerational "dynasty" 529 planning, grandparent-owned account considerations, and interplay with financial aid. It also addresses state-level variations, compliance issues, and common pitfalls. Using real-world scenarios, the course evaluates when 529 plans are advantageous, the limitations families may encounter, and alternative approaches to education and long-term savings. Participants will gain a clear understanding of tax benefits, penalties, strategic funding approaches, and planning opportunities for high-net-worth families as well as typical households.
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