CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Clean, Transform & Load Data in Power BI
-
Online
2.00 Credits
This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. 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.
Accommodation Requests - Substance Abuse - Contagious Infections
-
Online
1.00 Credits
Good judgment works well in handling most employee relations matters. However, there are special situations where legal requirements dictate specific handling to avoid significant personal and employer liability. This course provides practical knowledge and scripts for responding to requests for accommodation regarding religious practices or disabilities, confronting employees in substance-abuse situations, and handling disclosures of contagious infections so that individual is properly helped, and the health of your workforce is protected.
Interviewing, Onboarding and Training 101
-
Online
1.00 Credits
Master the essential skills to build a high-performing team with our online course on interviewing, onboarding, and training. This comprehensive program dives into proven best practices for identifying top talent, creating a seamless onboarding experience, and fostering a culture of continuous development. Whether you’re a seasoned manager or new to hiring, this course equips you with the tools to make confident decisions, engage new hires effectively, and set your team up for success from day one.
The Ethics Hour: Heartfelt Leadership: How Ethical Leaders Build Trust, featuring John F. Levy, MBA, CPA, CIA
-
Online
1.00 Credits
The best leaders are always ethical. Every great leader has heart and readily shows that they care. What is the true value of a trustworthy leader? Why do we need trustworthy leaders? How do we examine ethical issues - what is the process? Trust provides a safety net that enables innovation to flourish. Be the best leader you can be by caring about others and remaining ethical. Ethics is fundamentally how we treat others. Do we measure up to that standard?
Annual Update on the 2024 Revised Uniform Guidance And Time & Effort Reporting
-
Online
2.00 Credits
The Uniform Guidance (2 CFR 200) pertains to the management of Federal Financial Assistance for grants and cooperative agreements. The Biden Administration has performed a comprehensive update where the revised Uniform Guidance was released in April 2024. We will review all of the significant compliance and threshold changes. In addition, we will provide a brief presentation of the revised guidance as it pertains to Time and Effort reporting.
International Tax Treaties
-
Online
2.00 Credits
This course presents an overview of tax treaties and how they are used in structuring transactions and determining the tax impact of cross-border transactions. It discusses the ordering rules for local laws versus treaty laws, and the purpose of the tax treaties in avoiding and eliminating double taxation to promote trade and investment. The participant will learn about planning opportunities to contemplate when structuring foreign operations. **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.
The ABCs of Advisory Services
-
Online
2.00 Credits
Over the next decade, the area of “Advisory Services” has the greatest potential for growth in your practice. Complexities within your clients’ financial, estate, and asset protection plans coupled with the ever-changing Internal Revenue Code has created an opportunity for the CPA, the EA, and other advisors to expand their client offerings. This course provides the practitioner with the framework for practice expansion as well as an understanding of a variety of necessary issues and techniques.
2025 AICPA Regulatory Ethics Update
-
Online
2.00 Credits
The Professional Ethics Executive Committee (PEEC) of the AICPA has been very busy issuing new and updating existing ethics rules. This course will provide an overview of recently issued and soon to be effective ethics rules that CPAs in both industry and public accounting need to know to be compliant. 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.
Everything You Need to Know About the Pass-Through Entity Rules: IRC 199A The Code and Regulations
-
Online
4.00 Credits
As part of the Tax Cuts and Jobs Act (TCJA), IRC § 199A was added. This Internal Revenue Code section allows certain pass-through entities the ability to has made it deduct up to 20% of their qualified business. Although practitioners have had over three years of “experience” utilizing IRC § 100A, many practitioners still do not feel comfortable with this part of the Internal Revenue Code. The purpose of this presentation is to provide the practitioner with an understanding of the rules of IRC § 199A as well as an understanding of the IRC § 199A regulations. **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.
K2's Small Business Internal Controls, Security, and Fraud Prevention and Detection
-
Online
8.00 Credits
Internal controls are more important than ever, and their importance increases daily. However, internal controls present a challenge for many smaller organizations. This program will teach you how to evaluate, develop, and implement an effective internal control structure in a small business environment. You will identify how to assess risk in smaller organizations and implement preventive, detective, deterrent, and compensating controls to mitigate these risks, even without proper segregation of duties. Additionally, participating in this program will teach you technology-focused techniques for preventing and detecting fraud and securing information systems and sensitive data. For small organizations, maintaining an effective system of internal controls presents a significant challenge. Realistically, implementing many theoretical concepts surrounding internal controls may not be possible in some cases. Consequently, many internal control structures foster an environment where too much risk exists. This factor and uncontrolled information systems can often lead to disastrous results. Participate in this program to learn the necessary insights and tools to design, implement, and monitor effective internal controls, security, and anti-fraud measures in small organizations.
Unlocking Deep Secrets: Case Studies in Financial Analysis
-
Online
2.00 Credits
Unlock the secrets to understanding a company's financial health and management performance through comprehensive financial analysis. This seminar will guide you through essential tools such as vertical analysis, horizontal analysis, and ratio analysis to gain deep insights into business performance. - Vertical Analysis: Learn how to express each line item of financial statements as a percentage, making it easier to compare companies of different sizes and identify key trends. - Horizontal Analysis: Discover how to compare financial information over multiple periods to spot significant changes and trends, providing a clearer picture of a company's growth and performance. - Ratio Analysis: Dive into calculating and interpreting financial ratios to assess profitability, liquidity, and solvency. Understand how these ratios reveal the effectiveness of management and the potential of the business. This seminar goes beyond just teaching terms and formulas. We will apply these analytical tools to real-world financial data, demonstrating how to derive meaningful insights and make informed decisions. Join us to enhance your financial analysis skills and gain a competitive edge in evaluating business performance. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
AI & You
-
Online
1.00 Credits
Every organization today is facing an onslaught of pressure to master Artificial Intelligence “AI” strategies across their enterprises. Never before have we witnessed such a steep expectation for how a “technology” can transform a business, and never before have we been expected to leverage a technology so quickly and so completely. There is no denying AI presents perhaps the opportunity of a lifetime to transform and improve operations, but to date few plans or roadmaps on how to unlock the promise of AI exist. In this class, Steve Cadigan, a globally renowned future of work expert, will present a practical plan for how you can build your own AI strategy, and how you can thrive in the AI revolution. Steve will show present a roadmap of how to build your confidence with AI to address this massive change management challenge.
Linking Risk Management to Strategy
-
Online
1.00 Credits
Risk mitigation and response Boards and executive teams must manage an ever-changing landscape filled with uncertainty - due to economics, geopolitics, technology, tax regulations, talent pool, cyber-terrorism, data privacy and more. Emerging technologies, such as artificial intelligence and the Internet of things (IoT), are disrupting business models across all sectors. Learn strategies for mitigating risks and dealing with risks quickly.
Providing Ethical Leadership: Learning to be the Best Version of Yourself
-
Online
1.20 Credits
This course will examine certain qualities a leader must exhibit to set an ethical tone from the top.
Accountants and Malpractice: Can We Get Sued for This?
-
Online
2.00 Credits
This seminar reviews situations in which a CPA or accounting professional may be in danger of being sued. We cover common law causes of action, such as negligence, and the relevant standards and case law defining what constitutes reasonable practitioner behavior. This course is ideal for lawyers, CPAs, EAs, tax preparers, accountants and insurance personnel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Leading Up: The Superpower Every Ascending Leader Needs
-
Online
2.00 Credits
Most leadership training focuses on leading downstream, with the goal of eventually advancing to an executive role. Few people get to be “top dog” in their organization. So, nearly every worker will spend their entire career leading up, even while serving in a leadership role. Learn the skills and tactics needed to develop an effective working relationship with your boss and other superiors. Gain the credibility and support necessary to get things done and advance professionally.
Surgent's Elder Fraud
-
Online
2.00 Credits
When we leave our jobs, we also leave the protection our employer provides us with regards to internet and Wi-Fi security. Hired people may be able to help with the newest applications, but they may not understand the security risks posed. This session will cover some basic information about cybersecurity weaknesses and some of the scams that target older, retired people. Many times, the perpetrator is someone close and someone who we think we can trust. In this course, you will learn some basic tools to protect against those who wish to perpetrate fraud.
Surgent's Managing Millennials
-
Online
2.00 Credits
By 2025, millennials will represent 75% of the workforce. Whether you are an owner of a small practice or manager in a multinational corporation, it is important to understand characteristics and expectations of this large segment of the workforce. Research reveals that many of the common stereotypes surrounding millennials are unfounded and counterproductive. This course provides an understanding of who millennials are in comparison to their predecessors, the Gen-Xers and baby boomers. Equally important, the presentation will look at common myths regarding millennials and why understanding this class of employees provides opportunities for your organization to grow and succeed.
Surgent's Tax Research - Intermediate Concepts
-
Online
2.00 Credits
Answering clients' tax questions accurately and on time is a key challenge for tax practitioners. Through simple, plain language explanations and examples, this course will help practitioners perform tax research more efficiently by describing the structure of the primary sources, highlighting the difference between primary and secondary sources, and describing the steps in the tax research process.This course qualifies for IRS credit.