CPE Catalog & Events

Excel gives you multiple ways to solve the same problem - but which formula is the right one? This course teaches a decision-based approach to function selection, helping you confidently choose between similar and competing functions. Through real-world examples and side-by-side comparisons, you'll learn when IFS or SWITCH is cleaner than nested IFs, how SUMPRODUCT can help with complex summarizing data, how to use LET in place of defined names, and much more. Ideal for professionals who want to make smarter, faster formula choices that are easier to maintain and audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The ancient Romans had a saying about using caution when appointing someone to a position of trust, "don't set a wolf to watch the sheep". That saying is in use today and has changed to include "don't put a fox to guard the henhouses";. The thought is similar, but the wolf and fox are vastly different animals. Wolves rely upon their strength to survive while foxes rely on their cunning. Like foxes, fraudsters rely upon their cunning to defeat or circumvent internal controls. This session reviews the investigation of a deputy court clerk who exploited a weakness in internal controls and committed fraud in the courthouse.

Business professionals can automate data collection processes by using today's electronic forms. Learn about these tools and how to deploy them in this session.

Most leadership training focuses on leading downstream, with the goal of eventually advancing to an executive role. Few people get to be “top dog” in their organization. So, nearly every worker will spend their entire career leading up, even while serving in a leadership role. Learn the skills and tactics needed to develop an effective working relationship with your boss and other superiors. Gain the credibility and support necessary to get things done and advance professionally.

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!

Are you intrigued by the buzz around Artificial Intelligence (AI) but unsure how to dive in? You're not alone! Many professionals find AI tools like Gemini, ChatGPT, and Copilot to be a mystery. But don't worry, we're here to help you unlock the potential of these powerful tools! Join K2's "Getting Started With Artificial Intelligence" session and discover how to harness the power of today's AI tools to boost your efficiency and productivity. This session will guide you through accessing and using multiple popular AI tools, making it easier than ever to integrate AI into your daily workflow. If you're new to AI, this is the perfect opportunity to get started and transform the way you work!

Have you ever considered a tax audit from the perspective of an IRS examiner? This session explains how you can use IRS Audit Technique Guides (ATGs) to enhance tax compliance. You will obtain a glimpse of the audit process from the viewpoint of an IRS agent as we explore insights that the IRS provides to its own examiners. 

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. 

As reported by the Association of Certified Fraud Examiners 2024 Report to the Nations on Occupational Fraud and Abuse, organizations lose an average of 5% of their revenues to fraud. Yet, the report disclosed that only 3% of all frauds are detected by the external auditor. However, the thing that management depends on the detect fraud is the external audit. To detect fraud an auditor must: Know what fraud looks like; be able to think like a thief; always maintain healthy professional skepticism; be able to recognize the risk of fraud; and build your audit program to look for fraud. Auditing For Fraud addresses each of these areas as well as several others.    During this presentation, I will discuss how to distinguish between an error and a fraud; how to recognize the indicators of fraud; develop and refine a hypothec as to how a fraud was committed; who steals (the basic honest person) and why and lastly; how to prove intent. If you cannot prove intent, all you have is a dumb mistake! Chances are that after this presentation, you will never look at an audit the same way you do now.

This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners "tax basis" capital accounts, now required for tax form reporting. 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 focuses on the key federal tax issues affecting business from the internal accountant's point of view, with a focus on the major ramifications of the TCJA and other recent tax legislation and developments.  Planning alternatives and the potential risks associated with those strategies 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  

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.

Accounting and finance managers and executives must demonstrate sound soft skills necessary for personal growth and organizational success.  This course will provide insights into the most crtical  personal skills critical for CFOs and Controllers - or those that want to be!

The COVID pandemic changed the way many people worked, yet others have had remote teams for decades and little changed.  Many organizations trying to bring people back to the office have experienced significant turnover.  Some practices have changed forever while some principles will always remain the same.  Keeping your people happy equals keeping your best people.  Learn the changes you should make now and the things you should do forever!

In today's fast-paced world, automation is like having a time machine at your fingertips. By implementing strategic automation solutions, you can transform an eight-hour workday into twelve hours of productivity without working longer hours. This course explores how automation can save time, improve accuracy, promote effectiveness, and maximize the value of your workday. When you invest time in automating routine tasks, you create permanent time savings that compound over time, reducing daily stress and providing better mental clarity for more important activities. This hands-on course will equip you with practical knowledge of various automation tools, methods, apps, and technologies that can revolutionize both your personal and professional life. From home automation systems to iPaaS (Integration Platform as a Service) tools and the Elgato Streamdeck, you'll discover how to create a seamlessly automated environment. Join us to learn how to reclaim hours or even weeks of time through smart automation strategies that will transform your daily routine.

For most people, funding their own retirement is the largest expense they will ever have. Due to advances in medical technology and overall healthier lifestyles, it is not unusual for someone to live 30 years or more in retirement. In this course, we will discuss how to quantify and calculate the retirement needs of the client. We will talk about time value of money concepts, how to help clients quantify their retirement goals, and even how to address risk perceptions. By doing this, we will allow practitioners to be able to better address client questions and frame trade-offs when necessary. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Building on Part 1, this course will review the application of sampling in financial statement audits with a focus on sampling for tests of controls. We'll also review the requirements for sampling in Single Audits with a focus on tests of controls and tests of compliance. 

Many organizations struggle to keep budgets current in an ever-changing business climate.  Twenty-first century performance metrics focus on determining what budgets should be rather than what they were in the past.  Using performance metrics effectively reduces work, reduces politics, provides flexibility and substantially improves the performance management process.  This session will show you powerful techniques to drive your organization’s performance.

This course provides tools and insights into financial statement analysis - both quantitative and qualitative. We'll look not only at the three main financial statements but also dive into the MD&A and footnotes. We'll also discuss the affect of industry nuances on comparability of different analysis tools. 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 provides a concise overview of how to utilize ChatGPT for advanced financial analysis in accounting. The session reveals how to combine sophisticated evaluation and interpretation of financial data with the cutting-edge AI capabilities of ChatGPT. Aimed at enhancing the understanding of an entity's performance, predicting future financial health, and aiding in informed business decision-making, this course goes beyond basic financial statement analysis to include a wide array of techniques and tools. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.