CPE Catalog & Events
K2’s Excel Essentials For Staff Accountants
-
Online
8.00 Credits
Member Price: $250
Staff accountants often face unique challenges when working with Excel, and their existing knowledge might not always meet their needs. This comprehensive eight-hour session is designed to bridge that gap and empower you with the essential skills to maximize efficiency and accuracy. Participate in this dynamic and engaging session, and you will learn how to: • Summarize data quickly and accurately • Generate stunning, professional reports • Create essential accounting calculations for depreciation, amortization, and interest We start with a quick overview of Excel best practices and dive into advanced topics like PivotTables, sophisticated formulas, Tables, formatting, and working with dates. Our course is packed with accounting-centric examples to reinforce key learning points. Plus, you'll enjoy a "laptop-friendly" environment with access to all demonstration files. This seminar is a must for all staff accountants eager to enhance their Excel skills and transform their workflow. Don't miss out on this opportunity to elevate your Excel expertise and take the first step towards mastering Excel today! Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate
2025-2026 Federal Tax Updates - Business Entities
-
Online
8.00 Credits
Member Price: $239
The tax landscape is constantly changing, challenging tax practitioner to stay abreast of these developments. This eight hour program will cover issues unique to business entities, including new court decisions, recent IRS publications, and the latest tax legislation that will impact businesses and individuals. The remaining time will be spent on IRS procedure and other issues. This course will provide a concise look at the hottest topics affecting every tax practitioner. 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.
Forensic Accounting: When The Office Is A Crime Scene
-
Online
4.00 Credits
Member Price: $149
Embezzlement happens often to many small businesses. Unfortunately, the lack of internal controls allow the embezzlement to remain undetected for years. But when it is discovered, the small business owner will most likely contact their CPA for advice. What should you do when your client contacts you about their employee embezzling money from their business? What options should you present to your client? How can your client protect themselves, while investigating the embezzlement? What steps need to be taken about preserving any documents, emails, texts, or phone calls? This course teaches how to engage the client, properly identify the evidence needed to prove the crime, how to write the report for civil and criminal trial, and best practices in preserving electronic and paper evidence. 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.
Digital Resilience: Building Stronger, Smarter Organizations
-
Online
1.00 Credits
Member Price: $39
In an era of unrelenting technological disruption-where cyberattacks, AI-driven risks, and digital transformations collide-resilience is no longer a luxury; it's a strategic imperative. This session will explore how organizations can build digital resilience, leveraging technology not just to survive disruptions but to emerge stronger and more adaptive. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Business Tax Update for Industry
-
Online
2.00 Credits
Member Price: $89
This course focuses on the key federal tax issues affecting businesses from the internal accountant's point of view, with a focus on recent tax legislation and developments. Planning alternatives and the potential risks associated with those strategies will also be discussed. *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: 2Program Level: Intermediate
ChatGPT and Advanced Financial Analysis for Accountants
-
Online
2.00 Credits
Member Price: $89
This course provides a concise overview of how to utilize ChatGPT for advanced financial analysis in accounting. The session reveals how to combine sophisticated evaluation and interpretation of financial data with the cutting-edge AI capabilities of ChatGPT. Aimed at enhancing the understanding of an entity's performance, predicting future financial health, and aiding in informed business decision-making, this course goes beyond basic financial statement analysis to include a wide array of techniques and tools. 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 Budgeting Ideas
-
Online
2.00 Credits
Member Price: $99
Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.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.
Surgent's Understanding Partnership Taxation: Debt Allocations
-
Online
2.00 Credits
Member Price: $99
How debt is allocated to the partners in a partnership is important. It dictates how much money may be taken tax-free as a distribution, the losses that flow down to the partners, and the gain or loss on the sale of a partnership interest. However, the allocation of debt can differ depending on the type of debt it is and the type of partner we are talking about. Furthermore, 704(c) can complicate things. And what in the world is a constructive liquidation scenario? In this course, we will tackle the concept of debt allocations - how you do it, what it means, and why you do it.Delivery Method: Individual webcastCPE Credit: 2Program 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.
Federal Tax Update – Individual & Business Current Developments
-
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 one-day fast-paced update course focusing on the hottest Federal income tax topics affecting individuals, businesses and their owners with an emphasis of newly enacted income tax legislation. *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: Update
K2’s Excel PivotTables For Accountants
-
Online
8.00 Credits
Member Price: $250
Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge, then this course is for you! In this dynamic and engaging session, you'll master how to: • Build PivotTables from scratch • Group data inside PivotTables, including options for fiscal periods • Create user-defined calculations in your PivotTables We start with the fundamentals and quickly move to advanced techniques, including: • Building PivotTables that consolidate data from multiple ranges • Connecting PivotTables dynamically to external databases and financial accounting systems • Leveraging other Excel features associated with PivotTables, such as Slicers, Power Query, and Power Pivot This seminar is a must for anyone eager to enhance their Excel skills and transform their workflow. With guidance and coaching from your K2 instructor, you'll be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks. Delivery Method: Individual webcast CPE Credit: 8Program Level: Advanced
Understanding and Creating an Internal Control System
-
Online
8.00 Credits
Member Price: $239
Successful organizations, both large and small, must understand the importance of effective internal controls and be able to develop a system of controls that will keep the entity on its intended course. Moreover, those that design policies and procedures benefit by knowing why control measures are necessary. This session sets forth internal control concepts and explains the importance of strong internal control policies. The material highlights some of the reasons that measures are needed and it also provides an overview of control creation methods. Finally, it discusses ways to successfully implement the developed policies and procedures. Participants that take this course will gain a well-rounded understanding of internal control procedures of all types. 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.
Executive Presence, Personal Brand: Structure Your Narrative
-
Online
1.00 Credits
Member Price: $55
Professional credibility is communicated, not assumed. In this 1-CPE session (Professional Development), participants examine structured approaches to articulating their professional identity. Drawing directly from the course framework, the session covers development of an elevator pitch, a professional value proposition, and a concise executive biography. Participants will analyze how credibility is established through clarity, relevance, and alignment with audience needs. The course emphasizes service-centered communication rather than self-promotion and provides structured guidance for refining professional messaging in leadership and client-facing contexts. 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.
Individual Tax Update: OBBA and Recent Developments
-
Online
2.00 Credits
Member Price: $89
A discussion of the latest tax developments impacting individual 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.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.
Monthly Federal Tax Updates - June 2026
-
Online
2.00 Credits
Member Price: $89
Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. 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.
K2’s Advanced Excel
-
Online
8.00 Credits
Member Price: $250
Elevate your Excel expertise with K2's Advanced Excel program! This laptop-friendly course is designed for experienced Excel users who are ready to take their skills to the next level. In this session, you will master critical advanced Excel skills in six key areas: 1. Collaborating seamlessly with other users and securing your workbooks 2. Utilizing tables to analyze and report data efficiently 3. Integrating and manipulating data from external sources with ease 4. Creating and auditing complex formulas 5. Harnessing advanced data analysis tools for deeper insights 6. Employing visualization techniques to communicate information effectively Drawing from over thirty years of experience in delivering Excel training to accountants and business professionals, this program is packed with relevant, real-world examples that reinforce the topics presented. Don't miss this opportunity to become more efficient and proficient in Microsoft Excel, the go-to tool for accounting and financial professionals. This course covers advanced Excel topics that are essential for business success. Participate in this session to elevate and transform your Excel skills! Delivery Method: Individual webcast CPE Credit: 8Program Level: Advanced
How to Audit Cash
-
Online
2.00 Credits
Member Price: $89
Cash is essential to every business, and is often one of the first accounts audit staff are exposed to. This course will cover the basics of auditing cash, including the related audit assertions, risks, & threats to the cash balance. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through some real-world examples. 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.
Partnership Essentials: Tax Basis Capital Accounts
-
Online
2.00 Credits
Member Price: $89
This course examines the critical issues and special opportunities facing partnerships and their partners, with a focus on reporting tax basis capital accounts. *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: 2Program Level: Intermediate
Accounting for the Gig Economy
-
Online
2.00 Credits
Member Price: $89
Freelance work and other non-permanent employment arrangements are becoming increasingly popular ways for people to earn a living. Although these non-traditional activities offer novel, flexible ways to earn income from diverse sources, they also introduce nuanced recordkeeping, reporting, and attestation issues. We investigate characteristics of the gig economy, employee-versus-contractor considerations, bookkeeping, regulatory compliance, and external reporting considerations. We also explore best practices for CPAs who fulfill the role of trusted advisor for gig economy clients. 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.
Federal Tax Update – Individuals (Form 1040)
-
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 one-day update course focusing on individual income tax issues with an emphasis of newly enacted income tax legislation. This comprehensive class will not only review the current Federal individual income tax laws but will also update tax return preparers of new tax forms, changes to existing tax forms, as well as tax planning opportunities and pitfalls. This is a “must-attend” course for all tax practitioners who want to be up to speed quickly and have a successful Federal individual income tax filing season. *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: Update
K2’s Business Intelligence, Featuring Microsoft’s Power BI Tools
-
Online
8.00 Credits
Member Price: $250
In today's fast-paced business world, staying ahead of the competition means leveraging every advantage. Business Intelligence (BI) is the game-changer that can transform your organization. Imagine uncovering hidden insights and gaining a competitive edge with data that was once out of reach. With tools ranging from Excel add-ins to the revolutionary Power BI, you can now harness your existing skills to create dynamic, interactive dashboards and analyses that were unimaginable just a few years ago. This program will empower you with the skills to implement "yourself business intelligence" using a variety of techniques and tools. You'll start by mastering advanced Excel data query and summarization features to create stunning Excel-based dashboards. Then, you'll take your knowledge to the next level by building even more powerful BI objects using Microsoft's Power BI tools. If you're passionate about gaining better insights into your data to make smarter decisions, this fast-paced program is for you. Delivery Method: Individual webcast CPE Credit: 8Program Level: Advanced