CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Complete Guide to Analyze Data with Excel PivotTables
-
Online
4.00 Credits
Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Federal Tax Update - Individuals (Form 1040)
-
Online
8.00 Credits
With the increasing complexity and ever-changing nature of tax laws and issues, today’s accountant needs a one-day update course focusing on individual income tax issues with an emphasis of newly enacted income tax legislation. This comprehensive class will not only review the current Federal individual income tax laws but will also update tax return preparers of new tax forms, changes to existing tax forms, as well as tax planning opportunities and pitfalls. This is a “must-attend” course for all tax practitioners who want to be up to speed quickly and have a successful Federal individual income tax filing season. **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
Partnership & LLC (Form 1065) - Formation to Liquidation
-
Online
8.00 Credits
With the increasing complexity and ever-changing nature of tax laws and issues, today’s accountant needs a partnership/LLC course focusing on the hottest tax topics and most frequently encountered issues. This case driven course will deal with both partnership/LLC and partner/member developments addressing the most common, yet complex Federal partnership/LLC issues and problems. **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
Basis Calculations & Distributions for Pass-Thru Entity Owners Schedule K-1 Analysis
-
Online
8.00 Credits
This comprehensive case-driven training is designed to get the accountant up to speed quickly in the area of basis calculations and distribution planning for the owners of pass-thru entities (i.e., S corporations, partnerships, and limited liability companies (LLCs)). The cornerstone of this course is the line-by-line analysis of the Schedule K-1s and how it affects the basis calculations. **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
S Corporation Preparation, Basis Calculations & Distributions - Form 1120S Schedule K & K-1 Analysis
-
Online
8.00 Credits
This comprehensive training is designed to get the accountant up to speed quickly with S corporation formation and preparation issues as well as a complete understanding of calculating a shareholder’s stock and debt basis. The cornerstone of this course is the in-depth line-by-line analysis of the Form 1120S Schedule K and K-1 and how these items affect the shareholder’s Federal individual income tax return. **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
Walter Haig's Personal Financial Health Checkup
-
Online
8.00 Credits
This course has significantly changed for the better the lives of a significant number of practitioners and their clients. Participants will learn a step-by-step process for performing an annual personal financial health checkup for themselves, family members, employers, and, if in the practice of accounting, their clients. This course is loaded with practical aids to enable CPAs to help individuals get a "great" financial health checkup result! This course will enable practitioners to add a huge value to their tax preparation services. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Accountants and Malpractice: Can We Get Sued for This?
-
Online
2.00 Credits
This seminar reviews situations in which a CPA or accounting professional may be in danger of being sued. We cover common law causes of action, such as negligence, and the relevant standards and case law defining what constitutes reasonable practitioner behavior. This course is ideal for lawyers, CPAs, EAs, tax preparers, accountants and insurance personnel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Communication Miracles At Work and In Life - Part 1
-
Online
4.00 Credits
Communication is the glue that connects people, but it doesn’t come easy for many of us. If you want to quickly and effectively handle problems with co-workers or clients, and you want people to do what you want without a lot of hassle, this seminar is for you. The bottom line will be better client and co-worker relationships, leading to increased enjoyment and productivity at work.
Accommodation Requests - Substance Abuse - Contagious Infections
-
Online
1.00 Credits
Good judgment works well in handling most employee relations matters. However, there are special situations where legal requirements dictate specific handling to avoid significant personal and employer liability. This course provides practical knowledge and scripts for responding to requests for accommodation regarding religious practices or disabilities, confronting employees in substance-abuse situations, and handling disclosures of contagious infections so that individual is properly helped, and the health of your workforce is protected.
Interviewing, Onboarding and Training 101
-
Online
1.00 Credits
Master the essential skills to build a high-performing team with our online course on interviewing, onboarding, and training. This comprehensive program dives into proven best practices for identifying top talent, creating a seamless onboarding experience, and fostering a culture of continuous development. Whether you’re a seasoned manager or new to hiring, this course equips you with the tools to make confident decisions, engage new hires effectively, and set your team up for success from day one.
K2's Harnessing ChatGPT - Unlocking Professional Efficiency
-
Online
1.00 Credits
Enhance your productivity and streamline your accounting practices with ideas learned in this course. This dynamic program, designed specifically for accountants seeking a competitive edge, delves into the practical applications of ChatGPT in your daily workflow. From conducting comprehensive research and crafting compelling correspondence to swiftly addressing technical inquiries and optimizing Excel formulas, you will gain invaluable skills to expedite your tasks and improve overall efficiency. Furthermore, we will delve into the power of ChatGPT plugins, equipping you with the knowledge to process PDF documents seamlessly and efficiently navigate the vast expanse of the web. Join us on this transformative journey and unlock your potential as a proficient and empowered accountant.
K2'S Supercharging Your Spreadsheet Collaboration
-
Online
1.00 Credits
Collaboration is a key to productivity and success. But remote work can make collaboration more challenging, including collaborating on spreadsheets. Fortunately, tools such as portals with check-in/check-out capabilities, version control, comment tracking, and co-authoring can enable online spreadsheet collaboration. Further, Excel’s Inquire tool can facilitate spreadsheet collaboration in offline environments. Don’t let remote work hamper your spreadsheet collaboration needs! Participate in this session to learn how to collaborate on spreadsheets effectively from anywhere using tools you already own or license.
Sampling - Avoiding Common Mistakes on Financial Statement and Compliance Audits
-
Online
2.00 Credits
Sampling is an important method for determining the extent of testing controls, testing compliance, and tests of substantive details. It allows the auditor to apply procedures to less than 100% of the population yet extend results to project likely conclusions about the entire population. This module will describe the proper process for both attribute testing and variable sampling in financial statement and compliance audits.
Emerging Innovations in Forensic Data Analytics, Crypto Currencies and AI, ChatGPT
-
Online
2.00 Credits
In this course, participants will learn about key trends and innovations impacting the field of forensic data analytics. From generative AI to ChatGPT, machine learning and transaction review, data sharing consortiums and cryptocurrency trends, this course is for the futurist who wants to be leading edge in compliance and anti-fraud technology innovation.
Introduction to Governmental Accounting
-
Online
2.00 Credits
Governmental accounting is distinct from other forms of accounting, requiring a unique approach to financial reporting. This course introduces the fundamentals of governmental accounting, including fund accounting principles and the modified accrual basis of accounting. Participants will explore the structure and purpose of fund financial statements alongside government-wide financial statements, gaining a comprehensive understanding of their layouts and key elements. The course also delves into critical topics such as the concept of component units, the role and structure of Management Discussion & Analysis (MD&A), and the preparation and importance of the Annual Comprehensive Financial Report (ACFR). Perfect for those new to governmental accounting, this course provides a solid foundation for understanding and applying these essential principles.
Surgent's Data Analytics for Accountants and Financial Managers
-
Online
2.00 Credits
Data analytics and mining are the fastest growing disciplines in accounting and general management. Many organizations are either planning programs or have them already underway. Unfortunately, a number of these attempts fail due to poor planning/preparation and a lack of commitment, training, and clear vision of the program's goals. Today there is no shortage of data, but relatively few organizations have established an environment and ongoing process to isolate, capture, analyze, and convert data into actionable information. At times, even organizations that are employing leading-edge analytics are doing it with traditional, limited sets of data. This session explores how an organization can successfully become data driven. The discussion includes numerous examples demonstrating how accounting and financial professionals can build upon their current analytical skills to better perform traditional tasks and assume a role as a business partner with others in their organization. The program is aimed to assist those just beginning the journey, as well as those who want to test their current efforts or are considering the need for a restart. In addition to discussing a number of analytical tools, including available software, lists of reference books and next-level software are provided. This program continues to build upon the Controllership Update Series.
Surgent's Ethics for Tax Professionals
-
Online
2.00 Credits
The purpose of this program is to discuss the ethical mandates that govern the conduct of tax practitioners. The program focuses on the ethical pronouncements of the IRS in Circular 230, as well as the preparer penalty provisions set forth in the Internal Revenue Code. Please note: This ethics course does not cover state-specific issues and so is not applicable in states that require ethics courses to include specific state laws and regulations. Please check with your state board prior to registering for this program if you are in doubt about whether this program satisfies your state's ethics requirements.This course qualifies for IRS credit.
Surgent's Lessons Learned from Successful Companies
-
Online
2.00 Credits
Why do some companies fail while others grow and succeed for generations? Common perceptions often attribute organizational success to great leadership, timing, or unique ideas. Although these traits certainly play a role in helping companies grow, research shows that corporate success often hinges on whether a company is value driven. Such companies have core ideologies that drive almost every major decision. In this course, we look at empirical data on why some companies succeed while others fail. By looking at companies that were created prior to 1950 (e.g., Disney, Marriott, or 3M), we can understand why certain organizations have been able to grow and achieve exceptional success through many different eras in the American economy. The lessons learned from these visionary companies can be broadly applied to organizations of all sizes, including accounting and financial service firms.
Yellow Book Ethics
-
Online
2.00 Credits
Government Auditing Standards (or Yellow Book) has a unique perspective on ethics and transparency due to accountability owed to taxpayers, oversight bodies, and others. This course will discuss the foundational principles in the Yellow Book relevant to professional conduct on related engagements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course qualifies for yellow book credit.
2025 Governmental Auditing Update: Yellow Book & Uniform Guidance
-
Online
3.00 Credits
This course provides a concise update on key changes in governmental auditing. We'll review the 2024 Yellow Book updates, including the shift from quality control to quality management, key audit matters, and implementation timelines. For Single Audits, we'll cover the 2024 Uniform Guidance updates, the 2025 Compliance Supplement, GAO reports on improper payments and fraud, the Financial Data Transparency Act (FDTA), and recent Department of Education guidance on related parties. Stay informed on critical standards and updates to ensure compliance and audit quality.