CPE Catalog & Events

Quality management is important.  Every CPA firm that provides audit and other attest services must undergo a third-party quality control review.  This session will provide you with the tips on how to avoid common quality control deficiencies in all services that are subject to peer review.

This 8-credit boot camp is perfect for accountants in public practice or industry who work with nonprofit and governmental entities. The course starts by exploring key financial reporting differences for these organizations, providing a solid foundation for understanding what makes their accounting and auditing unique. Participants will then dive into the essentials of Yellow Book and Uniform Guidance audits, gaining practical insights to confidently navigate these specialized areas. Whether you're new to the nonprofit and governmental arena or seeking a refresher, this course equips you with the knowledge and tools to succeed.  

Learn how to enhance your Excel workflows with AI in this course, "AI-Powered Excel: Leveraging AI and ChatGPT for Supercharged Productivity." Discover the various AI features built into Excel and how to use ChatGPT to create, understand and troubleshoot Excel functions and formulas. Imagine turning two-hour Excel tasks into two minutes of effort! This course will help you streamline your Excel work, research and documentation, saving you time and effort in your day-to-day tasks.

This advanced course is designed to complement the 4-part 706 Preparation Series and will discuss various aspects of the Generation-Skipping Transfer Tax.

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.

Many finance departments spend considerable time managing cash, particularly if the organization is highly leveraged or cash rich.  Many opportunities exist to reduce your financing costs or increase short-term cash returns if you manage cash effectively.  This session will cover a wide variety of day-to-day cash management tools.  

Discover critical insights from the latest Department of Labor studies on employee benefit plan audits and tackle the pressing issue of audit deficiencies head-on. This course dives deep into the most common errors undermining audit quality and explores the underlying causes of these issues. Through practical strategies, engaging case studies, and regulatory guidance, participants will learn how to close gaps in compliance, enhance audit execution, and protect plan participants and beneficiaries. Whether you're an experienced auditor or new to benefit plan audits, this course will equip you with the tools needed to elevate audit quality and ensure regulatory compliance.  

This course is designed for financial professionals looking to understand Form 1120S. It covers the essential aspects of S corporation taxation, including the preparation of Form 1120S, determining taxable income, and accurately reporting and allocating income, deductions, and credits. Participants will also learn how to calculate shareholder basis and understand the strategic advantages and limitations of an S corporation.

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 interviewing to gather accurate information, such as creating and asking open ended questions, effective listening, and understanding verbal and non-verbal communication. Attendees will end the session with takeaways to immediately implement in future HR investigations. Two of three Episodes in the series.

As litigation becomes more complex, attorneys are relying more on accountants to serve as consulting experts or expert witnesses at trial. Serving as an expert witness is not as difficult as you might expect. Accounting experts educate lawyers and jurors on issues such as valuation, tax liability, and forensics. Learn how accountants become expert witnesses, the role they play during pre-litigation through to trial, and the techniques experts employ to avoid challenges from opposing counsel.

In order not to perform an excessive number of audit procedures (over audit) auditors must perform procedures in order to determine in what areas are there weak internal controls that could result in a risk that the financial statements would be materially misstated and not be detected.  SAS No. 122, AU 300 – 499, Measuring Audit Risk provides guidance as well as required procedures that must be performed in every audit in order to determine the risk of material misstatement.  No longer can the auditor state that they assess the risk of material misstatement at maximum without having a basis for making such assessment.  As a result, the standards now require that the auditor make such an assessment of a material misstatement of the financial statement on every audit in order to have a basis for such assessment.  This program is an overview of the statement documentation requirements in assessing such a risk.

Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. 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 equips practitioners with the knowledge to help clients navigate complex tax and financial challenges. Covering a range of difficult situations—such as divorce, bankruptcy, and other personal and business matters—this course provides key tax insights and strategic planning considerations. Participants will gain practical strategies to support clients in making informed decisions while understanding the tax implications of these situations.

Properly designed and effectively operating internal control over financial reporting is critical for preventing, or detecting and correcting, material misstatement. This course describes how to satisfy the audit requirements related to taking a control reliance strategy by testing the operating effectiveness of internal controls, while promoting an effective and efficient financial statement audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Tax credit and incentive programs offer significant but rarely utilized savings. This presentation will introduce the most important federal and California tax credits and incentives available to business taxpayers. Attendees will hear an overview of these benefits and learn how to identify these opportunities for their clients.

PowerPoint is a widely available resource that is potentially underutilized by accountants because many accountants do not stray beyond Excel and Word in the Microsoft Office suite. You will learn how to create and edit a professional PowerPoint slide deck. This session places particular emphasis on efficiency tips and tricks that will allow you to develop creative, professional visual aids while minimizing time and effort. The course’s author will share personal insights he has cultivated throughout more than two decades of public speaking. Although the session will focus on creating and editing slides, we will illustrate best practices for presentation delivery. We will also explain how PowerPoint can be used for purposes other than delivering presentations.

This course explores the latest tax provisions impacting non-profit entities, including charities, hospitals, and universities, with a focus on common issues CPAs may face when completing their clients Form 990. *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

Power BI - Bringing It All Together for Data Analysis is an advanced-level course designed for professionals looking to integrate and optimize their use of Microsoft Power Pivot and Power BI. Building on the foundational knowledge from previous courses, this session focuses on the crucial next steps after creating data models and measures, guiding participants on how to fully utilize the potential of these tools to uncover insights and create impactful, actionable visualizations. This course takes a deep dive into the critical aspects of using Power BI to its fullest potential, emphasizing a holistic approach to data analytics. You'll learn how to build a streamlined workflow, ensuring every step in your data journey contributes to actionable insights. The course also focuses on optimizing performance for data models, utilizing advanced features of Power BI Services, and moving beyond basic data models to create advanced solutions tailored to real-world business needs. By the end of the course, you'll be able to synthesize all your Power BI skills to design and deliver powerful analytics solutions tailored to any audience. Whether you're presenting to stakeholders, sharing insights across teams, or managing enterprise-level reporting, this course will equip you with the tools and strategies to succeed. Perfect for Power BI users looking to tie all the pieces together into a comprehensive, efficient workflow. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Answering clients' tax questions accurately and on time is a key challenge for tax practitioners. Through simple, plain language explanations and examples, this course will help practitioners perform tax research more efficiently by describing the structure of the primary sources, highlighting the differences between primary and secondary sources, and detailing the steps in the tax research process.

In May 2023, the IIA released a draft of the new Global Internal Audit Standards. The intent was to provide more effective standards for Internal Audit globally. 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