CPE Catalog & Events
Mastering the Excel Lookup Functions
-
Online
2.00 Credits
Member Price: $89
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. 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.
Are You Up For the Challenge? Test Your Skills as a Quality Control Reviewer
-
Online
4.00 Credits
Member Price: $149
Have you ever wanted to reduce the number of financial statement review points you receive? Are you curious about a reviewer's thought process? This hands-on session will answer these questions by helping you understand the role of an engagement quality control reviewer. Not only will you develop an appreciation for the role of an engagement quality control reviewer, but this interactive session will allow you to step into the reviewer's shoes by performing a quality control review during the class session. You will leave with an understanding of best practices for minimizing your exposure to critique by reviewers. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Coping With the Growth of Online Fraud
-
Online
4.00 Credits
Member Price: $149
Just about every company, no matter its size or the types of activities it undertakes, is at greater risk because of all the types of fraud that can be be carried out electronically. Potential perpetrators can be operating internally or externally and the scope of the damage that occurs is almost never limited to cyber-assets. While threat awareness is improving, there are still too many owners or top level executives that underestimate the scale of the issue. In this session, we delve into the types and the nature of many electronic defalcation schemes. The material then explores measures that organizations can implement to help stop these activities and add additional layers of security. 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 Data Analytics For Accountants And Auditors
-
Online
4.00 Credits
Member Price: $149
In today's world of "Big Data" every business professional is a data analyst to some extent. This is especially true for auditors, who increasingly rely on data analytics to identify situations that require follow-up and investigation. Those who master the tools and techniques for thorough data analysis can achieve superior results in less time. Join our dynamic session to unlock the full potential of data analytics! You'll explore various tools and techniques, including Excel, multiple Excel add-ins, and Microsoft's Power BI application. Whether you're looking to enhance your skills or dive deeper into the world of data analytics, this course is designed for you. Our expert instructors will guide you through practical, real-world examples, ensuring you grasp the key concepts and apply them effectively. Don't miss this opportunity to elevate your data analysis skills and stay ahead in your field. Enroll now and transform your approach to data analytics! Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Federal Tax Update - C & S Corporations, Partnerships & LLCs (Forms 1120, 1120S & 1065)
-
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 business income tax issues with an emphasis of newly enacted income tax legislation. This comprehensive class will not only review the current Federal business 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 business 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 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
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
Surgent's Annual Accounting and Auditing Update
-
Online
8.00 Credits
Member Price: $299
Designed as an all-you-need-to-know update for accounting, auditing, and attestation practitioners at all levels in public accounting and industry, this course provides a comprehensive review of recent standard-setting and rulemaking activities of the Financial Accounting Standards Board (FASB), American Institute of Certified Public Accountants (AICPA), Public Company Accounting Oversight Board (PCAOB), and Securities and Exchange Commission (SEC). On the financial accounting front, we will cover the FASB's Post-Implementation Review (PIR) report released in late 2025 for lease accounting under ASC 842 and discuss the best practices in applying the standard and identifying any ongoing issues practitioners are experiencing with applying the standard. We will also discuss the more than a dozen ASUs the FASB has issued since the beginning of 2024 and into 2026 covering government grants, derivatives and financial instruments, practical expedients for credit losses under ASC 326, and expense disaggregation on the income statement. Our focus on AICPA standards includes a detailed discussion of revamped AICPA quality management standards. The AICPA updated and modernized the standards by issuing Statement on Quality Management Standards 1, 2, and 3 (SQMS 1, SQMS 2, and SQMS 3, respectively), SSARS No. 26, and SAS 146, Quality Management for an Engagement Conducted in Accordance with Generally Accepted Auditing Standards (SAS 146). These standards, now effective as of December 15, 2025, modernize quality management standards to reflect an increased focus on risk assessment, technology use, and the presence of outside experts on engagements. We will also discuss AICPA's proposed SAS, The Auditor's Responsibilities Relating to Fraud in an Audit of Financial Statements, intended to supersede AU-C section 240. We will also cover new rules impacting public company audits and present case studies on recent fraudulent accounting stories and best practices for detecting and preventing such frauds. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.Delivery Method: Individual webcastCPE Credit: 8Program Level: UpdateThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
The Best S Corporation, Limited Liability, and Partnership Update Course by Surgent
-
Online
8.00 Credits
Member Price: $299
This year practitioners need to keep abreast of tax changes affecting pass-through entities used by their business clients and employers, and this enlightening course delivers that information. You will learn invaluable strategies, techniques, innovative tax-planning concepts, income-generating ideas, and other planning opportunities available to S corporations, partnerships, LLCs, and LLPs. In addition, this course will discuss current trends and emerging issues, helping practitioners stay informed about relevant and significant topics that may impact their clients. Continually updated to reflect enacted legislation.Delivery Method: Individual webcastCPE Credit: 8Program Level: UpdateThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Microsoft 365 Application Lightning Round Review-Updated
-
Online
1.00 Credits
Member Price: $55
Do you use Microsoft (Office) 365? Are you satisfied that you are getting the most that you can from it? If you answered yes then no, this course will provide a really high return on your investment of time and money in this application suite. John Higgins, one of the profession's leading experts on the integration of Microsoft 365 into business, will explain and demonstrate the depth and breadth of the Microsoft 365 ecosystem. The course is designed to raise your awareness of all that you can do with Microsoft 365 and substantially increase your monthly subscription ROI. 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.
Advanced ChatGPT for Accountants
-
Online
2.00 Credits
Member Price: $89
This course concisely explains the latest "see, hear, speak" multi-modal updates to ChatGPT and how they can be used in an accounting context. New features include vision processing, voice conversation, image generation, real-time Internet access, advanced data analysis, plugins and more. Discover how this technology can be used in mind-blowing ways to analyze financial data, optimize processes, and solve problems in the accounting domain. Through the lens of ChatGPT, practitioners can explore innovative solutions, automate routine tasks, and generate deeper insights and value to their clients and organizations in previously unimaginable workflows. You'll walk away with scores of advanced ChatGPT strategies and tips that can be immediately applied and deliver instant results to elevate the efficiency and effectiveness of your accounting projects and tasks. 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.
2026/27 Annual Update for Governments and Not-for-Profits
-
Online
4.00 Credits
Member Price: $149
This comprehensive annual update brings together key accounting and auditing developments affecting governmental and not-for-profit organizations. The course integrates recent standard-setting activity, emerging global frameworks, and major compliance updates to provide a well-rounded view of changes impacting financial reporting and audit requirements. Participants will begin with an overview of recent accounting developments affecting not-for-profit organizations, including Accounting Standards Updates issued by the Financial Accounting Standards Board and an introduction to the International Non-Profit Accounting Standard (INPAS). Emphasis is placed on understanding the purpose of INPAS and how it compares conceptually to U.S. GAAP for not-for-profit entities. The course then shifts to governmental accounting developments, covering recent pronouncements issued by the Governmental Accounting Standards Board, including GASB Statements No. 103, 104, and 105, along with a high-level overview of active GASB exposure drafts and projects. Participants will gain insight into how these changes affect financial reporting, disclosures, and communication with governing bodies. Finally, the course addresses recent developments affecting Single Audits, including the 2024 Uniform Guidance overhaul, updates to Appendix B of the AICPA GAS/Single Audit Guide, and recent guidance issued through the Office of Management and Budget (OMB). Reporting changes related to SAM.gov are also discussed. Designed for auditors, preparers, and financial leaders working with governmental and not-for-profit entities, this course helps participants understand how recent accounting and auditing changes intersect-and what to monitor as requirements continue to evolve. 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.
CFO Solutions to IRS Problems
-
Online
4.00 Credits
Member Price: $149
Many CPAs are becoming full-time or fractional CFOs for small businesses. In that position, they are the resident expert in finances, cash flow planning, and budgeting. But what about dealing with the IRS? The IRS has broad powers to administer the assessment and collection of taxes. From removing penalties to criminal prosecutions, this presentation focuses on how CFOs can prevent problems with the IRS and how to develop winning strategies if the IRS knocks on the door. 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
Embracing Neurodiversity in the Workplace
-
Online
1.00 Credits
Member Price: $39
This webinar will explore embracing and supporting neurodiversity in the workplace, promoting inclusivity, and creating a more diverse and dynamic environment. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Reclaiming Your Energy - 3 Keys to Control Your Chaos and Boost Resilience
-
Online
1.00 Credits
Member Price: $39
Are you running around with a fire extinguisher permanently strapped to your back? Do everyday crises run your life, both at work and at home? Do you find yourself consistently taking care of your customers, your family, and your friends, and you are left with no time to take care of yourself? In this session, we will explore controlling your chaos and managing your energy. Make no mistake, this isn't your parent's time management class. It's an energy management class developed on behalf of and with tired, frustrated, and burned-out Professionals like yourselves! If you find yourself drained and drinking far too much coffee and approaching burnout, this is the session for you! Delivery Method: Individual webcast CPE Credit: 1Program 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