WICPA CPE & Special Event Catalog
Yellow Book Independence & Single Audit Fundamentals
-
Online
4.00 Credits
Member Price: $149
This CPE course explains Yellow Book independence including the general requirements, requirements for auditors providing non-audit services and documentation requirements. This course also explains the basic elements of a Uniform Guidance compliance audit, including an overview of requirements, major program determination with examples, an understanding of compliance requirements and related internal control over compliance, sampling and single audit reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Financial & Tax Accounting for S Corporations & Partnerships
-
Online
8.00 Credits
Member Price: $239
This program compares and contrasts the financial and tax accounting differences of partnerships, LLCs and S corporations, as well as discuss the tax accounting for these entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Unlock the Power of AI with Copilot in Excel
-
Online
2.00 Credits
Member Price: $89
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.
Upholding Independence While Holding Your Client's Hand
-
Online
2.00 Credits
Member Price: $89
Many entities look to their CPA as a trusted advisor when tackling complex accounting topics. This is more relevant now than ever. The FASB's big three accounting pronouncements involving revenue recognition, leasing & credit losses have placed a magnifying glass on this reality. Practitioners need to exercise caution to ensure they maintain independence as they assist their review & audit clients with such matters, as well as with compilation engagements. This course addresses these issues & explores best practices & guidance provided by the AICPA's Code of Professional Conduct.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Excel for Accounting Professionals Session III: Workbook Design Principles & Organization
-
Online
2.00 Credits
Member Price: $89
Enhancing Excel workbook productivity. This workshop covers organizing and managing worksheet information, offering hands-on participation alongside the instructor. Through the practical tasks, you will gain a comprehensive grasp of commonly utilized Excel functions such as: Hiding worksheets Inputting cells styles for users Organizing workbooks Mastering Excel capabilities Becoming proficient in Excel entails developing workbooks that are efficient and well-organized. The facilitator will guide you through mastering complex functions, selecting cells and objects and organizing principles of workbook design. You'll enhance your basic understanding of Excel with topics including: Creating complex formulas with nested functions Applying techniques for group selection
Self-Rental Real Estate: Passive Activity & Section 199A
-
Online
2.00 Credits
Member Price: $89
This program presents a detailed analysis of the self-rental passive activity rules, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Accounting & Tax Ethics: Standards, Issues, & Case Studies 26-27
-
Online
4.00 Credits
Member Price: $175
In recent history, even the most prestigious CPA firms have had ethical lapses and oversights that have cost them both financially and, at that moment, clouded their brand. This course will review the AICPA code of ethics for both accounting and tax practitioners and encourage you to examine your firm's policies and choices relative to those standards and common sense through thought-provoking and sometimes humorous Q&A and case studies. Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Audits Under Uniform Guidance --Single Audit & NPOs 26-27
-
Online
4.00 Credits
Member Price: $175
Audits conducted under the Uniform Guidance for Federal Awards continue to be among the most challenging audit engagements as the number of federally funded programs for not-for-profit organizations continues to increase. This course will provide you with what you need to know to prepare for Single Audits conducted during 2026, including performing the compliance audit and auditor reporting responsibilities.
Preparation, Compilation & Review Services 26-27
-
Online
4.00 Credits
Member Price: $175
SSARS 21 significantly changed the way CPA services are being offered. There is still confusion about CPA responsibilities and procedures. The course will discuss differences between bookkeeping, preparation and compilation engagements and how they differ. It will also discuss financial statement frameworks and how they influence the engagement as well as analytical procedures in review engagements.
Dashboard & Report Design Principles Using Excel
-
Online
4.00 Credits
Member Price: $149
Transform your data presentation skills with our comprehensive course on creating impactful dashboards & reports using Excel. This workshop is tailored for professionals who: Regularly produce or update dashboards & reports Struggle with confusing or overly complex reporting tools Seek to streamline varied reporting styles across their organization Aim to establish a consistent, replicable "house style" for reporting Want to impress stakeholders with clear, user-friendly data presentations Through a combination of theory & hands-on practice, you'll learn the fundamental principles that make reports & dashboards easy to understand. We'll distill these concepts into a set of practical rules & guide you through their application in Excel.
Shorten Month-End: Closing Best Practices
-
Online
4.00 Credits
Member Price: $149
Surveys show that the average North American company completes its monthly financial statement closing in six (6) days. However, some companies can close their books in one day or less. You don't have to sacrifice accuracy for speed. This session will show you how to close month-end faster, better & cheaper. Yes, to all three.
Optimize Your Staff's Performance
-
Online
4.00 Credits
Member Price: $149
A chain is only as strong as its weakest link. The same theory applies to departmental performance-- the overall result is only as strong as its weakest contributor. Leave our interactive & entertaining session with insight for developing & sustaining the best team you can possibly assemble. The four elements in this process are (1) development, (2) leadership, (3) hiring & (4) environment. Discuss how to effectively use these elements in your creation of an outstanding organization. Discover the power of the 10 Attributes for Leadership Success & the negative impact of Leadership's Fatal 13. Above all, learn how to combine these four elements as a successful catalyst for sustained high-quality output & results.
Preparation, Compilations & Reviews--A Practical Workshop 26-27
-
Online
8.00 Credits
Member Price: $329
Participants will go over the changes on preparation, compilation and review engagements using SSARS rules, followed by a general overview of how to perform these services. This interactive workshop is designed for practitioners in small and medium-sized CPA firms and will include a lecture with generous time for questions and case studies.
Hands-On Tax Return Workshop: Partnerships & LLCs (Form 1065)
-
Online
8.00 Credits
Member Price: $300
This case-driven training is designed to get the inexperienced accountant up to speed quickly in the most common areas of partnership, limited liability company (LLC) & limited liability partnership (LLP) taxation. A cornerstone of this course is the preparation of the Form 1065 using a fairly complex trial balance common to most partnership, LLP & LLC income tax returns. 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 & submit to terri.storer@acpen.com
Overcoming Tech Adoption Challenges in CPA Firms
-
Online
1.00 Credits
Member Price: $55
The accounting profession stands at a critical inflection point where artificial intelligence and emerging technologies are reshaping how firms operate, serve clients and compete in the marketplace. This course, based on the 2025 CPA Firm Tech Report, provides expert guidance on overcoming the five key challenges that prevent firms from successfully adopting transformative technologies: decision paralysis from overwhelming choices, leadership resistance to change, difficulty proving ROI, growing cybersecurity risks and critical skills gaps. Through real-world case studies and insights from industry leaders, participants will learn practical strategies for evaluating AI solutions, implementing change management frameworks and building a technology-forward culture that enhances both efficiency and client value. Participants will explore the CPA Firm Digital Maturity Model to assess their firm's readiness for transformation, examine the evolving AI ecosystem specifically designed for accounting applications and discover how leading firms are leveraging AI to move beyond traditional compliance work toward high-value advisory services. The course addresses critical considerations for firms of all sizes, from solo practitioners to large regional firms, providing actionable frameworks for prioritizing technology investments, measuring success beyond traditional ROI metrics and developing the hybrid talent needed to thrive in an AI-enhanced future. Whether you're a firm leader hesitant about technology adoption or a forward-thinking professional ready to champion change, this course equips you with the knowledge and tools needed to navigate the technology revolution transforming the accounting profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Financial Decisions that Led Two Businessmen to Prison
-
Online
2.00 Credits
Member Price: $89
Two college graduates built impressive careers: One worked in sales, the other in technology and investing. Both of those people made decisions in the course of their business that led to government investigations. They had to hire attorneys, go through judicial processes, face charges and plead guilty. Each of those people are on their way to prison. Learn from the lessons they offer. We interview both financial professionals and they tell us more about how their decisions influenced the consequences that followed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Viewing A&A Through the Eyes of a Tax Practitioner
-
Online
2.00 Credits
Member Price: $89
This session offers insight for tax practitioners beyond merely checking a box to satisfy accounting & auditing requirements for license renewal. We devote significant attention to extracting utility From financial statements to support decision needs of both external financial statement users & internal stakeholders. We explore best practices for cross-functional support within firms that perform tax, accounting solutions, financial statement & consulting services. We also highlight similarities & differences between U.S. GAAP & tax-basis accounting.
Tax Practice Standards
-
Online
2.00 Credits
Member Price: $89
Please join us for a comprehensive discussion on standards that professionals must adhere to as tax practitioners. We will be covering the major governing rules, such as Treasury Circular 230, the AICPA Statements on Standards for Tax Services (SSTS), the Internal Revenue Code (IRC) & common law. Also included will be case studies illustrating dilemmas faced by tax practitioners. 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 & submit to kori.herrera@acpen.comNote: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Accounting & Attestation for ESG
-
Online
2.00 Credits
Member Price: $89
Environmental, Social and Governance (ESG) reporting has become an increasingly important area of focus for standard setters, regulators and stakeholders. This course provides an overview of how ESG considerations intersect with accounting and attestation services, with attention to developments affecting both preparers and assurance providers. Participants will review current ESG-related initiatives and projects underway at the Financial Accounting Standards Board, Governmental Accounting Standards Board and the AICPA. The course also explores the types of services CPAs may provide in connection with ESG reporting, including advisory and attestation engagements and discusses how these engagements differ in scope and responsibility. Designed for CPAs seeking to understand the evolving ESG landscape, this course helps participants recognize where ESG fits within existing professional standards and how CPAs can support organizations seeking credibility and assurance over ESG information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Online
2.00 Credits
Member Price: $99
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.
