WICPA CPE & Special Event Catalog
Microsoft Excel: Moving Beyond the Basics
-
Online
2.00 Credits
Member Price: $89
This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods & techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing & reporting information.
Technology Trends for CPAs & CFOs: 2026 Update
-
Online
2.00 Credits
Member Price: $89
Believe it or not, AI is not the only mega trend in the information technology landscape. There are many other trends that enable and leverage the power of AI. As a CPA professional, it is imperative that you develop a baseline understanding of the key technology trends that are impacting businesses across the board. This course will provide the update you need to help you understand the nature of the key technologies and the role they play. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2026/27 Yellow Book Update
-
Online
1.00 Credits
Member Price: $55
Stay current on key developments affecting governmental audits with this focused update on the 2024 revision of the Yellow Book. This course highlights significant changes related to quality management and updates affecting key audit roles, with an emphasis on how these revisions impact audit planning and execution. The course also addresses the GAO's implementation delay and its implications for 2026 audit planning. Participants will gain context around recent leadership changes at the U.S. Government Accountability Office and what those transitions may signal for future guidance and oversight priorities. In addition, the course includes an overview of recent updates to the Green Book, helping auditors understand changes to internal control guidance that may affect governmental entities and Single Audit engagements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Group Audits: Who is Responsible for What?
-
Online
2.00 Credits
Member Price: $89
Financial statement audits often involve audits of components of a larger entity. This course will focus on the responsibilities for both the group auditor & component auditor, including implementation of SAS No. 149 relate to group audits.
K2’s Microsoft Power Tools
-
Online
2.00 Credits
Member Price: $89
Unlock the full potential of your Microsoft 365 subscription with our exclusive session on Microsoft's Power Tools! Discover the incredible capabilities of Power BI, Power Query, Power Pivot & Power Automate & learn how these tools can revolutionize your productivity & efficiency. Many professionals are unaware that they already have access to these powerful tools, leading to missed opportunities & suboptimal performance. Don't let this be you! Participate in this session to explore the practical applications of these tools & elevate your productivity & internal control structure to new heights
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.
How to Audit Accounting Estimates
-
Online
2.00 Credits
Member Price: $89
When auditing management's accounting estimates, increased professional skepticism is necessary as there is always the potential for bias in areas of increased subjectivity & complexity. This course will demonstrate procedures to test the process used by management to develop estimates, as well as walk through common examples of accounting estimates that are included in the financial statements. It includes the updated requirements in SAS 143. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Profitability Pricing: Boost your Bottom Line
-
Online
2.00 Credits
Member Price: $89
Two seemingly similar products can have very different costs, yet many companies are completely oblivious to these differences causing them to lose money or competitive bids. When companies compete, those with good information win the "gravy" contracts & those with bad information lose money on "dog" jobs. Attend this session to gain insights on how to win bids for the best opportunities & give the money-losers to your competitors. Achieve your target profitability in the process.
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 and 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 and internal stakeholders. We explore best practices for cross-functional support within firms that perform tax, accounting solutions, financial statement and consulting services. We also highlight similarities and differences between U.S. GAAP and tax-basis accounting. 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 Critical Issues Involving Taxation of Construction Contractors
-
Online
4.00 Credits
Member Price: $159
Many consider taxation of construction contractors to be the most complex area of the Internal Revenue Code. This industry is subject to many elections and considerations to reduce or defer amounts owed. In this course, we will highlight these areas and discuss potential opportunities for practitioners and their clients. We will also discuss the impact of recent legislation on construction taxation, including changes to net operating losses and the AMT rules. This is a critical presentation tailored for CPAs who work for or represent construction contractors.
Surgent's You’ve Got This: An Introduction to Yellow Book & Single Audits
-
Online
4.00 Credits
Member Price: $159
If you work with governments or not-for-profits, mastering the fundamentals of Yellow Book and single audits is essential. This beginner-friendly course breaks down the key requirements of the Yellow Book and the Uniform Guidance for Federal Awards into clear, manageable concepts. You'll learn the essentials of performing Yellow Book and single audits with confidence—building a strong foundation, boosting your understanding and equipping you to conduct audits efficiently and effectively.
Controls to Secure the Growing Digital Footprint
-
Online
4.00 Credits
Member Price: $149
The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they and their companies secure digital information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's Excel Best Practices 26-27
-
Online
8.00 Credits
Member Price: $329
There are right and wrong ways to work with Excel. In this session, you will learn a series of best practices to help you create Excel workbooks efficiently and effectively, including handling security issues, collaboration needs and reporting options.
Know Your Cost: Double Your Profit 26-27
-
Online
8.00 Credits
Member Price: $329
Companies with poor cost information make bad decisions about products that are not "average.— Poor information causes companies to overprice easy, high-volume "gravy" products and underprice difficult, low-volume "dog" products. Regardless of whether your company sells goods or services, learn how to double your profit by giving the dogs to your competitor and keep the gravy for yourself.
How Changes in Business Methods Affects Internal Control
-
Online
8.00 Credits
Member Price: $239
New Technology, the move toward telecommuting, the widespread adoption of electronic documentation and a wide range of other factors have significantly and forever changed the way business is conducted. It should go without saying that changes in tools and methods lead to upheaval in any organizations internal control system. In this session, we look at all the changes that are occurring and discuss what's coming in the not too distant future. The material then looks at how internal controls have been affected and what other updates are on the horizon. Anyone trying to use controls to keep their organization efficient and secure should consider this session because the rate of change to both operational methods and control processes has been and will continue to be incredible. 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 Fiduciary Income Tax Returns – Form 1041 Workshop with Filled-in Forms
-
Online
8.00 Credits
Member Price: $279
This course is designed as a comprehensive guide to the core concepts of trust and estate income tax preparation. The course explains the common terminology and complicated income tax rules of estates and trusts, fiduciary accounting and an introduction to or refresher on preparing Form 1041. This practical, over 300-page manual is an excellent reference source for your practice, which begins with quite simple cases. Building upon that base throughout the manual, the course ends with two complicated preparation cases, one trust and one estate, each with filled-in forms.
AICPA's New SSTS #4: New Ethics Standard for Tax Resolution
-
Online
1.00 Credits
Member Price: $55
This 1-hour course is designed for CPAs and EAs who want to stay ahead in the ever-evolving field of tax resolution. Dive into the latest updates to the AICPA Statements on Standards for Tax Services (SSTS) #4 and explore their practical implications for your practice. Through real-world examples and case studies, you'll gain a deeper understanding of how to navigate ethical challenges while maintaining compliance with professional standards. 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.
Leadershift Ethics: Things Must Change!
-
Online
2.00 Credits
Member Price: $89
With the rapid pace of change, change now happens daily in business and our personal lives. It can be difficult to navigate change when right and wrong get a bit fuzzy. New processes, new technology, new circumstances and new impacts to people must be measured and decisions made as the change evolves. Change always becomes something different than what was originally planned or imagined. In this session, learn how to measure your ethics through change. You will learn how to filter everything you do during change through a simple litmus test. Through the power of story, you will learn from the lessons of other organizations and their ethical mistakes. Lastly, you will take away what is required to manage yourself so that when ethical decisions arise, you have the mental capacity to manage through it well. 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.
Navigating IRS Collections: The Collection Process
-
Online
2.00 Credits
Member Price: $89
This course is designed for tax professionals seeking to understand and navigate the IRS collection process effectively. Participants will gain indepth knowledge of the various collection methods employed by the IRS, including liens, levies and wage garnishments. Additionally, participants will learn strategies to avoid or halt collection actions and the implications of the statute of limitations on tax collection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Controllership Series: Overhead, Direct & Indirect Costs & Allocation Methods
-
Online
1.00 Credits
Member Price: $39
Managing expenses is a key for business success & overhead costs play a pivotal role in realizing favorable profit margins. Almost all companies have some form of overhead consisting of specific categories of indirect expenses. The better organizations are able to manage overhead costs, the more competitive they are in the marketplace. It is incumbent in the Controller's role to effectively manage, monitor & perform ongoing assessment of overhead costs, allocations & rates. Overhead refers to the ongoing business expenses not directly attributed to creating a product or service. A company must pay overhead on an ongoing basis, regardless of how much or how little the company sells. It is important for budgeting purposes but also for determining how much a company must charge for its products or services to make a profit. Overhead can be fixed, variable, or a hybrid of both. There are different categories of overhead, such as administrative overhead, which includes costs related to managing a business. In short, overhead is any expense incurred to support the business while not being directly related to a specific product or service.