CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Clean, Transform & Load Data in Power BI
-
Online
2.00 Credits
This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
IRS Penalties and Abatements
-
Online
2.00 Credits
Penalty abatement is a technique that tax practitioners can utilize to help their clients reduce penalties and interest they owe to the IRS if the taxpayer can prove "reasonable cause". This informative and insightful webinar will provide you with some insider tips, practical steps and effective strategies to help your client manage IRS tax penalties and interest. Learn about various types of penalties that you may face, and the various forms and procedures used for requesting penalty and interest abatement, including First Time and Reasonable Cause abatement. Plus, learn about the procedure to follow when requesting refund of paid penalties. 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.
Cyber Attacks Through Impersonation
-
Online
1.00 Credits
This course describes how cyber attacks through impersonation are conducted. It also provides practical advice and recommended security controls to implement, reducing the likelihood and impact of an impersonation cyber attack. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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.
Walter Haig's Business Financial Health Checkup
-
Online
8.00 Credits
This course fills an important need for both financial managers and accountants in the practice of public accounting by offering the tools to help ensure the future success of a business. Practical guidance for the effective use of benchmarking and analytical procedure is also provided. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 407: Auditing Contingencies and Going Concern
-
Online
2.00 Credits
Auditing Contingencies and Going Concern Uncertainty - Testing for Completeness and Proper Disclosure will provide tips and techniques for obtaining sufficient appropriate audit evidence to support conclusions related to contingencies and going concern uncertainty. Financial statements may contain significant uncertainties requiring special audit consideration for evaluating proper accounting and financial reporting treatment. Note: This course is recommended as a part of a 16-hour audit skills curriculum for supervisory or managerial auditors, while it is also appropriate for anyone who has responsibilities for evaluating loss contingencies and substantial doubt about 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.
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.
Ethics of AI: A CPA's Guide
-
Online
2.00 Credits
The practical application of artificial intelligence (AI) in the accounting profession is spreading like wildfire with the release of powerful applications such as ChatGPT. A byproduct of this evolution is the origination of new ethical dilemmas for CPAs on how to address the use of this technology in the delivery of their services. This course, presented by John Higgins, CPA, a nationally recognized technology advisor to the profession, will provide CPAs with a practical framework for addressing the various ethical issues that can arise with the application of AI in their work. 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.
Advanced ChatGPT for Accountants
-
Online
2.00 Credits
This course concisely explains the latest "see, hear, speak" multi-modal updates to ChatGPT and how they can be used in an accounting context. New features include vision processing, voice conversation, image generation, real-time Internet access, advanced data analysis, plugins and more. Discover how this technology can be used in mind-blowing ways to analyze financial data, optimize processes, and solve problems in the accounting domain. Through the lens of ChatGPT, practitioners can explore innovative solutions, automate routine tasks, and generate deeper insights and value to their clients and organizations in previously unimaginable workflows. You'll walk away with scores of advanced ChatGPT strategies and tips that can be immediately applied and deliver instant results to elevate the efficiency and effectiveness of your accounting projects and tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 408: Coaching Staff to Stay on the Right Track
-
Online
2.00 Credits
Supervisor Skills - Coaching Staff to Stay on the Right Track provides tips and techniques for critical coaching responsibilities. Being a successful coach requires tackling various responsibilities, including motivating, providing positive and constructive feedback, and otherwise getting the best performance out of engagement team members in the given situation. Note: This course is recommended as a part of a 16-hour audit skills curriculum for supervisory or managerial auditors, while it is also appropriate for anyone who has responsibilities for coaching others. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Implementation Challenges with the New FASB Lease Standard
-
Online
2.00 Credits
Learn the basics of FASB's Accounting Standard Update for Leases (ASC Topic 842), the key differences between ASC Topic 842 and ASC Topic 840, Leases, and the practical challenges and complexities within the new standard and how they apply to you. We will focus on lessee accounting, and will discuss key issues within the standard, required analyses, critical judgments, policy elections, disclosures, and the lessons learned from public filings. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event
Tax Depreciation: Review and Update
-
Online
2.00 Credits
A discussion of recent law changes that impact capitalization, depreciation, and disposition of assets. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Data Analytics: Practical Insights for Today's Accountant
-
Online
2.00 Credits
This session explores tools and techniques that can enhance the efficiency and effectiveness of client engagements and business processes using data analysis tools. We will introduce some of today's popular and software tools and examine the AICPA's Five-step approach to incorporating data analytics into public accounting engagements. 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.
Using ChatGPT with Excel
-
Online
2.00 Credits
In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Controls to Secure the Growing Digital Footprint
-
Online
4.00 Credits
The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they, and their companies secure digital information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
S Corporations: Calculating Shareholder Basis
-
Online
2.00 Credits
A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination. An illustrative example demonstrates how the process works, as well as the many 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.
Talk This Way - Communication Skills for the CPA
-
Online
2.00 Credits
Have you ever met an accountant who exhibits solid technical prowess but possesses lackluster communication skills? It is not unusual to meet a savvy accountant who is a technical expert but could enhance the delivery of written and spoken words. This course is designed to help CPAs improve their written and verbal communication skills. Participants will learn how to tailor communication to their audience, with particular emphasis on techniques for crafting a message that effectively conveys technical information in an engaging manner. The course's author will share personal success tips gleaned from more than two decades of experience communicating myriad topics to a variety of audiences. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.