CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Cases in Corporate Ethics: Discuss Real Life Conflicts
-
Online
4.00 Credits
If you have ever had someone just read you the rules in an ethics class, you know there is a better way. Cases in Corporate Ethics reviews 10 real life cases and puts you in the position of someone in the middle of it all. You'll learn about conflicts that corporate financial professionals often encounter, you'll gain skills for dealing with a boss who is behaving badly and find out where to go for help. Once you have studied ethics using real world cases, you'll never want to do it any other way. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Power BI - Advanced Data Analytics with Power Pivot
-
Online
8.00 Credits
This fast-paced course focuses on using Excel Power Pivot features to enhance data analysis. One of the strengths of Power Pivot is the formula language DAX (Data Analysis eXpressions). We will spend considerable time using the power of DAX to create meaningful calculations that add new dimensions to our data. We will also review the use of a date or calendar table that allows us to perform date analysis that was never possible before. This will allow us to use the new time-intelligent functions to perform complex calculations on our data such as: month-to-date, quarter-to-date, year-to-date, last year same period, last year-to-date, etc. We will also demonstrate the hottest tips and tricks that will take your data analysis to the next level. Although our focus will be on using Power Pivot, we will review some of the other Power BI Tools including: Power Query (Get & Transform), Power BI Desktop and Power BI Services (PowerBI.com). NOTE: If you want to apply the concepts presented, you will need Excel 2013, 2016 or 2019/Office 365 AND the Power Pivot add-in pre-installed. To see our full prerequisite recommendations, see PROGRAM CONTENT section below. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
How To Use Microsoft 365 Forms to Create Online Surveys
-
Online
1.00 Credits
When you need to create a simple survey or form to capture data online, the Microsoft 365 Forms app can be just the right solution. You can use it for simple forms such as a client information form or client service evaluation form. You can create more sophisticated forms, such as a client tax organizer. All responses can remain confidential and can be viewed in Excel format for further analysis or to prepare the form data for import into another application. This course will take you through the step-by-step process for creating, distributing, compiling and analyzing digital forms and surveys. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethics and Technology for CPAs
-
Online
2.00 Credits
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.
The Omniverse and Metaverse for Accountants
-
Online
2.00 Credits
This course provides a concise overview and non-technical explanation of the Omniverse and Metaverse - a shared virtual space that integrates various virtual, augmented, and actual realities. While futurists have been predicting and describing this concept for decades, interest and investment in this platform have recently exploded. Facebook has changed its very name to Meta - as in Metaverse - to reflect its pivot from a social media company to a virtual space company. Other tech companies, big and small, have announced ambitious plans to enable people to access digital environments and experiences through different devices. While sometimes perceived as science fiction, the metaverse is no entertainment gimmick. A growing consensus is that it will be the successor to the mobile Internet, and fundamentally transform the Internet, and perhaps even reality itself. You'll walk away with a foundational understanding of how the metaverse is transforming the modern business world, and how accountants can position themselves for success in this emerging economic digital dimension. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Moving Away from Time-Based KPIs: Five P's to Get You There
-
Online
2.00 Credits
We all know that measuring performance and pricing your services based on time isn't ideal. Pricing and billing based on time doesn't allow you to capture the full value or risk of your work, and automation and increased efficiency could lead to an unintended consequence of reducing firm fees. Yikes! Yet changing this fundamental business-model construct can seem overwhelming and it's hard to know where to start. In this session, we'll examine five "P" elements needed to make the gradual, but definite, move away from the outdated time-based paradigm and move toward a truly results-based model.
Why Cybersecurity Matters to CPAs
-
Online
2.00 Credits
CPA's are responsible for understanding (1) the presence of fraudulent activity, (2) that financial reports are complete and accurate, and (3) applying the going concern principle to a business. Appropriate cybersecurity controls, processes and oversight directly impact these three areas. Fraud Bad actors can exploit systems with weak security controls to perform fraud. The increasing prevalence of hacked systems reflect this. Bad actors are stealing data, intellectual property, financial assets, and other information. Digital fraud is becoming more prevalent and can be substantially more damaging than historical types of fraud. Not only can digital fraud result in financial loss, but it can subject companies to expensive lawsuits, damage reputations and can even put a company out of business. Complete & Accurate Financial Reports Having cybersecurity controls on systems and networks is critical to ensure information reported in financial statements is complete and accurate. Data residing in financial reports is processed, stored and transmitted using IT Systems. It is important for CPA's to understand the required cybersecurity controls to prevent or detect inaccurate data in financial reports. Going Concern With an increasing volume of system hacks (e.g. Target, Experian, Sony, and most recently the US Government), it is no longer "if" you're going to get hacked, it is "When." If organizations do not have appropriate cybersecurity controls in place to protect against an attack, then a malicious hack can put them out of business. An organization's cybersecurity posture should be a factor in evaluating the Principle of Going Concern. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 201: Fraud Risk - Minimum Audit Requirements
-
Online
2.00 Credits
Fraud Risk - Complying with Minimum Audit Requirements will highlight the audit procedures most effective in identifying, assessing and responding to fraud risk. The financial statement auditor's overall responsibility is to obtain sufficient appropriate audit evidence to provide reasonable assurance as to whether the financial statements are materially misstated due to fraud or error. The difficulty is that there are inherent limitations related to detecting fraud due to deliberate schemes to conceal the intent to deceive, such as collusion. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Becoming a Fraud Investigator
-
Online
2.00 Credits
The course helps the forensic accountant prepare to perform a fraud investigation. We discuss occupational fraud schemes and their characteristics, and how to spot a fraud in progress. You will learn the skills a fraud investigator needs for successful investigations, as well as how to plan and prepare for a fraud investigation. This is the most practical fraud investigation course you will ever take. Rather than learning only the theory of fraud, you will learn how a forensic accountant actually investigates fraud from the beginning to the end. We focus on forensic accounting techniques used in the field to prove what happened, who was involved, how much money was stolen, and where the money went. Becoming a Fraud investigator is Part 1 of a series of four courses on fraud investigations. Each course is a stand-alone class that may be taken individually. For comprehensive instruction on completing a fraud investigation from start to finish, take all four. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethics: Environmental, Social and Governance for Accountants
-
Online
2.00 Credits
The course provides a concise overview of Environmental, Social and Governance (ESG) reporting -- an emerging system of non-financial record-keeping and governance. Around the world, organizations of all sizes and kinds are under increasing pressure from regulators, consumers, employees, and other stakeholders to provide a fuller and more integrated picture of the way in which entities operate, invest, and create value. This includes taking into account how their operations impact financial, manufactured, intellectual, human, social, relationship, and natural capital. Participants will walk away with an increased situational awareness of ESG reporting, and an ESG starter strategy. This can be used immediately to position themselves for ESG success in an era of growing expectations for conscious capitalism, ethical investing, and moral leadership. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Coaching the Next Generation of CPAs
-
Online
2.00 Credits
Attracting and retaining staff is critical to an organization's success, especially in the age of the millennial worker who will change jobs multiple times in the course of a career. This course will focus on best practices for nurturing the human element of your organization, especially millennial workers who comprise a growing percentage or the workforce. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel - Advanced Financial and Statistical Calculations
-
Online
2.00 Credits
Depending on your version, Excel has over 500 functions already built in and ready to use. How many of those do you incorporate into your spreadsheets? After this course, you will learn some powerful functions that will take your calculating power to the next level. In this webinar, we will focus on Financial, Statistical and Math functions. In the Financial functions section, you will learn how to use the financial functions to build better amortization schedules. In the Statistical and Math functions sections, you will learn how to use various statistical functions to analyze your data. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 202: Applying Audit Risk to the Detailed Audit Plan
-
Online
2.00 Credits
Best Practices for Identifying and Evaluating Audit Risk - Linking Risk to the Detailed Audit Plan will emphasize the key concepts and best practices that drive a thoughtful risk-based approach to forming an opinion on the financial statements. Properly identifying, assessing, and responding to risk through a detailed audit plan is critical to an effective and efficient financial statement audit. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff, while it is also appropriate for anyone who has the need to better understand how to link risk assessments to the detailed audit plan. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Yellow Book Update
-
Online
2.00 Credits
More and more entities need Yellow Book engagements, including a growing number of for-profit entities. In this course, we will review the unique independence requirements in GAGAS. We'll also review the recent changes to quality management in Yellow Book. We'll close with a reminder of common deficiencies found in Yellow Book engagements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
CPA Ethics in a Crisis World: Tales From the Front
-
Online
2.00 Credits
Based on real life experiences! This program addresses the many issues impacting CPA practice with a world in crisis. The unique challenges facing practitioners are related through actual practice situations - and then analyzed for their ethical implications. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Taxation of Judgements and Settlements
-
Online
2.00 Credits
In the course of legal actions, payments may be made pursuant to a final disposition of a court case or a mutually agreed-upon settlement. This course will cover the tax implications for payments made for personal injury, emotional distress, lost wages, punitive awards, pre- and post-judgement interest, contract claims, among other damages. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Mail Fraud and Wire Fraud: Why Business Owners go to Prison
-
Online
2.00 Credits
When federal prosecutors contemplate charges against business owners, two of their most potent and readily available tools include charges for mail fraud and wire fraud. The elements to convict for these crimes are clear: 1) The defendant devised or intended to devise a scheme or artifice to defraud, and, 2) in executing or attempting to execute the scheme, the defendant used or caused the use of mail or an interstate wire or wireless transmission. Mail, emails, cell phone calls, text messages, Internet transmissions, and even tweets could form the basis for charges of wire fraud or mail fraud. The crime of wire fraud is a reason that many business owners go to prison. In this course, we'll learn about a few people who've experienced a conviction for wire fraud. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
IRS Revenue Officers, Field Collection, and Best Practices
-
Online
1.00 Credits
You've probably been there. You have a client in your office with excess baggage. That's right, they're in field collection with a Revenue Officer. Now what are you going to do? How are you going to get where you want to be? This program will provide an overview of field collection, how to effectively work with Revenue Officers, general case processing, and important IRM deadlines. This will include taking a deep dive into the "RO Mindset" along with structuring your casework to flow with IRS case processing actions so you can get to the outcome you want. 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 For An IRS Levy Or Wage Garnishment
-
Online
1.00 Credits
You are likely familiar and/or have experience with IRS levies and wage garnishments. BUT - Did you know that there's a lot of technicalities and procedural requirements that go into issuing an IRS levy or wage garnishment that you can exploit as a practitioner? This program will focus on the basics of an IRS levy or wage garnishment along with breaking down common errors that IRS employees tend to make in the issuance of a levy and remedies that can be used to obtain relief from a levy or wage garnishment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Communicating Financial Information to Non-Accountants
-
Online
2.00 Credits
Do you ever get blank looks when you present your company's financial statements? Does your board nod knowingly, during your presentation, but never seem to have any meaningful questions? It could be that they have no idea what you are talking about and are just pretending to understand! Learn how to connect with your CEO, board, fellow managers, and ordinary employees so they understand your message. Learn to motivate them to action. Come hear a veteran CFO tell you how. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.