CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Become a Data Analysis Expert
-
Online
2.00 Credits
In today's rapidly evolving business landscape, accounting professionals are expected to be more than just number crunchers, they are expected to be insightful interpreters of data. In an era where data is king, this course is your gateway to becoming a savvy data analyst, giving you a competitive edge in your field. We will guide you through the intricacies of making complex data analysis approachable and engaging. You will learn the all important Data Analysis Process Flow that will take you from collecting data all the way to making insightful decisions based upon your data. We will explore the basics of data modeling that will allow you to access data from multiple sources and use sophisticated calculations to create our data metrics. You will learn how to create interactive dashboards, perform sophisticated reporting, and uncover deep insights from your data. Whether you're looking to streamline your reporting process, enhance your data visualization skills, or make more data-driven decisions, this course is tailored to meet those needs. It's not just about learning a tool; it's about enhancing your professional identity as a forward-thinking accounting professional. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Financial Planning: Auto & Homeowners Insurance
-
Online
1.00 Credits
While many financial services professionals advise their clients on tax, investment, and life insurance issues, far fewer venture to help in the area of property and casualty insurance. Auto and homeowners policies are mandatory products that everyone generally needs - yet they are also complex products. This complexity raises questions in clients' minds: Are all my belongings covered under my policy? Do I have to adjust my policy if I want to let my neighbor borrow my car? Do I need an additional policy if I want to work as a rideshare driver? And will my premium go up when I move? In this course, we will cover the fundamentals of auto and homeowners' policies. We will touch on these questions, explore basic coverages, and offer some guidance on what practitioners should cover with their clients in this area, so you can offer guidance and give them the peace of mind they need. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Before You Let Them Go: A Whole Brain Approach to Helping Team Members with ADHD Thrive in Your Organization
-
Online
1.00 Credits
Many employees with ADHD struggle with productivity. It’s heart-breaking to feel you have to let a team member go due to lack of performance. This course is for HR Professionals and Team Leaders who want more tools in their tool belt to help improve retention with ADHD team members. You will learn whole brain strategies to help your team members with ADHD improve performance, so they can not only survive but thrive. This innovative science-based approach is designed to help people with ADHD get more done in less time with a process designed with their creative brain in mind. Presented by: Christine WilsonType: Live Webcast Replay
ACPEN: Communicating in a Virtual and Live Environment – Numbers Matter But So Do Words
-
Online
2.00 Credits
People fear presenting more than they do “death”. Communicating numbers is a scary proposition to overcome for both the presenter and the recipients. This course is designed to enhance the communication skills of CPAs and CFOs by emphasizing the importance of understanding and mastering the facts before delivering any presentation, understand the key elements of presenting a narrative, and provide examples to engage live and virtual teams in effective numbers presenting. The goal is to equip financial professionals with the tools needed to overcome fears and provide the best practices research on all types of presentations-from communicating complex financial information effectively to conducting a casual virtual meeting. This is a fun session intended to be interactive with participation either live, virtual or both. Presented by: Bob MimsType: Live Webcast Replay
ACPEN: Viewing A&A Through the Eyes of a Tax Practitioner
-
Online
2.00 Credits
This session offers insight for tax practitioners beyond merely checking a box to satisfy accounting and auditing requirements for license renewal. We devote significant attention to extracting utility from financial statements to support decision needs of both external financial statement users and internal stakeholders. We explore best practices for cross-functional support within firms that perform tax, accounting solutions, financial statement, and consulting services. We also highlight similarities and differences between U.S. GAAP and tax-basis accounting. Presented by: Dr. Chris HarperType: Live Webcast Replay
ACPEN: Tax Practice Standards
-
Online
2.00 Credits
Please join us for a comprehensive discussion on standards that professionals must adhere to as tax practitioners. We will be covering the major governing rules, such as Treasury Circular 230, the AICPA Statements on Standards for Tax Services (SSTS), the Internal Revenue Code (IRC) and common law. Also included will be case studies illustrating dilemmas faced by tax practitioners. **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: Allison McLeodType: Live Webcast Replay
ChatGPT and IRS Taxation Law Research
-
Online
2.00 Credits
The course provides a concise overview of how to use ChatGPT to more effectively and efficiently research IRS taxation law. It delves into techniques for extracting precise information from complex tax legislation, interpreting IRS guidelines with AI assistance, and utilizing ChatGPT's advanced language models for nuanced legal analysis. Participants will learn how to streamline their research process, identify relevant tax law precedents, and apply AI insights to real-world tax scenarios, enhancing their professional proficiency in navigating the intricate world of IRS taxation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel for Accounting Professionals Session 4: Conditional Summing and Lookups
-
Online
2.00 Credits
Boosting productivity with Excel For those unfamiliar with conditional summing, you're in for a revelation —it's an impactful technique that improves productivity in creating reports. You'll learn how to optimize Excel efficiency by managing duplicates, selecting appropriate shortcuts, and performing lookups. Practical hands-on Excel learning exercises taught by highly engaging expert in the field You'll also deepen your skills and tackle real-world Excel workbooks that address the following: Benefits of using lookup functions over direct cell referencing A comprehensive exploration of the popular VLOOKUP function Techniques for removing duplicates to create a distinct set of report labels *Session 4 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 5: Error Trapping and Improving Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-5--error-trapping-and-improving-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*
Surgent's Marijuana: A Generalized Business Viewpoint
-
Online
2.00 Credits
Each year, more states legalize cannabis (i.e., marijuana) for medical or recreational purposes. As legalization grows, so too does the cannabis industry. While some financial professionals have stayed away from this growing sector of the economy, others have embraced the opportunities the cannabis industry has to offer. The legalization of cannabis brings with it a complex regulatory landscape, which includes strict compliance with federal and state regulations. However, the complexity of this emerging market provides opportunities for accountants and other financial professionals. Behind the cannabis dispensaries are scores of related business sectors including food production, retail, farming, and chemical production, as well as facilities, design, and construction. Simply stated, the commercialization of marijuana offers financial professionals an opportunity to participate in an industry expected to reach $73 billion worldwide within six years.
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
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
What If Your Client Didn't Take Reasonable Compensation
-
Online
1.00 Credits
Are you a new advisor handling S Corp clients, or perhaps a seasoned professional facing this common scenario: "My S Corp client didn't take reasonable compensation last year. Now what?" Knowing that reasonable compensation isn't just a tax obligation, but a strategic financial decision, you need to be armed with expert knowledge to help your client navigate this situation. Join us to discuss IRS regulations, understand preventive measures, and address challenges within the year. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Working Through Grief and Loss - How to Build a Supportive Workplace
-
Online
1.00 Credits
Now more than ever, navigating loss, grief and crisis in the workplace is a skillset that leaders must possess. Keeping the heart in human resources is so important, especially in this post-pandemic state we are living in. We will explore ways that you can show empathy to your employees while also balancing your business needs. Presented by: Kelly SimantsType: Live Webcast Replay
ACPEN: Real Estate Professionals: Passive Activity, Sec. 199A and Investment Income Tax
-
Online
2.00 Credits
When do they exist and how to report them? This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction. *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: Steven DilleyType: Live Webcast Replay
ACPEN: K2's AI Accounting And Fraud Detection
-
Online
2.00 Credits
As accounting software evolves, AI-native systems are transforming how firms manage data and measure results. This session explores emerging AI-integrated general ledger platforms such as Digits, Puzzle.io, and Docyt. It examines how new technologies, like vibe coding and low-code/no-code automation, are reshaping efficiency and improving fraud detection. Attendees will learn to assess ROI across accounting tools, identify key performance metrics, and develop an automation strategy that enhances accuracy, productivity, and profitability. This course equips professionals to make smarter technology investments and prepare for the next wave of AI-driven accounting transformation. Presented by: Randolph (Randy) JohnstonType: Live Webcast Replay
ACPEN: K2's Ripped From The Headlines: Lessons Learned From The Most Interesting Tech Crimes
-
Online
2.00 Credits
This session dives into real-world cases of financial fraud, cybercrime, and ethics breaches that captivated the business and accounting world. This session analyzes how these crimes unfolded, the warning signs that were missed, and the internal control and technology failures that enabled them. Participants will explore modern threats, including AI-enabled deception, and learn practical steps to strengthen fraud prevention, data protection, and governance. From shocking embezzlements to headline-making cyberattacks, this course turns true stories into powerful lessons for today's accounting and finance professionals. Presented by: Brian TankersleyType: 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.
Professional Ethical Considerations for CPAs
-
Online
2.00 Credits
Every CPA must comply with a Code of Professional Conduct, which is a hallmark of the CPA designation. CPAs in public practice must overcome higher barriers, such as when attest service providers must also retain independence. This course will provide an overview of the core principles from which the CPA profession is built upon. 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 for Accountants: Using Excel to Cleanse and Prepare Data
-
Online
2.00 Credits
Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.