CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Improve Spreadsheets by Building Controls in Excel
-
Online
2.00 Credits
In today's data-driven world, spreadsheets serve as the backbone of business and personal productivity. However, creating complex and error-prone spreadsheets can lead to critical mistakes and inefficiencies. This course aims to equip you with the knowledge and tools to build robust spreadsheets, implementing a range of controls and safeguards to ensure data integrity, streamline processes, and maximize accuracy. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Cryptocurrency Transactions: Navigating Federal Tax Rules
-
Online
1.00 Credits
As cryptocurrencies like Bitcoin, Ethereum, and others become more popular, tax authorities around the world are working to create regulations for their use and transactions. This session will address cryptocurrency tax issues and their complexities and challenges that individuals and businesses face when dealing with the taxation of digital currencies. *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
ACPEN: The Controllership Series - Addressing Budgeting Uncertainty
-
Online
1.00 Credits
With new accounting standards, the economic landscape and evolving technology, accounting, financial reporting and finance continue to grow in complexity. FASB has tried to address the growing complexity, by working towards making GAAP less convoluted. The struggle to stay on top of accounting financial reporting requirements and finance changes due to the economy continues for several reasons. Lack of in-house SMEs, managing high volumes of transactions, and data and evolving information technology systems. In the future, executives must consider the challenges they will face in future years that will bring their own nuances and complexities. Budgeting is certainly one of those processes that must be evaluated and re-evaluated for efficiency. This session delves into the corporate budgeting process and discusses methods used and which methods may or may not allow for the organization’s to properly plan for a volatile future. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Preparing to be a Forensic Accountant - Focus on Computer Forensics - Part 1
-
Online
1.00 Credits
This course is a continuation of our series on preparing to become a forensic accountant. Within this segment we focus on elements of computer forensics. This session is designed to delve into further investigative procedures used in computer forensics. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: K2’s Taking Another Look At PDFs
-
Online
2.00 Credits
We’re all familiar with PDF documents. However, it’s safe to say that most professionals use only a tiny fraction of their features. This circumstance is unfortunate, considering all you can do with PDF documents. Therefore, isn’t it time to take another look at PDF K2’s Taking Another Look At PDFs documents and all you can do with them? Participate in this session to learn more about PDFs and how and why they should be a cornerstone technology in most organizations. Collaboration options, long-term storage and archival, and fillable forms are just a few features you will learn about in this session. If you’re ready to elevate your PDF productivity, this session is for you! Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: Common Sense CFO: Balance Sheet Issues Walk through to Understand and Build Value
-
Online
2.00 Credits
We mostly focus on the income statement, but what about other financial statements and countless other accounting concerns? This seminar is dedicated to breaking down common balance sheet issues, both on-the-books and off, that have an impact on our stakeholders and the value of the organization. Using practical analysis, we highlight several key tools in understanding and communicating the importance of the forgotten cornerstone of accounting: the balance sheet. Most notably, we dedicate time to the pressing issue of “unrecorded assets”. This session is designed to also be fun and entertaining. This seminar stands on its own but is also part of the Common Sense CFO series. Presented by: Bob MimsType: Live Webcast Replay
ACPEN: Advanced Excel: Hidden Secrets and Gems
-
Online
2.00 Credits
This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level. Presented by: Dr. Chris HarperType: Live Webcast Replay
Hot Topics Audit & Attest Update - 2026
-
Online
2.00 Credits
Many public accountants desire to have a quick overview of only the most current changes to professional and ethical requirements. This course will provide an executive summary of the major changes in audit and other attest requirements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. 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 Excel Shortcuts for Accountants
-
Online
2.00 Credits
This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.
Surgent's The Risks and Benefits of ChatGPT and Artificial Intelligence
-
Online
2.00 Credits
We see multiple stories about the rapid growth of artificial intelligence (AI) and its entry into our lives in the form of AI tools, including ChatGPT. They seem to be everywhere. It is difficult to overstate how much things will change with the rise of these new technologies, or how important it is that companies embrace the opportunity to execute them correctly. Having conversations regarding the proper adoption of these technologies and tools is a crucial first step, including drafting policies to assist companies with their beneficial and thoughtful implementation and use. This course will define the state of AI tools, what benefits and risks exist, and which steps to take to begin adopting these technologies with appropriate guardrails, policies, and training. It is less likely that AI will destroy industries, and more likely that companies that embrace AI will overtake those companies that do not.
ACPEN: 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 terri.storer@acpen.com Presented by: Doug Van Der AaType: Live Webcast Replay
ACPEN: Partnership Essentials: Review & Update
-
Online
4.00 Credits
This course examines the critical issues and special opportunities facing partnerships and their partners, as well as the relationship between limited liability companies and partnerships, with a focus on reporting tax basis capital accounts. *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: Doug Van Der AaType: Live Webcast Replay
Fraud, Controls & Ethics: Best Practices & Case Studies
-
Online
4.00 Credits
This course explores actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters from achieving their nefarious acts. Then we will switch gears to an interactive, case-based discussion that asks participants to reach their own conclusions by analyzing facts in concert with the AICPA Code of Professional Conduct and other sources of ethical guidance. This course ultimately provides practical, action-oriented insight that can be implemented by accounting professionals in both public practice and industry. This event may be a rebroadcast of a live event and the instructor will be available for questions during the event.
ACPEN: 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, then this course is for you! In this dynamic and engaging session, you'll master how to: • Build PivotTables from scratch • Group data inside PivotTables, including options for fiscal periods • Create user-defined calculations in your PivotTables We start with the fundamentals and quickly move to advanced techniques, including: • Building PivotTables that consolidate data from multiple ranges • Connecting PivotTables dynamically to external databases and financial accounting systems • Leveraging other Excel features associated with PivotTables, such as Slicers, Power Query, and Power Pivot This seminar is a must for anyone eager to enhance their Excel skills and transform their workflow. With guidance and coaching from your K2 instructor, you'll be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks. Presented by: Thomas StephensType: Live Webcast Replay
How to Audit Cash
-
Online
2.00 Credits
Cash is essential to every business, and is often one of the first accounts audit staff are exposed to. This course will cover the basics of auditing cash, including the related audit assertions, risks, & threats to the cash balance. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through some real-world examples. 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 Select Estate and Life Planning Issues for the Middle-Income Client
-
Online
4.00 Credits
Clients think that estate planning only applies to the very rich. In truth, there are many issues of critical concern for which the middle-income client needs to plan. This course is a must-attend for all Accounting and Financial Professionals who work with middle-income clients and are looking for ways to provide additional quality services. Updated for developments relative to estate tax changes.
Forensic Accounting: When The Office Is A Crime Scene
-
Online
4.00 Credits
Embezzlement happens often to many small businesses. Unfortunately, the lack of internal controls allow the embezzlement to remain undetected for years. But when it is discovered, the small business owner will most likely contact their CPA for advice. What should you do when your client contacts you about their employee embezzling money from their business? What options should you present to your client? How can your client protect themselves, while investigating the embezzlement? What steps need to be taken about preserving any documents, emails, texts, or phone calls? This course teaches how to engage the client, properly identify the evidence needed to prove the crime, how to write the report for civil and criminal trial, and best practices in preserving electronic and paper evidence. 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 to be a Forensic Accountant - Focus on Computer Forensics - Part 2 (Cryptology)
-
Online
1.00 Credits
This is a continuing part of our series on forensic accounting. Within this segment we discuss the concepts that are part of computer forensics known as cryptology. The term cryptography is from Ancient Greek and means “hidden secret”. It is the practice and study of techniques for secure communications in the presence of adversarial behavior. Cryptography is about constructing and analyzing protocols that prevent third parties or the public from reading private messages. Cryptography starts with secrets. Various aspects in information security such as data confidentiality, data integrity, authentication and non-repudiation (where a statement’s author cannot successfully dispute its authorship) are central to modern cryptography. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: The Controllership Series: The Controllers Role in Internal Controls
-
Online
1.50 Credits
This course in part of our series on the Controllership Role. Internal control is relevant to everyone in the workplace. It represents our moral responsibility to understand and comply with organization policies and procedures. It also provides the means to hold individuals accountable for their work. The controller is an impactful position that affects a company's processes including financial, compliance and operational. Controller functions vary across companies often following the size and complexity of the business and the industry. Smaller companies require more versatility for the controller Larger companies are more able to segregate job responsibilities across other employees. The controller should be knowledgeable of the various controls to create a control system that will appropriately safeguard company assets and processes. Internal controls are typically comprised of control activities such as authorization, documentation, reconciliation, security and segregation of duties. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: 1065 – Understanding Partnerships Tax Returns
-
Online
2.00 Credits
Form 1065 is the tax return filed by partnerships, which is one of the most common forms of business organizations in the United States. This course provides an in-depth understanding of the preparation and filing of Form 1065. The course will cover the basics of partnership taxation, including how partnerships are taxed, the different types of partnerships, and the tax obligations of partners. It will also discuss the importance of keeping accurate financial records, the role of the partnership agreement in tax reporting, and the filing deadlines for Form 1065. Participants will gain a comprehensive understanding of the various sections of Form 1065, including the Schedule K-1, which reports each partner's share of the partnership's income, deductions, and credits. The course will also cover how to report partnership income, expenses, and deductions, as well as the tax implications of buying and selling partnership interests. In addition, the course will provide an overview of common errors and omissions made when preparing Form 1065, and how to avoid them. It will also cover recent changes in tax laws that affect partnership taxation. Overall, this course is designed for tax professionals, accountants, business owners, and individuals who need to understand the intricacies of partnership taxation and the preparation and filing of Form 1065. Upon completion of the course, participants will have a solid understanding of partnership taxation and will be able to prepare and file Form 1065 with confidence. **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: Arthur WernerType: Live Webcast Replay