CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Create Measures in Power BI that Define Your Metrics
-
Online
4.00 Credits
Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. 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 Excel Tips, Tricks, and Techniques for Accountants
-
Online
8.00 Credits
Excel is the accountant’s tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your level of experience, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills, best practices for linking Excel data from other worksheets and workbooks, and how to streamline report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples that will improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals, which assures you of the relevance and usefulness of the information and guidance provided during the program.
Surgent's Audits of 401(k) Plans: New Developments and Critical Issues
-
Online
8.00 Credits
One of the most favored employee benefit plans, the 401(k) plan, provides unique challenges for auditors. Through this course, auditors will obtain an understanding of the rules and regulations unique to employee benefit plans and obtain practical guidance on applying them. Auditors will enhance their knowledge of the performance and reporting requirements through real-world examples, best practices, and efficient audit techniques that can be utilized in various audit engagements. Make sure your audits don't trigger a DOL inspection by conforming to all applicable rules and regulations.
Surgent's Handbook for Mastering Basis, Distributions, and Loss Limitation Issues for S Corporations, LLCs, and Partnerships
-
Online
8.00 Credits
The most difficult concepts to master when dealing with flow-through business entities are the basis and distribution concepts. Major error and malpractice issues occur if the CPA does not fully understand the impact of these rules. This course is designed to focus on the practical applications of these rules.This course qualifies for IRS credit.
You Don't Know What You Don't Know About Microsoft Excel
-
Online
8.00 Credits
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ChatGPT: What Every CPA Should Know-Updated
-
Online
2.00 Credits
Don't look now, but ChatGPT is taking the business world, including the accounting profession, by storm. Every CPA, whether in public accounting or working in corporate, should have a fundamental understanding of ChatGPT and generative AI applications more broadly. This course will provide you with a foundation of knowledge about ChatGPT technology that will prepare you to have conversations with clients, customers, colleagues and service providers. More importantly, you will learn how to leverage ChatGPT to increase your personal productivity. If you feel your ChatGPT knowledge is lacking, that will not be the case after you attend this course, taught by John Higgins, one of the leading technology strategists and thought leaders for the accounting profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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
Maximizing Fringe Benefits: Strategies for Business and Personal Needs for Today and Beyond
-
Online
8.00 Credits
As tax policies and economic conditions continue to evolve, staying ahead in fringe benefit planning is more essential than ever. This course provides financial professionals with a comprehensive update on fringe benefit strategies, ensuring compliance with evolving regulations while maximizing tax efficiency for businesses and individuals. Participants will explore the latest legislative and regulatory updates impacting employer-sponsored benefits, IRC §132 fringe benefits, cafeteria plans, and retirement healthcare strategies. This course also examines ERISA reporting requirements, tax-efficient compensation planning, and healthcare benefits, offering practical applications to help practitioners navigate compliance and optimize benefits for their 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
Consulting Services Secrets
-
Online
1.00 Credits
Award winning discussion leader Mark Hugh discusses how to create and capture value with consulting services. Whether you want to consult a little or full time, this valuable course reviews identifying a specialty, growing a practice, capturing value, creating deliverables, and effective marketplace marketing strategies.
Are Those Independent Contractors Really Independent Contractors?
-
Online
1.00 Credits
Various legal tests are used to evaluate whether a worker should be classified as an employee or an independent contractor. There is no uniform standard or bright-line rule for determining whether an individual is properly classified as an independent contractor. Instead, the inquiry is always fact-intensive, and the analysis can vary based what body is performing it, i.e. the Internal Revenue Service (“IRS”), Department of Labor (“DOL”), various state agencies, or the courts. This presentation will review the various tests and highlight some of the common, most important factors for consideration.
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.
The CFO Series-Artificial Intelligence: A Practical Guide for Financial Leaders and CFOs
-
Online
2.00 Credits
In today's world, AI hype bombards us from every direction. Every system seems to boast magical AI capabilities, leading to confusion and overwhelming information. This course cuts through the noise to reveal the true, practical applications of AI for your business today. Our goal is to give you real world examples of using AI on a day-to-day basis, with a clear understanding of its particular strengths and limitations.
Behind the Curtain: Exploring IRS Audit Technique Guides
-
Online
2.00 Credits
Have you ever considered a tax audit from the perspective of an IRS examiner? This session explains how you can use IRS Audit Technique Guides (ATGs) to enhance tax compliance. You will obtain a glimpse of the audit process from the viewpoint of an IRS agent as we explore insights that the IRS provides to its own examiners. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Business Tax Update: Recent Developments
-
Online
2.00 Credits
A discussion of the latest 2021/222 tax developments impacting business taxpayers, with a focus on important provisions, rules and concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
International Cross Border Transactions
-
Online
2.20 Credits
Please join us for an introductory course in international cross border transactions. We will discuss typical situations in which a cross-border transaction arises, and how a taxpayer can utilize the rules to potentially decrease an entities effective tax rate. Other issues, such as documentation and IRS audit risk will also be covered. These rules will be illustrated by a hypothetical US- Canada transaction. **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 leighanne.conroy@acpen.com.
Surgent's Guide to Understanding the At-Risk Basis Rules and Forms 6198 and 7203
-
Online
2.00 Credits
Many tax clients with losses from their S corporations, partnerships, and multiple-member LLCs treated as partnerships will want to use these losses to offset their other income from other sources. This program explains when, why, and how the at-risk rules apply to allow or to prevent the owner of a pass-through entity from taking a loss from a pass-through entity and using it to offset other income. This program is extremely helpful for anyone with pass-through entity clients.This course qualifies for IRS credit.
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.
Preparing and Reviewing Workpapers for Higher Quality Audits
-
Online
4.00 Credits
This course will focus on preparing financial statement audit documentation critical for high quality audits that can pass peer review.
The Big Beautiful Bill: Tax Reform 2025 and What's Ahead
-
Online
4.00 Credits
What The Big Beautiful Bill Means for You and Your Clients: Breaking Down Key Tax Provisions The “Big Beautiful Bill” is the most significant tax law package since the TCJA, and it’s now law. With dozens of TCJA provisions made permanent and plenty of new rules introduced, this session is packed with critical content for tax professionals. You’ll walk away understanding what’s changed, what’s new, and what to prepare for across individual, business, and estate taxation. Art Werner breaks down key topics like bonus depreciation, enhanced 199A deductions, Trump accounts, SALT cap changes, estate planning, charitable limits, 1099-K thresholds, and much more. He’ll also examine areas with future sunsets, business incentives, and international tax provisions that could impact clients at all income levels. *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
Tax Planning for Small Businesses - Tax Staff Essentials
-
Online
4.00 Credits
Modern planning ideas and tax-saving strategies to help guide your small business clients.