WICPA CPE & Special Event Catalog
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.
Will Your Ethics Be Burned by Burnout?
-
Online
2.00 Credits
Member Price: $89
Ethical behavior is not a destination it is a journey with twists, turns and bumps in the road. We are faced with ethical dilemmas every day. Do I speed to make it to a meeting? Do I call in sick because I need a break? When does "helping my child with their homework" become "doing it for them"? CPAs are ethical most of the time, but staying ethical is hard. It gets harder when we are under stress. 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.
Global Internal Audit Standards (GIAS) Domain IV: Part I
-
Online
2.40 Credits
Member Price: $99
The new Global Internal Audit Standards were released on January 9, 2024 & 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 & elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation & examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics & Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service
2026/27 Annual Update for Accountants & Auditors
-
Online
4.00 Credits
Member Price: $149
This comprehensive annual update brings together key accounting and auditing developments affecting accountants and auditors across industries. The course combines recent standard-setting activity issued by the Financial Accounting Standards Board with major audit and attestation updates from the AICPA, providing a well-rounded view of changes impacting financial reporting and engagement performance. Participants will begin with an overview of recently issued and upcoming Accounting Standards Updates (ASUs), including standards effective for December 31, 2026 year-ends for public companies, private entities and not-for-profit organizations. The course also highlights issued ASUs with future effective dates and provides high-level insight into recent exposure drafts to support implementation planning. The course then shifts to auditing and attestation developments, including the next phase of quality management with a focus on monitoring and remediation requirements. Participants will also review recent and proposed standards affecting audit, attestation and consulting engagements, including SSAE No. 24, SSARS No. 26, exposure drafts related to confirmations and fraud and SAS No. 149 addressing group audits. Designed for preparers, auditors and firm professionals, this course helps participants understand how recent accounting and auditing changes intersect-and what to watch for as standards and expectations continue to evolve. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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
A&A Update for Nonprofits & Single Audit: 2026
-
Online
8.00 Credits
Member Price: $239
This course provides a high-level overview of the most important accounting, financial reporting, compliance and audit issues facing nonprofit entities and their accountants. The focus is on explaining the basis behind major issues and trends in executive summary (yet practical) form, enabling professionals to understand the most important aspects of relevant standards and the basis for any potential changes on the horizon. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
AI & Accounting in Construction
-
Online
2.00 Credits
Member Price: $89
This course provides a concise overview of how artificial intelligence (AI) is revolutionizing the construction industry and reshaping financial oversight, accounting practices and regulatory compliance. From autonomous equipment to predictive risk analytics, construction firms are increasingly adopting AI to enhance safety, efficiency and profitability. As this transformation unfolds, accountants and financial professionals must evolve their roles-leveraging AI for smarter budgeting, automated compliance and real-time auditing. The course highlights the top 20 macro-level AI trends in construction and explores how accounting professionals can align financial systems with operational AI, uphold audit integrity and prepare for emerging tax and compliance challenges. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Written Information Security Plans
-
Online
1.00 Credits
Member Price: $55
This course provides a comprehensive overview of Written Information Security Plans (WISP), focusing on their purpose, requirements and implementation. All PTIN holders must certify they have a WISP prior to renewal, along with certifying the training of employees, staff and contractors as necessary. Participants will explore the history and legal foundation of WISP under the Gramm-Leach-Bliley Act and how compliances is enforced through IRS Circular 230, AICPA Statements of Standards, The American Bar Associations and the Federal Trade Commission (FTC). This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethical Tax Practice Strategies in a Crisis World
-
Online
2.00 Credits
Member Price: $89
This program addresses the many issues impacting CPA practice with a world in crisis. The unique challenges facing practitioners are related through actual practice situations: & then analyzed for their ethical implications. Based on real life experiences. This course does not qualify for IRS credit.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Accounting Update in a Post COVID-19 World
-
Online
2.00 Credits
Member Price: $89
The COVID-19 pandemic has altered corporate & public accounting in ways we could never have imagined. This broad-based course will discuss accounting & auditing implications that have arisen as a result of the pandemic.
Fraud Busters: Controls to Prevent & Detect Fraud
-
Online
2.00 Credits
Member Price: $89
This course investigates actual real-world fraud schemes and discusses what controls could have prevented the fraud from occurring and what controls could detect and curtail the fraud scheme. The instructor speaks from experience, finding multiple frauds very early in her career leading to a career-long focus on fraud prevention and detection. 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 How to Effectively Represent Clients Under IRS Audit
-
Online
2.00 Credits
Member Price: $99
Increased funding resulting from the enactment of the Inflation Reduction Act will allow the IRS to target many more wealthy individuals and large businesses for audit. These efforts will become more intense over the next several years as the IRS employs artificial intelligence in more of its audits. This program discusses how and when the IRS's energized audit efforts will result in more audits of taxpayers and what attendees need to know to effectively represent clients that the IRS audits.
Taxation of Judgements & Settlements
-
Online
2.40 Credits
Member Price: $99
In the course of legal actions, payments may be made pursuant to a final disposition of a court case or a mutually agreed-upon settlement. This course will cover the tax implications for payments made for personal injury, emotional distress, lost wages, punitive awards, pre- & post-judgement interest, contract claims, among other damages. 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.com.
Accounting & Auditing Update 26-27
-
Online
4.00 Credits
Member Price: $175
This annual update covers activities of the FASB and Private Company Council (PCC) and reviews new SAS and SSARS. Stay current on new standards related to financial accounting and attest and assurance services including compilations, review and auditing. You'll learn the specific requirements of the standards and their potential impact on financial statements and we will review the pipeline of proposed standards. This years' update will cover induced conversions of convertible debt, stock compensation accounting and disclosure, income tax disclosures, crypto currency accounting, joint venture accounting and updates to the accounting for government grants. We will cover new audit standards including group audit standards and new fraud, evidence and materiality standards. We'll do a deep dive into SAS 145 and the new quality management standards. Note: SEC reporting requirements and public company audit requirements will not be covered.
Not-For-Profit Organizations: Financial Overview 26-27
-
Online
4.00 Credits
Member Price: $175
Not-for-profit organizations always need volunteers as treasurers or members of the financial oversight committee! CPAs are often asked to fulfill these roles. This course highlights the financial accounting needs of such organizations. Along with covering the status of the not-for-profit organizations, an update on recent ASC updates affecting nonprofit entities is covered. This course is geared toward hands-on, or future hands-on, treasurers of service clubs and similar not-for-profit organizations.
Federal Tax Update: Individual Form 1040 26-27
-
Online
8.00 Credits
Member Price: $329
This course is a comprehensive overview of critical Federal tax law updates resulting from changes to current laws, regulations and court cases impacting individual taxation. We will also review recent modifications to tax forms, small business tax law and administrative updates, retirement plan changes and tax practice and procedures.
Advanced Excel for Staff: Build Reports & Analyze Data
-
Online
2.00 Credits
Member Price: $89
Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize and structure data, apply calculations to derive key metrics and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Numbers to Narrative: Storytelling in Business Communication
-
Online
1.00 Credits
Member Price: $55
Information becomes influential when it is structured. In this 1-CPE session (Professional Development), participants explore narrative frameworks presented in the course materials, including situation-complication-resolution and hero-based narrative arcs. Using business-oriented examples, the session demonstrates how structured storytelling enhances clarity and impact without sacrificing rigor. Participants will examine how to define context, introduce tension, present evidence and guide audiences toward resolution. The emphasis is on logical flow and disciplined narrative construction rather than dramatization. The course concludes with application of a structured storytelling model to a professional scenario. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Risk Wrangling: Surviving the Modern Business Rodeo
-
Online
2.00 Credits
Member Price: $89
Risk-based factors are becoming exponentially important considerations for accountants in both public practice & industry. We examine the nature of risks for today's enterprises while exploring the role of internal controls for mitigating business risks. We also explore SAS 145 & other guidance aimed at risk considerations for professional engagements. Public & private accountants will enhance their capabilities for assessing & addressing risks faced by today's organizations.
Global Internal Audit Standards (GIAS) Domain IV: Part II
-
Online
2.00 Credits
Member Price: $89
The new Global Internal Audit Standards were released on January 9, 2024 & 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 & elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation & examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics & Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service
