WICPA CPE & Special Event Catalog
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.
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.
Partnership Preparation, Basis Calculations & Distributions: Form 1065 Schedule K & K-1 Analysis
-
Online
8.00 Credits
Member Price: $300
This comprehensive training is designed to get the accountant up to speed quickly with partnership & limited liability company (LLC) formation & preparation issues as well as a complete understanding of calculating a partner & LLC member's basis. The cornerstone of this course is the in-depth line-by-line analysis of the Form 1065 Schedule K & K-1 & how these items affect the partner/member's individual income tax return. 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
Smarter Tax Services with Artificial Intelligence Tools
-
Online
2.00 Credits
Member Price: $89
There has never been a greater opportunity to leverage technology tools to automate your tax services. This course will provide specific examples of how you can use AI (artificial intelligence) based tools to complement your tax planning, research and compliance services. You will learn how to leverage AI to automate the collection and organization of client data, the engagement management process, tax research and enhance client advisory services with AI too This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The One Big Beautiful Bill: 2025 Tax Legislation
-
Online
4.00 Credits
Member Price: $149
The President signed on July 4, 2025, one of most consequential tax legislation in recent years. The well-informed tax practitioner will want to stay abreast of these developments! This course will start with a short background of this legislation as it made its way through Congress and to the President's desk. We will then review the final provisions that was approved by the Senate and passed by the House. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
