CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
The Leadership Skills of Tomorrow: Delegate and Listen
-
Online
2.00 Credits
Mastering two leadership skills will decrease your stress, and give you room to enjoy your career. Delegating and listening are key essential skills to hone to elevate your career. You were born with two ears and one mouth. And yet, good listeners aren't born. World-class listeners deliberately practice this skill, even when their audience is challenging. This is a skill which can be learned. Participants will gain awareness into their blind spots to listening, strategies to regain focus, how to stop interrupting, and demonstrate to their audience they are listening. How often have you said, "It would just be easier if I did this myself?" or "Nobody can do this task as well as I can, so I'll just do it myself." If this sounds like you, then it's time to start working on your delegation skills. Delegation is not only important as a means to save you time, but it is also about developing the next generation of leaders. 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.
Integrate ChatGPT into Your Client Advisory Services-Updated
-
Online
2.00 Credits
Two of the hottest topics in the CPA profession today are CAS (client advisory services) and ChatGPT. This course will explain how to bring these two worlds together by integrating ChatGPT and other generative AI applications into your client advisory services. John Higgins, a leading advisor to the profession on ChatGPT and a seasoned client advisor on technology based solutions, will show you how you can position your firm and yourself as a "go to" advisor on how to embrace this technology in virtually any type of business. John will address how to use this technology as a research and writing assistant in your client services and how to advise your clients on this revolutionary technology and all benefits and "gotchas" that come with it. If you want to step up your advisory game, this course is a "must take." This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Independence and Conflicts of Interest
-
Online
1.00 Credits
This course focuses on how to integrate independence and avoid conflicts of interest in situations accounting professionals face daily. Participants will be able to know not just what is the right thing to do according to the AICPA Code of Professional Conduct, but how to put values into action. As part of this course, we also walk through real-world examples of individuals and companies faced with these dilemmas. 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 Create an ROI-Based Marketing Plan for Your Firm
-
Online
1.00 Credits
This course will help you develop a strategic marketing and business development plan for your firm using 7 key principles to help maximize lead generation. You will learn how to establish and grow your B2B business in any niche using time-tested strategies, proven processes for attracting and retaining customers, and how to measure your results so you can spend your money and time effectively to own your market and attract higher ROI clients. This event may be a rebroadcast of a live event and the instructor will be available to answer 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.
Excel - Advanced Spreadsheet Troubleshooting Techniques
-
Online
2.00 Credits
Do you dread that annoying ERROR! message popping up on your spreadsheets? Tired of using the same long, elaborate formulas when you could be using the ones that are already built into Excel? Then this class is for you! In this webinar, we will focus on Debugging and Troubleshooting complex formulas. You will learn various techniques that will assist you in creating complex compound formulas. You will also learn techniques to resolve issues when you receive errors. This session will also discuss the 9 built-in error checking options and demonstrate resolution techniques. We will also review techniques to resolve rounding errors. 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.
Mail Fraud and Wire Fraud: Why Business Owners go to Prison
-
Online
2.00 Credits
When federal prosecutors contemplate charges against business owners, two of their most potent and readily available tools include charges for mail fraud and wire fraud. The elements to convict for these crimes are clear: 1) The defendant devised or intended to devise a scheme or artifice to defraud, and, 2) in executing or attempting to execute the scheme, the defendant used or caused the use of mail or an interstate wire or wireless transmission. Mail, emails, cell phone calls, text messages, Internet transmissions, and even tweets could form the basis for charges of wire fraud or mail fraud. The crime of wire fraud is a reason that many business owners go to prison. In this course, we'll learn about a few people who've experienced a conviction for wire fraud. 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.
Retaining Talent in a Competitive Marketplace
-
Online
4.00 Credits
Retaining Talent in a Competitive Marketplace -Creating a Benefits Program Employees Care About In today's competitive marketplace, retaining talented employees is becoming increasingly difficult. A solid benefits program can make a difference in the fight for talent - but only if those benefits matter to the employees you are trying to hire! Through statistics and case studies, this course will explore what benefits are most valuable to employees. We will also explore the basic types of retirement and health insurance plans and discuss what financial leaders should consider before adopting a benefits package. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 203: Auditing Accounts Receivable - Common Risks
-
Online
2.00 Credits
Auditing Accounts Receivable - Focusing Procedures for Testing Existence and Valuation will explain tips and best practice techniques for auditing common accounts receivable risks, primarily focusing on existence and valuation. Accounts receivable tends to carry higher risk of material misstatement due to the complexity and subjectivity involved with initial recognition, subsequent measurement, and valuation. In addition, revenue recognition is presumed to be a significant fraud risk. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for auditing accounts receivable. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Data Visualization and Mapping Tools for Accountants
-
Online
2.00 Credits
The course provides a concise overview of more than 200 data visualization tools which can be used by accountants to enhance the visual appeal of their financial work. All resources are easy-to-use web-based applications that require virtually no artistic or design skill - simply drag and drop, point and click, cut and paste, and/or edit text. You'll discover how to create new image content in a snap to better inform, persuade, and inspire action. Participants will walk away with a whole new creative toolkit and skillset that cuts through data clutter, improves analysis and sharpens decision-making. 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.
Audit 204: Auditing Basic Inventory - Focus on Observations
-
Online
2.00 Credits
Auditing Inventory - Performing Required Observations and Other Common Procedures will primarily focus on performing the inventory observation, while introducing other risk concepts related to inventory. Assets classified as inventory varies widely with the nature of the entity and industry. Depending on the complexity of the inventory and the related pricing model, risk of material misstatement will vary widely as well. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for auditing inventory. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Synchronize Your Files to the Cloud with SharePoint -Updated
-
Online
2.00 Credits
One of the most cost effective methods for storing your files safely and economically in the cloud is with Microsoft 365 OneDrive and SharePoint apps. If you use either or both of these cloud storage apps, this course is a "must take." There are often times when you want or need cloud based files to be stored on your local laptop or desktop PC. With the OneDrive Sync app, you can have the best of both worlds. You can have copies of a file stored locally and in the cloud simultaneously. The Synch app will update both copies of the file in real time for any changes that are made in the local or cloud copy of the file. A classic example is if you have a QuickBooks Desktop data file that you need to store locally to work with the files in QuickBooks. However, you also want the file stored in the cloud for anytime, anywhere access and enhanced security. The Sync app facilitates this scenario effortlessly. Nationally recognized accounting technology advisor and thought leader, John Higgins, will take you through the step-by-step process of setting up and using the Sync app. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Advanced Googling for Accountants
-
Online
2.00 Credits
The course provides a concise overview of how accountants can instantly and dramatically improve their Google search skills. Discover how to use the search service to spot opportunities and threats in your enterprise landscape earlier and faster, improve your research tactics as a trusted business advisor, slice through the endless online static and distractions, and interpret search results related to accounting in their proper context. You'll walk away with scores of practical and proven online discovery lessons that can be immediately applied, deliver instant results and serve you forever in both your professional and personal life. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Digging Deep with Excel Pivot Tables
-
Online
1.00 Credits
This session focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
A 7-Step Framework for Marketing Client Accounting Services
-
Online
1.00 Credits
This course will help you develop an effective plan for revenue generation with client accounting services. The course will help you define and market to your chosen niches with effective and cost-efficient tactics. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Annual Update for Accountants & Auditors
-
Online
8.00 Credits
This course will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We'll then switch our attention to the items coming down the pike, including a look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation. We'll also review year 2 considerations for leases including modification accounting. Then we will switch gears, switching to the audit side of the house. We'll review the impact of the changes to auditing group audits as well as the status of the AICPA's quality management project management. This course will keep auditors up to date on the work of the ASB. 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