WICPA CPE & Special Event Catalog
K2’s Mastering Advanced Excel Functions
-
Online
4.00 Credits
Member Price: $149
With approximately 500 functions now available in Excel, some newer & more powerful tools are easily overlooked. But if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel's more advanced features-some new & some legacy-to elevate your productivity to higher levels. In this session, you will learn about many of Excel's newer tools, including XLOOKUP, SUMIFS, SWITCH & STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT & PPMT & how to retrieve summarized data easily using GETPIVOTDATA & CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power & create more accurate forecasts with Excel's FORECAST.ETS function. Regardless of your experience working with Excel, participating in this course will help you work more efficiently & effectively in Excel.
Leverage PowerBI.com to Create Data Analysis for Others
-
Online
2.00 Credits
Member Price: $89
Unlock the full potential of data analytics with our specialized course, "Leverage PowerBI.com to Create Data Analysis for Others". This two-hour, intensive training is specifically designed to empower professionals in harnessing the powerful features of Microsoft PowerBI.com. Whether you're a data analyst, business intelligence professional, or someone keen on mastering data visualization and report creation, this course is your gateway to becoming a proficient Power BI user. Dive into the dynamic world of data analytics and learn to transform raw data into visually compelling stories that drive decision-making. Our expertly crafted program offers a deep dive into the essentials of PowerBI.com, starting with a comprehensive tour of its interface and core concepts. You'll gain experience in connecting to diverse data sources, creating stunning visualizations and building interactive dashboards that communicate insights effectively. The course also covers the innovative Q&A feature of PowerBI.com, allowing you to explore data with natural language queries. By mastering the art of sharing datasets, reports and dashboards and creating comprehensive apps, you'll be equipped to deliver top-tier data analysis solutions to colleagues and clients alike. Through this course, attendees will gain a deep understanding of how to leverage the PowerBI.com platform to disseminate datasets, reports and dashboards, catering to the specific needs of their audience. Our course is tailored for those who aspire to lead in the data-driven landscape, offering not just theoretical knowledge but real-world applications. Upon completion, participants will not only have a thorough understanding of PowerBI.com but also the confidence to apply this tool in creating impactful data analysis for diverse audiences. Join us to elevate your professional skillset, make data-driven decisions with ease and add a valuable credential to your portfolio. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Appreciation Intelligence: The New AI Elevate Culture. Deepen Loyalty. Strengthen Performance.
-
Online
1.00 Credits
Member Price: $39
Appreciation isn't a soft skill-it's a strategic advantage. In today's competitive professional landscape, your ability to express appreciation effectively can be the difference between retaining top talent, building strong client relationships and creating a thriving team culture-or not. This course introduces a powerful, research-backed framework for understanding how appreciation works-and how to use it to fuel performance, loyalty and engagement across your firm, practice, or department. Based on the work of Dr. Gary Chapman and Dr. Paul White, you'll explore the four core "languages of appreciation" and learn how to recognize and use them in a way that resonates with clients, colleagues and team members. The truth is, everyone wants to feel valued-but not everyone receives appreciation the same way. In this hands-on session, you'll discover your own appreciation style, learn to spot others' and develop practical tools to build a more energized, connected and committed workplace.
Controller Series: Technology: Must Have Excel Competencies
-
Online
1.00 Credits
Member Price: $75
This session will cover what the accountants of today should know about Excel to improve their efficiency, access data and gain insights into the company, industry and economy.
Surgent's Reasonable Suspicion
-
Online
1.00 Credits
Member Price: $59
Given the opioid epidemic and the legalization of medical and recreational marijuana in a growing number of states, many employers are concerned about the impact drugs and alcohol may be having on the safety and security of their workplaces. Reasonable suspicion testing is among the best ways for employers to identify whether an employee is under the influence of drugs or alcohol while working. This webinar explores what managers and supervisors need to know to implement a Reasonable Suspicion Testing Policy.
What If Your Client Didn't Take Reasonable Compensation
-
Online
1.00 Credits
Member Price: $55
Are you a new advisor handling S Corp clients, or perhaps a seasoned professional facing this common scenario: "My S Corp client didn't take reasonable compensation last year. Now what?" Knowing that reasonable compensation isn't just a tax obligation, but a strategic financial decision, you need to be armed with expert knowledge to help your client navigate this situation. Join us to discuss IRS regulations, understand preventive measures and address challenges within the year. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Common Financial Statement Disclosures
-
Online
2.00 Credits
Member Price: $89
Financial statement disclosures are important to provide the information necessary for financial statement users to make economic decisions. Disclosures further explain and clarify information provided in the basic financial statements, but also provide critical information about subsequent events, litigation risk and other concerns. This course focuses on the most common financial statement disclosures for small- or medium-sized nonpublic entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
How AI Fits into the Accounting World 26-27
-
Online
2.00 Credits
Member Price: $99
This session is designed as a primer to introduce artificial intelligence (AI) and to discuss how it will impact accountants as they work. The material will briefly explain what AI is and then focus on ways that it is already serving those in the accounting realm. It will close with a look at future AI-centric developments that will have great potential to positively impact on the accounting profession. Those wishing to gain an understanding of what artificial intelligence is and how it will be used by accountants should consider attending this session.
Surgent's Guide to Partner Capital Account Reporting
-
Online
2.00 Credits
Member Price: $99
Accounting and finance professionals are responsible for presenting partner capital accounts on the tax basis. But what does this mean and how have rules changed in recent years regarding partner capital accounts? This webinar covers exactly that. For accounting and finance professionals preparing partnership 1065 forms, this course explains these complex rules in practical and understandable terms.
Surgent's Understanding How the IRS Rewards Whistleblowers
-
Online
2.00 Credits
Member Price: $99
In 2006, Congress passed the Tax Relief and Health Care Act. Prior to the Act's passage, rewards to individuals who provided information to the IRS regarding tax fraud were capped at $10 million. The Tax Relief and Health Care Act authorized the IRS to create a Whistleblower Office dedicated to investigating, processing and recovering claims concerning the underpayment of taxes. Under the IRS' new program, whistleblowers may recover 15 to 30 percent of the amount collected provided the taxes and amounts in dispute exceed $2 million. If the whistleblower's claim does not meet these criteria, the IRS may still consider granting an award under its pre-2006 Tax Relief Act discretionary authority. Given the rapid growth of this program, practitioners should have a basic understanding of the procedure and content for IRS Whistleblower claims, both from the perspective of a claimant's potential to recover and a taxpayer's exposure to liability.
Surgent's Ethical Considerations for the CPA
-
Online
4.00 Credits
Member Price: $159
CPAs today face greater challenges than ever to maintain the high ethical standards of their profession. It is vitally important that all CPAs understand their professional responsibilities related to all aspects of their job. This course, which focuses on key components of the AICPA Code of Professional Conduct, reviews a history of the CPA profession and focuses on ethical requirements that CPAs must adhere to in their everyday practice, including practical examples of potential ethical dilemmas that practitioners may encounter, particularly those related to objectivity and independence. PLEASE NOTE: THIS COURSE COVERS GENERAL ETHICS AND IS APPLICABLE IN STATES IN WHICH STATE-SPECIFIC ETHICS IS NOT REQUIRED. This course does not qualify for IRS credit. Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
The Role of Internal Control in the Risk-Based Audit
-
Online
4.00 Credits
Member Price: $149
This program addresses the role of client internal controls for balancing efficiency and effectiveness in a risk-based audit. Practical insights regarding an auditor's assessment of the risk of material misstatement when auditing financial statements of non-issuers will be explored, with particular emphasis on internal controls of small-to-medium clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. This event may be a rebroadcast of a live event and the instructor will be available for your questions during the event.
Corporate Finance Technology Selection: Practical Frameworks
-
Online
1.00 Credits
Member Price: $55
Finance technology decisions (ERP, FP&A, AP/expense automation, close/consolidation, bank integrations and AI-enabled tools) can dramatically improve close speed, forecasting and control execution-but vendor demos and "AI" marketing often hide integration complexity, data readiness gaps, governance risk and long-term total cost. This course provides a practical, vendor-neutral approach for CPAs and finance leaders to evaluate and implement corporate finance technology with an audit-ready mindset. Participants learn how to cut through AI claims using an AI capability framework, apply a weighted vendor evaluation scorecard focused on controls and assurance, build a five-year total cost model that captures hidden and ongoing costs and follow an implementation roadmap with checkpoints and red flags to reduce failure risk and improve ROI realization. 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 Guide & Update to Compilations, Reviews & Preparations
-
Online
4.00 Credits
Member Price: $159
Specifically designed for preparation, compilation and review practitioners, this course provides a comprehensive review and hands-on application for performing financial statement preparation, compilation and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-27 by the AICPA's Accounting and Review Services Committee (ARSC). The course also reviews recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARSs requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform compilation, preparation and review engagements.
Surgent's The Most Critical Challenges in Governmental Accounting Today
-
Online
4.00 Credits
Member Price: $159
With the constant churning of governmental accounting standards, now is the time to know more than just what the standards say; we need to know what they mean and how they will affect governmental entities. This course is designed to do just that! The course materials utilize a highly illustrative and innovative format. Over 15 focused exercises are included to provide an enhanced working knowledge of the most critical challenges in governmental accounting today.
Comprehensive Accounting & Financial Reporting Update
-
Online
4.00 Credits
Member Price: $149
This course covers recently issued accounting and financial statement reporting standards from the Financial Accounting Standards Board. Key implementation challenges and experiences from public company filings will be identified. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
HR's Role in Business Evolution: Strategy, Finance & Growth
-
Online
2.00 Credits
Member Price: $39
This course is tailored for business leaders and HR professionals who want to enhance their strategic management skills and create actionable plans for success. You'll learn the overall strategic management process, how to develop both simplified and detailed business and strategic plans and the crucial role of corporate culture, leadership and staff development in driving or hindering strategic outcomes. Additionally, you'll explore how to leverage ChatGPT (Generative AI) as a powerful tool to improve your performance as a key business partner to the management team, helping you make data-driven decisions and enhance organizational effectiveness.
Resistance to Resilience: Strive for Tech Change Acceptance
-
Online
1.00 Credits
Member Price: $55
Technology adoption often comes with resistance, but it's possible to transform this challenge into an opportunity for growth. This course explores the journey from resistance to resilience in embracing new technologies, focusing on overcoming barriers and ensuring successful implementation. Participants will examine cutting-edge audit technologies, including AI, data analytics and automation and learn how to align these innovations with both organizational and personal goals. Through case studies, insights into the Technology Acceptance Model (TAM) and practical discussions, participants will gain the tools and strategies to foster acceptance, driving seamless integration of new technology into both individual tasks and team workflows. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Addressing Misconduct
-
Online
1.00 Credits
Member Price: $39
The objective of corrective action is to change conduct through teaching. Corrective action may be sequential, out of order, repetitive, or not appropriate to take at all. The action selected should reflect the type, frequency and severity of the misconduct. Changing conduct through teaching requires effective employee relations skills. This course provides practical knowledge and scripts for handling a wide array of sensitive misconduct situations with good judgment, such that personal and employer liability is avoided.
AICPA & CIMA Faculty Hour Series (6/26/2026)
-
Online
1.50 Credits
Understand emerging trends in academia. Academics will receive timely and critical information on emerging issues and the latest news affecting accounting education. Subject matter experts provide insights, analysis and practical guidance on the key issues facing the profession and academia. Faculty Hour contributors will share their experiences, tools and resources to ensure the success of the next generation of accountants. In addition, AICPA & CIMA staff will provide the latest news concerning changes to regulations, exams and licensure requirements that may affect faculty and their schools.