CPE Catalog & Events
K2's Mastering Advanced Excel Functions
-
Online
4.00 Credits
Member Price: $156
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.
The Future of Audit: Technology, Talent & Transformation
-
Online
1.00 Credits
Member Price: $55
The audit profession stands at a critical inflection point, facing unprecedented challenges from technological disruption, evolving regulatory landscapes, and workforce transformation. This comprehensive course, based on the Pennsylvania Institute of CPAs' groundbreaking research report "The Future of the Audit: Building Relevance and Sustaining Quality," provides auditors with essential insights and actionable strategies to navigate these seismic shifts. Through expert perspectives from industry leaders including PCAOB board members, Big Four executives, and audit committee chairs, participants will explore how artificial intelligence, blockchain, and data analytics are fundamentally reshaping audit practices while creating new opportunities for value creation and risk assessment. Beyond technology adoption, this course addresses the pressing talent crisis facing the profession and offers practical solutions for building a future-ready workforce. Participants will learn how to leverage emerging technologies to enhance audit quality, understand the implications of regulatory modernization including the concept of "regulatory sandboxes," and develop strategies for attracting and retaining top talent in an increasingly competitive market. Whether you're a partner in a small firm, a manager in a large organization, or an audit professional seeking to future-proof your career, this course provides the roadmap for maintaining relevance, ensuring quality, and thriving in the evolving audit landscape. You'll leave with concrete action steps for immediate implementation and a clear vision for transforming your audit practice to meet the demands of tomorrow's financial ecosystem. 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 Forms 7217 and 7203
-
Online
2.00 Credits
Member Price: $119
IRS Form 7217 is an IRS tax form required for partners receiving distributions of property from partnerships. Starting for tax years beginning in 2024, a partner who receives property from a partnership must file Form 7217 with his or her annual income tax return. Form 7217 is filed by any partner receiving a distribution of property from a partnership to report the basis of the distributed property, including any basis adjustment to such property as required by Section 732(a)(2) or (b). This new IRS form is part of the IRS's general concern regarding basis shifting in favor of high marginal tax rate related partners. Form 7217 is now required and details the types of property distributed, the aggregate basis, and the allocation of basis to the distributed property. Form 7203 is designed to assist in tracking an S corporation shareholder's stock and debt basis. Form 7203 is a significant improvement from the worksheets the IRS provided formerly and over time will serve to help partners and partnerships keep track of their stock and debt basis. The course covers the structure and organization of Form 7203 as well as how an S corporation shareholder's stock and debt basis are calculated.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 Virtual Currency: Keeping Up with the Tax Code
-
Online
2.00 Credits
Member Price: $119
Whether you are an experienced veteran or new to the industry, one of the toughest parts of being a tax practitioner is keeping up with all of the changes in tax legislation. This course takes a look at recent changes to tax law from a practitioner perspective. In this session, we will explore the nuances of virtual currency and the new Form 8300 reporting requirements.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.
Using ChatGPT with Excel
-
Online
2.00 Credits
Member Price: $89
In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. 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.
IT Controls & SOC Reporting in Financial Audits
-
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
All About Fraud - Examples, Prevention and Auditing
-
Online
4.00 Credits
Member Price: $149
Fraud continues to make headlines, underscoring the importance of understanding how fraud occurs, how it can be prevented, and how auditors are expected to respond. This course begins with an overview of common fraud schemes identified in the 2026 Report to the Nations issued by the Association of Certified Fraud Examiners, along with key characteristics commonly observed among fraud perpetrators. The course then explores practical approaches organizations use to prevent and deter fraud, highlighting controls, policies, and cultural factors that can reduce fraud risk. Participants will also review recent fraud cases reported in the news to reinforce how these schemes manifest in real-world settings. The course concludes with a discussion of the auditor's responsibilities related to fraud under AU-C 240, including an overview of proposed changes to the fraud standards and what they may mean for future audit engagements. 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.
The AI Revolution in 2026: What CPAs Should Know
-
Online
2.00 Credits
Member Price: $89
AI is reshaping accounting, tax, and finance. This update surveys the state of AI technology in 2026: core concepts, software tools, risks/controls, and practical CPA use cases. You will leave with an expanded AI vocabulary, a current view of the AI landscape, and actionable talking points for staff, clients, and service providers. 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.
Retaining Top Talent: Strategies for CPA Firms
-
Online
1.00 Credits
Member Price: $55
In today's challenging talent market, accounting firms face unprecedented pressure to retain their best performers. This course provides actionable, research-backed strategies to help firms keep their top talent from leaving. Based on comprehensive surveys of both current accounting professionals and those who have recently left the profession, participants will learn the real reasons employees stay or go-and what firms can do about it. The course goes beyond simple solutions like "pay more, expect less" to explore comprehensive retention strategies including whole-person compensation, work-life balance improvements, career development pathways, and necessary business model transformations. Participants will discover why 73% of surveyed professionals want to stay with their current firm, yet many still leave-and how to bridge that gap. Key topics include understanding the true cost of turnover versus retention, implementing flexible work arrangements that actually work, creating meaningful career paths for non-partner track professionals, and transforming firm operations to support both profitability and employee satisfaction. Special attention is given to retaining diverse talent and adapting to the expectations of younger professionals who will comprise 27% of the workforce by 2025. Whether you're a firm leader, HR professional, or manager responsible for team retention, this course provides the insights and tools needed to build a sustainable talent strategy in an evolving profession. 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.
HR Investigations – Episode 1 – Introduction-Assessing-Planning
-
Online
1.00 Credits
Member Price: $39
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. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Humanize Automation: Frameworks for Understanding AI and Your Strategy
-
Online
1.20 Credits
Member Price: $39
By now you've heard of AI, and a lot about Generative AI (ChatGPT, Co-Pilot, etc.). And in experimenting with these tools, you've likely had some success and some disappointment. That's all part of the process! And it's also why we're bringing you this session, so that you can avoid the failures and accelerate the efficiencies. In this session you'll take a journey. From learning an effective method for prompting generative AI tools, to understanding the importance of data organization, to leveraging automations for strategic points in your customer experience, and to the ever-expanding area of building your own AI agents, this session will provide you with frameworks and processes to better understand AI and craft a strategy for your business. Delivery Method: Individual webcast CPE Credit: 1.2Program Level: Basic
Revenue Recognition - Topic 606 Overview
-
Online
1.80 Credits
Member Price: $79
This session is the beginning in a series on the new revenue recognition standard. The standard outlines five steps for proper compliance. At the surface, these steps seem simplistic. However, there are many considerations that should be considered within each step based on your process and industry. This course is designed to provide an overview of the technical guidance and outline the five steps involved in the revenue recognition model. We also explore some concepts to consider within each step and then evaluate some challenges that specific industry's may have when complying with the standard. Future courses will further delve into each step and provide example and scenarios that should be considered to properly apply the step. Delivery Method: Individual webcast CPE Credit: 1.8Program Level: Intermediate
From Numbers to Narrative: Effectively Presenting Your Budget and Reporting
-
Online
2.00 Credits
Member Price: $89
Perhaps the most important element of the budget process is its communication. If management does not understand the budget – there is an issue. Knowing the right ways to communicate at all levels is essential to stakeholders laying an ownership claim to successful budgets. This session reveals several key guidelines in successful budget presentations and will identify key problems in how people often communicate financial plans. Presenting your budget and reporting is the final part of a four part series, but can easily stand on its own course that is intended to be fun, enjoyable and educational. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
K2’s Excel Tips – Today’s Best Features
-
Online
2.00 Credits
Member Price: $89
Wow! So many new Excel features and so little time! Microsoft continues to add tremendous functionality to Excel - the business professional's tool of choice. Yet most Excel users have not discovered these new tools and remain mired in yesterday's practices for working in Excel. In this session, you will learn how to use many of Excel's latest features to work more efficiently and effectively with your spreadsheets. Participate in this session to learn about recently released features such as PIVOTBY, GROUPBY, Office Scripts, integration with Copilot, new ways to share and collaborate in Excel, and data entry and formula improvements. If you work with Excel - and who doesn't - this session is necessary to help you improve your efficiency and effectiveness when using Excel. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Introverts Have Real Power, Why Quiet Leaders are So Successful
-
Online
2.00 Credits
Member Price: $89
Leaders were once chosen for their character, but today we live in an age where loudmouthed extroverts seem to take center stage in everything, including business, politics and entertainment. While the talkative, charismatic leader makes the front page of business magazines, recent research shows that successful business leaders tend to be more reserved, pensive and sometimes outright shy. Learn why your desire to spend significant time inside your own head may be your greatest asset. Whether you are introverted or not, you likely work with, manage or are a related to an introvert. We will discuss proven methods to better understand introverts, how to manage them, and how to get the most out of their amazing talents. If you want to enhance your leadership skills, this seminar is for you. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Taxation of Non-fungible Tokens (NFTs)
-
Online
2.00 Credits
Member Price: $89
Non-fungible Tokens (NFTs), unique, identifiable digital assets based on blockchain technologies, have become a fast-growing industry. This course will provide a background on how NFTs came into the mainstream marketplace. These materials will assist the practitioner to understand the tax implications of the creation, purchase and sale of these assets. **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: 2Program Level: Basic
Cash Flow Clarity: Effectively Communicate Cash Flows for your Board and C-Suite
-
Online
2.00 Credits
Member Price: $89
The cash flow statement is one of the most confusing financial reports—yet it has the potential to deliver the essential keys to understand business performance. After all, cash is still both king and queen! This session explores how to present, interpret, and communicate cash flows effectively to help CEOs, boards, and decision makers drive smarter results. By using the Sources and Uses format, professionals can make the statement more intuitive and actionable. Learn how to simplify cash flow information and focus discussions on what matters most: how cash is generated and deployed? We will demonstrate how to confidently present this powerful financial statement to non-financial leaders. The cash flow statement is misunderstood, and we will show you how to fix that, and include some amusing videos to drive the points home. We will use the Apple Corporation as an example company in presenting. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
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.
How to Develop Your System of Quality Management Using the AICPA Practice Aids
-
Online
3.00 Credits
Member Price: $109
This course provides an overview of the Quality Management standards and the requirements under SQMS 1. The AICPA requires CPA firms with accounting and auditing practices to implement a system of quality management, including firms performing preparation and compilation engagements. While the objective is to improve quality within the profession, implementation may seem overwhelming. To assist, the AICPA has developed practice aids to guide firms through the development and documentation process. In this webcast, Jeff walks through where to find the practice aids, how to use them, required documentation, use of the risk assessment template, and development of final documentation. Practical guidance is provided throughout to simplify implementation. Delivery Method: Individual webcast CPE Credit: 3Program Level: Basic