WICPA CPE & Special Event Catalog
AI-Powered Excel: Leveraging AI & ChatGPT for Supercharged Productivity
-
Online
1.00 Credits
Member Price: $75
This course will have you streamlining your Excel work, research and documentation, saving you time and effort in your day-to-day tasks.
Excelling at Excel: The Magic of Power Query
-
Online
2.00 Credits
Member Price: $79
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 and teach you some of the ways to take advantage of its ability to handle messy data and automate repetitive tasks. Harness the efficiency of Power Query to revolutionize the way you work with data. Learn how to "program" your tasks once and set them on repeat, eliminating the need for repetitive, robotic work. This automation not only saves time but also ensures consistency and 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 and knowledge to make Excel work for you like never before.
Cash Management: Strategies for Long-Term Success
-
Online
2.00 Credits
Member Price: $79
Many finance departments spend considerable time managing cash, particularly if the organization is highly leveraged or cash rich. Many opportunities exist to reduce your financing costs or increase short-term cash returns if you manage cash effectively. This session will cover a wide variety of day-to-day cash management tools.
Financial Decisions that Led Two Businessmen to Prison
-
Online
2.00 Credits
Member Price: $89
Two college graduates built impressive careers: One worked in sales, the other in technology and investing. Both of those people made decisions in the course of their business that led to government investigations. They had to hire attorneys, go through judicial processes, face charges and plead guilty. Each of those people are on their way to prison. Learn from the lessons they offer. We interview both financial professionals and they tell us more about how their decisions influenced the consequences that followed. 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.
HR Investigations: Episode 2: Interview Techniques
-
Online
2.00 Credits
Member Price: $79
Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session provides best practices for interviewing to gather accurate information, such as creating and asking open ended questions, effective listening and understanding verbal and non-verbal communication. Attendees will end the session with takeaways to immediately implement in future HR investigations. Two of three Episodes in the series.
Surgent's The Accountant as the Expert Witness
-
Online
2.00 Credits
Member Price: $99
As litigation becomes more complex, attorneys are relying more on accountants to serve as consulting experts or expert witnesses at trial. Serving as an expert witness is not as difficult as you might expect. Accounting experts educate lawyers and jurors on issues such as valuation, tax liability and forensics. Learn how accountants become expert witnesses, the role they play during pre-litigation through to trial and the techniques experts employ to avoid challenges from opposing counsel.
Measuring Audit Risks
-
Online
3.00 Credits
Member Price: $99
In order not to perform an excessive number of audit procedures (over audit) auditors must perform procedures in order to determine in what areas are there weak internal controls that could result in a risk that the financial statements would be materially misstated and not be detected. SAS No. 122, AU 300: 499, Measuring Audit Risk provides guidance as well as required procedures that must be performed in every audit in order to determine the risk of material misstatement. No longer can the auditor state that they assess the risk of material misstatement at maximum without having a basis for making such assessment. As a result, the standards now require that the auditor make such an assessment of a material misstatement of the financial statement on every audit in order to have a basis for such assessment. This program is an overview of the statement documentation requirements in assessing such a risk.
Ethics: A Line in the Sand; Implications for Daily Business
-
Online
4.20 Credits
Member Price: $129
Ethical behavior continues to be a problem in society and even in the CPA ranks. "Ethics: A Line in the Sand" looks at the behavioral issues that influence how CPA's act. The course will address why individuals make ethical blunders, the state of ethical conduct in business organizations, the relationship between strong cultures, policy and procedures and successful ethical work environments. In addition, the course will highlight the one behavior to watch for as an indicator of potential ethical violations.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Complete Guide to Analyze Data With Excel PivotTables
-
Online
4.00 Credits
Member Price: $149
Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Business Tax Credits 2025
-
Online
1.00 Credits
Member Price: $55
Tax credit and incentive programs offer significant but rarely utilized savings. This presentation will introduce the most important federal and California tax credits and incentives available to business taxpayers. Attendees will hear an overview of these benefits and learn how to identify these opportunities for their clients.
Internal Control: Testing for Operating Effectiveness
-
Online
2.00 Credits
Member Price: $89
Properly designed and effectively operating internal control over financial reporting is critical for preventing, or detecting and correcting, material misstatement. This course describes how to satisfy the audit requirements related to taking a control reliance strategy by testing the operating effectiveness of internal controls, while promoting an effective and efficient financial statement audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
PowerPoint: Tips & Tricks for Today's Accountant
-
Online
2.00 Credits
Member Price: $79
PowerPoint is a widely available resource that is potentially underutilized by accountants because many accountants do not stray beyond Excel and Word in the Microsoft Office suite. You will learn how to create and edit a professional PowerPoint slide deck. This session places particular emphasis on efficiency tips and tricks that will allow you to develop creative, professional visual aids while minimizing time and effort. The course's author will share personal insights he has cultivated throughout more than two decades of public speaking. Although the session will focus on creating and editing slides, we will illustrate best practices for presentation delivery. We will also explain how PowerPoint can be used for purposes other than delivering presentations.
Ethics & Technology for CPAs
-
Online
2.00 Credits
Member Price: $89
Explore the ethical principles included in the Code of Professional Conduct that address the emerging practice issues created by new technologies. Consider how technologies may impact audit quality and the integrity of the financial systems and whether they create a need for CPAs to adjust their skill sets to address those challenges. Look at the potential ethical challenges created by the data related to privacy, security and its application. Discuss the changes being proposed to address emerging ethics challenges. 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.
Power BI: Bringing It All Together for Data Analysis
-
Online
2.00 Credits
Member Price: $89
Power BI - Bringing It All Together for Data Analysis is an advanced-level course designed for professionals looking to integrate and optimize their use of Microsoft Power Pivot and Power BI. Building on the foundational knowledge from previous courses, this session focuses on the crucial next steps after creating data models and measures, guiding participants on how to fully utilize the potential of these tools to uncover insights and create impactful, actionable visualizations. This course takes a deep dive into the critical aspects of using Power BI to its fullest potential, emphasizing a holistic approach to data analytics. You'll learn how to build a streamlined workflow, ensuring every step in your data journey contributes to actionable insights. The course also focuses on optimizing performance for data models, utilizing advanced features of Power BI Services and moving beyond basic data models to create advanced solutions tailored to real-world business needs. By the end of the course, you'll be able to synthesize all your Power BI skills to design and deliver powerful analytics solutions tailored to any audience. Whether you're presenting to stakeholders, sharing insights across teams, or managing enterprise-level reporting, this course will equip you with the tools and strategies to succeed. Perfect for Power BI users looking to tie all the pieces together into a comprehensive, efficient workflow. 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 Successfully Completing an Estate Tax Return : Form 706
-
Online
2.00 Credits
Member Price: $99
Since the early 2000s, the estate tax burden on taxpayers has gradually decreased along with the number of practitioners specializing in the field. Nevertheless, some of your most wealthy clients will owe estate tax & this issue will eventually be thrust upon you. Finding an affordable, competent specialist who you trust to work with you & your client may be difficult. Learning the basics of the tax & how to complete the form will give you confidence to help your clients navigate that difficult time.
Surgent's Tax Research
-
Online
2.00 Credits
Member Price: $99
Answering clients' tax questions accurately and on time is a key challenge for tax practitioners. Through simple, plain language explanations and examples, this course will help practitioners perform tax research more efficiently by describing the structure of the primary sources, highlighting the differences between primary and secondary sources and detailing the steps in the tax research process.
Global IIA Standards (GIAS) Fundamentals & Domain I & II: Part I
-
Online
2.20 Credits
Member Price: $79
In May 2023, the IIA released a draft of the new Global Internal Audit Standards. The intent was to provide more effective standards for Internal Audit globally. The new Global Internal Audit Standards were released on January 9, 2024 and 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 and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service
Fundamentals of Form 1040: Individual
-
Online
4.00 Credits
Member Price: $149
This course introduces professionals to the fundamentals of individual tax preparation. Participants will learn the essentials of Form 1040, including filing requirements, income reporting, and deductions. The session will also cover preparer responsibilities, due diligence, and taxpayer rights under Circular 230. By the end, attendees will have a solid understanding of the foundation of personal tax returns. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Best Practices: Conducting Meaningful Walkthroughs
-
Online
2.00 Credits
Member Price: $89
This course will serve as an introduction to conducting effective walkthroughs to gain an understanding of the client's transaction processes as well as identifying internal controls within each process. This course will review the procedures, questions to ask and documentation requirements of walkthroughs. It will also include real-world examples of the red flags that may arise while executing a walkthrough. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
HR Investigations: Episode 3: Gathering-Analyzing-Reporting
-
Online
1.00 Credits
Member Price: $39
Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session provides best practices for gathering and analyzing evidence and reporting the investigation results. Attendees will end the session with takeaways to immediately implement in future HR investigations. Three of three Episodes in the series.
