CPE Catalog & Events

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.

Owners of S corporations and partnerships are subject to numerous limitations on pass-through losses, each with unique rules, applications, and complexities. With the increase in popularity of pass-through business entities, it is essential for CPAs to understand the complexities and interactions of these pass-through loss limitations.

The IRS began replenishing its workforce with the additional funding only to have to terminate workers or lay them off due to mandated federal workforce reductions. The IRS trains its audit workforce by examining the tax returns of individuals and small businesses. As the IRS continues to examine tax returns, Accounting, Tax, and Financial Professionals need clients to understand the need for documentation and procedures to substantiate what IRS examiners are pursuing. Learn the high audit risk areas and ways to help clients survive an IRS audit with little or no change. It is critical for Accounting, Tax, and Financial Professionals in public accounting to understand the risk to clients and to themselves in tax return preparation and planning since the IRS continues to increase its audit coverage and is examining more taxpayers than it has in the recent past.

If you work with governments or not-for-profits, mastering the fundamentals of Yellow Book and single audits is essential. This beginner-friendly course breaks down the key requirements of the Yellow Book and the Uniform Guidance for Federal Awards into clear, manageable concepts. You'll learn the essentials of performing Yellow Book and single audits with confidence—building a strong foundation, boosting your understanding, and equipping you to conduct audits efficiently and effectively.

Just about every company, no matter its size or the types of activities it undertakes, is at greater risk because of all the types of fraud that can be be carried out electronically. Potential perpetrators can be operating internally or externally and the scope of the damage that occurs is almost never limited to cyber-assets. While threat awareness is improving, there are still too many owners or top level executives that underestimate the scale of the issue. In this session, we delve into the types and the nature of many electronic defalcation schemes. The material then explores measures that organizations can implement to help stop these activities and add additional layers of security. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The workplace is shifting rapidly, and HR professionals are at the center of it all. The next four years will challenge us to embrace courageous leadership, strategic vision, and continuous learning. Here's the reality: " We're stressed, overworked, and often under-resourced. " The job market for HR professionals is more competitive than ever. " Aligning with organizations that share our values is non-negotiable. " Agility and the ability to lead change are critical. We cannot solely depend on our employers to rise to the occasion.  This is our moment to rise.  Join our Founder & CEO Anthony P. Howard on how we can empower ourselves and each other in 2025. Together, we can lead the future of HR. How are you stepping into courageous leadership this year? Bring the discussion to the event!

Creating a culture of safety in a workplace requires attention in many different areas.  We will bring these areas into focus and provide attendees with information on how to make their individual workplaces safer for everyone. 

This session describes a state agency's quality review of a not-for-profit organization's A-133 Single Audit.  The case study describes the organization audited, its federally- and state-funded programs, and the CPA firm retained to do the audit.  Various anomalies in the financial statements alerted state officials to potential problems, and a detailed quality review followed.  Find out how the entity turned hundreds of thousands of dollars in bank overdrafts into hundreds of thousands of dollars of cash on its balance sheet.  Explore other “creative” ways to deal with fixed assets, accounts receivable, and related-party transactions.  Were the auditors just sloppy, ignorant, negligent?  Or were they active participants in producing fraudulent financial statements?  You be the judge.

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.

Strong analytical procedures are critical for evaluating the fair presentation of financial statements. In addition, Financial statements are only as good as the information and trends that they produce for operational, strategic, or compliance purposes. This course will provide insights into how to determine the strength and efficiency of nonprofits in achieving objectives and knowledge to improve the analysis of the fair presentation of a nonprofit's financial statements.  

Following the ever-changing tax deprecation rules is not a game for the faint hearted! This course analyzes the current landscape of depreciating, capitalizing and disposing of business assets, with examples and illustrated case studies to enhance the CPAs understanding of the most current tax depreciation provisions. *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

Understanding the dynamics of family interaction is one of the most important skills in helping a family business succeed. This course takes a candid look inside the family business, and will help the participant navigate delicate issues while learning to provide counsel that will grow - or protect - the family business and non-family staff.

Since 1919, the Internal Revenue Service had a civil and criminal function in the United States tax system. Little do people know, the IRS has an elite criminal function that started with five United States Postal Inspectors. From its early days in taking down Al Capone to now solving cybercrimes, the IRS special agents are tasked with investigating tax fraud, money laundering, and other white collar crimes. This presentation will show you the importance of this law enforcement function, the training, techniques, expertise, and actions that cause them to be known as the "world's finest financial investigators." This presentation has been prepared by a 20 year veteran with the IRS-Criminal Investigation. The presenter investigated crimes, and trained and mentored other special agents. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The AICPA Town Hall Series delivers: Timely & Critical Information Interpretation & Analysis Firm and Business Strategies Practitioner Capabilities **Free for AICPA members Not an AICPA or CIMA member? Become one today.

Data security and privacy issues persist as a significant concern for businesses of all sizes. No matter where you look, the numbers are bad - really bad! But that doesn't mean you can't take steps to reduce these risks. In this session, you will learn about the key security and privacy risks facing businesses today and the steps you can take to mitigate these risks. This session begins with a review of how cybercriminals target businesses of all sizes and the associated costs of these attacks. From there, you will progress to discussions of practical tools, policies, and other solutions that can be used to mitigate cybersecurity risks to prudently acceptable levels. This is a "must-see" session for all concerned about data security and how to mitigate threats to sensitive and confidential data.

AU-C Section 315 requires the auditor to gain an understanding of the entity and its environment and the entity's internal controls in order to design appropriate audit procedures. This course will review the key requirements of COSO which is one of the most widely used internal control frameworks. We'll also review the limitations of internal controls. Additionally, this course will introduce the risk assessment process and the various audit procedures to evaluate controls and to determine whether to test the operating effectiveness of controls. 

This course will allow you to get reacquainted with the statement of cash flows. We will refresher your skills regarding both the preparation and utilization of the statement of cash flows. Significant emphasis will be placed on the informational role of the statement of cash flows and insights that can be obtained using the statement of cash flows in concert with the other elements of a company’s accrual-basis financial statements.

Gift taxation is a critical component of estate planning, and Form 709 serves as the key reporting tool. This course provides a comprehensive line-by-line guide to preparing Form 709, ensuring accuracy and compliance. Participants will learn how to determine taxable gifts, apply exclusions, and utilize available deductions. Special attention will be given to valuation techniques, gift-splitting, and generation-skipping transfer tax (GSTT) considerations. Additionally, this course will examine any new legislative changes from the current administration and how they may impact gift tax planning and 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 Course Materials Tab and submit to kori.herrera@acpen.com

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.

SQMS No. 2, Engagement Quality Reviews, sets out requirements and guidance for firms to conduct an engagement quality (EQ) review. The standard also addresses the qualifications, eligibility, responsibilities, and appointment of an EQ reviewer. The predecessor standard, SQCS No. 8, combined quality control policies with the engagement quality control review. SQMS No. 2 was issued separately to highlight the importance of the EQ review within a firm's system of quality management. SQMS No. 2 formalizes and strengthens the review process through clarified guidance and enhanced documentation requirements. It also distinguishes the responsibilities of the firm from those of the EQR reviewer, ensuring greater accountability and transparency.