CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Taking Advantage of Array Formulas in Excel
-
Online
2.00 Credits
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
SEC Case Studies: Ethical Dilemmas in Finance and Accounting
-
Online
2.00 Credits
Overview: Ethical challenges in finance and accounting can be complex and far-reaching, impacting not only individual careers but also entire organizations and the public trust. This webinar will provide a practical exploration of the ethical considerations professionals face in today's financial landscape. Through real-world case studies, participants will examine common ethical issues, learn to navigate conflicts between financial performance and ethical integrity, and gain tools for making sound decisions under pressure. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Learning to Teach "Tax" as a Second Language
-
Online
1.00 Credits
Sometimes the vernacular of accounting seems more challenging than technical aspects. This session offers suggestions for translating the foreign language of taxation into tangible terms for non-accountants. We explore techniques for simplifying the complexity of taxation terminology. This course will equip you with tools for demystifying tax technicalities so you can help clients and other non-tax professionals grasp fundamental concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Yellow Book Ethics
-
Online
2.00 Credits
Government Auditing Standards (or Yellow Book) has a unique perspective on ethics and transparency due to accountability owed to taxpayers, oversight bodies, and others. This course will discuss the foundational principles in the Yellow Book relevant to professional conduct on related engagements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course qualifies for yellow book credit.
Coping With the Growth of Online Fraud
-
Online
4.00 Credits
Just about every company, no matter its size or the types of activities it undertakes, is at greater risk because of all the types of fraud that can be be carried out electronically. Potential perpetrators can be operating internally or externally and the scope of the damage that occurs is almost never limited to cyber-assets. While threat awareness is improving, there are still too many owners or top level executives that underestimate the scale of the issue. In this session, we delve into the types and the nature of many electronic defalcation schemes. The material then explores measures that organizations can implement to help stop these activities and add additional layers of security. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Walter Haig's Personal Financial Health Checkup
-
Online
8.00 Credits
This course has significantly changed for the better the lives of a significant number of practitioners and their clients. Participants will learn a step-by-step process for performing an annual personal financial health checkup for themselves, family members, employers, and, if in the practice of accounting, their clients. This course is loaded with practical aids to enable CPAs to help individuals get a "great" financial health checkup result! This course will enable practitioners to add a huge value to their tax preparation services. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Installment sales: Maximize Tax Benefits and Stay Compliant
-
Online
1.00 Credits
This course explores the complex rules of installment sales, with a focus on their tax treatment and strategies to maximize the benefits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Accountants and Malpractice: Can We Get Sued for This?
-
Online
2.00 Credits
This seminar reviews situations in which a CPA or accounting professional may be in danger of being sued. We cover common law causes of action, such as negligence, and the relevant standards and case law defining what constitutes reasonable practitioner behavior. This course is ideal for lawyers, CPAs, EAs, tax preparers, accountants and insurance personnel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Using e-Signature Software to Process Agreements-Updated
-
Online
2.00 Credits
Transforming your practice or business to a digital model is a journey, not a destination. There are some digital initiatives that require a great deal of time and money to deploy. There are also many "low hanging fruit" initiatives that are relatively easy and inexpensive to deploy. E-signature software is a perfect example of the latter. John Higgins, a nationally recognized leader in accounting technology, will guide you through the process of evaluating, selecting and implementing e-signature software to streamline a solution, and secure your document signing processes. You will be surprised to discover how easy it is to take your engagement letter and contract signing workflow digital. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Navigating IRS Authorizations: Form 2848 & Form 8821
-
Online
2.00 Credits
Providing a practical overview of the IRS Power of Attorney, Form 2848, and IRS Tax Information Authorization, Form 8821. Participants will explore the differences between these forms, understand when each is required, and how to comply with IRS requirements for representing clients and accessing their tax information. The course will cover practical issues, ethical considerations, and best practices for managing client authorizations through the IRS Centralized Authorization File (CAF) system. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Best Non-Google Search Tools for Accountants
-
Online
2.00 Credits
The course explains why you need more than Google to search the Internet and highlights a rich constellation of alternative search engine applications. The session also explains how to set up your own customized online research management platform, and discusses dynamic search strategies (two-step, vertical and lateral searching) that can be used to gain an extra edge when using any search engine. Participants will walk away with scores of new knowledge sources and streams that will complement their use of Google and improve their online research power. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Build a Data Model for Analysis in Power BI
-
Online
4.00 Credits
This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Financial Decisions that Led Two Businessmen to Prison
-
Online
2.00 Credits
Two college graduates built impressive careers: One worked in sales, the other in technology and investing. Both of those people made decisions in the course of their business that led to government investigations. They had to hire attorneys, go through judicial processes, face charges, and plead guilty. Each of those people are on their way to prison. Learn from the lessons they offer. We interview both financial professionals, and they tell us more about how their decisions influenced the consequences that followed. 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
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.
Retirement Planning: Next Stage for You or Your Client
-
Online
2.00 Credits
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.
Accounting of the Soul: Making the World a Better Place
-
Online
1.00 Credits
This workshop explores how each of us can play a part in helping to make the world a more fair and gentler place. This one-hour webinar includes an overview of Aristotle's virtue ethics and its application to present day life. We will focus on the virtue of compassion both individually and organizationally and its impact on individual, organizational and world wellbeing. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
A Working Parent's Guide to Prioritizing Mental Wellness
-
Online
2.00 Credits
Balancing the demands of a career and family life is a challenge faced by many working parents. The pressure to excel at work while being fully present at home can leave little room for self-care, often leading to burnout and mental fatigue. This course is designed to address these challenges head-on by providing actionable strategies to prioritize your mental health and overall well-being. The course emphasizes practical, easy-to-implement techniques tailored for busy working parents. From setting boundaries to prioritizing sleep and physical activity, you'll learn how to create sustainable habits that enhance your well-being. You'll also explore how to recognize the signs that additional support -whether from friends, family, therapy, or other resources- is necessary, and how to seek help without guilt or hesitation. Ultimately, this course will help you regain a sense of balance and control in your life by equipping you with tools to manage stress, build resilience, and rediscover joy in both your professional and personal roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
AI for CPAs - How it Works and How to Apply it
-
Online
4.00 Credits
Generative AI tools such as ChatGPT, Microsoft Copilot, Google Gemini and many others are transforming the digital landscape of virtually every business, including CPA firms. We will demystify the complex world of generative AI in this informative session designed specifically for CPAs. We will break down the nuts and bolts of how generative AI works, making the technical aspects accessible and relevant. Equip yourself with the foundational knowledge to leverage AI in your practice or business. You will learn multiple examples of how you can apply generative AI tools in accounting, finance and tax to boost your team's productivity and improve the quality of your work product. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Hot Topics Audit & Attest Update
-
Online
2.00 Credits
Many public accountants desire to have a quick overview of only the most current changes to professional and ethical requirements. This course will provide an executive summary of the major changes in audit and other attest requirements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2025 AICPA Regulatory Ethics Update
-
Online
2.00 Credits
The Professional Ethics Executive Committee (PEEC) of the AICPA has been very busy issuing new and updating existing ethics rules. This course will provide an overview of recently issued and soon to be effective ethics rules that CPAs in both industry and public accounting need to know to be compliant. 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 to answer your questions during the event.