CPE Catalog & Events

A comprehensive review of the newest version of the U.S. Government Accountability Office’s Government Auditing Standards, otherwise known as “the Yellow Book.”  The standard will affect all auditors who perform audits of government and nonprofit organizations who receive federal funds, or where application of GAO standards is required by law, regulation or contract.  It does not address the standards applicable to performance audits.

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 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.

When you ask someone in accounting and finance how often they use generative AI, it's no longer a "sometimes" -- it's usually daily. Effective use of the AI tools may vary, though. This webcast can help improve both efficiency and effectiveness for accounting and assurance professionals by unlocking the key to well-structured AI prompts. Examples of effectively written prompts will illustrate how to craft prompts that improve AI outputs and create even more efficiency in your work.

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.

GAAP is changing at an increasing rate. Every successful organization has a sound strategy. Financial leaders are faced with the dual challenge of navigating evolving accounting standards while strategically guiding their organizations toward sustainable growth and profitability. What are the newer accounting changes that will impact professional accounting? This seminar will equip finance professionals with the critical skills and practical insights needed to effectively manage the complexities of ever-changing accounting standards and upgrade your essential strategic planning skills. Strategic skills are mandatory today. Strategies that do not keep pace with the market are doomed to fail. If we do not keep up, our successor will.

Although Power BI has been available for ten years, most business professionals don't fully appreciate all it can do and its easy use. Further, many are intimidated by the platform and continue to use less efficient and effective reporting practices. If this describes you, invest some time in this session to learn how to work with Power BI almost immediately. In this session, you will learn how to use Power BI to create compelling dashboard reports. You will also learn how to optimize these reports to enhance their effectiveness. If you want to improve financial and operational reporting processes, this session is for you!

If you are efficient and want to learn lessons from the best in a short time, this seminar is for you.  Popular speaker Don Minges will review the key lessons from five fantastic business books that will help you become more effective.  The topics are; leadership, how to create a valuable business, how to turnaround a business, how to make terrific presentations and how do humans think?  These lessons are valuable for every business leader. 

This course examines actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters' ability to accomplish their nefarious acts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.

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.

Mastering revenue recognition It's crucial to know the key principles of revenue recognition to recognize revenue effectively. You'll gain an understanding of these key principles by exploring the five-step revenue recognition process. You'll learn more about: Identifying a customer contract Determining performance obligations Establishing a transaction price Allocating the transaction price Recognizing revenue Fulfilling performance obligations Enhancing financial acumen through practical management strategies and real-world examples can significantly improve your organization's ability to excel in revenue recognition practices. You'll cover several aspects of performance obligations, including: Identifying distinct goods and services Implications of promised goods Complexities associated with shipping and handling activities

Many leaders in business organizations of all sizes view the system of Internal Control almost purely as a protective security measure. A well-designed internal control system can and will drive all entity objectives which includes successful operations. This session uses information gathered from years of creating internal control systems as well as concepts from well-respected authoritative pronouncements and frameworks to illustrate the power of a strong and well supported control system as well as actions that can help establish such a system. Those that work with internal controls who are tasked with developing ways to improve operation level capabilities should strongly consider this session. 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 fast-paced update course focusing on the hottest Federal income tax topics affecting individuals, businesses and their owners with an emphasis of newly enacted income tax legislation.   *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 seminar offers a practical and in-depth exploration of IRS Schedule K-1, a critical reporting document issued to taxpayers with interests in pass-through entities such as Partnerships, S Corporations, and Estates or Trusts. Participants will gain a clear understanding of how to interpret and accurately report Schedule K-1 data on Form 1040, with emphasis on common income, deduction, and credit items. The course also demystifies the Qualified Business Income (QBI) Deduction, including eligibility criteria, reporting mechanics, and integration with K-1 data. Key compliance topics-such as basis and loss limitations, material participation rules, and passive activity considerations-will be addressed through practical examples. In addition, attendees will be briefed on recent developments affecting Schedules K-2 and K-3, ensuring they are equipped to navigate evolving international reporting requirements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

If you perform Yellow Book audits and/or single audits, it is a given that a peer reviewer will be looking at your work on those engagements! Why fret and sweat about what peer reviewers are going to be looking for? In this course, we will explore the key audit requirements that peer reviewers focus on, how the auditor complies with those requirements, and common pitfalls seen in Yellow Book and single audits. This course will help you proceed and succeed in your Yellow Book and single audits.

This course explores the best practices for hiring remotely while leveraging personality assessments to make more informed decisions. Learn how to effectively integrate personality testing into your recruitment process to identify candidates who are the right fit for your team, even from a distance.

Understanding your own and the people style of others whom you are dealing with which can establish rapport more easily, help you become more persuasive, and avoid miscommunication with the possibility of rubbing someone the wrong way.  In our session, you will gain insights into your people style, ways to improve communication connectivity and how to understand your team's functionality (or more likely dysfunctionality).  

Small CPA firms, defined as those with 30 or fewer professionals, face distinct challenges amid rapid technological change, evolving regulatory demands, and mounting pressure to attract and retain talent. This webcast keeps practitioners current on the developments that matter most while offering practical, immediately applicable insights to strengthen their practices. Participants will gain clarity on today's most pressing questions: How can small firms address staffing shortages and build a sustainable talent pipeline? Which emerging technologies merit investment now? How should firms prepare for new compliance requirements and regulatory updates? What practice-management strategies are most effective for staying competitive in a fast-changing landscape? What sets this webcast apart is its exclusive focus on small firms. Each session emphasizes practical, resource-efficient solutions tailored to their needs. Attendees will hear real-world examples, explore current trends, and receive actionable guidance from experts who understand the realities of small-firm leadership. Designed for partners, managers, and future leaders, this program equips small firms to operate more efficiently, respond effectively to evolving standards, and position themselves for sustainable growth.