CPE Catalog & Events
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
Google Gemini AI for Accountants
-
Online
2.00 Credits
Member Price: $89
This course provides a concise overview of Gemini AI, Google's advanced multimodal artificial intelligence model. It explains how Gemini is integrated into different Google products, including Gmail, Docs, Sheets, Slides, and as a stand-alone chatbot. Participants will learn how Gemini enhances productivity by summarizing email threads, suggesting responses, drafting emails, generating formulas, creating tables, and more. By the end of the course, students will have a solid foundation in understanding Gemini AI's role in the evolving landscape of artificial intelligence. 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.
ProActive Response Group De-Escalation Training
-
Online
1.20 Credits
Member Price: $39
In today's workplace, employees are faced almost daily with customers or teammates that may have needs or concerns that we are forced to handle. Though many of these situations are easily dealt with through simple communication skills, others may become heated and, in some instances, violent. Today we will discuss healthy ways to de-escalate a wide variety of potential issues. Delivery Method: Individual webcast CPE Credit: 1.2Program Level: Basic
Behavioral Finance Biases
-
Online
1.00 Credits
Member Price: $55
If you have been a practitioner for any length of time, you know that there is often a difference between what clients should do and what they actually do. Have you ever wondered why that is? In this course, we will explore how we make decisions with less-than-perfect information. Through real-life examples and case studies, we will examine common behavioral biases and how to deal with them. 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.
Mastering Form 7217: A Guide to Partnership Property Distribution
-
Online
1.00 Credits
Member Price: $39
This program will address the complex rules for partnership distribution of property with a focus on liquidation of a partner’s interest, Section 751, and how to complete the Form 7217. OBBBA of 2025 update for property distributions is included. *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
Preparing for & Conducting Discharge Meetings
-
Online
1.00 Credits
Member Price: $39
Over 80% of all employment-related lawsuits relate to termination. Every termination should be treated as a potential lawsuit. The facts supporting a leader's recommendation of discharge must be fully investigated. The discharge of an employee requires prior review and approval. Narrow self-interest, spite, or personal animosity must not play a part in making termination decisions. This course provides practical knowledge and scripts for handling discharges with good judgment such that personal and employer liability is avoided. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Learning to Teach "Tax" as a Second Language
-
Online
1.00 Credits
Member Price: $39
Sometimes the vernacular of accounting seems more challenging than technical aspects. This session offers suggestions for translating the foreign language of taxation into tangible terms for non-accountants. We explore techniques for simplifying the complexity of taxation terminology. This course will equip you with tools for demystifying tax technicalities so you can help clients and other non-tax professionals grasp fundamental concepts. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Providing Ethical Leadership: Learning to be the Best Version of Yourself
-
Online
1.20 Credits
Member Price: $39
This course will examine certain qualities a leader must exhibit to set an ethical tone from the top. Delivery Method: Individual webcast CPE Credit: 1.2Program Level: Basic
Global Internal Audit Standards (GIAS) Domain V - Part 1
-
Online
2.00 Credits
Member Price: $89
The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service Delivery Method: Individual webcast CPE Credit: 2Program Level: Update
Introduction to Risk Assessment
-
Online
2.00 Credits
Member Price: $89
Effective risk assessment is foundational to designing an appropriate audit response. This course introduces the audit risk model and provides an overview of the risk assessment procedures performed during engagements. Participants will review the components of the audit risk model and examine common risk assessment procedures, including inquiries, analytical procedures, and observation and inspection techniques. Emphasis is placed on understanding how risk assessment drives engagement planning and supports the development of appropriate audit responses. Designed for auditors seeking a structured introduction or refresher, this course builds foundational knowledge necessary for effective engagement planning and execution. 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.
No Tax on Overtime: Payroll Compliance
-
Online
2.00 Credits
Member Price: $89
This course provides tax and accounting professionals with a comprehensive overview of overtime requirements under the Fair Labor Standards Act (FLSA). Participants will examine the statutory framework governing overtime, including employee classification, the definition of a workweek, and the calculation of the regular rate of pay. Through practical examples and compliance-based scenarios, the course focuses on the accurate application of overtime rules across various compensation structures. Emphasis is placed on identifying risk areas, avoiding common misclassification and calculation errors, and maintaining proper documentation to support compliance. 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: Basic
Introduction to Amplified Management Practice (AMP)
-
Online
2.50 Credits
Member Price: $99
Introduction to Amplified Management Practice (AMP) is a high-impact, 120-minute crash course designed for leaders tired of juggling chaos, burnout, and broken systems. Whether you're an HR professional, executive, or manager, this session equips you with a practical, repeatable framework to lead with clarity, align your team with purpose, and build momentum without losing your mind, through the core AMP mindsets—Respect, Curiosity, Transparency, and Stewardship—and its three pillars—Vitalizing, Conducting, and Reinforcing—you’ll learn how to connect customer needs, strategy, and operations while inspiring innovation and meaningful change. Perfect for busy professionals, this course delivers quick wins and lasting impact, helping you lead smarter, not harder. Delivery Method: Individual webcast CPE Credit: 2.5Program Level: Basic
A Practical Guide to Trusts
-
Online
8.00 Credits
Member Price: $250
This course provides financial professionals with a comprehensive understanding of trusts and their role in estate planning. Participants will learn how to determine whether a trust aligns with a client's financial goals and explore strategies to maximize tax efficiency. The course covers various trust structures and their potential to reduce income, estate, and generation-skipping taxes at both federal and state levels. Additionally, it delves into trustee responsibilities and the benefits of irrevocable life insurance trusts and dynasty trusts. With a focus on practical applications and real-world scenarios, this course equips CPAs, EAs, attorneys, bankers, and financial planners with the expertise to navigate probate avoidance, streamline asset distribution, and manage complex tax considerations. Whether working with revocable or irrevocable trusts, participants will gain the tools to enhance their clients' financial well-being across generations. *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: 8Program Level: Basic
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
Get started with Power BI
-
Online
2.00 Credits
Member Price: $89
Embark on a journey to master Power BI, a powerful tool for data analysis and business intelligence, in our comprehensive course, "Get Started with Power BI." This course is meticulously designed for professionals who seek to understand the full spectrum of Power BI capabilities, including its integration with Excel's Power BI features like Power Pivot and Power Query, and its comparison with standalone Power BI tools such as Power BI Desktop, Power BI Service, and Power BI Report Server. In the first part of the course, participants will be introduced to the fundamentals of Power BI. This includes an overview of Power BI's interface, key features, and its seamless integration with Excel. The course will cover Excel's Power BI tools - Power Pivot, for advanced data modeling, and Power Query, for efficient data transformation and preparation. This segment is essential for understanding how Power BI extends and enhances the data processing and analytical capabilities of Excel. The second section of the course delves into the standalone Power BI tools. Here, participants will explore Power BI Desktop for creating complex data models and sophisticated reports, Power BI Service for cloud-based collaboration and sharing, and Power BI Report Server for on-premises report deployment. This part of the course will focus on the unique features and strengths of these standalone tools, providing attendees with the skills to leverage Power BI in a variety of business contexts. 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.
Cryptocurrency Transactions: Navigating Federal Tax Rules
-
Online
1.00 Credits
Member Price: $39
As cryptocurrencies like Bitcoin, Ethereum, and others become more popular, tax authorities around the world are working to create regulations for their use and transactions. This session will address cryptocurrency tax issues and their complexities and challenges that individuals and businesses face when dealing with the taxation of digital currencies. *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: 1Program Level: Intermediate
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.
March 2027 AI Update: Current Issues, Future Possibilities
-
Online
1.50 Credits
Member Price: $55
This quarterly update keeps CPAs current on new topics and issues with LLMs, chatbots, AI research and writing, rules and regulations, and AI agents. The course covers recent changes in the AI field, focusing on applications for CPAs in business and accounting firms. Handouts are designed as takeaways for discussions about AI with clients or in business firms. Join us for all five live updates: 2026 - June, August, & November 2027 - January & MarchDelivery Method: Individual webcastCPE Credit: 1.5Program Level: Update
K2’s Taking Another Look At PDFs
-
Online
2.00 Credits
Member Price: $89
We’re all familiar with PDF documents. However, it’s safe to say that most professionals use only a tiny fraction of their features. This circumstance is unfortunate, considering all you can do with PDF documents. Therefore, isn’t it time to take another look at PDF K2’s Taking Another Look At PDFs documents and all you can do with them? Participate in this session to learn more about PDFs and how and why they should be a cornerstone technology in most organizations. Collaboration options, long-term storage and archival, and fillable forms are just a few features you will learn about in this session. If you’re ready to elevate your PDF productivity, this session is for you! Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Common Sense CFO: Balance Sheet Issues Walk through to Understand and Build Value
-
Online
2.00 Credits
Member Price: $89
We mostly focus on the income statement, but what about other financial statements and countless other accounting concerns? This seminar is dedicated to breaking down common balance sheet issues, both on-the-books and off, that have an impact on our stakeholders and the value of the organization. Using practical analysis, we highlight several key tools in understanding and communicating the importance of the forgotten cornerstone of accounting: the balance sheet. Most notably, we dedicate time to the pressing issue of “unrecorded assets”. This session is designed to also be fun and entertaining. This seminar stands on its own but is also part of the Common Sense CFO series. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate