CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's Excel PivotTables for Accountants
-
Online
8.00 Credits
Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge of PivotTables, then plan to participate in this course. You will learn how to build PivotTables, group data inside PivotTables – including grouping options for fiscal periods – and create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques, including building PivotTables that consolidate data from multiple data ranges and PivotTables that connect dynamically to external databases and financial accounting systems. Additionally, you will learn to take advantage of other Excel features associated with PivotTables, including Slicers, Power Query, and Power Pivot. You will be a master of Excel PivotTables at the end of the day! This course is for you if you have been leery of working with PivotTables or have struggled to realize their many benefits. With some information, guidance, and coaching from your K2 instructor, you will be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.
Retirement Planning: Next Stage for You or Your Client
-
Online
2.00 Credits
If you or your clients are facing that stage of life where careers are passing into the background, and a new "to be determined" life is emerging, then you are entering what is called "retirement". Some people are excited, some are scared, and most are both. There are many issues and questions people face at this time - what to do with time, financial, relationships, health, identity and more. This program summarizes the key research studies, provides stories from those who have made this work, and offers thoughtful, practical exercises from my award winning book NEXT STAGE. It will help you (or your clients) address key issues and develop a Master Plan for the transition. If not now, when? This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Best S Corporation, Limited Liability, and Partnership Update Course by Surgent
-
Online
8.00 Credits
This year practitioners need to keep abreast of tax changes affecting pass-through entities used by their business clients and employers, and this enlightening course delivers that information. You will learn invaluable strategies, techniques, innovative tax-planning concepts, income-generating ideas, and other planning opportunities available to S corporations, partnerships, LLCs, and LLPs. In addition, this course will discuss current trends and emerging issues, helping practitioners stay informed about relevant and significant topics that may impact their clients. Continually updated to reflect enacted legislation.
The Ethics Hour: I Can't Believe This Really Happened - Real World Ethics Stories
-
Online
1.00 Credits
You may have read all sorts of stories in books about how bad people steal and make their coworkers and organizations miserable. Come hear veteran Internal Auditor Rob Berry and veteran CFO John L. Daly discuss situations they have seen in the real world.
K2's Accounting Automation
-
Online
1.00 Credits
Why can it be hard to automate accounting? Because many accountants don’t know their options and, therefore, fail to reap the rewards of accounting automation. This session will teach you how easy and profitable accounting automation can be. In it, you will learn how to automate many traditional accounting processes, often with technology you already own. In addition to bank feeds, you will learn about automation options for processing accounts payable and receivable, approving transactions, and linking data from one platform to another. If you are serious about improving efficiency and accuracy, you should make plans to attend this session.
K2's Advanced Collaboration Solutions
-
Online
2.00 Credits
Collaboration is more important now than ever. In this session, you will learn how to take advantage of today’s collaboration tools to improve accuracy, customer/client service, and organizational efficiency.
Analytical Procedures: Practical Applications and Standards
-
Online
2.00 Credits
This session explores the nature of analytical procedures, with significant emphasis placed upon professional standards involving the use of analytical procedures in audit and review engagements. Practical examples to illustrate the application process will also be given.
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.
Private Company Simplified GAAP Alternatives
-
Online
2.00 Credits
The FASB formed the Private Company Council to provide certain alternatives in U.S. GAAP that are only available to nonpublic business entities, with limited exceptions for certain nonprofits. This course will provide insight into when adopting the accounting and financial reporting alternatives would be to the advantage of private companies.
Business Intelligence (BI) and Business Analytics (BA)
-
Online
2.00 Credits
Volatility and complexity are the new normal. Most organizations are drowning in data, but starving for information. The finance and accounting function has the opportunity to leverage Big Data and the continuum of analytics – descriptive, diagnostic, predictive, and prescriptive. All are useful for better decision making. Collecting, validating, and reporting data is not the same thing as analyzing information where we can glean valuable, actionable insights. In some ways the finance function is many years behind other disciplines such as marketing, sales, and supply chain managers, in applying analytics. How can the CFO’s function catch up?
SECURE Act 2.0 and Updates (2025)
-
Online
2.00 Credits
After a false start in 2022 when it failed to pass through Congress, the Secure Act 2.0 was passed in a flurry of year-end legislation. This two hour program will cover the important changes in savings and distributions of retirement plans that impact individuals. Employers will also need to consider how Secure Act 2.0 will the administration of existing plans or the creation of new ones. This course will provide a concise look at these hot topics. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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.
Preparing and Reviewing Workpapers for Higher Quality Audits
-
Online
4.00 Credits
This course will focus on preparing financial statement audit documentation critical for high quality audits that can pass peer review.
Getting On Top of It All: How to Work Smarter, Not Harder - Part 1
-
Online
4.00 Credits
There is always too much to do and too little time to do it all. Fortunately, if you know the right ways to manage people, projects and your time, you can get on top of everything by working smarter. In this seminar you'll learn the best ways to get more done in less time, how to stay sane with all you have to do, and how to get other people to do some of "your" work by building great relationships.
Current Nonprofit Fraud Trends
-
Online
4.00 Credits
Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Preparing and Reviewing Workpapers - Essential Tips for Avoiding Deficient Audit and Other Attest Engagements
-
Online
8.00 Credits
Workpapers are the primary support for findings, conclusions and opinions on any audit or other attest engagement. This course will provide the essential tips and techniques for ensuring workpaper documentation is of a high quality, yet efficient, nature.
ACPEN Signature 2025: Accounting & Auditing Update
-
Online
8.00 Credits
The Accounting and Auditing Update is designed to provide its participants with a comprehensive, in-depth review of what’s happening at the FASB, AICPA, and other professional bodies who may impact accounting and auditing this year, including FASB Statements and Interpretations, Statements on Auditing Standards, Statements of Position, Statements on Standards for Accounting and Review Services, Ethics Interpretations, exposure drafts and projects in progress, with emphasis on the practical application and impact on practitioners in small to medium sized firms and members in industry. Special attention this year will be focused on the emerging use of data analytics related to audit evidence.
Surgent's Annual Accounting and Auditing Update
-
Online
8.00 Credits
Designed as an all-you-need-to-know update for accounting, auditing, and attestation practitioners at all levels in public accounting and industry, this course provides a comprehensive review of recent standard-setting and rulemaking activities of the Financial Accounting Standards Board (FASB), American Institute of Certified Public Accountants (AICPA), Public Company Accounting Oversight Board (PCAOB), and Securities and Exchange Commission (SEC). On the financial accounting front, we will cover the FASB's Post-Implementation Review (PIR) report for revenue recognition under ASC 606 and discuss the best practices in applying the standard and identifying any ongoing issues practitioners are experiencing with applying the standard. We will also discuss the more than a dozen ASUs the FASB has issued since the beginning of 2023 and into 2025 covering crypto assets, disaggregated expenses, business combinations, and leases for entities under common control. Our focus on AICPA standards includes a detailed discussion of revamped AICPA quality management standards. The AICPA updated and modernized the standards by issuing Statement on Quality Management Standards 1, 2, and 3 (SQMS 1, SQMS 2, and SQMS 3, respectively), SSARS No. 26, and SAS 146, Quality Management for an Engagement Conducted in Accordance with Generally Accepted Auditing Standards (SAS 146). These standards, effective December 15, 2025, modernize quality management standards to reflect an increased focus on risk assessment, technology use, and the presence of outside experts on engagements. We will also cover new rules impacting public company audits and present case studies on recent fraudulent accounting stories and best practices for detecting and preventing such frauds. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.
Becoming Conflict Competent
-
Online
2.00 Credits
Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles, and build constructive behaviors to manage conflict. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Cultural Transformation
-
Online
1.00 Credits
This course provides a complete framework for transforming the culture in your organization. Key topics covered include: - What is organizational culture - A self assessment - Why culture matters - How to change your culture This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.