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.
Internal Control Changes for Remote Workers
-
Online
2.00 Credits
Member Price: $89
For the past two decades the trend has been to move away from brick and mortar offices and have a greater number of people work or telecommute from home. Because of the upheaval caused by recent events, the rate of this move has been accelerated. This has and will continue to create control challenges and organizations must work to address these. Such things as moving from time based employee value to task completion based measurement and the ability to drive needed inter-company communication are just a sample of the issues with which entities must contend. This session looks at the benefits and pitfalls of workers that telecommute. It then discusses important risks and controls to consider as this trend continues and evolves in the business world. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Self-Rental Real Estate: Passive Activity & Section 199A
-
Online
2.00 Credits
Member Price: $89
This program presents a detailed analysis of the self-rental passive activity rules, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Forensic Accounting: Investigating Divorce Cases
-
Online
4.00 Credits
Member Price: $149
With over 50% of marriages ending in divorce, forensic accountants are frequently used in uncovering hidden income and assets. It is not uncommon for one spouse to hide money from another, sometimes for nefarious reasons. As a CPA, your services are valued by high-net-worth individuals who hire attorneys in their divorce proceedings. In this course, you will learn the art of financial investigations and how to uncover the truth in divorce cases, whether from offshore accounts to lifestyle analysis. Step by step, the course will teach you the valuable skills necessary in finding, analyzing, evaluating and presenting your findings to your client and if needed, ultimately in divorce court. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Preparing to be a Forensic Accountant: Focus on Computer Forensics: Part III (Steganography)
-
Online
1.60 Credits
Member Price: $79
This course is a complement to our series on Becoming a Forensic Accountant & the focus of the course is on steganography techniques. Steganography is the art & science of embedding secret messages in a cover message in such a way that no one, apart From the sender & intended recipient, suspects the existence of the message. The first use of steganography can be traced to 440 BC when ancient Greece, people wrote messages on wood & covered it with wax, that acted as a covering medium Romans used forms of Invisible Inks, to decipher those hidden messages light or heat were used. During World War II the Germans introduced microdots, which were complete documents, pictures & plans reduced in size to the size of a dot & were attached to normal paperwork. Null Ciphers were also used to hide unencrypted secret messages in an innocent looking message. Given the amount of data being generated & transmitted electronically, it's no surprise that numerous methods of protecting that data have evolved. There are various types of steganography: Text Steganography: Hiding information inside the text files. This involves changing format of existing text, changing words in a text, generating random character sequences or using context-free grammars to generate readable texts. Image Steganography: Process of hiding text in an image without distorting the picture. Video Steganography: Technique to hide any kind of files into a cover video file. Audio Steganography: The secret message is embedded into an audio signal which alters the binary sequence of the corresponding audio file. Network Steganography: The process of utilizing active network protocols as carriers to transmit a covert message, undetectable by an uninformed party, From a host to its destination. This session will review these methods & also discuss relevant software.
Retirement Planning: Next Stage for You or Your Client
-
Online
2.00 Credits
Member Price: $89
If you or your clients are facing that stage of life where careers are passing into the background and a new "to be determined" life is emerging, then you are entering what is called "retirement". Some people are excited, some are scared and most are both. There are many issues and questions people face at this time - what to do with time, financial, relationships, health, identity and more. This program summarizes the key research studies, provides stories from those who have made this work and offers thoughtful, practical exercises from my award winning book NEXT STAGE. It will help you (or your clients) address key issues and develop a Master Plan for the transition. If not now, when? 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 Top 10 Celebrity Estate Mistakes & How to Avoid Them
-
Online
2.00 Credits
Member Price: $99
This course uses the lives of the rich and famous as a template to better understand the realm of estate planning. With stories ripped from the headlines, we will examine pitfalls and best practices. Did you know that Prince died without a will, opening the door for 45 people claiming to be his beneficiaries? Or that Michael Jackson was not careful in properly funding his trust, leading to delays and legal battles in the administration of his estate? Even Abraham Lincoln, it turns out, did not have a will. In discussing an array of celebrities, from Jackie Kennedy, Joan Rivers, Jimi Hendrix and Whitney Houston to Aretha Franklin, Barry White, Leona Helmsley and Florence Griffith Joyner, the course is designed as an enjoyable learning experience with tips for all levels of expertise. We may not have their fame or fortune, but we can certainly walk the red carpet when it comes to estate planning.
Audit Skills for Beginners
-
Online
4.00 Credits
Member Price: $149
Learn the basic skills new staff need to hit the ground running & efficiently complete assigned tasks, including what new auditors are expected to know & do, including the nature, timing & extent of common audit procedures. Focus on why certain procedures are performed & perform typical procedures.
Partnership & S Corporations: How to Calculate Basis
-
Online
4.00 Credits
Member Price: $149
The IRS has recently increased the pressure on how to calculate & report partner & shareholder basis. Changes in the forms reflect these developments. This program provides a detailed analysis of the calculations related to determining tax basis for a partnership interest & S corporation shareholder shares & loans. How to use the Form 1065, Schedule K-1 & Form 1120S, Schedule K-1 information for basis determination. Illustrated examples with filled in forms will demonstrate how the process works & their many potential 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 kori.herrera@acpen.com
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.
LLC's & S Corporations: a Comparative Analysis
-
Online
8.00 Credits
Member Price: $239
This course focuses on the most common aspects and tax implications of Limited Liability Companies and S Corporations. It will further compare forms of entities, along with corporate formalities compliance issues of each entity type. Electing Subchapter S status as well as reviewing the mechanics of electing Subchapter S status will be discussed. Highlights of entity specific tax forms will be discussed, as well as accountable plans, taxable fringe benefits, officer reasonable compensation, estate planning, business continuation planning and audit strategies. Schedules K-1, K-2, K-3 and effectively connected income will be reviewed in this course as well. 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 Compilations, Reviews & Preparations: Engagement Performance & Annual Update
-
Online
8.00 Credits
Member Price: $299
Specifically designed for preparation, compilation and review practitioners, this course will provide you with 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 the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will review 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 SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical and technical requirements.
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.
Effective Governance for Nonprofit Success
-
Online
1.00 Credits
Member Price: $39
Effective governance is the cornerstone of any nonprofit organization. This course delves into the foundational elements of nonprofit governance, emphasizing fiduciary duties, board responsibilities & best practices for board operations. Participants will explore key compliance requirements, risk management strategies, policy development & regulatory obligations. By the end of the session, you'll be equipped with practical tools & insights to confidently navigate the complexities of nonprofit governance.
Business Valuation: Asset Approach
-
Online
1.00 Credits
Member Price: $39
This course provides a comprehensive introduction to the business valuation process, beginning with key terminology, professional standards & the rules that guide the appraisal profession. Participants will explore the three primary approaches to value-- Asset, Income & Market-- before focusing in depth on the Asset Approach. The course examines when & why this method is used, its advantages & limitations & how to apply it effectively in real-world scenarios. Through practical examples & clear explanations of each of the three methods within the Asset Approach, learners will gain both the confidence & competence to apply valuation principles in their professional practice.
The Controllership Series: The Treasury Function Part I: Cash & Investing
-
Online
2.00 Credits
Member Price: $89
This course corresponds to our Controllership series. This course is dedicated to exploring the traditional controller role & stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we discuss the area of cash & investments & explore how the controller can move these responsibilities into more of a strategic role. In today's world, the role of cash management is often a pivotal role in the organization. In economically difficult times, controllers may find that they spend a great deal of their time on understanding & managing the organizations' cash position. This is certainly important and, in some areas, can be seen as a staple of the lifeblood of the organization's ongoing viability. This course takes a look at some of the typical objectives involved in Cash management & then evaluates how those objectives can be further stretched into strategic pillars of the organization.
Bytes, Bias & Balance: Data Ethics for Savvy Accountants
-
Online
2.00 Credits
Member Price: $89
This course explores the transformative role of artificial intelligence (AI) in accounting and auditing, highlighting its vast potential while addressing the associated risks and ethical considerations. Participants will discover how to harness AI tools to enhance efficiency and innovation, while mitigating challenges such as overreliance, data security vulnerabilities and ethical dilemmas. Through case studies and interactive discussions, you'll gain practical skills to navigate AI complexities, ensure trustworthy outputs and uphold ethical standards in today's fast-paced digital environment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Fiduciary Taxation Part III: Complex Trusts & Charitable Deduction 26-27
-
Online
2.00 Credits
Member Price: $99
During Part III, of this 4-part series, we'll focus on the accounting and taxation of Complex Trusts. Using a series of calculations, determine whether the fiduciary or the beneficiary bears the burden of taxation and if the trust or estate is treated as a taxpaying entity or a conduit. The requirements and use of a charitable contribution deduction are also reviewed and its relationship with and difference from fiduciary accounting. Be sure to register for all courses in this series: Fiduciary Taxation Part I: Introduction to Form 1041 Fiduciary Taxation Part II: Fiduciary Accounting & Simple Trusts Fiduciary Taxation Part III: Complex Trusts & Charitable Deduction Fiduciary Taxation Part IIII: Miscellaneous Topics & AMT
K2's AI Accounting And Fraud Detection
-
Online
2.00 Credits
Member Price: $89
As accounting software evolves, AI-native systems are transforming how firms manage data & measure results. This session explores emerging AI-integrated general ledger platforms such as Digits, Puzzle.io & Docyt. It examines how new technologies, like vibe coding & low-code/no-code automation, are reshaping efficiency & improving fraud detection. Attendees will learn to assess ROI across accounting tools, identify key performance metrics & develop an automation strategy that enhances accuracy, productivity & profitability. This course equips professionals to make smarter technology investments & prepare for the next wave of AI-driven accounting transformation.
Tax Practice Conduct Standards: Circular 230 & AICPA Statements 26-27
-
Online
4.00 Credits
Member Price: $175
Meet the ethics requirement while addressing significant changes in the statutory and regulatory standards that govern tax practitioners. We'll explore rules that govern professional conduct in tax practice, including responsibilities to advise clients on tax positions and related penalty avoidance. Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.