CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Fraud & Embezzlement: Case Studies from the Trenches
-
Online
2.00 Credits
Governmental entities are the second largest victims of embezzlement. This seminar examines recent events involving theft of public money and circumstances that allowed the fraud to occur. Case studies we examine include the 2012 $54 million embezzlement from the City of Dixon by Rita Crundwell. The events that impacted the small Illinois town of 16,000 residents was the largest governmental fraud case to date, and spanned an astonishing 20 years. This remarkable story inspired an award-winning documentary, "All the Queen's Horses." We will also examine factors that led to scandals involving the Baptist Foundation of Arizona, World Com, Collin Street Bakery and the Ohio American Cancer Society, among others. This course is ideal for CPAs, government finance personnel, all Internal Auditors, lawyers, governance professionals, accountants and human resource personnel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Microsoft Teams Features Every User Should Know
-
Online
2.00 Credits
Microsoft Teams is one of the most widely used applications for communications, collaboration and knowledge sharing in business today. Most users are unaware of many time saving features available to help you manage your conversations, files and related content on a daily basis. John Higgins, a strategic advisor to the profession on Microsoft 365, will teach you how to leverage all the functionality Teams has to offer to compose, organize and retrieve your conversations, files and related content for maximum effectiveness. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
A Review of the Uniform Guidance Requirements
-
Online
2.00 Credits
The Uniform Guidance present unique challenges to auditors of governmental organizations and not-for profit organizations receiving federal financial assistance. This Guidance requires auditors to take a risk-based approach to the audit, including a methodology of determining which federal programs are considered major and therefore subject to Single Audit compliance requirements. A significant challenge facing many auditors is determining the Uniform Guidance requirements in a Single Audit. All professional involved in Single Audits must have a working knowledge of the requirements imposed by the Uniform Guidance. We will cover the issues that all auditors need to know about the Uniform Guidance requirements, including how to determine major federal programs. This course will provide example about how to comply with these requirements. 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 Start a CFO Service
-
Online
1.00 Credits
This Masterclass is a one-hour training to show accountants how they can grow their practice this year through CFO and business advisory services. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Leveraging Marketing Automation for Accounting Firm Growth
-
Online
1.00 Credits
This course will provide an overview of 6 key areas of automation that accounting firms can leverage to effectively increase their lead generation and client retention efforts while reducing the burden on their time and budget. These areas include: 1. Social media 2. Content development. 3. Email marketing. 4. Text (SMS) marketing. 5. Chatbots and other interactive AI tools. 6. Drip marketing campaigns. Attendees will receive a practical guide to the technologies and tactics needed to improve marketing efforts with efficiency and ease! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethics Case Studies: Remaining Ethical in the Age of Oversharing
-
Online
2.00 Credits
In an era when sharing a photo of lunch can be considered an "update," the ethical standards that define the CPA profession are not always as intuitive as they once were. Our expert helps you navigate this new realm by using real-world examples to help illustrate the dos and don'ts in ethical social situations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Role of Internal Control in the Risk-Based Audit
-
Online
4.00 Credits
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.
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.
Forgotten Managerial Accounting Tools for CPAs
-
Online
2.00 Credits
This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Analyzing Financial Statements
-
Online
2.00 Credits
This course provides tools and insights into financial statement analysis - both quantitative and qualitative. We'll look not only at the three main financial statements but also dive into the MD&A and footnotes. We'll also discuss the affect of industry nuances on comparability of different analysis tools. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Steps to Stop External Fraud
-
Online
2.00 Credits
Until recently, a percentage of organizations discounted the risk related to external fraud attempts. Most were only concerned with protecting physical assets such as inventory or fixed assets. However, because of the many highly publicized corporate hacking events, such as the ones that affected the Colonial Pipeline and JBS Meats, more attention is being paid to external fraud risk of all types. In this session, we look at what is included in a definition of external fraud and then delve into specific control issues that can give rise to increased risk. We then discuss measures that organizations can employ to help reduce exposure to external attacks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Monthly Federal Tax Updates - February 2025
-
Online
2.00 Credits
Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
What's Changing in A&A for Governmental Entities (2024)
-
Online
4.00 Credits
We kick off this course with a look at the GASB standards that are effective this year including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We will then switch to the audit side of the house to examine the impact of the 2024 Compliance Supplement on Single Audits and the changes to the Uniform Guidance. We close with a look at common deficiencies found in Single Audits. 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.
Sustainability: Doing Well by Doing Good
-
Online
2.00 Credits
Looking for an idea that will help recruit and retain employees, engage customers, and invite investors? Sustainability is the solution! Sustainability is no longer just a "nice thing to do," it is both a business and moral imperative. Incorporating sustainable strategies into your day-to-day operations creates a competitive advantage, enhances your brand, and benefits the bottom line. On the business side, according to Harvard University, companies with strong sustainability initiatives have 4 times the sales growth, 8 times the employee engagement, and a 47% greater increase in stock value than their non-sustainable competitors. On the moral side, your customers and employees will no longer support an organization that does not address environmental and social issues. This session will explain the 6 benefits of sustainability and 6 steps to building a sustainable business. Learn how to make sustainability a competitive advantage to attract and retain loyal customers and high-performing employees. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Project Management: Getting the Best Out of Your Team
-
Online
2.00 Credits
With capacity challenges on the mind of many tax and accounting leaders, finding ways for their teams to work more efficiently is crucial. They need their teams to not be busy, but deliver value, and continue to develop their skills and knowledge. Project Management techniques help uncover inefficiencies and gaps in current processes, as well as, manage the planning and forecasting needed to drive necessary changes for future success. In this session, learn when to incorporate project management best practices that can help you get the best out of your team.
The 10 Must Know Excel Features
-
Online
2.00 Credits
Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. 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.
Business and Government Investigations
-
Online
2.00 Credits
This course shows how undisciplined decisions in business can lead to government investigations and prison terms. We profile three entrepreneurs from three separate industries who built billion-dollar enterprises. Despite well-developed infrastructures, simple business decisions led to their being wrapped into government investigations, criminal indictments, and collateral consequences that accompany felony convictions for white-collar crime related to federal election laws, tax fraud, and securities fraud. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.