CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Online
2.00 Credits
How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.
Surgent's Understanding Partnership Taxation: Debt Allocations
-
Online
2.00 Credits
How debt is allocated to the partners in a partnership is important. It dictates how much money may be taken tax-free as a distribution, the losses that flow down to the partners, and the gain or loss on the sale of a partnership interest. However, the allocation of debt can differ depending on the type of debt it is and the type of partner we are talking about. Furthermore, 704(c) can complicate things. And what in the world is a constructive liquidation scenario? In this course, we will tackle the concept of debt allocations - how you do it, what it means, and why you do it.This course qualifies for IRS credit.
Independence for Auditors - AICPA, PCAOB, GAO & DOL
-
Online
4.00 Credits
This course will look at the various rules related to Independence and compare and contrast the requirements. This overview course will help auditors understand the nuances of independence and ensure they meet the requirements to perform attest services for their clients. We will review the requirements for the AICPA, GAO, DOL, and PCAOB.
Federal Tax Update for Business with Doug Van Der Aa
-
Online
4.00 Credits
This program will address recent legislation, rulings and developments affecting business taxpayers and provide practitioners with a comprehensive update for the upcoming tax 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.
Individual Income and Tax Compliance Annual Update
-
Online
4.00 Credits
Tax professionals can get caught up on all the latest developments in the areas of individual, estate, trust and gift tax in this comprehensive course.
Creative Strategies for Buying, Selling, or Gifting a Business
-
Online
8.00 Credits
Navigating the complexities of business transactions requires a deep understanding of tax and estate planning strategies. In this comprehensive course tailored for financial professionals, participants will explore the intricacies of creative approaches to buying, selling, or gifting a business. Through real-world scenarios and practical insights, attendees will gain invaluable expertise in identifying tax risks, minimizing liabilities, and safeguarding assets. From evaluating valuation methods to exploring the details of stock versus asset purchases, this course equips you with the essential tools to provide informed counsel to clients. Discover the potential for strategic success as you master topics including estate transfer and tax implications, gifting strategies, and the utilization of various trusts and partnerships. Whether you're a CPA, EA, attorney, or financial planner, this course offers indispensable knowledge to elevate your practice. With a recommended 8 credit hours of Continuing Professional Education (CPE), this intermediate-level course is designed for professionals with a foundational understanding of business tax and estate planning. Join us and immerse yourself in a journey towards mastery in the vibrant landscape of business transactions. **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.
Nonprofit Accounting and Financial Reporting Explained
-
Online
8.00 Credits
This course provides a high-level overview of the most important issues facing nonprofit entities and their auditors. The focus of this course is on explaining the theory behind major issues and trends, enabling professionals to understand the most important aspects of relevant professional and regulatory standards related to reliable financial reporting for nonprofit entities.
360 Budgeting: A Holistic Approach to Process and Solutions
-
Online
8.00 Credits
The budgeting process can be a time consuming and frustrating process for accountants. The constraints and pressures can lead to poor decisions in both the technical and human components. This series will offer solutions to the budgeting woes from both the big picture and in the details. Budget Mastery: Process, Problems, and Solutions The budgeting process can be a mundane one for accountants. Let’s be realistic and agree that even the word “budget” does not bring excitement to you and your departmental colleagues. The constraints and pressures can lead to poor decisions in both the technical and human components. This session is the first part of a four part series and will cover the big picture of keeping the process fresh, pragmatic and useful. We discuss these keys in an engaging manner by discussing both our flaws and strengths, including how to build on these characteristics towards an enjoyable solutions-based method that should deliver effective results for your organization. Budget Mastery: Walkthroughs and Real World Calculations Towards Tying Budgets to Value This session takes a unique review of the fundamental budget issues faced by all and walks through a detailed modeling process intended to generate discussion and best practices to improve your organization’s financial modeling. From the beginning of the accounting process – ‘the chart of accounts’ to the end of the process – ‘the valuation of the company’, the budgeting cycle via a live case model to learn best practices common to successful companies. This course stands on its own but is part two of a four part budget mastery series. Budget Mastery: The Human Side of Budgeting-Navigating People's issues with 360 Insight You have a fantastic budget, but certain players are not pleased. Financial plans have a technical component and human component. We can resolve some of our budget issues by exploring the process’ human aspect. Understanding what makes you and others operate can enhance your understanding of the entire organization and build upon the respect and influence needed to navigate and lead the budgeting cycle. This session includes a case study that measures an individual’s personality type and then explores how to use our strengths and weaknesses to create a better budget process and quite frankly maybe a better you. This is a great and fun course on its own, but is also part three of a four part series on budget mastery. Budget Mastery: From Numbers to Narrative: Effectively Presenting Your Budget and Reporting Perhaps the most important element of the budget process is its communication. If management does not understand the budget – there is an issue. Knowing the right ways to communicate at all levels is essential to stakeholders laying an ownership claim to successful budgets. This session reveals several key guidelines in successful budget presentations and will identify key problems in how people often communicate financial plans. Presenting your budget and reporting is the final part of a four part series, but can easily stand on its own course that is intended to be fun, enjoyable and educational.
Introduction to Yellow Book: 8-Credit Boot Camp
-
Online
8.00 Credits
This course is designed for accountants in public practice and industry who focus on nonprofit and governmental entities. We will cover the basics needed to understand what makes nonprofit and governmental accounting & auditing unique. The course starts with the key financial reporting differences for governmental and nonprofit entities and then switches focus to review the fundamentals of Yellow Book and Uniform Guidance audits. This foundational course is perfect for those getting started in the nonprofit and governmental arena and those looking for a refresher. 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.
Surgent's S Corporation Core Tax Issues From Formation Through Liquidation
-
Online
8.00 Credits
As experienced staff members master the preparation intricacies of an 1120-S tax return, they are expected to understand and apply the underlying concepts, principles and laws governing S corporation status. This course is designed to illustrate in both theory and practice overarching principles that govern S corporations from formation to revocation, termination and liquidation. Experienced, client-facing staff should be aware of the pitfalls that may inadvertently cause an S-status termination or may generate unintended tax consequences to shareholders.This course qualifies for IRS credit.
The Ethic of Recruitment and Selection
-
Online
2.00 Credits
Today, more than ever, it is essential that employers have an ethical and effective recruiting strategy and selection process that fosters an environment of diversity and inclusion. This webinar focuses on identifying recruiting strategies that help to increase talent pools and employment interviewing that maximizes hiring success. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Awful Ethical Dilemmas - Bringing it to Life, featuring J. Michael Inzina and Don Minges
-
Online
1.00 Credits
Professional Codes of Conduct make Ethics seem easy and clear cut. However, this is not so in real life. This session discusses five cases where the ethics is not so clear cut. What should be considered? We will explain how you can be more diligent and maintain awareness of ethical issues to become more effective and enhance the reputation of the profession.
A Guide to Sampling - Part 2
-
Online
2.00 Credits
Building on Part 1, this course will review the application of sampling in financial statement audits with a focus on sampling for tests of controls. We'll also review the requirements for sampling in Single Audits with a focus on tests of controls and tests of compliance.
Microsoft Excel: Moving Beyond the Basics
-
Online
2.00 Credits
This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information.
Mastering Partnership Basis: Inside and Outside Basis
-
Online
2.00 Credits
This course will provide a detailed analysis of how to determine a partner's tax basis for a partnership interest, with an explanation of the use of both "inside" and "outside" basis determination. An illustrated example with filled in forms will demonstrate how the process works and the potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Monthly Federal Tax Updates - November 2025
-
Online
2.00 Credits
Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Common Yellow Book & Single Audit Deficiencies
-
Online
4.00 Credits
Yellow Book and Single Audit engagements are considered must-select engagements for peer review. This course will review the common deficiencies noted by peer reviewers and federal agencies. We'll focus on the requirements of Yellow Book independence, CPE, and reporting. We will also review deficiencies related to internal controls over compliance, compliance testing, and major program determination for Single Audits. We'll close the course with a look at the deficiencies often identified in COVID-related funds.
K2's Technology Update
-
Online
4.00 Credits
Which technology trends will impact you and your business? What emerging technologies will potentially help you to address security and efficiency? How will the emergence of Windows 11 affect you? Should you consider subscription-based software? What does the future of communication technology have in store for you? Get answers to these and other questions by participating in K2’s Technology Update, a four-hour review of technology trends and developments affecting virtually all business professionals. In this session, you will learn about significant issues such as: • Hardware trends, • Software innovations, • Communication and collaboration tools, • Security issues and solutions, • Key products to consider for implementation, and • Unusual and emerging technologies you may have missed. If you’re taking just one technology-focused training session this year, this should be it!
K2's Excel Best Practices
-
Online
8.00 Credits
As spreadsheets evolve, so must your practices for creating, editing, and auditing them. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today’s best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this “must-see” CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel to its fullest potential.
Google Gemini AI for Accountants
-
Online
2.00 Credits
This course provides a concise overview of Gemini AI, Google's advanced multimodal artificial intelligence model. It explains how Gemini is integrated into different Google products, including Gmail, Docs, Sheets, Slides, and as a stand-alone chatbot. Participants will learn how Gemini enhances productivity by summarizing email threads, suggesting responses, drafting emails, generating formulas, creating tables, and more. By the end of the course, students will have a solid foundation in understanding Gemini AI's role in the evolving landscape of artificial intelligence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.