CPE Catalog & Events
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.
K2’s Formatting Excel Spreadsheets The Right Way
-
Online
2.00 Credits
Member Price: $89
Did you know that business professionals can spend up to half their time in Excel just formatting? It’s time to change that! Join this fast-paced, results-driven session and discover Excel formatting best practices that will save you hours and elevate your spreadsheets to a professional level. From Custom Format Codes and Templates to Styles, Precision as Displayed, and powerful date and accounting formats, you'll learn how to streamline your workflow and make your data shine. Whether you're building reports, dashboards, or financial models, these formatting techniques will help you work smarter, not harder. Don't let formatting slow you down. Transform your Excel experience, starting now! Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Preparation, Compilation and Review Engagements
-
Online
2.00 Credits
Member Price: $89
This course is an introduction to preparation, compilation, & review engagements. During this course, we will compare and contrast these different engagements by reviewing the procedures that should be performed, different reports, as well as the level of assurance specific to each type of engagement. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Criminal Tax: How CPAs Bring Value to Defense Attorneys
-
Online
2.00 Credits
Member Price: $89
CPAs can be requested to assist attorneys in litigation support in criminal proceedings. For criminal tax cases, the IRS has recommended prosecution. However, the rules and stakes are different than a simple civil audit. This presentation will focus on how to assist defense attorneys in calculating tax loss, asking the right questions, and probe possible weaknesses in criminal tax investigations. 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
Unlocking Deep Secrets: Case Studies in Financial Analysis
-
Online
2.00 Credits
Member Price: $89
Unlock the secrets to understanding a company's financial health and management performance through comprehensive financial analysis. This seminar will guide you through essential tools such as vertical analysis, horizontal analysis, and ratio analysis to gain deep insights into business performance. - Vertical Analysis: Learn how to express each line item of financial statements as a percentage, making it easier to compare companies of different sizes and identify key trends. - Horizontal Analysis: Discover how to compare financial information over multiple periods to spot significant changes and trends, providing a clearer picture of a company's growth and performance. - Ratio Analysis: Dive into calculating and interpreting financial ratios to assess profitability, liquidity, and solvency. Understand how these ratios reveal the effectiveness of management and the potential of the business. This seminar goes beyond just teaching terms and formulas. We will apply these analytical tools to real-world financial data, demonstrating how to derive meaningful insights and make informed decisions. Join us to enhance your financial analysis skills and gain a competitive edge in evaluating business performance. 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.
Guide to Deducting Travel, Meals and Entertainment Expenses
-
Online
4.00 Credits
Member Price: $149
This program will explain the new rules for deducting travel, meals and entertainment expenses and the TCJA disallowance of business entertainment expenses. Documentation requirements and planning opportunities related to travel, entertainment, and automobile expenses will also be addressed. *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: 4Program Level: Intermediate
Maximizing Fringe Benefits: Strategies for Business and Personal Needs for Today and Beyond
-
Online
8.00 Credits
Member Price: $250
As tax policies and economic conditions continue to evolve, staying ahead in fringe benefit planning is more essential than ever. This course provides financial professionals with a comprehensive update on fringe benefit strategies, ensuring compliance with evolving regulations while maximizing tax efficiency for businesses and individuals. Participants will explore the latest legislative and regulatory updates impacting employer-sponsored benefits, IRC §132 fringe benefits, cafeteria plans, and retirement healthcare strategies. This course also examines ERISA reporting requirements, tax-efficient compensation planning, and healthcare benefits, offering practical applications to help practitioners navigate compliance and optimize benefits for their clients. *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 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
Business Valuation Fundamentals
-
Online
1.00 Credits
Member Price: $39
This course provides a practical overview of business valuation, guiding participants through the key concepts, methodologies, and considerations involved. You will explore the types of valuation reports, the standards governing their preparation, and the step-by-step process of transforming raw data into actionable insights. The course also examines how the intended purpose of a report can influence its conclusions and offers strategies for valuing minority interests. By the end of the course, participants will gain a clear understanding of how to read, interpret, and apply business valuation reports effectively. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
K2’s Better Reporting With QuickBooks Online
-
Online
1.00 Credits
Member Price: $39
With over 7 million businesses relying on QuickBooks Online, one thing is clear: excellent financial reporting isn't optional - it's essential. Yet many users struggle to access the insights they need, often limited by subscription tiers or simply unaware of the powerful tools at their fingertips-that's where this session comes in. This session is your fast track to mastering QuickBooks Online's reporting capabilities. Whether you're a small business owner, accountant, or financial manager, you'll discover how to: Build and customize Standard, Custom, and Management Reports Leverage the new Spreadsheet Sync tool to create dynamic, multi-company reports in Excel Uncover hidden features that help you make smarter, faster decisions If you're ready to transform your data into actionable insights and finally get the reports you need, this session is your game-changer. Join us and take control of your QuickBooks Online reporting like never before! Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
K2’s Ten PDF Tips You Need To Know
-
Online
1.00 Credits
Member Price: $39
Portable Document Format (PDF) documents are everywhere! Yet few know how to work effectively with these documents. If you are interested in working more effectively and efficiently with PDFs, this session is for you. In this session, you will learn valuable tips you can use to assist you with creating, editing, and securing PDFs. You will also learn how to convert PDFs to fillable forms and secure PDFs, among other features. Don't miss this chance to learn ten PDF tips you need to know to increase your ROI on PDFs. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Executive Presence, Personal Brand: Structure Your Narrative
-
Online
1.00 Credits
Member Price: $55
Professional credibility is communicated, not assumed. In this 1-CPE session (Professional Development), participants examine structured approaches to articulating their professional identity. Drawing directly from the course framework, the session covers development of an elevator pitch, a professional value proposition, and a concise executive biography. Participants will analyze how credibility is established through clarity, relevance, and alignment with audience needs. The course emphasizes service-centered communication rather than self-promotion and provides structured guidance for refining professional messaging in leadership and client-facing 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.
K2's Ten Questions To Ask Your IT Team
-
Online
1.00 Credits
Member Price: $39
Business leaders often struggle to engage meaningfully with their IT teams about critical technology decisions that impact organizational success. This structured program presents ten essential questions every executive should discuss with their technology professionals to ensure proper oversight of cybersecurity, infrastructure, and strategic technology initiatives. Participants will gain confidence in addressing complex topics including network security protocols, backup procedures, cloud governance, and remote work policies through targeted questioning frameworks that drive actionable outcomes. The course systematically addresses ten critical areas where executive oversight proves essential for business continuity and growth. Attendees will develop practical communication strategies to bridge the gap between business objectives and technology capabilities, ensuring their organizations maintain competitive advantage while managing digital risks effectively. Each question framework provides executives with the tools needed to evaluate current technology practices, identify vulnerabilities, and guide strategic technology investments that support organizational goals in today's rapidly evolving digital landscape. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
A Guide to Sampling - Part 1
-
Online
2.00 Credits
Member Price: $89
Sampling is often identified as a common audit deficiency in peer review. This course will review when is sampling applicable and basics of planning a sample. We'll then focus on the application of sampling in financial statement audits with a look at sampling for substantive procedures. We'll look at the use of monetary unit sampling and tools that can be leveraged to reduce bias in sampling. Delivery Method: Individual webcast CPE Credit: 2Program Level: Overview
Mastering Communication Skills for the CPA
-
Online
2.00 Credits
Member Price: $89
Have you ever met an accountant who exhibits solid technical prowess but possesses lackluster communication skills? It is not unusual to meet a savvy accountant who is a technical expert, but could enhance the delivery of written and spoken words. This course is designed to help CPAs improve their written and verbal communication skills. Participants will learn how to tailor communication to their audience, with particular emphasis on techniques for crafting a message that effectively conveys technical information in an engaging manner. The course's author will share personal success tips gleaned from more than two decades of experience communicating myriad topics to a variety of audiences. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
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
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
Maximizing the Tax Benefits of an Installment Sale
-
Online
1.00 Credits
Member Price: $39
This course will explore the many complex rules of installment sales, with a focus on the tax treatment and strategies to maximize the benefits. *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Handout Tab and submit to kori.herrera@acpen.com Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Sarbanes Oxley - Sourcing Emerging Risks- 20 years later - Part 1
-
Online
1.60 Credits
Member Price: $79
Emerging risks seem to be an issue for all business processes these days. It's been 20 years and counting since the Sarbanes-Oxley legislation was passed. In theory the legislative requirements outlined are still in place. Although the requirements haven't changed, time has changed and as a result, execution of the processes has most likely changed. However, it would be amiss to not recognize that the passage of time has changed our world. Think of various events such as economic change, technological evolution, the pandemic etc. These are just a few of the changes that may have impacted the manner in which we execute some of the processes outlined in the SOX legislation. Delivery Method: Individual webcast CPE Credit: 1.6Program Level: Update