CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Streamlined Excel Reporting Series Session 3: PivotTables Displays and Alternatives
-
Online
2.00 Credits
Essential techniques for displaying data in alternative ways You'll work alongside an expert instructor as you practice using PivotTables and exploring creative alternatives for insightful data presentation. You'll learn techniques for effective data presentation, including: Filtering and sorting data Cleaning and organizing data through text manipulation Using dynamic features to summarize and analyze large datasets Using slicers and filters for visual filtering Highlighting key Excel features through guided practice You'll walk through realistic scenarios that show alternative functions for greater data management, such as: GROUPBY PIVOTB PERCENTOF In addition, various text functions such as TEXTJOIN and TEXTSPLIT will be explained, highlighting how to concatenate and split text strings efficiently. *Session 3 is one of four individual sessions. Each session builds on the previous one, so consider watching [Streamlined Excel Reporting Series Session 4: External Data and PivotCharts](https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series-session-4-external-data-and-pivotcharts) to tackle real-world issues and create powerful workbooks.*
Surgent's Working Remotely: Best Practices, Challenges, and Opportunities
-
Online
2.00 Credits
Working from home presents both benefits and challenges for professionals. For employees, working from home provides opportunities to be more productive and gain time that would otherwise be spent commuting to and from the office. Employers who utilize remote work enjoy fewer fixed costs, more efficiency, and greater employee satisfaction. Without proper planning, professionals who work remotely may experience increased anxiety and disorganization. They may also jeopardize data privacy. However, when executed properly, working remotely can help organizations become more efficient and profitable, while at the same time improving employee morale. This course looks at how firms and companies have successfully implemented work from home programs and discusses mistakes that can be avoided through proper planning.
What You Can Learn From the Statement of Cash Flows
-
Online
2.00 Credits
This course allows you to get reacquainted with the statement of cash flows. We will refresh your skills regarding both the preparation and utilization of the statement of cash flows. Significant emphasis will be placed on the informational role of the statement of cash flows and insights that can be obtained using the statement of cash flows in concert with the other elements of a company's accrual-basis financial statements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
AI for CPAs - How it Works and How to Apply it
-
Online
4.00 Credits
Generative AI tools such as ChatGPT, Microsoft Copilot, Google Gemini and many others are transforming the digital landscape of virtually every business, including CPA firms. We will demystify the complex world of generative AI in this informative session designed specifically for CPAs. We will break down the nuts and bolts of how generative AI works, making the technical aspects accessible and relevant. Equip yourself with the foundational knowledge to leverage AI in your practice or business. You will learn multiple examples of how you can apply generative AI tools in accounting, finance and tax to boost your team's productivity and improve the quality of your work product. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's Microsoft Teams
-
Online
4.00 Credits
Microsoft Teams is one of the most exciting personal and organizationally productivity tools to ever appear on the business landscape. With Teams, you can communicate and collaborate easily and securely with others, including colleagues outside your organization. Further, you can extend the already-robust functionality in Teams by incorporating add-in solutions with just a few clicks of the mouse. Unfortunately, despite Teams’ power and relatively simple interface, many organizations struggle with deploying and using Teams. In this session, you will learn how you can get up and running quickly in Teams so that you can take full advantage of this powerful tool. More specifically, you will learn how you can get started in Teams and critical decisions that will affect your deployment. Also, you will learn how to work in Teams, including how to take advantage of the chat, voice, and video call services and how to share documents securely with others. Moreover, you will learn how to extend your Teams platform to external organizations for improved communication and collaboration. Additionally, you will identify how you can add other applications into Teams and optimize Team's configuration for the best overall efficiency and security. If you are working with Teams or plan to do so, this is one CPE session you can’t afford to miss!
Reviewing Partnership Tax Returns: What Are You Missing?
-
Online
4.00 Credits
Strategies to help reviewers catch errors in partnership and LLC tax returns before they are submitted.
Recruit. Retain. Engage. Mastering LinkedIn for HR Success
-
Online
2.00 Credits
Today's savvy executives use LinkedIn to accelerate hiring, as well as, to promote employee retention and engagement. This interactive session is for the financial executive who is actively growing and nurturing a team or company and wants to leverage LinkedIn, which is the best digital resource available. Join us for this powerful webinar and unlock the full potential of LinkedIn as your HR secret weapon for recruiting top talent, retaining your best employees, and elevating overall team engagement. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Understanding the Tax Implications of Retirement Plan Distributions
-
Online
1.00 Credits
This session will address the complex rules of retirement distributions, review key provisions of the SECURE Act 2.0, and provide practical strategies of maximizing tax benefits for your client. **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.
Disaster Relief Act of 2024
-
Online
1.00 Credits
Literally thousands of individual taxpayers may have increased deductions or exclusions from gross income as a result of the Disaster Relief Act of 2024. Casualty provisions of the Act are retroactive to December 19, 2019 through early 2025. Both low and high income taxpayers may benefit from the Act through exclusions of payments received as compensation for wildfire damages - retroactive to 2014! This course will review the provisions of this new act. *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
Listen to Lead: The HR Champion's Guide to Building an Employee Listening Strategy
-
Online
1.00 Credits
When it comes to assessing your organization's employee experience, it's no longer enough to administer an annual survey and call it a day. Rather to engage and retain today's talent, it's all about an integrated, strategic approach to employee listening woven throughout the entire employee lifecycle. While this thought can overwhelm many HR professionals, the good news is that this is an area where you can start to see big ROI in a short period of time. In this session, we'll break down where to start, steps to improve your existing efforts, and strategies you can use to move the needle in your organization and drive HR and business success.
Introduction to Forensic Data Analytics
-
Online
2.00 Credits
In this introductory course, you'll learn the fundamentals of integrating forensic data analytics into your anti-fraud risk management program. We will cover key definitions, use cases, methodologies and some of the leading innovations and techniques driving this ever-evolving field of "finding hidden money."
Data Extraction, Transformation, Validation the Right Data Sources for Analysis
-
Online
2.00 Credits
In this course, we will explore the various types of data - both structured and unstructured - used in conducting fraud risk investigations and proactive monitoring. We will explore the various tools available on the market and techniques to confirm completeness and accuracy of the data before the analysis begins. The course will cover the process for selecting the right data sources to align with the various risks as well as pitfalls to avoid when preparing the data for analysis.
Global Internal Audit Standards (GIAS) Domain V - Part 1
-
Online
2.00 Credits
The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service
2025 EBP Update: Standards, Compliance, and Best Practices
-
Online
2.00 Credits
Stay ahead in the evolving landscape of employee benefit plan (EBP) audits with this essential 2025 update. This course covers key regulatory changes, including the SECURE 2.0 Act, newly effective accounting and auditing standards (SAS 145 and Quality Management Standards), and insights from the Department of Labor's latest findings on audit quality. We'll also dive into emerging hot topics shaping the EBP audit environment, equipping you with the knowledge to enhance compliance, mitigate risks, and deliver exceptional audit quality. Whether you're a seasoned professional or new to EBP audits, this session will provide actionable insights to keep you confident and prepared.
Erase the Mark: Best Practices in Penalty Abatement
-
Online
2.00 Credits
If there is a potential error, the IRS will assess a tax and add a hefty penalty, without even knowing the facts. As a tax professional, you will be exposed to the IRS and their methods of penalizing taxpayers for the smallest of violations. This presentation will focus on the rules and regulations that create the penalty, and the reasons that exist that the IRS will consider to remove those penalties. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's AI - Better Prompts, Better Results
-
Online
1.00 Credits
Generative AI is seemingly everywhere, and business professionals are embracing the technology. And for a good reason - generative AI provides opportunities for enormous gains in efficiency and productivity. However, those gains can be even greater if you understand best practices for issuing AI prompts. In this session, you will learn the best ways to ask questions of your AI platforms so that you get the information you seek quickly and easily. Stop wasting time with inefficient and ineffective prompts! Learn the best ways to get the information you seek!
Officer Compensation Audits: What It Is and How to Defend It
-
Online
2.00 Credits
This course examines the key elements of Officer Reasonable Compensation requirements for S and C Corporations. It focuses on the role of court cases in guiding compensation standards, the identification of individuals required to receive it, and strategies for advising taxpayers based on specific circumstances. Participants will also learn how to represent taxpayers before the IRS to defend the Officer’s Reasonable Compensation amount effectively for any given year. *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
Neurodiversity & Productivity. Include More Minds to Make the Most of Your Time
-
Online
1.00 Credits
Being neuro-inclusive is not only kind, but can also help your team get the right things done in less time. This course will be about what neurodiversity is, give an overview of brain science, and show you tactical tips and techniques you can use to help your company get more of the right things done in less time with a strategy designed with more brains in mind.
Accounting and Disclosure Issues After a Natural Disaster
-
Online
2.00 Credits
The repercussions from a natural disaster can be devastating. Properly accounting and reporting for the impact of those disasters can be confusing. This course will focus on some of the most FAQ related to the proper treatment of accounting for disasters in GAAP basis financial statements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Art of Accountability: Effective Strategies for Tough Conversations
-
Online
1.00 Credits
The Art of Accountability is a dynamic training session tailored for leaders seeking to cultivate a culture of accountability while fostering respect and trust within their teams. High morale is intrinsically linked to high accountability in todays fast-paced work environment.