CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Mastering the Excel Lookup Functions
-
Online
2.00 Credits
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Money Laundering 101 for CPAs
-
Online
4.00 Credits
CPAs spend most of their working lives reviewing bank statements and books and records of businesses. They are experts in understanding how to prepare financial statements according to GAAP. But would a CPA know a possible money laundering transaction if they saw it? Would they know about a money laundering business? Money laundering is a subject of many action and thriller movies, but rarely understood. This presentation will educate the CPA in understanding the basics of money laundering and how to identify money laundering. This presentation will help the CPA know the truth about money laundering, how to identify it, the statutes that define it, and the court cases that interpret it. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Hold Your Horses! How Landmark Fraud May Have Been Avoided
-
Online
2.00 Credits
What can we learn from one of the largest municipal frauds in U.S. history? Rita Crundwell stole nearly $54 million from the citizens of Dixon, Illinois over the course of two decades. This course examines circumstances that allowed this landmark fraud to occur. We will explore internal control deficiencies and other circumstances that hindered prevention or timely detection of Rita's scheme. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The CFO Who Went to Prison
-
Online
2.00 Credits
Joshua, a CFO from Chicago, did not go to prison for stealing the $2 million in liquid cash he had access to on a daily basis. Instead, Joshua ended up in prison by rationalizing that he was entitled to a few small perks of the profession. This course explores Joshua's story and covers how and why executives with high annual incomes make short-sighted decisions that can cost them their job and freedom. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 304: Auditing Basic Investments - Common Risks
-
Online
2.00 Credits
Auditing Investments - Understanding Risks and Procedures for the Most Common Investments will provide an overview for evaluating the proper recognition, measurement and disclosure of the most common investments types. Many small- and mid-size entities hold less-complex investments, including mutual funds, 'plain vanilla' derivatives (such as interest rate swaps), and permanent life insurance policies. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for auditing common investments. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Key Cybersecurity Controls for CPAs
-
Online
2.00 Credits
This course will provide overview of key cybersecurity security domains that CPA's should evaluate in an audit. It will provide an overview of each security domain, and an overview of how to evaluate and assess the sufficiency of the cybersecurity control. Examples of security domains that will be covered include: Change management Access management Data integrity This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Emotional Intelligence: The Critical Factor in Success
-
Online
2.00 Credits
Emotional intelligence is an individual's capacity to understand both their own and other people's emotions, as well as how to react to these feelings in an appropriate manner. Research proves that Emotional Intelligence (EI) is a compelling predictor of personal, professional and social success. Every business leader can improve their Emotional Intelligence, including you. Many businesses utilize EI for promotions and hiring. This session will discuss the twelve keys to EI and proven tactics to help every aspiring leader "work smarter". This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel - Using Charts for a Non-Financial Audience
-
Online
2.00 Credits
This webinar will show you how to use Excel's charting and formatting features to present financial data to a non-financial audience. As the saying goes, "A picture is worth a thousand words." People tend to better understand your point when visuals are used. We will explore the many capabilities of presenting your data without showing rows and rows or columns and columns of data. Help your audience visualize the meaning of the data, whether it is a trend, an exception, a distribution or a good vs. bad relationship. 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.
Engagement Management with the Microsoft 365 Planner App
-
Online
2.00 Credits
Are you using Excel to keep track of progress and task completion for your engagements? Or, are you using a sophisticated engagement management app that takes too much time or requires too much information to keep your task completion progress up to date? Worst of all, are you relying primarily on email communications to keep track of your engagement task completion progress? If any of these scenarios apply to your practice, this course will show you a better way to manage engagements from simple 1040 tax preparation to comprehensive audits. The Microsoft 365 Planner app, which you are likely already paying for as part of your Microsoft 365 subscription, provides a comprehensive, yet simple solution for all of your client engagements and internal projects. John Higgins, a nationally recognized strategic accounting technology advisor will guide you through the process of how to deploy this app to effectively manage all your projects. This app is effective for sole practitioners and firms of all sizes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Long-Term Care Insurance: Make the Switch
-
Online
1.00 Credits
How to pay for the cost of long-term care remains a primary concern for most clients over the age of 50. Explore clients' motivations, misconceptions and objections to purchasing long-term care insurance, and a look at the latest long-term care solutions, including hybrids. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
I Spy with My Little Eye ... an Illegality
-
Online
1.00 Credits
In the fight against global corruption, accountants are being asked to be more forthcoming when they discover information or evidence that points to illegal or prohibited activities. This ethics workshop considers new international professional ethics proposals for responding to non-compliance with laws and regulations (NOCLAR). This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Why People Are Irrational, Biased and Emotional With Money
-
Online
2.00 Credits
In this course, we will explore the psychological and behavioral factors that contribute to irrational and biased money decision-making. We will examine the role of cognitive biases and emotions in financial decision-making, and discuss strategies for overcoming these biases to make more rational financial choices. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Office 365 Teams App - Optimizing Your Setup & Configuration
-
Online
4.00 Credits
If you are familiar with the Office 365 Teams app, you know it is an extremely powerful tool to transform the way you communicate, collaborate and share knowledge. What you may not know is how to configure Teams to optimize your ROI and how effectively your team members use it. This course takes you on a tour of the important setup and configuration settings you need to be familiar with to ensure the best Teams experience for your organization. Whether you are already using Teams, in the process of deploying it, or are contemplating whether or not to bring it into your organization, this course will prove to be invaluable. The information shared in this course is sure to help you avoid costly mistakes in your Teams app deployment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Financial & Tax Accounting for S Corporations & Partnerships
-
Online
8.00 Credits
This program compares and contrasts the financial and tax accounting differences of partnerships, LLCs, and S corporations, as well as discuss the tax accounting for these entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethics - Regulatory and Standards Update
-
Online
2.00 Credits
Stay current on recent changes to the AICPA Code of Professional Conduct and keep abreast of emerging trends in ethics standards and regulatory initiatives and their potential impact on your practice. Explore frequent practitioner ethics compliance challenges, including competence, due professional care, audit quality, and independence. 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 Civility in the Workplace
-
Online
2.00 Credits
The issue of civility, or lack thereof, has garnered much attention from leaders, Human Resource professionals and employees at large. The cost of incivility is high not only to the bottom line but to the human spirit. This webinar, based on ethical principles and values, is designed to look at the fundamental relationship skills that foster workplace civility. Understanding that workplace civility is far more than manners, we will dive into behaviors that help promote a workplace where each individual feels respected and valued. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel - Create KPI Dashboards for Maximum Impact
-
Online
2.00 Credits
Most accountants use Excel to help them make decisions about their data. However, as the amount of data grows, it becomes difficult to make strategic decisions based on rows and rows and columns and columns of data. In this course, you will learn how to build robust dashboards for analyzing key metrics in Excel. We will begin with some dashboard design guidelines, such as understanding your audience and identifying necessary metrics. Then, we will work through importing data, setting up calculated fields and columns, and creating key performance indicators (KPIs) for the dashboards. You will learn how you can add charts and eye-catching visuals with Power View, in order to make your dashboards easily understood. 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 305: Strengthening Substantive Analytic Procedures
-
Online
2.00 Credits
Substantive Analytic Procedures - Strengthening Evidence to Satisfy Audit Objectives will provide the tips and best practice techniques for strengthening substantive analytic procedures in order to reduce over-reliance on tests of details. One of the ways to perform a more effective and efficient audit is to maximize the use of substantive analytic procedures in the detailed audit plan. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for analytical procedures. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
A Culture of Regulatory Ethics: A Competitive Advantage
-
Online
4.00 Credits
In a competitive market, every company is looking for anyway to differentiate themselves from their competition. While we often look to new markets and data for a competitive advantage, ethics can be the factor that makes the biggest difference to customers, employees, and the public at large. Using surveys, research, case studies, and examples, this course will explore why the CPA credential and the AICPA Code of Professional Conduct is so different. We will discuss why CPA's are in a unique position of trust and how this can put their companies ahead. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Dark Web & Cybersecurity for Tax and Accounting Pros
-
Online
2.00 Credits
This course provides a concise overview of the Dark Web, a part of the internet that isn't indexed by search engines, and is often associated with anonymous transactions and nefarious activities. Discover the leading threats and risks that the Dark Web poses to accounting firms. Explore how practitioners can effectively mitigate the risk of data breaches, ransomware attacks, financial fraud and other risks connected to the Dark Web. You'll walk away with a foundational understanding of leading cybersecurity strategies that can help you maintain client trust and protect your firm's sensitive data in this complex and ever-changing threat landscape. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.