WICPA CPE & Special Event Catalog
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Online
2.00 Credits
Member Price: $99
How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.
Taxation of Judgements & Settlements
-
Online
2.40 Credits
Member Price: $79
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- and 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 and submit to kori.herrera@acpen.com.
Annual Update for Accountants & Auditors 2025
-
Online
6.00 Credits
Member Price: $189
While the pace of FASB's standard-setting has slowed in recent years, the standards that have been issued will be impactful for many organizations. This course will begin with a review of standards effective in 2025 for public, private and nonprofit organizations. From there, we'll explore upcoming standards, FASB exposure drafts and ongoing projects to ensure you're prepared for what's next in financial reporting. The second half of the course will shift focus to developments at the AICPA. From quality management to ethics standards and the talent pipeline, there's no shortage of activity. We'll start with a detailed look at the quality management standards effective this year and their impact on firms, including changes to the Peer Review Program. Next, we'll cover essential ethics standards and the latest SSARS updates. We'll also examine common deficiencies in employee benefit plan (EBP) audits and discuss the initiatives of the National Pipeline Advisory Group.
Beyond the Basics of SSARS & Nonattest Services: Are You Certain You Are in Compliance?
-
Online
8.00 Credits
Member Price: $225
Practitioners that provide non-audit services must strike the right balance between complying with relevant professional and regulatory standards, providing value-added client service and mitigating litigation and other practice management risks. This course contains many case studies to reinforce best practices for managing the accounting, reporting and performance issues associated with the attest services of compilations and reviews where reports are issued, as well as the SSARS preparation of financial statements service and other nonattest engagements.
Finding Errors in Excel Spreadsheets
-
Online
2.00 Credits
Member Price: $89
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.
Accounting & Tax Ethics: Standards, Issues & Case Studies 25-26
-
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. This course fulfills the four-hour ethics education requirement.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
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.
OCBOA Case Studies 25-26
-
Online
8.00 Credits
Member Price: $329
Understanding the advantages and disadvantages of alternatives to Generally Accepted Accounting Principles (GAAP) financial statement presentations is vital to making proper client choices. For example, practitioners may seek to use the Other Comprehensive Basis of Accounting (OCBOA) financial statement presentations, as GAAP will increase complexity and the cost of compliance. Here, we'll explore compliance with the preparation, presentation, disclosure and reporting nuances of cash- and tax-basis financial statements. We'll also discuss the AICPA's Financial Reporting Framework for Small- and Medium-Sized Entities (FRF for SMEs). This course meets the specific OCBOA requirements that CPAs must meet for the re-issuance of their license.
Workforce Transformation & Talent Management in 2025
-
Online
1.00 Credits
Member Price: $55
The accounting profession faces unprecedented workforce challenges that demand a fundamental rethinking of traditional firm structures. This course examines why the century-old pyramid practice model is becoming obsolete and presents the inverted pentagon framework as a sustainable alternative. Based on comprehensive research showing that 52% of firms expect to shrink by 20% or more in the next five years, participants will learn how to restructure their firms to thrive with fewer entry-level staff while expanding specialized expertise. The course explores the "6 Ps of Business Model Transformation" - Precision Hiring, Proactive Retention, Practical Technology Implementation, Pricing Expertise, Practice Area Expansion/Focus, and People Acceleration. Drawing from success stories in manufacturing, healthcare, and technology industries, attendees will discover proven strategies for accelerating staff development, implementing effective knowledge transfer programs, and building sustainable talent pipelines in an era of technological disruption and demographic shifts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Five Amazing Business Books in 100 Minutes
-
Online
2.00 Credits
Member Price: $79
If you are efficient and want to learn lessons from the best in a short time, this seminar is for you. Popular speaker Don Minges will review the key lessons from five fantastic business books that will help you become more effective. The topics are; leadership, how to create a valuable business, how to turnaround a business, how to make terrific presentations and how do humans think? These lessons are valuable for every business leader.
Monthly Federal Tax Updates: April 2026
-
Online
2.00 Credits
Member Price: $89
Seismic changes in tax legislation is currently taking place and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
S Corporation Checkup: Tax Issues & Forms Reporting
-
Online
4.00 Credits
Member Price: $129
A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination, as well as an update on Schedules K-2 and K-3. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. *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
Fraud, Controls & Ethics: Best Practices & Case Studies
-
Online
4.00 Credits
Member Price: $149
This course explores actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters from achieving their nefarious acts. Then we will switch gears to an interactive, case-based discussion that asks participants to reach their own conclusions by analyzing facts in concert with the AICPA Code of Professional Conduct and other sources of ethical guidance. This course ultimately provides practical, action-oriented insight that can be implemented by accounting professionals in both public practice and industry. This event may be a rebroadcast of a live event and the instructor will be available for questions during the event.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
K2's Excel PivotTables For Accountants 25-26
-
Online
8.00 Credits
Member Price: $329
Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge of PivotTables, then plan to participate in this course. You will learn how to build PivotTables, group data inside PivotTables, including grouping options for fiscal periods, and create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques, including building PivotTables that consolidate data from multiple data ranges and PivotTables that connect dynamically to external databases and financial accounting systems. Additionally, you will learn to take advantage of other Excel features associated with PivotTables, including Slicers, Power Query, and Power Pivot. You will be a master of Excel PivotTables at the end of the day! This course is for you if you have been leery of working with PivotTables or have struggled to realize their many benefits. With some information, guidance, and coaching from your K2 instructor, you will be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.
The Ethics of Care in the Workplace
-
Online
2.00 Credits
Member Price: $89
Ethics involve relationship to self, others and the world in which we live. In the busyness of our world we often act out of habit without realizing that what we do truly matters. We matter! This session explores ethical values and principles as they apply to creating an Ethic of Care in the workplace with specific emphasis on compassion, accountability and respect. 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.
Cryptocurrency Transactions: Navigating Federal Tax Rules
-
Online
1.00 Credits
Member Price: $29
As cryptocurrencies like Bitcoin, Ethereum and others become more popular, tax authorities around the world are working to create regulations for their use and transactions. This session will address cryptocurrency tax issues and their complexities and challenges that individuals and businesses face when dealing with the taxation of digital currencies. *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
Fiduciary Accounting: Fundamentals & Rules
-
Online
2.00 Credits
Member Price: $79
This course will dive into the fundamentals of fiduciary accounting and provide a reporting guide for determining whether receipts and expenditures are assigned to income or principal/corpus.
Integrate ChatGPT into Your Client Advisory Services-Updated
-
Online
2.00 Credits
Member Price: $89
Two of the hottest topics in the CPA profession today are CAS (client advisory services) and ChatGPT. This course will explain how to bring these two worlds together by integrating ChatGPT and other generative AI applications into your client advisory services. John Higgins, a leading advisor to the profession on ChatGPT and a seasoned client advisor on technology based solutions, will show you how you can position your firm and yourself as a "go to" advisor on how to embrace this technology in virtually any type of business. John will address how to use this technology as a research and writing assistant in your client services and how to advise your clients on this revolutionary technology and all benefits and "gotchas" that come with it. If you want to step up your advisory game, this course is a "must take." This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
COSO's Internal Control Framework Essentials
-
Online
3.50 Credits
Member Price: $175
Evaluate your or your client's system of internal control with confidence using COSO's internal control framework.
The Art of Marketing for CPAs
-
Online
4.00 Credits
Member Price: $129
To make more money in less time, all accountants need to learn to market themselves effectively to their clients or their firm. For better or worse, promotions and more money go to those who are the best marketers, rather than the most competent accountants. In this fascinating and fun workshop, participants will learn seven key ways to get more clients and/or promotions through the art of marketing.
