CPE Catalog & Events

AICPA's Fundamentals of Forensic Accounting Certificate Program This course is part of the Fundamentals of Forensic Accounting Certificate Program - a comprehensive, integrated curriculum - covering AICPA's entire Body of Knowledge in this topic area. The program will provide you with the training, knowledge, and practical guidance needed for a solid understanding of financial forensics. Credit for individual courses purchased can be applied to the full program when you enroll within one year of the original purchase date. Please visit cpa2biz.com/forensic for information on the complete program. This course provides an overview of how to plan and prepare for a financial forensic engagement. Topics include considerations when accepting an engagement, defining the terms of the engagement, working with attorneys, and identifying and managing resources. Discounts FVS Section Members Save an Additional 20%! When you log into this website with your AICPA member user account, the section discount will be automatically applied during checkout. Please contact the AICPA Service Center at 888-777-7077 or service@aicpa.org if you have any questions or encounter any issues.

This CPE course can be purchased individually or as part of the Risk Management and Insurance Planning Certificate Program. Health insurance is affected not only by tax law, but by other legislation, as well. In this audiovisual CPE course, Tom Tillery covers significant pieces of legislation affecting your clients' health care. Of all the insurance contracts that will need to be employed in a client's personal financial plan, the disability insurance contract is one of the most difficult to apply. This course will educate you in the various definitions of disability, the numerous riders and options available, and the variety of sources for disability income benefits. Planning for property and casualty insurance is more than simply insuring the risk; it is the process of integrating property and casualty insurance contracts into the overall risk management plan. This course will give you the tools you need to master this complicated area.

This CPE course can be purchased individually or as part of the Specialized Forensic Accounting Certificate. Mergers and acquisitions happen in all industries and in all sizes of companies. Forensic accountants should know the differences between mergers and acquisitions, as well as the types of disputes in these transactions. Through narration by an industry subject matter expert and practical scenario-based exercises, this CPE course provides a nuanced exploration of the differences between mergers and acquisitions and details the role a forensic accountant plays in these transactions. Enhanced On-Demand Format This enhanced on-demand format offers meaningful and relevant content in the form of tables, charts, and discussion points on slides. An instructor who is an expert on the topical area breaks down complex topics, offers best practices, provides clarity, and shares insights that help the learner achieve the learning objectives for the course.

Improve your powers of analysis using a pivot table. This course is the third in the Microsoft Power BI series and is designed to teach participants the importance of the PivotTable tool. This course demonstrates how to create pivot tables to make data analysis an easy task for all accountants. Participants will learn, step-by-step, the process for creating pivot tables and pivot charts for reporting. Set-up options will also be covered. 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 self-study online course is part of the Microsoft Power BI: Power BI Series.

Make strategic decisions from an Excel dashboard! This is the fourth course in the Microsoft Power BI series. In this course, you will learn how to build robust dashboards for analyzing key metrics in Excel. The course begins with some dashboard design guidelines, such as understanding your audience and identifying necessary metrics, and shows how to create key performance indicators (KPIs). You will learn how to add charts and eye-catching visuals to make your dashboards easily understood. This course is presented using Excel 2019 but most concepts covered in this course apply to all versions of Excel. This self-study online course is part of the Microsoft Power BI: Power BI Series.

Take the next step with Power Pivot! This is the sixth course in the Microsoft Power BI series. This course focuses on using the Power Pivot features to enhance data analysis. Four features of Power Pivot will be reviewed: Data model Calculations Hierarchies KPIs A majority of the course will be spent on building a data model and using calculations. You will learn how to add data to your data model either directly into PowerPivot or from Get & Transform/Power Query. This self-study online course is part of the Microsoft Power BI: Power BI Series.

Get comfortable with data visualization! This course is an introduction to Microsoft Power BI tools. The course discusses the challenges of using Excel for data analysis while explaining the benefits of using the various Power BI tools to analyze data. In this course, you will: Learn to access data from on-premise and cloud-based sources. Identify data modeling tools that can save time in data preparation. Advanced users of Excel can learn to use the powerful DAX formula language to dig deeper into data that lead to actionable insights, as well as create interactive data visualizations. This self-study online course is part of the Microsoft Power BI: Power BI Series.

Get started on data gathering! This is the second course in the Microsoft Power BI series of courses. This course focuses on getting data from different sources into Excel. Tools like Power Query (now known as "Get & Transform") can make transforming data from those sources quick and easy. Whether you are importing data or cleaning it, learn how to make it happen! This self-study online course is part of the Microsoft Power BI: Power BI Series.

Get your head out of the clouds - and use the cloud! This is the ninth course in the Microsoft Power BI series. This course will focus on using Microsoft's cloud-based sharing/publishing platform, PowerBI.com. You will be introduced to the interface as well as the benefits of using PowerBI.com. You will learn how to leverage the work performed in Power Pivot or Power BI Desktop using the cloud. 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 self-study online course is part of the Microsoft Power BI: Power BI Series.

Use Data Analysis Expressions (DAX) to create advanced calculations! This is the seventh course in the Microsoft Power BI series. This course focuses on using DAX (Data Analysis Expressions) to create advanced calculations in Power Pivot data models. You will learn over 20 DAX functions that will allow you to perform calculations not possible with standard Excel. Use of a date or calendar table will be reviewed. The course 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 self-study online course is part of the Microsoft Power BI: Power BI Series.

