CPE Catalog & Events
Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting
-
Online
2.00 Credits
Member Price: $139
Which Excel function is your go-to? This session invites you to actively engage and practice with the instructor, exploring exercises demonstrated. In doing so, you'll gain a firmer grasp of common Excel functionalities, including: Data validation Conditional formatting Enhanced summing options Skinny rows Achieving proficiency in Excel features Gaining proficiency in Excel means learning to design workbooks that are both functional and streamlined. The facilitator will lead you through an array of formatting skills, formula functions, and beyond as we expand upon foundational Excel knowledge with topics such as: Managing data input for individual cells Using conditional formatting to prevent errors Enhancing productivity via the Subtotal feature Ensuring total formulas refresh automatically *Session 2 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 3: Workbook Design Principles and Organization] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-3--workbook-design-principles-and-organization) to further prepare to tackle real-world issues and build powerful workbooks.*
See more dates
Integrate ChatGPT into Your Client Advisory Services-Updated
Online
2.00 Credits
Member Price: $89
Two of the hottest topics in the CPA profession today are CAS (client advisory services) and ChatGPT. This course will explain how to bring these two worlds together by integrating ChatGPT and other generative AI applications into your client advisory services. John Higgins, a leading advisor to the profession on ChatGPT and a seasoned client advisor on technology based solutions, will show you how you can position your firm and yourself as a "go to" advisor on how to embrace this technology in virtually any type of business. John will address how to use this technology as a research and writing assistant in your client services and how to advise your clients on this revolutionary technology and all benefits and "gotchas" that come with it. If you want to step up your advisory game, this course is a "must take." 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
Surgent's Adapting to OBBBA Changes: A Strategic Review
Online
2.00 Credits
Member Price: $119
Accounting and finance practitioners are continually asked for strategic planning advice. In this course, we will cover topics that will make clients, and their advisors, tax smart and tax prepared for the coming year and beyond. This program is a two-hour review and analysis of what we consider some of the most important changes from the OBBBA impacting both individual and business clients.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 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.
The Essential Guide to Understanding Non-GAAP Financial Statements with Renee Rampulla
Online
4.00 Credits
Member Price: $149
Many entities prepare their financial statements using non-GAAP frameworks, such as tax and cash basis. Participants who attend this course will learn the unique reporting and disclosure requirements when preparing non-GAAP financial statements commonly referred to as special purpose frameworks (SPFs) or other comprehensive basis of accounting (OCBOA) financial statements. Delivery Method: Individual webcast CPE Credit: 4Program Level: Basic
Deep Dive Into Common Auditing Deficiencies
Online
4.00 Credits
Member Price: $149
This course will review common deficiencies identified by the AICPA and state boards of accountancy. It features discussion on a variety of topics, including analytical procedures, sampling, group audits and risk assessment. We will review the areas of concern and how you can overcome them by employing best practices. 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
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.
See more dates
The Art of Engaging in Difficult Conversations
Online
2.00 Credits
Member Price: $89
Difficult conversations tend to be avoided because professionals shy away from the uncomfortable, and the fear of polarizing their relationships. Participants will learn strategies and tactics to engage in productive conversations which address challenges and deepen relationships. They will understand where and why they are avoiding having difficult conversations. 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 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.
See more dates
Character and Trust: The Difference Maker in Effective Collaboration
Online
2.00 Credits
Member Price: $89
This course examines the foundational role of character and trust in building effective collaboration. While individuals are often hired for their skills and knowledge, they are frequently let go due to behavioral issues—highlighting the importance of character in professional success. Participants will explore key attributes of character and engage in a thought-provoking self-assessment exercise to increase self-awareness. The course also delves into the dynamics of trust, offering practical tools and frameworks to evaluate trustworthiness—both in oneself and in others, including managers, colleagues, and team members. Ideal for anyone seeking to strengthen professional relationships, this course provides actionable insights into how character and trust directly impact workplace performance and collaboration. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
K2’s Top Ten Productivity Booster Apps In Microsoft 365
Online
2.00 Credits
Member Price: $89
Are you ready to take your productivity to the next level? Join our exclusive two-hour CPE course designed for accounting professionals and technology enthusiasts. Discover how to harness the power of Microsoft 365's versatile applications to streamline your workflows and enhance collaboration. In this course, you'll explore ten essential apps, including Shared Mailboxes, Planner, Lists, To Do, Stream, Viva Learning, Forms, Bookings, Approvals, and Places. Discover how to effectively integrate these tools into your daily tasks and experience immediate improvements in your efficiency. Don't miss out on this opportunity to unlock the full potential of Microsoft 365 and transform the way you work. Sign up now and take the first step towards a more productive and collaborative work environment! Delivery Method: Individual webcast CPE Credit: 2Program Level: Overview
The Preparation of Form 706 and 709 – Understanding the Law
Online
2.00 Credits
Member Price: $89
Understanding the complexities of estate and gift taxation can be challenging for many financial professionals, especially those who lack direct experience in this area. In this comprehensive course, participants will gain a solid foundation in Federal estate and gift tax law, providing them with the necessary tools to confidently handle tax compliance issues related to Forms 706 and 709. By exploring the details of the Internal Revenue Code sections pertinent to estate and gift taxation, attendees will gain a thorough understanding of key concepts, including deductions, valuations, and tax credits. This practical knowledge will not only enhance their expertise but also empower them to provide effective tax planning strategies for their clients. Throughout the course, participants will investigate essential topics such as the valuation of assets, deductions for funeral and administrative expenses, charitable and marital deductions, and the calculation of tax credits. By mastering these critical areas, financial professionals will be better equipped to navigate the challenges of estate and gift taxation, ultimately enabling them to provide comprehensive and effective tax planning services for their clients. Whether you're looking to expand your expertise or deepen your understanding of tax compliance issues, this course offers invaluable insights and practical knowledge that can immediately be applied in your practice. **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
AI Prompt Engineering Masterclass for Accountants
Online
2.00 Credits
Member Price: $89
An advanced guide to prompting techniques that maximize AI efficiency and precision in everyday business research, operational due diligence and accounting tasks. Designed for accountants with no prior AI knowledge, the session explores how simple language and strategic prompting can unlock powerful, layered responses from large language models (LLMs). Participants will learn to overcome the "lazy" defaults of AI, using specific techniques to enhance detail, accuracy, and contextual understanding in their queries. By understanding prompt engineering's role, attendees will discover how to guide AI to provide practical, relevant, and analytical insights suited to complex financial scenarios, without needing extensive technical expertise. 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
Planning for Small Business Success
Online
4.00 Credits
Member Price: $149
Strategic Planning for SMEs Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Comprehensive FASB & AICPA Update for Tax Professionals 26-27
Online
6.00 Credits
Member Price: $259
This 6-hour program covers recent promulgations of the FASB and AICPA with broad applicability. In addition, the course includes the 2-hour Tax Basis Financial Statements, and 2-hour SSARS Highlight Reel, programs available as stand-alone courses.Delivery Method: Individual webcastCPE Credit: 6Program Level: Intermediate
Fundamentals of 1031 Exchanges 26-27
Online
8.00 Credits
Member Price: $329
Cover critical aspects, common problem areas and strategies for successful 1031 exchanges. Examine Form 8824 preparation, replacement property adjusted basis computations, advanced 1031 strategies and more. Study advanced 1031 exchange strategies such as reverse exchange, partners/TIC structures, and improvement exchanges (including "Bartell" parking arrangements). Bring questions and increase your expertise.Delivery Method: Individual webcastCPE Credit: 8Program Level: Intermediate
Unlock the Power of AI with Copilot in Excel
Online
2.00 Credits
Member Price: $89
In the ever-evolving world of data analytics and business intelligence, Microsoft Excel continues to be an indispensable tool for professionals across industries. With the introduction of Copilot, Microsoft has integrated the power of artificial intelligence directly into Excel, revolutionizing how users work with data. This 2-hour interactive course, Unlock the Power of AI with Copilot in Excel, provides a comprehensive overview of how Copilot transforms traditional Excel workflows into dynamic, AI-driven processes, enabling users to accomplish tasks faster, more accurately, and with less manual effort. During this course, you'll discover how Copilot leverages AI to enhance productivity and streamline operations. Whether you're a seasoned Excel user or just beginning your journey, this course will guide you through practical applications and best practices to make the most of Copilot's capabilities. Through hands-on demonstrations and real-world examples, you'll see how Copilot can save time, improve decision-making, and elevate your analytical skills to new heights. This course not only focuses on the technical aspects of Copilot but also highlights its potential to transform your day-to-day work, from automating repetitive tasks to uncovering trends and insights you might otherwise overlook. By the end of the session, you'll be equipped with the knowledge and confidence to integrate Copilot into your workflows and unlock its full potential in Microsoft Excel. 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
Corporate Storytelling in Financial Reporting
Online
1.00 Credits
Member Price: $55
Developments in the Management Commentary and MD&A Narrative reporting is entering a new era-one that moves beyond compliance checklists to focus on cohesive, decision-useful communication. This seminar examines the evolution of corporate narrative reporting through the revised 2025 IFRS Practice Statement 1: Management Commentary and the U.S. GAAP-based MD&A under SEC Regulation S-K, with key comparisons to help practitioners understand how each framework supports investor-focused disclosure. Using real-world examples and excerpts from the actual annual report of an IFRS reporting company, this seminar highlights how the revised Management Commentary guidance aims to improve the quality, relevance, and connectivity of narrative insights. Participants will explore its emphasis on strategy, risks, sustainability factors (ESG), key performance indicators (KPIs), and the integration of financial and non-financial information. The session also analyzes the modernization efforts in U.S. MD&A, including principles-based guidance, reduction of boilerplate disclosures, and expanded expectations for entity-specific analysis and trend-based insights. Through a comparative approach, participants learn how both frameworks are converging around common principles: enhanced connectivity, balanced presentation, entity-specific content, and alignment of strategy, performance, risk, and value creation. This practical seminar provides accounting, finance, and business professionals with the knowledge needed for better understanding the management commentary and MD&A. 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
Section 174: New Rules for R&E and OBBA Update
Online
1.00 Credits
Member Price: $39
This course introduces the new OBBA standards that redefine how research and experimentation are reported. Participants will learn key regulatory updates, compliance expectations, and best practices for aligning research activities with OBBA's principles of transparency, accountability, and innovation. **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: 1Program Level: Intermediate
FASB Update: What's New in Q3 - February 2027
Online
1.50 Credits
Member Price: $55
Stay current on FASB's activities, with this LIVE quarterly update. This course delivers an overview of Accounting Standards Updates (ASU) released over the past three months (up to the course delivery date) and addresses proposed ASUs issued and the deadline for comments. The course also covers changes to the FASB Workplan. Be sure to register for each quarterly update: FASB Update: What's New in Q1 - August 2026 FASB Update: What's New in Q2 - October 2026 FASB Update: What's New in Q3 - January 2027 FASB Update: What's New in Q4 - April 2027Delivery Method: Individual webcastCPE Credit: 1.5Program Level: Update