CPE Catalog & Events
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Online
2.00 Credits
Member Price: $99
Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work. 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.
See more dates
Surgent's Time Management for Professionals
Online
2.00 Credits
Member Price: $99
The phrase "time management" is misleading. No one manages time. Instead, we manage events in our lives which consume time. Like money, time is both finite and valuable; it should be budgeted and used wisely. Those individuals who "manage" or budget their time wisely often are more productive, less stressed, and able to achieve their goals more effectively than others. Professionals by nature place a high value on their time. Still, successful time management strategies vary based upon the personality, motivation, and discipline of each individual. This course provides simple, practical, and powerful techniques that help professionals work efficiently and achieve better balance in their lives. Successful time management skills also reduce the risk of burnout, which in turn improves the likelihood of achieving success in any endeavor.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 Gaining a Competitive Advantage: Critical Skills for CFOs and Controllers
Online
4.00 Credits
Member Price: $159
All organizations are looking for ways to gain an advantage over the competition. This practical and interactive session will present a toolkit of ideas to help CFOs, controllers, and finance professionals better position their organizations for the future. We know change is occurring at an exponential rate, and that has proven to be the case in all areas of finance, management, and leadership over the past year. The course deals with these new issues and will continue to be updated as necessary throughout the year. This year, we will take a special interest in the opportunities and threats of AI for the finance professional. Become the "financial hero" of your organization and make a positive impact on the bottom line.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.
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
Accounting & Auditing for Cryptocurrency
Online
2.00 Credits
Member Price: $89
Cryptocurrency continues to evolve rapidly, bringing new accounting and auditing considerations for CPAs and auditors. This course provides a practical overview of the accounting and auditing issues associated with cryptocurrency, with an emphasis on recent standard-setting developments and their implications for practice. The accounting portion of the course focuses on ASU 2023-08 and related developments, including recent FASB Board discussions, the FASB's Invitation to Comment, and the addition of cryptocurrency-related topics to the FASB's research agenda. Participants will work through a practical case study to apply the guidance in ASU 2023-08, building confidence in accounting for cryptocurrency transactions and balances. The auditing portion of the course addresses key audit considerations related to cryptocurrency, including implications for engagement acceptance and continuance, risk assessment, and the design and performance of audit procedures. The course also references the AICPA's Accounting for and Auditing of Digital Assets practice aid to help bridge authoritative guidance and real-world application. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
AI & Accounting in Manufacturing
Online
2.00 Credits
Member Price: $89
This course provides a concise overview of how artificial intelligence (AI) is reshaping financial oversight in the global manufacturing sector. With factories evolving into digital ecosystems powered by intelligent automation, predictive analytics, and edge computing, the role of accounting and finance professionals is rapidly transforming. Participants will explore how AI technologies intersect with core financial functions-cost accounting, audit, tax compliance, and financial planning-while enabling real-time reporting, fraud detection, and predictive decision-making. Drawing on current global trends and real-world case studies, the course offers actionable insights into integrating AI into financial operations, elevating the strategic role of accounting in manufacturing enterprises. 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.
See more dates
Measuring Audit Risks
Online
3.00 Credits
Member Price: $109
SAS 122, AU 240 requires that auditors determine if there is a significant risk that the financial statements are materially misstated due to either error of fraud. This presentation is an overview of how to determine if there is a significant risk of a material risk; whether it is due to error or fraud; and what to do in designing your audit program to address such risk. It’s important to know that without documentation as to such determination, an auditor has no basis for performing any specific audit procedure and thus would be performing a substandard audit. The standards require that each procedure be designed to decrease the possibility of a material misstatement. This program is an overview of how an auditor determines if there is a risk of a material misstatement; how document such determination; and how to address the risk if it is due to error vs fraud, because there is a big difference. Delivery Method: Individual webcast CPE Credit: 3Program Level: Intermediate
Surgent's International Tax Challenges and Opportunities for U.S. Filers
Online
3.00 Credits
Member Price: $149
Globalization continues to make it easier for taxpayers to live abroad, do business in other countries, or invest in foreign enterprises. This creates significant complications and tax planning opportunities when it comes to filing U.S. tax returns. This course provides an overview of the unique tax challenges and solutions presented to U.S. expats or investors living or investing abroad. It examines how foreign-source income is taxed in the U.S. and how the tax consequences could be mitigated by applying the tax treaties, claiming credit for foreign taxes paid, or excluding foreign-earned income. Additionally, the course discusses the numerous foreign informational form reporting requirements and the significant penalties that could be imposed by the IRS. Examples from real-life client scenarios are included.Delivery Method: Individual webcastCPE Credit: 3Program 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.
Not Just Your Everyday FASB Update
Online
4.00 Credits
Member Price: $149
This course highlights significant updates that affect financial reporting and related attestation services. We will explore novel FASB pronouncements while examining the enduring impact of lease accounting and revenue recognition standards. This course will provide reminders regarding both GAAP and non-GAAP financial reporting alternatives for closely held entities. We will also explore selected guidance regarding audit, review, and compilation engagements. Delivery Method: Individual webcast CPE Credit: 4Program Level: Basic
Create Measures in Power BI that Define Your Metrics
Online
4.00 Credits
Member Price: $149
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.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.
See more dates
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.
See more dates
Supporting Mental Wellness to Thrive in Work and Life
Online
2.00 Credits
Member Price: $89
In today's fast-paced world, maintaining a healthy work-life balance is essential for mental wellness. This course is designed to provide practical tools and strategies to help you create a balanced, fulfilling life. You'll learn actionable techniques for improving sleep hygiene, incorporating proper nutrition, fostering open communication, and managing stress. Whether you're struggling with burnout, seeking better work-life harmony, or simply looking to improve your overall well-being, this course offers valuable insights and tools to help you thrive. Designed to fit into your busy schedule, it delivers the guidance you need to make practical, sustainable changes in your life, starting today. 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.
See more dates
Business Tax Update 2026: Compliance and Planning
Online
2.00 Credits
Member Price: $89
This course addresses the most recent legislative and regulatory developments impacting business taxpayers, with a focus on important OBBBA 2025 provisions, rules and concepts to apply when preparing client returns. *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
K2’s Microsoft Copilot, Including Agentic AI
Online
2.00 Credits
Member Price: $89
Discover how artificial intelligence is transforming the accounting profession in this dynamic, intermediate-level CPE session. Microsoft Copilot for Accounting and Financial Professionals explores how AI-powered tools in Microsoft 365-like Excel, Outlook, and Teams-can streamline workflows, enhance data analysis, and improve client service. Learn how to harness Copilot to automate tasks, generate financial insights, and collaborate more effectively, while maintaining compliance and data integrity. Whether you're in public accounting, corporate finance, or advisory services, this course will equip you with practical strategies to integrate Copilot into your daily work and prepare for the future of intelligent accounting. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Peeking Behind the Curtain: Exploring IRS Audit Technique Guides
Online
2.00 Credits
Member Price: $89
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. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Real Estate Professionals: Passive Activity, Sec. 199A and Investment Income Tax
Online
2.00 Credits
Member Price: $89
When do they exist and how to report them? This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction. *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
Financial & Tax Accounting for Partnerships & LLCs
Online
4.00 Credits
Member Price: $149
This program compares and contrasts the financial accounting for partnerships and LLCs, as well as discusses the tax accounting for these entities, with a thorough discussion of the important differences between financial accounting for partnership capital accounts and the tax accounting for partnership capital accounts. Financial accounting for operations of a partnership will also be addressed. This course does not qualify for IRS credit. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Tax Depreciation: Review and Update
Online
2.00 Credits
Member Price: $89
A discussion of recent law changes that impact capitalization, depreciation, and disposition of assets. 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.
See more dates
PowerPoint: Tips & Tricks for Today's Accountant
Online
2.00 Credits
Member Price: $89
PowerPoint is a widely available resource that is potentially underutilized by accountants because many accountants do not stray beyond Excel and Word in the Microsoft Office suite. You will learn how to create and edit a professional PowerPoint slide deck. This session places particular emphasis on efficiency tips and tricks that will allow you to develop creative, professional visual aids while minimizing time and effort. The course’s author will share personal insights he has cultivated throughout more than two decades of public speaking. Although the session will focus on creating and editing slides, we will illustrate best practices for presentation delivery. We will also explain how PowerPoint can be used for purposes other than delivering presentations. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Deep Dive into Quality Management
Online
2.00 Credits
Member Price: $89
Quality management represents a significant shift in how CPA firms design, implement, and evaluate audit and attestation quality. This course provides a focused, practical deep dive into the quality management standards and related engagement-level requirements that firms are now operating under. The course covers SQMS 1 and SQMS 2, along with related engagement-level standards, including SAS 146, SAS 145, SSARS 26, and SSAE 23. Emphasis is placed on post-implementation responsibilities, including evaluating the effectiveness of quality management systems and addressing monitoring and remediation requirements. Participants will also examine engagement-level quality management responsibilities, including the auditor’s responsibilities under SAS 146 and the engagement partner's responsibilities in SSARS engagements. The course is designed to help firms navigate the second phase of implementation, moving beyond design and rollout to ongoing evaluation, monitoring, and continuous improvement. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate