CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
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.
The Ethics Hour: Deceit and the Whys Behind the Lies: Understanding Ethics
-
Online
1.00 Credits
Our guidance on ethics comes from the AICPA and other groups, but it does not fully address the “why” behind ethics. Understanding what motivates people and understanding those people are key to both solving ethical dilemmas and workplace issues that can lead to greater job satisfaction and efficiency. To correct an issue, you need to delve into the root cause – the why?
HR Investigations - Episode 1 - Introduction-Assessing-Planning
-
Online
1.00 Credits
Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session is an introduction to these differences and provides best practices for assessing allegations of employee misconduct and planning the investigation. Attendees will end the session with takeaways to immediately implement in future HR investigations. Episodes 2 and 3 complete the series.
ProActive Response: Active Shooter Training - Recognize. Respond. Survive.
-
Online
2.00 Credits
ProActive Response Group's Active Shooter Response Training course educates participants in current trends of active shooter incidents, how to recognize early warning signs of violence, appropriate actions to increase chances of survival in an active shooter event, and how to use basic medical equipment to save the lives of victims. *****(Warning: This video contains simulated graphic scenes that some viewers may find disturbing)*****
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.
PPP Fraud and Financial Professionals
-
Online
2.00 Credits
Casey Crowther did not have a college education, but he had an outstanding work ethic. With little more than a pickup truck and some hand tools, he built a roofing company that grew. Over time, Casey's company employed more than 100 people and generated more than $20 million in annual revenues. With a company of that size, Casey relied upon advice from his bookkeeper when filling out financial documents. As a result of representations he made on bank statements and loan documents, authorities charged Casey with criminal behavior related to PPP loan fraud. What should an accounting professional learn from Casey's story? Stay tuned to find out! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Streamlined Excel Reporting Series Session 4: External Data and PivotCharts
-
Online
2.00 Credits
Extracting data for richer insights You'll gain meaningful analysis techniques while working alongside an industry expert and knowledgeable instructor. This session begins with the GETPIVOTDATA function to enable report customization. It's a great starting point before moving on to more advanced techniques. Power Query introduction With its user-friendly interface, Power Query empowers Excel users to take the next step by enabling seamless data import and transformation. With Power Query, you will explore features, including: Getting and transforming data Loading data Managing columns Data source settings Layouts and parameters Visualizing with PivotCharts A well-designed chart can effectively illustrate data trends and comparisons. You'll learn how to create and customize PivotCharts to elevate your reports and make the data more accessible to others. *Session 4 is one of four individual sessions. Each session builds on the previous one, so consider watching all the sessions [Streamlined Excel Reporting Series](https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series) to tackle real-world issues and create powerful workbooks.*
Determining Reasonable Compensation for Owner Employees
-
Online
1.00 Credits
This session will expand on methodologies to employ when owner-employee compensation is at issue. The session will focus on determinations of reasonable replacement compensation for individuals who both provide services to a closely held business or professional practice and also have an ownership stake in the enterprise. Executive Compensation in the form of options and restricted stock will also be covered in the context of marital dissolution proceedings. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Be the Sun, Not the Salt, featuring Harry Cohen and John Daly
-
Online
1.00 Credits
What if being nice, or specifically being a positive best version of yourself, made you a more effective leader? Ethical leadership, is effective leadership. That’s what Dr. Cohen, noted psychologist, transformational speaker, executive coach, and author of Be The Sun, Not The Salt, has been teaching organizations to do for years. Dr. Cohen’s work is based on scientific studies of human behavior broken down into simple, easily digestible pillars structured around the Heliotropic Effect. In this webcast we will discuss Dr. Cohen’s path to this work, what the Heliotropic Effect is, and how Be The Sun, Not The Salt is the perfect reminder to Do More of That every day.
SECURE Act 2.0: What You Need to Know
-
Online
1.00 Credits
Signed by President Biden on December 29, 2022 as part of the Consolidation Appropriations Act, this program provides an explanation of the Secure Act 2.0 provisions impacting individuals and business taxpayers. Learn what you need to know for this filing season and how to plan for future years for your clients. **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.
Accounting & Attestation for ESG
-
Online
2.00 Credits
Environmental, Social and Governance (ESG) has become a hot topic among standard setters. This session will look at the work of the FASB, GASB, and AICPA in the areas of ESG. We'll also look at the types of engagements CPAs can provide to entities who want assurance around their ESG reporting.
Preparation, Compilation and Review Engagements
-
Online
2.00 Credits
This course is an introduction to preparation, compilation, & review engagements. During this course, we will compare and contrast these different engagements by reviewing the procedures that should be performed, different reports, as well as the level of assurance specific to each type of engagement.
Advanced Excel for Staff - Build Reports and Analyze Data
-
Online
2.00 Credits
Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize, and structure data, apply calculations to derive key metrics, and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful, and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Reasonable Compensation for S Corps
-
Online
2.00 Credits
Between 2010 and 2020 a parade of Court Cases, IRS Factsheets, Job Aids and Internal Memos, plus Heightened IRS scrutiny and Preparer Penalties has brought the issue of 'Reasonable Compensation for S Corp's out of the shadows and placed it forefront as a priority issue for CPA's, EA's, Tax and Financial advisors to cover with their clients. We will explore key court cases, IRS guidelines, preparer penalties and some of the obscure tools the IRS has put in place. We debunk common myths and fiction on how reasonable compensation should be calculated and replace it with facts and methodologies that the IRS relies on. 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 Tables and Conditional Summing
-
Online
2.00 Credits
In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.
Surgent's The Most Critical Challenges in Governmental Accounting Today
-
Online
4.00 Credits
With the constant churning of governmental accounting standards, now is the time to know more than just what the standards say; we need to know what they mean and how they will affect governmental entities. This course is designed to do just that! The course materials utilize a highly illustrative and innovative format. Over 15 focused exercises are included to provide an enhanced working knowledge of the most critical challenges in governmental accounting today.This course qualifies for yellow book credit.
Multistate Taxation - Issues and Planning Opportunities
-
Online
8.00 Credits
Join our course on Multistate Taxation – Issues and Planning Opportunities designed for financial professionals. Learn about crucial topics like nexus implications, state taxable income calculations, and audit defense strategies. Gain practical insights to integrate these considerations into client financial plans effectively. From deciphering complex formulas to understanding state-specific regulations, this course equips you with actionable knowledge to excel in finance. Explore multistate business activities, choice of business entity, and interstate commerce clauses. By course completion, you'll be ready to identify common pitfalls, mitigate risks, and ensure compliance with multistate taxation. Join us and navigate the complexities of finance confidently. **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.