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.
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.
Ethical Considerations in Working with Cannabis
-
Online
1.00 Credits
This session will explore the ethical considerations CPAs and CPA firms should be cognizant of when considering services to the state legal, regulated cannabis industry. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Donating Cryptocurrency and Avoiding Traps for the Unwary
-
Online
2.00 Credits
As the digital asset market continues to mature, more taxpayers may be contemplating blessing their favorite charitable organizations with gifts of cryptocurrency. Beneficiaries unfamiliar with digital assets may find it challenging to properly report any of these types of donations. Likewise, taxpayers will need to ensure that they properly value and substantiate any contributions or potentially risk their charitable deductions being denied. This course will provide a brief overview of digital assets. This will be followed by a discussion of the rules regarding the documentation required when claiming a charitable contribution of digital assets. This course will also cover recent IRS publications and cases discussing taxpayers whose deductions of digital assets charitable gifts was scrutinized. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
A&A Update for Nonprofits and Single Audit (2025)
-
Online
8.00 Credits
This course provides a high-level overview of the most important accounting, financial reporting, compliance and audit issues facing nonprofit entities and their accountants. The focus is on explaining the basis behind major issues and trends in executive summary (yet practical) form, enabling professionals to understand the most important aspects of relevant standards, and the basis for any potential changes on the horizon. 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.
Operations Level Internal Control
-
Online
4.00 Credits
Many leaders in business organizations of all sizes view the system of Internal Control almost purely as a protective security measure. A well-designed internal control system can and will drive all entity objectives which includes successful operations. This session uses information gathered from years of creating internal control systems as well as concepts from well-respected authoritative pronouncements and frameworks to illustrate the power of a strong and well supported control system as well as actions that can help establish such a system. Those that work with internal controls who are tasked with developing ways to improve operation level capabilities should strongly consider this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
1040 Tax Prep Automation with AI Tools
-
Online
2.00 Credits
There has never been a greater opportunity to leverage technology tools to automate various aspects of 1040 tax preparation. This course will provide specific examples of how you can use AI (artificial intelligence) based tools to complement your core 1040 tax prep software. You will learn how to leverage AI to automate the collection and organization of client source documents, enhance the engagement management process and add value to your 1040 service through AI enhanced 1040 advisory services. This course will separate the hype from reality about AI and how it can be used in 1040 tax preparation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Comprehensive Audit & SSARS Update
-
Online
4.00 Credits
This course covers recently issued standards from the AICPA Auditing Standards Board and AICPA Accounting and Review Services Committee including the new Quality Management Standards. The session will highlight projects in progress at the Public Company Accounting Oversight Board, and International Auditing and Assurance Standards Board. The course will also recap recent changes and present common peer review findings and best practices to improve practice quality. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Get started with Power BI
-
Online
2.00 Credits
Embark on a journey to master Power BI, a powerful tool for data analysis and business intelligence, in our comprehensive course, "Get Started with Power BI." This course is meticulously designed for professionals who seek to understand the full spectrum of Power BI capabilities, including its integration with Excel's Power BI features like Power Pivot and Power Query, and its comparison with standalone Power BI tools such as Power BI Desktop, Power BI Service, and Power BI Report Server. In the first part of the course, participants will be introduced to the fundamentals of Power BI. This includes an overview of Power BI's interface, key features, and its seamless integration with Excel. The course will cover Excel's Power BI tools - Power Pivot, for advanced data modeling, and Power Query, for efficient data transformation and preparation. This segment is essential for understanding how Power BI extends and enhances the data processing and analytical capabilities of Excel. The second section of the course delves into the standalone Power BI tools. Here, participants will explore Power BI Desktop for creating complex data models and sophisticated reports, Power BI Service for cloud-based collaboration and sharing, and Power BI Report Server for on-premises report deployment. This part of the course will focus on the unique features and strengths of these standalone tools, providing attendees with the skills to leverage Power BI in a variety of business contexts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
CFO Series: Enterprise Risk Management Implementation Keys
-
Online
2.00 Credits
Every organization faces risks, but successful organizations identify, monitor, and manage risks before they become real. This seminar will help you understand Enterprise Risk Management (ERM) and help you confidently implement an ERM framework in your organization. This seminar will explore what ERM is, why it is crucial, and how you can seamlessly integrate it into your strategic planning. We will discuss a route map of how to implement an effective ERM program without disrupting the organization by building ERM practices into everyday management and planning.
ChatGPT Vision for Financial Analysis
-
Online
2.00 Credits
This course offers an in-depth exploration of the "vision" capabilities of ChatGPT specifically tailored for accountants. The session demonstrates how artificial intelligence can interpret and analyze visual content to revolutionize financial management. The curriculum covers a wide range of applications, from understanding GPT Vision and its unique benefits to leveraging aerial and street view imagery for comprehensive financial analysis. Through detailed case studies, participants will learn how to access and utilize GPT Vision effectively, incorporating it into tasks like data visualization, text and object recognition from images, and the use of descriptive, diagnostic, predictive, and prescriptive (DDPP) analysis methods to enhance decision-making processes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Mastering Partnership Basis: Inside and Outside Basis
-
Online
2.00 Credits
This course will provide a detailed analysis of how to determine a partner's tax basis for a partnership interest, with an explanation of the use of both "inside" and "outside" basis determination. An illustrated example with filled in forms will demonstrate how the process works and the potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Behind the Curtain: Exploring IRS Audit Technique Guides
-
Online
2.00 Credits
Have you ever considered a tax audit from the perspective of an IRS examiner? This session explains how you can use IRS Audit Technique Guides (ATGs) to enhance tax compliance. You will obtain a glimpse of the audit process from the viewpoint of an IRS agent as we explore insights that the IRS provides to its own examiners. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethical Performance Management
-
Online
2.00 Credits
Today, more than ever, effective performance management is critical to the well-being of an organization, as well as the engagement and satisfaction of staff. Unfortunately, performance management is also often one of the most dreaded responsibilities managers face. This session will provide insight into what performance management is, how to prepare and conduct performance appraisals, how to coach the marginal employee, legal considerations to be aware of when conducting an appraisal, and ways to engage and motivate staff. In addition to providing tools to conduct effective appraisals, we will also look at the ethical implications of employee reviews. When done well, performance management has the power to improve communication between managers and their staff as well as help foster stronger career paths and routes for growth. It can motivate, re-engage, and energize everyone involved. Ethical values such as fairness, accountability, respect, intellectual honesty, and trust will be incorporated into this session. 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 Double Your Firm's Revenue Through CFO and Advisory
-
Online
1.00 Credits
In this webinar, accountants will discover how to double their firm's revenue through CFO and advisory services. Many accounting firm owners are stuck in what we call The Accountant's Trap. It's where the firm owner is trapped working for low fees, dealing with high-demanding clients, all the while being burnt out on compliance and transactional work. To make matters worse, these firm owners can't raise their fees because there is always another accountant or bookkeeper willing to do the work for less -- not to mention all the tech companies trying to get into our space. Does this sound familiar? If so, this webinar is for you. This course is for any practice owner looking to transform their practice - and double their revenue - by offering a productized CFO/Advisory service. We'll cover the systems you need to transform your practice and the services you should offer to double your firm's revenue. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Everyday Ethics at Work: Don't be the Next News Story!
-
Online
2.00 Credits
When asked, most people would say they are an ethical person. So why is it that every month there are reports of ethical breaches at major companies? The concept of ethics is easy to understand, easy to talk about, but incredibly hard to implement on a consistent basis. In this course, we will discuss current ethical issues, and walk-through a nine-step ethical decision-making model. 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.
Exercise Your Ethics: Techniques to Improve Ethical Response
-
Online
2.00 Credits
Many courses highlight ethical failures - this course goes beyond that. This course identifies the many barriers to ethical behavior, focuses on habits and techniques that improve ethics and offer ways to practice so that the ethical "muscle" is ready for any dilemma. This course incorporates ideas from leading ethical authors and includes data from the ACFE Report to the Nations. 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.
Technology Trends Update for CPAs with John Higgins
-
Online
4.00 Credits
Join us for an enlightening presentation where we delve into the pivotal technology trends reshaping the accounting profession. This course covers an array of topics including cloud computing, big data, data analytics, Robotic Process Automation (RPA), Machine Learning (ML), Artificial Intelligence (AI), cryptocurrency, blockchain technology, and the metaverse. We will also cover provide an update on the current market for cloud based accounting / ERP and personal productivity software. Designed for forward-thinking professionals, this session offers insights into how these technologies impact your business, your firm, your clients and most importantly, your career. Stay ahead in your field by understanding these emerging technologies and their practical applications in business. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.