Start making connections with Power BI Desktop! This is the eighth course in the Microsoft Power BI series. This course focuses on familiarizing yourself with the Power BI Desktop interface in order to connect to data sources and create rich visualizations. The course will demonstrate the creation of each of the various visualizations and options related to each. 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 self-study online course is part of the Microsoft Power BI: Power BI Series.

Clean, shape, and transform your data. This is the fifth course in the Microsoft Power BI series. This course focuses on using Power Query to clean, shape, and transform data while still allowing you a one-click refresh. The course will review various data issues including appending files, combining multiple files from a folder, adding custom columns, un-pivoting data, and creating a lookup table. The course is resented using Excel 2019, but most concepts covered in this course apply to all versions of Excel. This self-study online course is part of the Microsoft Power BI: Power BI Series.

Save when you buy the complete Tax Staff Essentials, Level 2 online bundle. Learn about multistate taxation to better guide your clients. Conquer the theoretical conundrums and compliance issues of multistate taxation so you can guide your client skillfully through the maze of multistate corporate tax codes. Spotlighting updates on the latest state tax reforms, this CPE self-study course will help you develop a working knowledge of both multistate tax compliance and related planning opportunities.

This CPE course provides an overview and changes with respect to ASU 2016-14 Presentation of Financial Statements and ASU 2016-18 Restricted Cash and Cash Equivalents in Statement of Cash Flows for Not-for-Profit Entities. This course provides common pitfalls and tips on functional expense reporting and, how to manage liquid resources, common peer review findings related to ASU 2016-14, and tips and suggestions on a successful audit. This course also reviews items to consider, given COVID-19, when preparing for an audit and reviewing financial statements. The instructor will explain the key facts and impacts of ASU 2018-08 Clarifying the Scope and Accounting Guidance for Contributions Received and Contributions Made, ASU 2019-03: Updating the Definition of Collections, ASU 2019-06: Extending the Private Company Accounting Alternatives on Goodwill and Certain Identifiable Intangibles to NFP Entities, and ASU 2020-07 Presentation and Disclosures by NFP Entities for Contributed Nonfinancial Assets. Lastly, this course will cover Cybersecurity Issues.

This CPE course is included in the comprehensive Not-for-Profit Certificate I Program. It can also be purchased individually or as a part of the Not-for-Profit Accounting and Financial Reporting track. Not-for-profits (NFPs) are unique in that they often receive substantial amounts of contributions, many of which contain donor-imposed restrictions as to how they are used. The existence or absence of donors' restrictions forms the basis for the classification of an NFP's net assets. In this CPE course, you will learn the basics of net asset classification. Topics covered include donor-imposed restrictions and identifying when they may be implied, financial statement presentation of net assets and required footnote disclosures. The course culminates in a virtual case study in which you will have an opportunity to apply the technical concepts you have learned to real-world scenarios. Note: As of August 1, 2018, the content of this course has been significantly updated to reflect implementation of FASB Accounting Standards Updates (ASUs) effective for most not-for-profit entities for their next financial reporting period, including those related to financial statement presentation (ASU 2016-14) and revenue recognition (ASU 2014-09 and ASU 2018-08). If you started Not-for-Profit Certificate I prior to July 31, but did not complete it, click here to find out how this and related course updates affect you. If you completed the program prior to July 31 and would like to retake only those courses with significant updates for new standards, click here to learn about the Certificate I Update Pack.

This CPE course can be purchased individually or as part of the Audit Staff Essentials - New Staff: Practical Application staff training bundle. Learn about accounts receivable and its related contra account allowance for doubtful accounts, which is an area often assigned to new staff. Gain the knowledge necessary to successfully audit accounts receivable, including how using audit data analytics can improve the audit with respect to accounts receivable. Understand that accounts receivable is considered a high-risk account because it is associated with sales and revenue recognition, which is very subjective in nature and relies primarily on management estimates. Learn how, with careful thought and an understanding of risk assessment, auditing accounts receivable can be an efficient and effective process.

This CPE course can be purchased individually or as part of the Audit Staff Essentials - New Staff: Practical Applicationn staff training bundle. Fully prepare yourself to perform an inventory audit. Understand the importance of knowing not only the types of products your clients manufacture, but also what goes into making those products - it's essential for you to understand how a company makes its money in order to effectively perform an audit. Gain knowledge about determining what goes into your clients' products and how those products are assembled. Explore inventory costing, observations, and other necessary audit procedures, as well as how using audit data analytics can improve audit quality in the inventory area.

** This CPE course can be purchased individually, or as a part of the Audit Staff Essentials - New Staff: Core Concepts staff training bundle.** Gain knowledge about audit evidence and the need for evidence in an audit. In this CPE self-study course, learn about sources of audit evidence and the various techniques auditors use to gather evidence. Understand what makes evidence sufficient and relevant as well as what an auditor should do when faced with conflicting or contradictory evidence. Learn how data analytics can be used as a risk assessment tool and how biases can play a role in your evaluation of audit evidence. Understand why controls over evidence are important and how controls make evidence more reliable.

This CPE course can be purchased individually, or as a part of the Audit Staff Essentials - New Staff: Core Concepts staff training bundle. In this CPE self-study course, learn the elements, performance requirements, and documentation expectations for preparation engagements, compilation engagements, and review engagements. Although these procedures are not audits, they typically involve similar concepts, just at a lesser level of assurance - from no assurance to limited assurance depending on the engagement.