CPE Catalog & Events

Dynamic arrays can be a tremendous time-saver in Excel, but most business professionals remain unaware of what should be a commonly used tool. With dynamic arrays you can reduce the time you spend creating and updating formulas and improve your accuracy at the same time. You can also take advantage of some innovative features associated with dynamic arrays to automate many calculations and data entry tasks. If you've yet to discover dynamic arrays, make plans to participate in this session to learn how you can take advantage of this terrific feature. 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!

Learn why creating an employer brand is so important and instrumental in competing in today's competitive marketplace. Elevate your recruiting experience for candidates and onboarding process for new hires to enhance your employer's brand.

This course is one of the courses dedicated to our Controllership series. This series of courses is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we will discuss the area of inventory. This specific segment in the first part of a two-part series on inventory. We explore how the controller can move these responsibilities into more of a strategic role. This course takes a look at some of the typical concepts and duties involved in the inventory function that is sometimes viewed as operational roles. We explore how these areas are strongly tied to the importance of the controllership role and how the controller can add value in each area.    

Inventory observations are often a right of passage for audit staff. This course will cover the basics of auditing inventory, including the related audit assertions, risks, & threats to inventory. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through how to conduct a physical inventory observation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Microsoft 365 is one of the most widely used business applications software suites used in business today. Microsoft Copilot is the generative AI application that is integrated directly into the Microsoft 365 ecosystem. If your firm or business is a Microsoft 365 user, this course will teach you how to use Copilot AI to optimize the use of your Microsoft 365 apps. This course will provide a comprehensive review and demonstration of how to put Microsoft Copilot AI to work for you and your clients. It is designed as a "hands-on" course that facilitates following along with the presenter to apply the features of Microsoft Copilot on your computer. Practice files will be provided so that you don't have to expose your confidential data. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Participants will learn how to interpret the most common IRS correspondence, adhere to response deadlines, and effectively communicate with the IRS to resolve issues and minimize risks. It provides professionals with knowledge and strategies needed to handle the most common notices including audit requests, collections & return inquiries as well as error notices. Focusing on best practices to ensure compliance and avoiding penalties or escalation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

How to properly account for and audit digital records is increasingly gathering importance as more entities have cryptocurrency and other digital assets on their financial statements. This course will address common questions, risks, and challenges evolving in this area. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

This course corresponds to our Controllership series. This course is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we discuss the area of cash and investments and explore how the controller can move these responsibilities into more of a strategic role. In today’s world, the role of cash management is often a pivotal role in the organization. In economically difficult times, controllers may find that they spend a great deal of their time on understanding and managing the organizations' cash position. This is certainly important and, in some areas, can be seen as a staple of the lifeblood of the organization’s ongoing viability. This course takes a look at some of the typical objectives involved in cash management and then evaluates how those objectives can be further stretched into strategic pillars of the organization.  

Peer review deficiencies commonly relate to the design, documentation, and evaluation of the results of analytical procedures.  This course will provide examples of how to strengthen evidence resulting from preliminary, substantive, and final analytics. It will reinforce the elements of strong analytical procedures that may enhance the quality of audits.

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.  *Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Coursw Materials Tab and submit to kori.herrera@acpen.com

AI is already being used in so many ways to aid business organizations in a wide array of ways. However, artificial intelligence is also being used by those seeking to steal or commit fraud to circumvent controls and mislead both people and systems working to keep fraud at bay. The use of AI for ill-intent is pervasive and difficult to detect which makes fighting defalcation attempts an even greater struggle. In this session we will look at some of the methods that are AI-centric which are being used to deceive and defraud. We will then dive deeper and explore ways to identify instances when AI is being used. Finally, we will look at control measures that can aid those working to fight AI driven fraud. If it is evident that artificial intelligence could be used as a weapon to harm you or your organization, you should strongly consider enrolling in 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.

Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take 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.

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.

The budget and the forecast are two common tools used by controllers and CFOs across almost every industry. However, are we really getting the most out of these tools? Or are we merely replicating whatever was done last year? In this course, we will use examples and illustrations to demonstrate various budgeting and forecasting techniques. We will discuss traditional approaches, as well as newer approaches such as flexible budgeting, in an effort to show how companies can gain more value. 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 profiles Brenda, a financial executive from the state of Washington. Despite earning her college degree, Brenda did not find employment in her area of study. Instead, she landed a series of dead-end jobs. Business reversals frequently led to the loss of employment. When a company that she knew to be unethical offered her an executive position that included bookkeeping tasks, including overseeing all finances, she accepted. While on the job, Brenda saw owners of the company misappropriating funds. Rather than reporting the fraud, she created an elaborate scheme to benefit herself - without the owner's knowledge. Her bad decisions led to a guilty plea for wire fraud, after authorities accused her of absconding with more than $600,000 in corporate funds. A prison term of 20 months followed. Listen and learn from Brenda's experience. 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 or your clients are facing that stage of life where careers are passing into the background, and a new "to be determined" life is emerging, then you are entering what is called "retirement". Some people are excited, some are scared, and most are both. There are many issues and questions people face at this time - what to do with time, financial, relationships, health, identity and more. This program summarizes the key research studies, provides stories from those who have made this work, and offers thoughtful, practical exercises from my award winning book NEXT STAGE. It will help you (or your clients) address key issues and develop a Master Plan for the transition. If not now, when? This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Mastering two leadership skills will decrease your stress, and give you room to enjoy your career. Delegating and listening are key essential skills to hone to elevate your career. You were born with two ears and one mouth. And yet, good listeners aren't born. World-class listeners deliberately practice this skill, even when their audience is challenging. This is a skill which can be learned. Participants will gain awareness into their blind spots to listening, strategies to regain focus, how to stop interrupting, and demonstrate to their audience they are listening. How often have you said, "It would just be easier if I did this myself?" or "Nobody can do this task as well as I can, so I'll just do it myself." If this sounds like you, then it's time to start working on your delegation skills. Delegation is not only important as a means to save you time, but it is also about developing the next generation of leaders. 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 the emerging role of CPAs as independent evaluators of artificial intelligence systems. Participants will explore how established accounting competencies-including professional skepticism, assurance, internal controls, risk assessment, and evidence evaluation-can be applied to AI. The course introduces major AI standards and frameworks, common AI failure modes, evaluation techniques, governance considerations, regulatory developments, and opportunities for CPAs to provide credible AI assurance and advisory services. 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 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.