CPE Catalog & Events

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!   

This three-day training course is taught using a hands-on methodology and provides a comprehensive understanding of the federal income tax laws applicable to individuals. The session includes a comprehensive case study (using actual W-2s, 1099s, 1098s, K-1s, etc.). Participants will walk through the preparation of Form 1040 and related tax schedules, learning complex income tax law. Each attendee will receive a comprehensive individual income tax reference manual that includes practice aids, real-world examples, new Federal income tax forms and schedules, and Pat Garverick's Quick Reference Chart.

Do you use Microsoft (Office) 365? Are you satisfied that you are getting the most that you can from it? If you answered yes then no, this course will provide a really high return on your investment of time and money in this application suite. John Higgins, one of the profession's leading experts on the integration of Microsoft 365 into business, will explain and demonstrate the depth and breadth of the Microsoft 365 ecosystem. The course is designed to raise your awareness of all that you can do with Microsoft 365 and substantially increase your monthly subscription ROI. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The introduction to governmental budgeting course is an overview of the typical timeline and process a government uses when creating their annual budget. Topics covered include the basics of governmental budgeting, establishing priorities for the budget, the common steps and timeline of the budget process, what, when and how we should be monitoring the budget throughout the year, and how long-term budgets fit in with the annual budget process. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This highly informative course comprehensively covers all the latest tax law developments. The focus is on individual taxation and discussion of the planning opportunities practitioners need to understand to help clients respond effectively. You will come away from the course with the up-to-date knowledge to educate your individual tax clients and implement tax-saving ideas that will serve their ever-evolving needs. This course is continually updated to reflect enacted legislation. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BFTU.

Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session provides best practices for gathering and analyzing evidence and reporting the investigation results. Attendees will end the session with takeaways to immediately implement in future HR investigations. Three of three Episodes in the series.

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 2027

This course explores the tests used to determine whether a worker is properly characterized as an employee or an independent contractor for tax purposes, with a focus on the cost of getting it wrong and possible Section 530 relief.  The game changing impact of the Dynamex case and AB5 will also be discussed.    *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      

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

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  

This course investigates actual real-world fraud schemes and discusses what controls could have prevented the fraud from occurring, and what controls could detect and curtail the fraud scheme. The instructor speaks from experience, finding multiple frauds very early in her career leading to a career-long focus on fraud prevention and detection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

With the increasing complexity and ever-changing nature of tax laws and issues, today’s accountant needs a one-day update course focusing on individual income tax issues with an emphasis of newly enacted income tax legislation. This comprehensive class will not only review the current Federal individual income tax laws but will also update tax return preparers of new tax forms, changes to existing tax forms, as well as tax planning opportunities and pitfalls. This is a “must-attend” course for all tax practitioners who want to be up to speed quickly and have a successful Federal individual income tax filing season.   *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  

In today's fast-paced business world, staying ahead of the competition means leveraging every advantage. Business Intelligence (BI) is the game-changer that can transform your organization. Imagine uncovering hidden insights and gaining a competitive edge with data that was once out of reach. With tools ranging from Excel add-ins to the revolutionary Power BI, you can now harness your existing skills to create dynamic, interactive dashboards and analyses that were unimaginable just a few years ago. This program will empower you with the skills to implement "yourself business intelligence" using a variety of techniques and tools. You'll start by mastering advanced Excel data query and summarization features to create stunning Excel-based dashboards. Then, you'll take your knowledge to the next level by building even more powerful BI objects using Microsoft's Power BI tools. If you're passionate about gaining better insights into your data to make smarter decisions, this fast-paced program is for you.

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

How does a forensic accountant calculate financial losses? Federal courts have approved various ways to calculate losses ranging from net worth method of proof to the expenditures method. Each method of proof depends on the available facts to the forensic accountant. This presentation will focus on the various court approved methods of proof, when to use them, and how to calculate the total loss. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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

Finance technology decisions (ERP, FP&A, AP/expense automation, close/consolidation, bank integrations, and AI-enabled tools) can dramatically improve close speed, forecasting, and control execution-but vendor demos and "AI" marketing often hide integration complexity, data readiness gaps, governance risk, and long-term total cost. This course provides a practical, vendor-neutral approach for CPAs and finance leaders to evaluate and implement corporate finance technology with an audit-ready mindset. Participants learn how to cut through AI claims using an AI capability framework, apply a weighted vendor evaluation scorecard focused on controls and assurance, build a five-year total cost model that captures hidden and ongoing costs, and follow an implementation roadmap with checkpoints and red flags to reduce failure risk and improve ROI realization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Elevate your data analysis capabilities with our focused course on Power Query. Tailored for financial professionals, this training will show you how to get started using Power Query and teach you some of the ways to take advantage of its ability to handle messy data and automate repetitive tasks. Harness the efficiency of Power Query to revolutionize the way you work with data. Learn how to "program" your tasks once and set them on repeat, eliminating the need for repetitive, robotic work. This automation not only saves time but also ensures consistency and accuracy in your data processes. Whether you're dealing with complex datasets or simply looking to streamline your reporting processes, this course will equip you with the tools and knowledge to make Excel work for you like never before.

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!

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.