CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
You Don't Know What You Don't Know About Microsoft Excel
-
Online
8.00 Credits
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Internal Control Changes for Remote Workers
-
Online
2.00 Credits
For the past two decades the trend has been to move away from brick and mortar offices and have a greater number of people work or telecommute from home. Because of the upheaval caused by recent events, the rate of this move has been accelerated. This has and will continue to create control challenges and organizations must work to address these. Such things as moving from time based employee value to task completion based measurement and the ability to drive needed inter-company communication are just a sample of the issues with which entities must contend. This session looks at the benefits and pitfalls of workers that telecommute. It then discusses important risks and controls to consider as this trend continues and evolves in the business world. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Self-Rental Real Estate: Passive Activity & Section 199A
-
Online
2.00 Credits
This program presents a detailed analysis of the self-rental passive activity rules, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Forensic Accounting: Investigating Divorce Cases
-
Online
4.00 Credits
With over 50% of marriages ending in divorce, forensic accountants are frequently used in uncovering hidden income and assets. It is not uncommon for one spouse to hide money from another, sometimes for nefarious reasons. As a CPA, your services are valued by high-net-worth individuals who hire attorneys in their divorce proceedings. In this course, you will learn the art of financial investigations and how to uncover the truth in divorce cases, whether from offshore accounts to lifestyle analysis. Step by step, the course will teach you the valuable skills necessary in finding, analyzing, evaluating, and presenting your findings to your client and if needed, ultimately in divorce court. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Business Valuation Fundamentals
-
Online
1.00 Credits
This course provides a practical overview of business valuation, guiding participants through the key concepts, methodologies, and considerations involved. You will explore the types of valuation reports, the standards governing their preparation, and the step-by-step process of transforming raw data into actionable insights. The course also examines how the intended purpose of a report can influence its conclusions and offers strategies for valuing minority interests. By the end of the course, participants will gain a clear understanding of how to read, interpret, and apply business valuation reports effectively. Presented by: James LairdType: Live Webcast Replay
ACPEN: The Controllership Series – The Controller’s Skillset
-
Online
1.00 Credits
This another course in our series on the controllership function. The controller's role encompasses many traditional responsibilities. The breadth and depth of the controller skill set has expanded and will continue to expand as the business world evolves. The controller position will typically lead teams of financial and accounting experts. Recognizing that leadership and team management skills are must-haves; they need to be able to command their team's respect, inspire them to act, and ensure that such actions are aligned with your organization's overall vision. These skills, along with tactical knowledge will ensure the controller's success. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Preparing to be a Forensic Accountant - Focus on Computer Forensics - Part 3 (Steganography)
-
Online
1.60 Credits
This course is a complement to our series on Becoming a Forensic Accountant and the focus of the course is on steganography techniques. Steganography is the art and science of embedding secret messages in a cover message in such a way that no one, apart from the sender and intended recipient, suspects the existence of the message. The first use of steganography can be traced to 440 BC when ancient Greece, people wrote messages on wood and covered it with wax, that acted as a covering medium Romans used forms of Invisible Inks, to decipher those hidden messages light or heat were used. During World War II the Germans introduced microdots, which were complete documents, pictures, and plans reduced in size to the size of a dot and were attached to normal paperwork. Null Ciphers were also used to hide unencrypted secret messages in an innocent looking message. Given the amount of data being generated and transmitted electronically, it’s no surprise that numerous methods of protecting that data have evolved. There are various types of steganography: Text Steganography - Hiding information inside the text files. This involves changing format of existing text, changing words in a text, generating random character sequences or using context-free grammars to generate readable texts. Image Steganography - Process of hiding text in an image without distorting the picture. Video Steganography - Technique to hide any kind of files into a cover video file. Audio Steganography - The secret message is embedded into an audio signal which alters the binary sequence of the corresponding audio file. Network Steganography - The process of utilizing active network protocols as carriers to transmit a covert message, undetectable by an uninformed party, from a host to its destination. This session will review these methods and also discuss relevant software. Presented by: Lynn FountainType: Live Webcast Replay
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.
Surgent's Top 10 Celebrity Estate Mistakes and How to Avoid Them
-
Online
2.00 Credits
This course uses the lives of the rich and famous as a template to better understand the realm of estate planning. With stories ripped from the headlines, we will examine pitfalls and best practices. Did you know that Prince died without a will, opening the door for 45 people claiming to be his beneficiaries? Or that Michael Jackson was not careful in properly funding his trust, leading to delays and legal battles in the administration of his estate? Even Abraham Lincoln, it turns out, did not have a will. In discussing an array of celebrities, from Jackie Kennedy, Joan Rivers, Jimi Hendrix, and Whitney Houston to Aretha Franklin, Barry White, Leona Helmsley, and Florence Griffith Joyner, the course is designed as an enjoyable learning experience with tips for all levels of expertise. We may not have their fame or fortune, but we can certainly walk the red carpet when it comes to estate planning.
ACPEN: Audit Skills for Beginners
-
Online
4.00 Credits
Learn the basic skills new staff need to hit the ground running and efficiently complete assigned tasks, including what new auditors are expected to know and do, including the nature, timing, and extent of common audit procedures. Focus on why certain procedures are performed and perform typical procedures. Presented by: Jennifer LouisType: Live Webcast Replay
ACPEN: Partnership & S Corporations: How to Calculate Basis
-
Online
4.00 Credits
The IRS has recently increased the pressure on how to calculate and report partner and shareholder basis. Changes in the forms reflect these developments. This program provides a detailed analysis of the calculations related to determining tax basis for a partnership interest and S corporation shareholder shares and loans. How to use the Form 1065, Schedule K-1 and Form 1120S, Schedule K-1 information for basis determination. Illustrated examples with filled in forms will demonstrate how the process works and their many potential pitfalls. *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: Steven DilleyType: Live Webcast Replay
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.
ACPEN: 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. Presented by: Jennifer LouisType: Live Webcast Replay
ACPEN Signature 2026: Partnership and LLCs Update
-
Online
8.00 Credits
LLCs and partnerships continue to present some of the greatest challenges for return preparers and advisors. This program addresses the latest developments affecting these entities, including new IRS audit initiatives, updates on self-employment tax for LLCs and partnerships, disregarded entity rules and transactions, and common allocation issues. Participants will also review how to properly identify various types of partnership debt for basis purposes, understand the use of the §754 election in the sale of interests and at death, and explore reporting requirements for LLC and partnership interests on gift and estate tax returns, including valuation considerations for closely held businesses and minority interests. The session also examines the impact of the recent Sirius Solutions decision. Join us for the course! And as with all ACPEN courses, your questions to the panelists are encouraged. 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: C. Clinton Davis, James Smith, Matthew Beard, Matthew Roberts, Mary McNultyType: 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 Compilations, Reviews, and Preparations: Engagement Performance and Annual Update
-
Online
8.00 Credits
Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical, and technical requirements.
Finding Errors in Excel Spreadsheets
-
Online
2.00 Credits
This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Consulting Services Secrets
-
Online
1.00 Credits
Award winning discussion leader Mark Hugh discusses how to create and capture value with consulting services. Whether you want to consult a little or full time, this valuable course reviews identifying a specialty, growing a practice, capturing value, creating deliverables, and effective marketplace marketing strategies. Presented by: Mark HughType: Live Webcast Replay
ACPEN: Effective Governance for Nonprofit Success
-
Online
1.00 Credits
Effective governance is the cornerstone of any nonprofit organization. This course delves into the foundational elements of nonprofit governance, emphasizing fiduciary duties, board responsibilities, and best practices for board operations. Participants will explore key compliance requirements, risk management strategies, policy development, and regulatory obligations. By the end of the session, you'll be equipped with practical tools and insights to confidently navigate the complexities of nonprofit governance. Presented by: Alex RomeroType: Live Webcast Replay
ACPEN: Business Valuation - Asset Approach
-
Online
1.00 Credits
This course provides a comprehensive introduction to the business valuation process, beginning with key terminology, professional standards, and the rules that guide the appraisal profession. Participants will explore the three primary approaches to value—Asset, Income, and Market—before focusing in depth on the Asset Approach. The course examines when and why this method is used, its advantages and limitations, and how to apply it effectively in real-world scenarios. Through practical examples and clear explanations of each of the three methods within the Asset Approach, learners will gain both the confidence and competence to apply valuation principles in their professional practice. Presented by: James LairdType: Live Webcast Replay