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.
The Art of Marketing for CPAs
-
Online
4.00 Credits
Member Price: $149
To make more money in less time, all accountants need to learn to market themselves effectively to their clients or their firm. For better or worse, promotions and more money go to those who are the best marketers, rather than the most competent accountants. In this fascinating and fun workshop, participants will learn seven key ways to get more clients and/or promotions through the art of marketing. Delivery Method: Individual webcast CPE Credit: 4Program Level: Update
Accommodation Requests - Substance Abuse - Contagious Infections
-
Online
1.00 Credits
Member Price: $39
Good judgment works well in handling most employee relations matters. However, there are special situations where legal requirements dictate specific handling to avoid significant personal and employer liability. This course provides practical knowledge and scripts for responding to requests for accommodation regarding religious practices or disabilities, confronting employees in substance-abuse situations, and handling disclosures of contagious infections so that individual is properly helped, and the health of your workforce is protected. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Business Partnerships: Managing Supplier Relationships
-
Online
1.00 Credits
Member Price: $55
As financial leaders, CPAs are often tasked with managing organizational risk. In this respect, the supplier relationship can be a tricky one. It is often one of the more familiar and comfortable business relationships we have, yet it may also be the one that presents the most significant risk to our company. In this course, we will explore how to manage the supplier relationship from onboarding to termination. Through case studies and best practices, we will discuss how to continue being a good partner to our suppliers while also understanding where potential risks exist. 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.
What Is Your Brand Reputation?
-
Online
1.00 Credits
Member Price: $39
What do people say about you when you leave the room? Is it what you want them to say? How you show up in the room, get listened to, build trust, and are known amongst your colleagues are all critical components of your future success. In this workshop Michelle Tillis Lederman, CEO and Founder of Executive Essentials, will discuss how to determine you brand attributes, demonstrate the nuances of body language on your professional presence, and discuss how to strengthen trust and the lasting impressions you make on your network, expanding upon lessons from her books The Connectors; Advantage and The 11 Laws of Likability. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
The Controllership Series: The Controller's Role in Debt Management
-
Online
1.50 Credits
Member Price: $79
Debt Management: Debt management often involves administering loan agreements and ensuring bank compliance. Compliance: Controllers help ensure compliance with federal and local laws, provisions, and financial regulations. Delivery Method: Individual webcast CPE Credit: 1.5Program Level: Basic
VSCPA Tax Essentials Series (Replay of 2/18/27)
-
Online
2.00 Credits
Member Price: $59
This is a replay of the live webcast originally held on 2/18/27. A presenter will not be available during this rebroadcast. The VSCPA Tax Essentials Series helps you stay current in a constantly changing tax environment with timely updates on federal and Virginia developments affecting individuals and businesses. Each webinar provides: Updates on significant tax developments and emerging issues. A review of recent legislation, guidance and regulatory changes. Insights into developments that may impact compliance, reporting and planning. A concise, practical overview designed for busy tax professionals. Stay informed on the issues shaping today's tax landscape — all in a focused, 100-minute webinar.
IFRS vs. US GAAP - Major Accounting Differences
-
Online
2.00 Credits
Member Price: $89
Whether a financial statement preparer or user is more familiar with IFRS or U.S. GAAP, it is important to be familiar with the important differences between the two financial reporting frameworks. This course will highlight some of the more significant differences between the standards. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
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
K2’s Eight Awesome PivotTable Features
-
Online
2.00 Credits
Member Price: $89
Unlock the full potential of Excel's most powerful feature-PivotTables! While many users rely on them daily, few tap into the advanced capabilities that can transform data into dynamic insights. Join us for an eye-opening session where you'll discover eight game-changing PivotTable techniques that go far beyond the basics. From custom calculations and KPI integration to multi-source consolidation and advanced reporting tricks, we'll show you how to elevate your analytics and impress stakeholders. Whether you're a seasoned Excel user or just getting started, this session will equip you with the tools to turn ordinary PivotTables into extraordinary decision-making engines. Don't just use PivotTables-master them! Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Eliminating Busy Season: Transforming Your Practice to Year- Round Advisory Services
-
Online
2.00 Credits
Member Price: $89
This course provides tax and accounting professionals with a comprehensive framework for transitioning from a compliance-driven busy season model to a sustainable, year-round advisory practice. Participants will explore strategies for expanding services into tax, financial, and estate planning. The course addresses both transitioning existing clients and attracting new, higher-value clients while improving efficiency, client value, and revenue stability. Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate
Failure to Detect Fraud and the Reasons Why
-
Online
2.00 Credits
Member Price: $89
SAS 122, AU 240, Consideration of Fraud in A Financial Audit state that auditors fail to detect fraud for two reasons. One, they haven’t been trained to look for it and two, they don’t know what it looks like. I would like to add a third reason: they don’t want to find fraud because it causes problems for the audit. This session is designed to familiarize auditors with the many faces of fraud; where and how to look for them and what to do if you think you have found fraud. Not everyone is able to recognize fraud. During this program, the attributes a fraud auditor (frauditor) will be discussed. In order to recognize fraud, an auditor must understand their client’s operation. What is an indicator in one client’s operation may be business as usual in another, and you have to know the difference. After viewing this program, chances are you will never look at your client the same way! Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Profiles in Fraud
-
Online
2.00 Credits
Member Price: $89
Nobody is immune to fraud risk. This course opens with stories of real fraud perpetrators then examines the similarities between the fraud perpetrators, discovering that they all have many common traits. It finishes with techniques accountants can use to deter these behaviors. 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.
Habits That May Keep You from Promotions, Raises or Achieving Your Potential in Organizations: Small Steps Can Lead to Big Changes
-
Online
4.00 Credits
Member Price: $149
In this course, we will discuss what derailer habits keep you from achieving your fullest potential and deserving place. Delivery Method: Individual webcast CPE Credit: 4Program Level: Basic
Finding the Right Fit: An Exploration Financial Reporting Options for SMEs
-
Online
4.00 Credits
Member Price: $149
This course is designed for accounting and finance professionals who desire financial reporting flexibility for small- and medium-sized entities (SMEs). We examine special-purpose frameworks (SPFs) that may offer simplification while enhancing the usefulness of financial reporting for SMEs. Our discussion offers practical ways to align financial reporting with the decision-making needs of users and other stakeholders. Real-world examples and case discussions will help attendees confidently prepare, review, and interpret SMEs’ financial statements. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Impact of OBBBA 2025 on the Individual Taxpayer
-
Online
6.00 Credits
Member Price: $189
This program covers all of the major individual provisions of the OBBA of 2025 (H.R. 1), including detailed examples of provisions which were extended, made permanent with substantial changes, and new for 2025 and beyond. A comprehensive case study will apply many of these provisions to illustrate the impact of these provisions on the individual taxpayer. Other current individual tax issues, including dependent care and student loan reporting, will also be review. *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: 6Program Level: Intermediate
Self-Rental Real Estate: Passive Activity & Section 199A
-
Online
2.00 Credits
Member Price: $89
This program presents a detailed analysis of the self-rental passive activity rules, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. 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.
Workforce Transformation and Talent Management in 2025
-
Online
1.00 Credits
Member Price: $55
The accounting profession faces unprecedented workforce challenges that demand a fundamental rethinking of traditional firm structures. This course examines why the century-old pyramid practice model is becoming obsolete and presents the inverted pentagon framework as a sustainable alternative. Based on comprehensive research showing that 52% of firms expect to shrink by 20% or more in the next five years, participants will learn how to restructure their firms to thrive with fewer entry-level staff while expanding specialized expertise. The course explores the "6 Ps of Business Model Transformation" - Precision Hiring, Proactive Retention, Practical Technology Implementation, Pricing Expertise, Practice Area Expansion/Focus, and People Acceleration. Drawing from success stories in manufacturing, healthcare, and technology industries, attendees will discover proven strategies for accelerating staff development, implementing effective knowledge transfer programs, and building sustainable talent pipelines in an era of technological disruption and demographic shifts. 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.
Group Audits: Who is Responsible for What?
-
Online
2.00 Credits
Member Price: $89
Financial statement audits often involve audits of components of a larger entity. This course will focus on the responsibilities for both the group auditor and component auditor, including implementation of SAS No. 149 relate to group audits. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Public Procurement Basics: Protecting the People's Money
-
Online
2.00 Credits
Member Price: $89
Procurement is a critical component of successful government operations. While there are challenges in public procurement, there are a number of guidelines and requirements that will help lead you to success. This course will offer guidance on how governments can meet complicated procurement needs and develop best practices that protect public and Federal funds. 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.