CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Impact of GASB Activities on State and Local Government
-
Online
3.00 Credits
Are you an accountant or finance professional working in the state and local government space? Are you an auditor with state and local government clients? If you answered "yes" to either of these questions, you're aware that to succeed at your job and to uphold the public trust, you need a solid understanding of governmental accounting and reporting. This course will walk you through GASB standards and look to the future by exploring current GASB projects.
How Culture Affects Risks
-
Online
1.00 Credits
Creating Culture Benefits Your Organization It's important to dedicate time and resources in: Evaluating the company's current culture Communicating the company's values Creating processes and risk avoidance activities for a healthy corporate culture Prioritizing and monitoring risks This course will help you evaluate your organization's current culture, and teach you strategies for building a thriving corporate culture.
Linking Risk Management to Strategy
-
Online
1.50 Credits
Risk mitigation and response Boards and executive teams must manage an ever-changing landscape filled with uncertainty - due to economics, geopolitics, technology, tax regulations, talent pool, cyber-terrorism, data privacy and more. Emerging technologies, such as artificial intelligence and the Internet of things (IoT), are disrupting business models across all sectors. Learn strategies for mitigating risks and dealing with risks quickly.
Risk Is Increasing - and Risk Management Is Evolving
-
Online
1.00 Credits
Tools for Risk Management A key to an effective risk management process is to move from the historic silo-based approach to an enterprise-wide approach. During this webcast, you will learn: Increased risks for organizations, including technology and cyber risks The use of a risk readiness assessment to identify management's current state regarding risk management The importance of retaining talent and updating your business model Findings from executive surveys that identify potential risks
Roles and Responsibilities in Risk Management
-
Online
1.00 Credits
Developing a Strong Risk Management Culture Successful leaders are anticipatory, understanding the potential effect and wider implications of risks. You can guide staff and correct behaviors with policies and procedures. But to fully actualize a risk management culture, leaders must convey integrity and must step up their commitment to enterprise risk management (ERM). Enterprise risk management means dealing with uncertainty. It requires leaders to make informed decisions managing people, processes and technology. In this webcast, you'll learn what it means to be an anticipatory leader, the five levels of defense in risk management and much more.
Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting
-
Online
2.00 Credits
Let us ask you a question. What function do you use most? Is it the SUM function? It shouldn't be - well, at least if efficiency is your goal. This session covers the function that sums better than the SUM function for accounting professionals. In addition, we review the data validation feature, which enables us to control what a user enters into a cell. We'll discuss the conditional formatting feature, which enables us to format a cell based on its value. Lastly, we'll conclude by reviewing a technique that addresses a major pitfall of Excel. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel, since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the session, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook, and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.
Excel for Accounting Professionals Session 3: Workbook Design Principles and Organization
-
Online
2.00 Credits
Are you familiar with the five workbook design principles that help us build reliable recurring-use workbooks? This session covers them, as well as workbook and worksheet organization ideas. We also discuss how, why and when to hide administrative worksheets. The importance of highlighting input cells, using selection groups and building formulas with nested functions are also explored. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the webcast, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook, and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.
Forensic Accounting: Fraud Investigations
-
Online
8.00 Credits
In high demand - forensic accounting knowledge and skills (bold) Forensic accounting has been a rapidly growing part of the accounting profession for some time. The rapid expansion in technology and growth in various sectors of business and industry, and the increase in complexity of white-collar crimes, all contribute to this growth. A diverse range of clients, as well as cases involving all types of fraud, make this an attractive profession, and one that is always in high demand. Enhance your knowledge and skills with our Forensic Accounting: Fraud Investigations webcast. Whether you're a forensic accountant, or an aspiring one, this webcast will provide you with the foundational knowledge to successfully identify, investigate, and communicate your findings. You will also receive a copy of the AICPA's Forensic & Litigation Service's Forensic Accounting - Fraud Investigations practice aid for future reference.
Auditing, Assurance, and Ethics Update for Governments and Not-for-Profits
-
Online
3.00 Credits
The right tools Change can be difficult if you do not have the right tools. You can gain those tools through this course, which includes case studies that provide more insight into the changes in the auditor's report and key areas to focus on during your audits.
SOC Mastery for CPA Firms: Your Roadmap to Starting a SOC Practice
-
Online
1.00 Credits
In the realm of modern business, the trend of outsourcing functions or activities to third-party service providers is on the rise. While this strategy can enhance efficiency and cost-effectiveness, it also introduces inherent risks that necessitate careful identification, assessment, and management. As a result, those utilizing such outsourced services, along with their auditors, increasingly demand comprehensive insights into the effectiveness of controls within these service organizations. To fulfill this need, the AICPA offers a range of SOC (System and Organization Control) for service organizations engagements, providing assurance reports that offer vital information for evaluating and mitigating the risks tied to outsourcing, thereby fostering trust and transparency. This webcast serves as an introduction for CPA firms who are new to SOC for service organizations engagements or as a refresher for those already acquainted. It does not delve into the specifics of conducting a SOC examinations; however, it offers a general understanding of how to start up a SOC practice.
AICPA Town Hall Series
-
Online
1.00 Credits
Up-to-the-minute guidance Hear the latest updates on the CARES Act and progress of the Paycheck Protection Program (PPP) from AICPA executive leads Susan Coffey, EVP - Public Practice, and Erik Asgeirsson, President and CEO, CPA.com in these weekly town hall webcasts. Topics will be updated weekly. *** Free for AICPA members
Excel for Accounting Professionals Session 4: Conditional Summing and Lookups
-
Online
2.00 Credits
This session opens with conditional summing. If you have not explored conditional summing yet, you are in for a surprise. Conditional summing is a game changer and will absolutely improve efficiency in your reporting workbooks. We then move to removing duplicates to create a list of unique report labels. We conclude with lookup basics. We discuss why we prefer lookups to direct cell references and explore the details of the most popular lookup function, VLOOKUP. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel, since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the session, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.
Power BI - Introduction to MS Power BI Tools
-
Online
2.00 Credits
This is the first webcast in the 2020 Power BI Series. Please see below for the suggested viewing order. Excel is a popular data analysis tool, yet most users have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. Those that learned to analyze data using PivotTables, soon learned there were many weaknesses in PivotTables that resulted in elaborate calculations in order to perform simple tasks. In 2010, after much development and little hype, Microsoft released Power Pivot, a new data analytic tool that removed the weaknesses of PivotTables. This single product took Excel from a low-end data analytic tool to one of the most sophisticated and comprehensive tools. Since 2010, Microsoft has continued their development of end-user data analytic tools. This entire suite of products is called Power BI. During this webcast... We will provide an overview of the various Power BI tools and discuss Microsoft's Power BI Strategy. We will begin by explaining the challenges faced by many accountants when it comes to analyzing data in Excel. You will learn how each Power BI tool reduces the challenges and improves your data analytic skills. You will also gain a complete understanding of when to use which tool. This is an overview of the various Microsoft Power BI tools and should be your first step in learning the complete set of Power BI tools. As an overview, we will not be teaching the details of each tool but you will receive a thorough understanding of what each tool can accomplish. This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. Explore the other webcasts in the Microsoft Power BI Series: Power BI - Prepare Your Data Efficiently for Excel Analysis Power BI - Analyze Your Data With Excel Pivot Tables Power BI - Create Excel Dashboards for Maximum Impact Power BI - Use Power Query to Transform Your Data Power BI - Go Beyond PivotTables with Power Pivot Power BI - Use Advanced Calculations with DAX Formulas Power BI - Use PBI Desktop to Create Reports and Dashboards Power BI - Share Your Data Analysis using PowerBI.com
Construction Contractors: Non-Revenue and Non-Lease Accounting Considerations
-
Online
4.00 Credits
The construction industry stands out in its need to adhere to a diverse range of accounting standards. This course explores the essential knowledge required for success in construction accounting, as well as the key issues influencing this field. Discover the implications of recent developments for yourself, your business, or your clients. In addition, we will examine the relationship between contractors and sureties. Given the construction industry's significant and ever-expanding share of the economy, staying up to date with the latest accounting updates in this sector is critical. Note: This course does not address FASB ASC 606, Revenue from Contracts with Customers, or FASB ASC 842, Leases. The AICPA offers a companion course which focuses on revenue and lease accounting for construction contractors. See Contract Accounting and Lease Accounting and Their Impact on Construction Contractors (CCREVL).
Contract Accounting, Lease Accounting, and their Impact on Construction Contractors
-
Online
1.50 Credits
Construction accounting is not just about revenue, but it is a lot about revenue. Leases too. Diving deep into the five-step approach for revenue recognition in the construction industry, this course has all of the rules and interpretations that you might need. Further, practical examples help to drive home the learning. Additionally, leases are critical for contractors. From equipment to warehouse space, leases appear prominently on many contractors' book. Review the current guidance and begin to understand the new guidance under ASC 842. Program features: Detailed discussion of the guidance under FASB ASC 606, Revenue from Contracts with Customers. Examples and exercises to understand the five-step recognition process. Detailed discussion of the guidance under FASB ASC 842, Leases. Reasons why leases are so important to contractors. A walkthrough of both current and future lease guidance.
Applying the Uniform Guidance in Your Single Audits
-
Online
8.00 Credits
Designed to provide you with the knowledge to be more efficient and effective at planning and performing audits in accordance with the requirements of the Uniform Guidance and the Single Audit Act, this course examines how the Single Audit Act relates to OMB Uniform Guidance, as well as the different types of guidance and requirements found in the Uniform Guidance. The course also covers responsibilities and requirements of the auditor and the auditee, how to identify federal assistance and how to determine a nonfederal entity's major programs. Make sure your skills are up to date with the latest information in this challenging audit area.
Power BI - Prepare Your Data Efficiently for Excel Analysis
-
Online
2.00 Credits
This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order. Before you can analyze data, you first must get the data. This webcast focuses on getting data into Excel using different data sources. Whether your data is text, comma delimited (CSV), reports, Excel, databases, web, applications and/or many others, Excel provides the ability to access that data. You will learn about tools that have been added to Excel that will make accessing that data even easier, such as data models and Power Query (Get and Transform). After this webcast you will finally be able to get the data you need to perform data analysis. This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. Explore the other webcasts in the 2020 Power BI Series: Power BI - Introduction to MS Power BI Tools Power BI - Analyze Your Data With Excel Pivot Tables Power BI - Create Excel Dashboards for Maximum Impact Power BI - Use Power Query to Transform Your Data Power BI - Go Beyond PivotTables with Power Pivot Power BI - Use Advanced Calculations with DAX Formulas Power BI - Use PBI Desktop to Create Reports and Dashboards Power BI - Share Your Data Analysis using PowerBI.com
Construction Contractors: Auditing Considerations
-
Online
4.00 Credits
Challenges and solutions of auditing contracts With construction comprising a large and growing portion of the economy, it's important to stay on top of the very latest in accounting and auditing changes for the construction industry. In this webcast, you will gain insight about: Audit planning and substantive auditing procedures The core knowledge necessary to succeed Key issues affecting construction auditing, including auditing under the new revenue recognition and leases guidance Audit risks and risk assessment
New Quality Management Standards: Resources - Expectations for Firms and Engagement Partners
-
Online
1.00 Credits
Leverage resources for optimal QM performance (bold) Managing a firm's resources to achieve the objectives of a quality management (QM) system involves planning, maintaining, scheduling, and allocating resources in ways that are best for each firm - but the system needs to use and leverage resources effectively. In this webcast, you'll gain a better understanding of how firms can design and operate their QM systems to appropriately manage resources - human, technological, intellectual, and financial. Managing resources is not only about the quantity available but also having the correct proportion of each resource to perform quality engagements. These revised standards strengthen an engagement partner's responsibilities for quality management at the engagement level and may positively change aspects of corporate culture. Second in a four-part webcast series (bold) This is the second webcast in a four-part series on the Auditing Standard Board's (ASB) new quality management standards. You'll take a deep dive into the resource component of the ASB's Statement on Quality Management Standards (SQMS) No. 1, A Firm's System of Quality Management (ital), and the engagement partner's responsibility for resources under Statement on Auditing Standards (SAS) No. 146, Quality Management for Engagements Conducted in Accordance with Generally Accepted Auditing Standards (ital). Attendance in each webcast in this four-part series will earn you one CPE credit. You can participate in one or all based on your interest in the topics. A rebroadcast of this webcast is scheduled for Dec. 8, 2022, at 2pm ET.
Yellow Book: Application of GAGAS Principles
-
Online
5.50 Credits
Gain the essentials Engaging with chapters 1-5 of *Government Auditing Standards, 2018 Revision,* gain the essentials for performing engagements in accordance with generally accepted government auditing standards (GAGAS). Build an excellent foundation of the principles of GAGAS as it relates to understanding Yellow Book requirements and application guidance.