CPE Catalog & Events

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.

Workpapers are the primary support for findings, conclusions and opinions on any audit or other attest engagement.  This course will provide the essential tips and techniques for ensuring workpaper documentation is of a high quality, yet efficient, nature.

LLCs and partnerships continue to present some of the greatest challenges for return preparers and advisors. This program addresses the latest developments affecting these entities, including new IRS audit initiatives, updates on self-employment tax for LLCs and partnerships, disregarded entity rules and transactions, and common allocation issues. Participants will also review how to properly identify various types of partnership debt for basis purposes, understand the use of the §754 election in the sale of interests and at death, and explore reporting requirements for LLC and partnership interests on gift and estate tax returns, including valuation considerations for closely held businesses and minority interests. The session also examines the impact of the recent Sirius Solutions decision.  Join us for the course! And as with all ACPEN courses, your questions to the panelists are encouraged. 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    

This course focuses on the most common aspects and tax implications of Limited Liability Companies and S Corporations. It will further compare forms of entities, along with corporate formalities compliance issues of each entity type. Electing Subchapter S status as well as reviewing the mechanics of electing Subchapter S status will be discussed. Highlights of entity specific tax forms will be discussed, as well as accountable plans, taxable fringe benefits, officer reasonable compensation, estate planning, business continuation planning and audit strategies. Schedules K-1, K-2, K-3, and effectively connected income will be reviewed in this course as well. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical, and technical requirements.

This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Award winning discussion leader Mark Hugh discusses how to create and capture value with consulting services. Whether you want to consult a little or full time, this valuable course reviews identifying a specialty, growing a practice, capturing value, creating deliverables, and effective marketplace marketing strategies.  

Effective governance is the cornerstone of any nonprofit organization. This course delves into the foundational elements of nonprofit governance, emphasizing fiduciary duties, board responsibilities, and best practices for board operations. Participants will explore key compliance requirements, risk management strategies, policy development, and regulatory obligations. By the end of the session, you'll be equipped with practical tools and insights to confidently navigate the complexities of nonprofit governance.

This course provides a comprehensive introduction to the business valuation process, beginning with key terminology, professional standards, and the rules that guide the appraisal profession. Participants will explore the three primary approaches to value—Asset, Income, and Market—before focusing in depth on the Asset Approach. The course examines when and why this method is used, its advantages and limitations, and how to apply it effectively in real-world scenarios. Through practical examples and clear explanations of each of the three methods within the Asset Approach, learners will gain both the confidence and competence to apply valuation principles in their professional practice.

Drawing on fresh data from Blue J and CPA.com’s "2026 AI Tax Research Solution Outlook Report," this session explores how accounting firms are shifting from trying AI to relying on it, and what this means for the future of the profession. From deepening client relationships to placing a greater emphasis on practitioner judgment, AI adopters are prioritizing human experiences and the uniquely human skills AI can’t replace. Hear what these changes mean for your firm, and gain practical strategies to make the most of your own AI transformation. Speaker  Ankit Dhawan, Partnerships Manager, Blue J Ankit Dhawan is a Partnerships Manager at Blue J, where he leads strategic relationships with national tax associations, accounting networks, and technology partners to expand the reach and impact of Blue J’s AI-powered tax research platform.  

Now more than ever, navigating loss, grief and crisis in the workplace is a skillset that leaders must possess. Keeping the heart in human resources is so important, especially in this post-pandemic state we are living in. We will explore ways that you can show empathy to your employees while also balancing your business needs. 

This course provides a high-level overview and introduction into the world of the forensic accountant. Most accountants have an understanding of the concept of fraud and how it impacts companies, but many individuals do not have a full comprehension of the variance in the work performed by a forensic accountant versus a typical management accountant.   This course is meant for those individuals interested in understanding the variances in the job tasks and responsibilities of forensic accountants versus typical financial or management accountants. Forensic accountants or auditors take a unique focus on performing their work.  Typically, when a person with forensic experience is called in to examine financial records, it is due to suspicion of fraud, evaluation of assets, or even to track down fundamentally incorrect accounting – intentional or not. As fraud continues to raise its head in business processes, forensic accountants are discovering new and unique ways to identify, examine, and support their hypotheses and investigative techniques.  The work performed by a forensic specialist can be interesting and full of potential potholes if evidence isn’t examined according to proper protocols and standards.  

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.   

As accounting software evolves, AI-native systems are transforming how firms manage data and measure results. This session explores emerging AI-integrated general ledger platforms such as Digits, Puzzle.io, and Docyt. It examines how new technologies, like vibe coding and low-code/no-code automation, are reshaping efficiency and improving fraud detection. Attendees will learn to assess ROI across accounting tools, identify key performance metrics, and develop an automation strategy that enhances accuracy, productivity, and profitability. This course equips professionals to make smarter technology investments and prepare for the next wave of AI-driven accounting transformation.

This session dives into real-world cases of financial fraud, cybercrime, and ethics breaches that captivated the business and accounting world. This session analyzes how these crimes unfolded, the warning signs that were missed, and the internal control and technology failures that enabled them. Participants will explore modern threats, including AI-enabled deception, and learn practical steps to strengthen fraud prevention, data protection, and governance. From shocking embezzlements to headline-making cyberattacks, this course turns true stories into powerful lessons for today's accounting and finance professionals.

This course explores the transformative role of artificial intelligence (AI) in accounting and auditing, highlighting its vast potential while addressing the associated risks and ethical considerations. Participants will discover how to harness AI tools to enhance efficiency and innovation, while mitigating challenges such as overreliance, data security vulnerabilities, and ethical dilemmas. Through case studies and interactive discussions, you'll gain practical skills to navigate AI complexities, ensure trustworthy outputs, and uphold ethical standards in today's fast-paced digital environment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Transfer taxes, such as the estate, gift, and generation-skipping transfer tax, create a drag on the accumulation of wealth over a family's generations. However, with the One Big Beautiful Bill's continuation of the high gift and estate tax exclusion amounts for the foreseeable future, advisers have the opportunity to create trusts that extend through the grandchildren's generation. This course examines the generation-skipping transfer (GST) tax and how it is designed to discourage avoidance of the estate and gift tax by families. Randy Gardner explores: GST tax terminology, how the GST tax is calculated, ways to avoid the GST tax, and how to design a dynasty trust to pass property from generation to generation. 

This course is designed for the accounting and auditing professional who provides attestation services to closely held businesses. The course reviews recent standard-setting activities of the Financial Accounting Standards Board (FASB) and the AICPA, specifically focusing on those standards having the most significant impact on closely held non-public business entities. The course also discusses adopting the latest audit standards, including the new audit risk assessment requirements.

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.

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.