WICPA CPE & Special Event Catalog
Advanced Excel for Staff: Build Reports & Analyze Data
-
Online
2.00 Credits
Member Price: $89
Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize and structure data, apply calculations to derive key metrics and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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
Ask Me No Questions & I Will Tell You No Lies
-
Online
3.00 Credits
Member Price: $109
As a parent, could you tell when your young children were lying to you? Most of you will say of course I could! How? Was it their words they said or how they acted when they were lying to you? Most of you will say, by the way they acted. We call that body language. Remember, words lie but the body always tells the truth...... without saying a word. At what age does a child learn to lie? When they are about six months old. We teach them & we are really good at it! (We'll talk about it.) As a rule, when an individual tells a lie, they know it's wrong & as result it causes stress. That stress manifests itself in many ways. The individual that is lying wants to get rid of the stress by saying or doing certain things. We call these stress indicators & they can be verbal or nonverbal. It's particularly important to observe what the subject is talking about when the stress indicator appears. If an interviewer is aware of the verbal & nonverbal stress indicators, they can read a person like a book. Remember, words lie but the body always tells the truth. In this session, we will discuss the types of individuals that lie, why they lie & both the verbal & nonverbal indicators of stress. In addition, we will discuss how to get them to tell the truth & make them feel good about it.
Forensic Accounting: When The Office Is A Crime Scene
-
Online
4.00 Credits
Member Price: $149
Embezzlement happens often to many small businesses. Unfortunately, the lack of internal controls allow the embezzlement to remain undetected for years. But when it is discovered, the small business owner will most likely contact their CPA for advice. What should you do when your client contacts you about their employee embezzling money from their business? What options should you present to your client? How can your client protect themselves, while investigating the embezzlement? What steps need to be taken about preserving any documents, emails, texts, or phone calls? This course teaches how to engage the client, properly identify the evidence needed to prove the crime, how to write the report for civil and criminal trial and best practices in preserving electronic and paper evidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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.
Risk Wrangling: Surviving the Modern Business Rodeo
-
Online
2.00 Credits
Member Price: $89
Risk-based factors are becoming exponentially important considerations for accountants in both public practice and industry. We examine the nature of risks for today's enterprises while exploring the role of internal controls for mitigating business risks. We also explore SAS 145 and other guidance aimed at risk considerations for professional engagements. Public and private accountants will enhance their capabilities for assessing and addressing risks faced by today's organizations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethics in Artificial Intelligence
-
Online
1.60 Credits
Member Price: $79
Artificial Intelligence (AI) is reshaping industries, decision-making & everyday life at an unprecedented pace. While its potential for innovation is immense, AI also raises profound ethical challenges around fairness, accountability, transparency & human rights. Bias in algorithms, misuse of personal data, opaque decision-making & the displacement of human judgment underscore the urgent need for ethical frameworks to guide AI development & use.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
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.
Will Your Ethics Be Burned by Burnout?
-
Online
2.00 Credits
Member Price: $89
Ethical behavior is not a destination it is a journey with twists, turns and bumps in the road. We are faced with ethical dilemmas every day. Do I speed to make it to a meeting? Do I call in sick because I need a break? When does "helping my child with their homework" become "doing it for them"? CPAs are ethical most of the time, but staying ethical is hard. It gets harder when we are under stress. 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.
Foundations of IT Audit for CPAs
-
Online
3.00 Credits
Member Price: $109
This course introduces CPAs, financial auditors as well as technology auditors to the foundational concepts of IT auditing. Participants will learn how IT systems support financial reporting, how to assess risk in IT environments & how IT General Controls (ITGCs) & application controls impact audit procedures. The course also introduces IT audit planning & scoping to help auditors determine what systems & controls to evaluate.
Advanced ChatGPT for Accountants
-
Online
2.00 Credits
Member Price: $89
This course concisely explains the latest "see, hear, speak" multi-modal updates to ChatGPT and how they can be used in an accounting context. New features include vision processing, voice conversation, image generation, real-time Internet access, advanced data analysis, plugins and more. Discover how this technology can be used in mind-blowing ways to analyze financial data, optimize processes and solve problems in the accounting domain. Through the lens of ChatGPT, practitioners can explore innovative solutions, automate routine tasks and generate deeper insights and value to their clients and organizations in previously unimaginable workflows. You'll walk away with scores of advanced ChatGPT strategies and tips that can be immediately applied and deliver instant results to elevate the efficiency and effectiveness of your accounting projects and tasks. 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: Accounting Scandals: What Happened & Why? Can We Prevent Them? featuring Tracy Cooper & Don Minges
-
Online
1.00 Credits
Member Price: $39
The staggering volume of accounting scandals is a scandal. What has happened & what were the root causes? Why do many financial professionals choose to do the wrong thing? What has been the cumulative impact on the profession? What can we do to enhance our professional reputation? We will discuss the many "fixes" imposed to address previous accounting scandals, including COSO; were they effective? We must understand that accounting fraud is prevalent & what should we look out for? Be aware. We do not want history to repeat itself.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
The Controllership Series: The Role of the Controller in ESG
-
Online
1.50 Credits
Member Price: $79
Why do for profit organizations exist" To make money!!!!! What a great concept. But if the organization does not have the proper collections & credit procedures in place, they may not be able to access that money. Hence the importance of the credit & collection process. Credit & collections are critical areas for the financial statement controllers. Customer credit is a form of payment that allows small business customers to purchase a product or service before paying for it in full. The process works similarly to the way a credit card does: you procure something & pay it back later. Collections is a term used by a business when referring to money owed to that business by a customer. When a customer does not pay within the terms specified, the amount of the bill becomes past due & is sometimes submitted to a collection agency. The sales & collection process includes business activities related to selling products & services, maintaining customer records, billing customers & recording payments From customers. It also includes activities necessary to manage accounts receivable, such as aging accounts & authorizing credit. This course delves into the topics that impact the sales, credit & collections process for management. We discuss strategic steps management can take to ensure their processes are efficient & that they are able to actually collect their revenue.
Sarbanes-Oxley 20 years later: Sourcing Emerging Risks Part II
-
Online
1.80 Credits
Member Price: $79
It would be amiss to not recognize that the passage of time has changed our world. Think of various events such as economic change, technological evolution, the pandemic etc. These are just a few of the changes that may have impacted the manner in which we execute some of the processes outlined in the SOX legislation. In this segment we will focus on sourcing of emerging risks by utilizing to COSO principles.
Interview Techniques & Detecting Deception
-
Online
2.00 Credits
Member Price: $89
The ability to create & ask good questions as well as the ability to know when someone is being deceptive are important skills for managers, auditors & investigators. This session will improve your interview techniques & your lie detection abilities. Multiple videos From various movies, TV shows & public figures showcasing the behaviors of liars are included.
Asset Misappropriation You Have It: They Want It
-
Online
2.00 Credits
Member Price: $89
Have you ever thought about stealing? If the answer is NO, then you need to find another profession because you will never be a successful fraud examiner/investigator or a financial auditor. To find fraud, you must first determine, given the opportunity through weak internal controls, how a person would steal. You have to say to yourself, given the opportunity that exists, how many ways could I take advantage of it? In other words, you must be able to think how you could steal & not be caught. So yes, to find fraud, you must first think about stealing. For a fraudster to be successful, they must make you think fraud is a legitimate transaction. They must make you think it is something that it is not. There are so many places where fraud can be hidden. It is up to you to evaluate where the risks of fraud are in an organization, then design effective investigative procedures to determine if someone took advantage of the opportunity. If they did not, how else may they have taken advantage of the opportunity? One must remember that one weakness in internal control may create several ways to take advantage of it & you must examine every such one. During this session, the many ways fraud can be hidden in asset misappropriations will be discussed. Remember, the number of ways is only limited by one's imagination.
Schedule K-1: What is it & What do I do with it?
-
Online
2.00 Credits
Member Price: $89
This seminar offers a practical and in-depth exploration of IRS Schedule K-1, a critical reporting document issued to taxpayers with interests in pass-through entities such as Partnerships, S Corporations and Estates or Trusts. Participants will gain a clear understanding of how to interpret and accurately report Schedule K-1 data on Form 1040, with emphasis on common income, deduction and credit items. The course also demystifies the Qualified Business Income (QBI) Deduction, including eligibility criteria, reporting mechanics and integration with K-1 data. Key compliance topics-such as basis and loss limitations, material participation rules and passive activity considerations-will be addressed through practical examples. In addition, attendees will be briefed on recent developments affecting Schedules K-2 and K-3, ensuring they are equipped to navigate evolving international reporting requirements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Strategic Use of Trump Accounts: Planning Opportunities for Tax Professionals
-
Online
2.00 Credits
Member Price: $89
This course provides tax & accounting professionals with a focused overview of Trump Accounts & their practical application in client planning. Participants will examine eligibility requirements, contribution rules, tax treatment & reporting considerations. Through practical examples, the course emphasizes evaluating suitability, identifying planning opportunities & avoiding common compliance pitfalls when incorporating Trump Accounts into client strategies. 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
Not Just Your Everyday FASB Update
-
Online
4.00 Credits
Member Price: $149
This course highlights significant updates that affect financial reporting & related attestation services. We will explore novel FASB pronouncements while examining the enduring impact of lease accounting & revenue recognition standards. This course will provide reminders regarding both GAAP & non-GAAP financial reporting alternatives for closely held entities. We will also explore selected guidance regarding audit, review & compilation engagements.
Microsoft 365 Application Lightning Round Review-Updated
-
Online
1.00 Credits
Member Price: $55
Do you use Microsoft (Office) 365? Are you satisfied that you are getting the most that you can from it? If you answered yes then no, this course will provide a really high return on your investment of time and money in this application suite. John Higgins, one of the profession's leading experts on the integration of Microsoft 365 into business, will explain and demonstrate the depth and breadth of the Microsoft 365 ecosystem. The course is designed to raise your awareness of all that you can do with Microsoft 365 and substantially increase your monthly subscription ROI. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
