CPE Catalog & Events
K2’s Mastering Advanced Excel Functions
-
Online
4.00 Credits
Member Price: $149
With approximately 500 functions now available in Excel, some newer and more powerful tools are easily overlooked. But if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel's more advanced features-some new and some legacy-to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel's FORECAST.ETS function. Regardless of your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
KPI Bootcamp for Small Businesses
-
Online
5.00 Credits
Member Price: $179
Running or advising a small business? The KPI Bootcamp can help you rapidly identify and implement the right KPIs to achieve your or your client's goals. Delivered by Bernie Smith, KPI specialist and seasoned entrepreneur, this course will guide you through selecting a powerful set of measures tailored to your business. The structured approach helps you refine your objectives and choose KPIs that drive growth and profitability. The program includes access to over 400 pre-defined KPIs, each with a clear, jargon-free definition, business benefits, real-world examples, and practical implementation tips. Delivery Method: Individual webcast CPE Credit: 5Program Level: Basic
Partnership & LLC (Form 1065) – Formation to Liquidation
-
Online
8.00 Credits
Member Price: $300
With the increasing complexity and ever-changing nature of tax laws and issues, today’s accountant needs a partnership/LLC course focusing on the hottest tax topics and most frequently encountered issues. This case driven course will deal with both partnership/LLC and partner/member developments addressing the most common, yet complex Federal partnership/LLC issues and problems. *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 Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate
Fringe Benefits & Compensation Planning - Today and Beyond
-
Online
8.00 Credits
Member Price: $250
In today's dynamic economic landscape, staying ahead with effective fringe benefit planning is more critical than ever for both businesses and individual clients. With evolving tax laws and shifting market dynamics, understanding the intricacies of fringe benefit planning is essential to ensure financial well-being and compliance. This course offers a comprehensive overview of essential tools and techniques tailored for financial professionals, allowing them to navigate the complexities of fringe benefit planning with confidence and precision. By attending this course, practitioners will gain invaluable insights into various planning tools and techniques essential for meeting fringe benefit planning objectives. From mastering the subtleties of employee benefit planning, including ERISA reporting and disclosure requirements, to unraveling the complexities of IRC §132 fringe benefit options, attendees will enhance their expertise to deliver superior advisory services. The curriculum also delves into the practical aspects of cafeteria plans, flexible spending accounts, group term life insurance plans, and strategies for financing retiree medical benefits, among others. With a focus on practical application and real-world scenarios, this course equips participants to tackle fringe benefit planning challenges head-on, providing them with the tools and knowledge needed to optimize benefits for both business and personal needs, now and in the future. **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. Delivery Method: Individual webcast CPE Credit: 8Program Level: Basic
The Yellow Book: From Beginning to End
-
Online
8.00 Credits
Member Price: $250
A comprehensive review of the newest version of the U.S. Government Accountability Office’s Government Auditing Standards, otherwise known as “the Yellow Book.” The standard will affect all auditors who perform audits of government and nonprofit organizations who receive federal funds, or where application of GAO standards is required by law, regulation or contract. It does not address the standards applicable to performance audits. Delivery Method: Individual webcast CPE Credit: 8Program Level: Update
Strategies for Guiding Clients Through Challenging Situations: Tax Insights
-
Online
8.00 Credits
Member Price: $250
This course equips practitioners with the knowledge needed to help clients navigate complex tax and financial challenges. It addresses difficult client situations including divorce, bankruptcy, debt issues, and other personal and business matters that create significant tax consequences. The course provides key insights into the tax implications associated with these situations and highlights planning considerations practitioners should evaluate when advising clients. Participants will explore the tax treatment of divorce-related matters, including filing status, support obligations, and property division. The course also examines bankruptcy, debt cancellation, business dissolution, and other financial hardships that may affect a taxpayer’s reporting and obligations. Through practical discussion and analysis, participants will gain strategies to help clients make informed decisions while understanding the related tax implications. 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 Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate
Written Information Security Plans
-
Online
1.00 Credits
Member Price: $55
Thsi course provides a comprehensive overview of Written Information Security Plans (WISP), focusing on their purpose, requirements, and implentation. All PTIN holders must certify they have a WISP prior to renewal, along with certifying the training of employees, staff and contractors as necessary. Participants will explore the history and legal foundation of WISP under the Gramm-Leach-Bliley Act, and how compliances is enforsed through IRS Circular 230, AICPA Statments of Standards, The American Bar Associations and the Federal Trade Commission (FTC). This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Business Valuation Fundamentals
-
Online
1.00 Credits
Member Price: $39
This course provides a practical overview of business valuation, guiding participants through the key concepts, methodologies, and considerations involved. You will explore the types of valuation reports, the standards governing their preparation, and the step-by-step process of transforming raw data into actionable insights. The course also examines how the intended purpose of a report can influence its conclusions and offers strategies for valuing minority interests. By the end of the course, participants will gain a clear understanding of how to read, interpret, and apply business valuation reports effectively. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
Navigating IRS Authorizations: Form 2848 & Form 8821
-
Online
2.00 Credits
Member Price: $89
Providing a practical overview of the IRS Power of Attorney, Form 2848, and IRS Tax Information Authorization, Form 8821. Participants will explore the differences between these forms, understand when each is required, and how to comply with IRS requirements for representing clients and accessing their tax information. The course will cover practical issues, ethical considerations, and best practices for managing client authorizations through the IRS Centralized Authorization File (CAF) system. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Surgent's Excel: Mastering PivotTables
-
Online
2.00 Credits
Member Price: $99
PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.Delivery Method: Individual webcastCPE Credit: 2Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Data Analytics & Journal Entry Testing for Auditors
-
Online
3.00 Credits
Member Price: $109
This course provides a practical understanding of IT controls and SOC reporting within financial audits. Participants will learn how to interpret SOC reports, evaluate control effectiveness, and determine reliance strategies. Real-world examples will demonstrate how IT controls tie directly to relevant financial statement areas and alignment with Complementary User Entity Controls (CUECs). Delivery Method: Individual webcast CPE Credit: 3Program Level: Intermediate
How Recent Auditing Standards Improve Risk-Based Audits
-
Online
4.00 Credits
Member Price: $149
Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in the SASs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Preparation, Compilation, and Review Engagements: Update and Review
-
Online
4.00 Credits
Member Price: $139
If you supervise preparation, compilation, and review engagements, this course is designed to assist you in adhering to professional standards. It will inform you of the latest developments and pertinent issues relevant to these engagements as you gain insights into: The U.S. business economy Peer review practices FASB updates Various other aspects that influence preparation, compilation, and review engagements
Calculating the Retirement Need
-
Online
1.00 Credits
Member Price: $55
For most people, funding their own retirement is the largest expense they will ever have. Due to advances in medical technology and overall healthier lifestyles, it is not unusual for someone to live 30 years or more in retirement. In this course, we will discuss how to quantify and calculate the retirement needs of the client. We will talk about time value of money concepts, how to help clients quantify their retirement goals, and even how to address risk perceptions. By doing this, we will allow practitioners to be able to better address client questions and frame trade-offs when necessary. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
NotebookLM Use Cases for Accountants
-
Online
2.00 Credits
Member Price: $89
This course provides a concise overview of how accountants can use Google NotebookLM (powered by Gemini) as a practical research, synthesis, and knowledge-management companion for high-trust work. You'll learn how to convert static financial statements, audit workpapers, client documents, and regulatory guidance into a structured, conversational knowledge base-so you can query, summarize, compare, and cross-reference sources with greater speed and clarity. This course emphasizes disciplined workflows such as source control, evidence-grounded outputs, and professional judgment so NotebookLM strengthens your analysis instead of replacing it. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Surgent's Best Practices in Not-for-Profit Accounting and Reporting
-
Online
4.00 Credits
Member Price: $159
Don't just wing it when you can soar! To catch the eye of resource providers and fulfill the needs of leadership, it is essential that not-for-profits prepare financial statements which excel. This course will empower you with the knowledge of not-for-profit accounting and reporting to surpass the expectations of financial statement users. Over 20 focused exercises are included to illustrate and refine today's best practices in not-for-profit accounting and reporting.Delivery Method: Individual webcastCPE Credit: 4Program Level: IntermediateThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Forensic Accounting: Investigating Divorce Cases
-
Online
4.00 Credits
Member Price: $149
With over 50% of marriages ending in divorce, forensic accountants are frequently used in uncovering hidden income and assets. It is not uncommon for one spouse to hide money from another, sometimes for nefarious reasons. As a CPA, your services are valued by high-net-worth individuals who hire attorneys in their divorce proceedings. In this course, you will learn the art of financial investigations and how to uncover the truth in divorce cases, whether from offshore accounts to lifestyle analysis. Step by step, the course will teach you the valuable skills necessary in finding, analyzing, evaluating, and presenting your findings to your client and if needed, ultimately in divorce court. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Revenue Recognition Topic 606 Contract with Customers - Identify the Contract Part 2
-
Online
1.20 Credits
Member Price: $39
This course is a continuation of discussion over Step One in the revenue recognition process of Identify the Contract. Specifically, this session delves further into the considerations surrounding contract modifications, change orders, unpriced change orders, cancelations, non-finalized changes and accounting treatment when a contract does not exist. Delivery Method: Individual webcast CPE Credit: 1.2Program Level: Intermediate
A Strategic Approach to Understanding Compensation Structures
-
Online
1.50 Credits
Member Price: $79
Understanding the principles and practices of compensation is essential for creating a motivated and satisfied workforce. In this webinar, we'll explore how these crucial elements drive fairness and engagement in HR practices. This program is designed for HR professionals and business leaders seeking to enhance their compensation strategies. Delivery Method: Individual webcast CPE Credit: 1.5Program Level: Intermediate
Don Farmer's Section 1202 QSBS: Qualification, Planning & Exit Strategies
-
Online
2.00 Credits
Member Price: $89
This course provides a comprehensive review of §1202 qualified small business stock (QSBS) rules, from initial qualification through exit planning. Participants will examine entity eligibility, active business requirements, holding period issues, redemptions, and multi-year sales strategies. Case studies highlight common QSBS failures and planning techniques to preserve the exclusion.