WICPA CPE & Special Event Catalog
You Don't Know What You Don't Know About Microsoft Excel
-
Online
8.00 Credits
Member Price: $239
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excelling at Excel: The Magic of Power Query
-
Online
2.00 Credits
Member Price: $89
Elevate your data analysis capabilities with our focused course on Power Query. Tailored for financial professionals, this training will show you how to get started using Power Query & teach you some of the ways to take advantage of its ability to handle messy data & automate repetitive tasks. Harness the efficiency of Power Query to revolutionize the way you work with data. Learn how to "program" your tasks once & set them on repeat, eliminating the need for repetitive, robotic work. This automation not only saves time but also ensures consistency & accuracy in your data processes. Whether you're dealing with complex datasets or simply looking to streamline your reporting processes, this course will equip you with the tools & knowledge to make Excel work for you like never before.
Microsoft 365 for CPAs: Unlocking Hidden Productivity Tools
-
Online
2.00 Credits
Member Price: $89
Microsoft 365 is likely the most underutilized software investment in your firm or business. This course will show how to tap in to many of the lesser known features of the Microsoft 365 ecosystem of apps to maximize your productivity and produce better outputs. Through a series of practical case study demonstrations you will learn how to leverage the full potential of Microsoft 365 in your organization. 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.
The New AICPA Statements on Standards for Tax Services
-
Online
2.00 Credits
Member Price: $89
The SSTS are tax standards that apply to all members who provide tax services & provide the framework for the AICPA ethical guidance for tax practitioners. This program explores the revised AICPA Statements on Standards for Tax Services, effective January 1, 2024. This program is not approved for IRS credit.Note: 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.
Accounting & Auditing for the Construction Industry 26-27
-
Online
4.00 Credits
Member Price: $175
The construction industry faces many unique challenges to survive and remain profitable. These include specific accounting and reporting aspects for construction contracts and estimating project costs and profitability. Analyze revenue recognition under the percentage of completion method (including comparing current standards to the new FASB revenue standard) by exploring the underlying details. Reduce potential errors made using established concepts, including the shortfalls of the "cost to cost" method. Take a focused look at construction contractors' accounting, reporting and auditing. Discuss techniques and examples that provide a realistic audit approach for the contractor, including detailed auditing procedures for many types of contracts.
Ethical Intelligence: Global Case Studies & Standards 26-27
-
Online
4.00 Credits
Member Price: $175
Don't fall behind! This course will ensure that you know the current ethical requirements set by standards-setting organizations and legislative action. Real-world cases coupled with analysis by a leading ethics expert will help you better recognize situations that may pose ethical or regulatory risks. Discover the regulatory, legal and ethical responsibilities you have and gain insight into a simple 4-step decision-making process that can strengthen your professional judgment. Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Tax Aspects of Stock Investing 26-27
-
Online
4.00 Credits
Member Price: $175
Despite the country's polarized politics and troubled economy, the interest in stock investing remains high as younger investors accumulate for retirement and retirees seek to outpace inflation. We'll explore the most popular stock investment strategies and their taxation, including dividend and capital appreciation strategies, while avoiding the net investment income tax and restrictions on losses and straddles. Companion course: Income Tax Planning For Bond Investments
Four Most Overlooked Business Risks: Preparing for the Future 26-27
-
Online
8.00 Credits
Member Price: $329
We tend to focus on fighting today's fires without spending adequate time on bigger, more important risks inherent in today's inter-connected, competitive world. This seminar drills down into four commonly overlooked business risks, looking at how to anticipate, manage, mitigate or exploit them. We will discuss the professional obligations of the board and executive management to assess risks and the responsibility of internal and external auditors to evaluate the adequacy of these assessments.
Corporate Transparency Act Developments
-
Online
2.00 Credits
Member Price: $89
U.S. Department of Treasury's Financial Crimes Enforcement Network (FinCEN) imposed a new reporting requirement that went into effect on January 1, 2024. Millions of businesses may have to file a Beneficial Ownership Information (BOI) Report. In a surprise turn of events, the Federal District Court from the Northern District of Alabama ruled on March 1, 2024 in National Small Business United v. Yellen ("NSB") that the CTA is unconstitutional. This course will discuss the CTA's provisions and the court's decision in NSB. Also covered will be future implications for business entities and steps to consider given the recent ruling. We will also discuss recent proposed rulemaking by FinCen with respect to nonfinanced purchases of residential real estate and gratuitous transfers so that businesses can prepare for any additional reporting burdens that might arise. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Executive Presence, Personal Brand: Structure Your Narrative
-
Online
1.00 Credits
Member Price: $55
Professional credibility is communicated, not assumed. In this 1-CPE session (Professional Development), participants examine structured approaches to articulating their professional identity. Drawing directly from the course framework, the session covers development of an elevator pitch, a professional value proposition and a concise executive biography. Participants will analyze how credibility is established through clarity, relevance and alignment with audience needs. The course emphasizes service-centered communication rather than self-promotion and provides structured guidance for refining professional messaging in leadership and client-facing contexts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Ethics Hour: Ethics is the Engine to Better Leadership: Taking Action, featuring Bob Mims & Don Minges
-
Online
1.00 Credits
Member Price: $39
Ethics is grounded in leadership & the finest leaders are always ethical. Every effective leader is ethical, in words & actions. The best leaders communicate effectively. Being trustworthy is more than being honest & fair. In today's turbulent environment, leadership matters more than ever as the talented staff will readily move to ethical leaders. We must enhance our leadership skills to remain valuable. Simple stated: we all want to work for & with, an ethical leader.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Understanding the 4 W's in Budgeting: Who, What, When & Which?
-
Online
2.00 Credits
Member Price: $89
This session introduces a structured approach to government budgeting using the four W's: Who, What, When & Which. Participants will explore WHO should be involved in the budgeting process, including internal teams & external stakeholders, while learning effective communication strategies to foster collaboration. The session examines WHAT the budgeting process entails, covering essential phases, components, legal requirements & common challenges. Attendees will also learn WHEN to engage the public through strategic planning, workshops & outreach initiatives. Finally, the session highlights WHICH departments play key roles, From financial planning to managing capital projects. By the end of this session, participants will have a comprehensive understanding of government budgeting & how to align financial planning with community priorities.
Excelling at Excel: Tips, Tricks & Updates
-
Online
2.00 Credits
Member Price: $89
Unlock the full potential of Excel with our comprehensive training on shortcuts & formulas. This course is designed for CPAs & financial professionals who want to enhance their efficiency & accuracy in Excel. Learn how to navigate & utilize different versions of Excel, discover powerful new functions & master the art of creating effective tables & automations. With practical examples & hands-on exercises, you'll transform your Excel skills, making your daily tasks quicker & more precise. Plus, benefit From insider tips & tricks drawn From the instructor's extensive real-world experience. Whether it's mastering keyboard shortcuts that save you time or applying formulas that simplify complex calculations, you'll gain practical knowledge that you can immediately apply in your work. This course isn't just about learning Excel; it's about learning to excel at Excel.
Ethical Intelligence for Artificial Intelligence
-
Online
2.00 Credits
Member Price: $89
Organizations and individuals enticed by the siren song of artificial intelligence cannot ignore ethical considerations. Professionals must consider accuracy of information, data privacy, independence, source citations, organizational policies, security, data retention and other ethical matters. This course discusses ethical issues associated with the utilization of AI in a professional setting and provides suggested best practices. 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.
Section 25F Scholarship Granting Tax Credit: Planning & Compliance Strategies
-
Online
2.00 Credits
Member Price: $89
This course provides tax & accounting professionals with a focused overview of the Section 25F scholarship granting tax credit & its application in client planning. Participants will examine eligibility requirements, qualifying contributions, credit limitations & interaction with other tax provisions. The course also addresses state-specific considerations, including variations in eligibility, conformity & planning opportunities across jurisdictions. Participants will learn to evaluate client eligibility, maximize available credits & ensure compliance while avoiding common 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 & submit to terri.storer@acpen.com
Streamlined Excel Reporting Series Session IV: External Data & PivotCharts
-
Online
2.00 Credits
Member Price: $89
Extracting data for richer insights. You'll gain meaningful analysis techniques while working alongside an industry expert and knowledgeable instructor. This session begins with the GETPIVOTDATA function to enable report customization. It's a great starting point before moving on to more advanced techniques. Power Query introduction With its user-friendly interface, Power Query empowers Excel users to take the next step by enabling seamless data import and transformation. With Power Query, you will explore features, including: Getting and transforming data Loading data Managing columns Data source settings Layouts and parameters Visualizing with PivotCharts A well-designed chart can effectively illustrate data trends and comparisons. You'll learn how to create and customize PivotCharts to elevate your reports and make the data more accessible to others.
Surgent's Controllership Skills Update – Budgeting, Forecasting & Big Data
-
Online
2.00 Credits
Member Price: $99
Budgets are the vehicle for allocating resources, measuring activities and identifying needed changes and improvements. An organization's strategy is the primary driver of costs. To be effective, the budget must be linked to strategy and long-term plans. Numerous organizations have achieved a series of short-term targets (budgets) but failed longer term, demonstrating the lack of this necessary linkage. Forecasting, a critical part of any successful budgeting process, can be flawed by technical errors, organizational structure, or emotional forces. The establishment of a system to collect, process and analyze big data can provide significant insights into the budgeting and forecasting process. An efficient system of incorporating big data and analytics into normal activities will improve management's decision-making. This brief program offers specific actions to improve your forecasting and budgeting activities. In addition, more advanced techniques are identified for the participant's further review, which can be applied throughout an organization. Good budgets effectively allocate resources, provide information for decision-making and serve as an early warning system for unforeseen events. A poor budgeting process fosters a false sense of security, provides inappropriate or inaccurate data and reinforces the status quo. Budgets are about the organization's story, not just the raw numbers!
