CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Use of technology in an audit of financial statements - Risk Assessment
-
Online
2.00 Credits
How technology can help auditors improve efficiency, effectiveness and quality [bold] Auditors are perpetually in pursuit of enhancing the efficiency and effectiveness of their audits while upholding consistently high standards of quality. The integration of technology into the audit process can seamlessly accomplish these objectives. Join us as we delve into the insights of two distinguished members of the AICPA Auditing Standards Board's Technology Working Group, including its chairperson. You'll learn how technology can empower auditors to navigate the escalating demands of modern audits, particularly in the face of overwhelming data volumes, by harnessing available tools. Our presenters discuss common reasons auditors may resist using technology and why those reasons, even more commonly, are not always valid. Once you have an understanding that overcoming barriers to entry is possible, the Technology Working Group experts will guide you through the audit process. You'll explore key junctures where automated tools, techniques and commercial software solutions can revolutionize your audit methodology for the better. Our presenters then return to examine, in detail, how technology can help auditors during one of the most important steps in the process, the risk assessment. Highlighting benefits to efficiency and effectiveness, the new AICPA practice aid "Use of technology in an audit of financial statements" is the focus. Part I of this evolving practice aid takes a deep dive into risk assessment procedures. Walking through examples allows you to see how the guidance in the practice aid can assist in your daily work.
Ethics: Avoiding the Slippery Slope of Ethical Pressures
-
Online
4.00 Credits
Maintaining an ethical climate (bold) Being on prime-time news might seem exciting, but not when the story is an ethics breach you committed. You may say, "that will never happen to me". And those were the words spoken by Wells Fargo, United Airlines, Senator Al Franken, and Steve Wynn. A claim of an ethical failure can stay in the news for almost five years. That's long enough to damage your reputation and lower your profitability. Upholding high ethical standards for yourself and your team requires constant care and feeding.
Streamlined Excel Reporting Series Session 1: PivotTable Fundamentals
-
Online
2.00 Credits
Harnessing the potential of PivotTables Whether you're just starting out or seeking to improve your Excel expertise, PivotTables are versatile and powerful tools for data analysis. This course delivers a well-organized method for effectively understanding and using PivotTables through: Practicing fundamentals with a leading expert in financial modeling Creating and using sample datasets Building PivotTables from the ground up Innovative possibilities for presenting data The core functionality of PivotTables for financial professionals is the ability to transform large datasets into meaningful summaries. By reorganizing data from a spreadsheet, PivotTables allows you to: Extract key information and identify trends quickly Simplify the process of analyzing data Reduce the time spent on repetitive tasks *Session 1 is one of four individual sessions. Each session builds on the previous one, so consider watching [Streamlined Excel Reporting Series Session 2: Working with PivotTables] (https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series-session-2-working-with-pivottables) to tackle real-world issues and create powerful workbooks.*
Governmental and Not-for-Profit Annual Update
-
Online
8.00 Credits
The latest GASB developments and federal audit changes affecting governments and not-for-profits (NFPs) are explored in this update overview.
Controller Series: Communicating for Connections with Coworkers, Customers, and Stakeholders
-
Online
1.00 Credits
How you communicate with your internal and external customer can make or break your career! We all know how to talk, but how do we make sure we are really connecting with others? This course will discuss different personality styles and demonstrate the different ways to communicate information to them. See how recognizing their personality style(s) can turn communication breakdowns into breakthroughs.
Accounting for Digital Assets Under U.S. GAAP: Crypto lending and borrowing
-
Online
1.00 Credits
You'll learn about crypto lending and borrowing considerations when accounting for digital assets under U.S. GAAP.
Streamlined Excel Reporting Series Session 2: Working with PivotTables
-
Online
2.00 Credits
Unlock the full potential of your data with PivotTables PivotTables are a versatile and transformative tool for organizing and analyzing data. Whether you're a beginner or an experienced user, this course will provide you with the knowledge and skills to make the most of PivotTables so that you can: Customize PivotTable options Execute advanced calculations Create insightful reports Moving beyond formula-based reports By delving into more advanced techniques for using PivotTables, you'll learn how to replace formula-based reports by: Incorporating multiple fields into the Values area Performing custom calculations using calculated fields and items Setting up PivotTable options to create sophisticated reports *Session 2 is one of four individual sessions. Each session builds on the previous one, so consider watching [Streamlined Excel Reporting Series Session 3: PivotTable Displays and Alternatives](Need new URL due to Title change) to tackle real-world issues and create powerful workbooks.*
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
Get Started with Power BI
-
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
Accounting for digital assets under US GAAP: Derivatives and mining
-
Online
2.00 Credits
Derivatives, embedded derivatives and mining (Bold) Complexities with digital assets increase when you move away from the fundamentals and start evaluating contracts to determine if they involve derivatives or have embedded derivatives. In addition, recording mining revenue has many unique considerations, especially if you have questions about differences related to transaction fees and block rewards or if you or your client are mining independently or within a mining pool. Part three of a series (bold) This webcast is part three of a series that will bring to life the content incorporated in the AICPA practice aid Accounting for and Auditing of Digital Assets. This webcast will walk you through: A specific fact pattern when evaluating whether or not there is an embedded derivative within the contract The difference between recording revenue for transaction fees and block rewards A flow chart for determining how to recognize revenue when participating in a mining pool Add more value (bold) Whether you're a CPA working with clients or an industry accountant responsible for corporate accounting policy, this webcast will give you a clear path to help your clients or entity by applying the appropriate accounting standards to your digital asset derivative and mining activities. Detailed examples and use cases will demonstrate the real-world application of this guidance. Note: FASB issued ASU No. 2023-08, Intangibles-Goodwill and Other-Crypto Assets (Subtopic 350-60): Accounting for and Disclosure of Crypto Assets, which is effective for all entities for fiscal years beginning after December 15, 2024. This ASU is not yet reflected in this webcast.
2026 Washington Tax Brief
-
Online
1.00 Credits
The AICPA Tax Advocacy Team in Washington, D.C., tackles the challenge of staying current with evolving tax laws. The team advocates for sound tax policy and effective tax administration. The Washington Tax Brief webcast series keeps members informed about: Key tax advocacy initiatives Proposed changes to tax law Fundamental tax reform, including recent updates to IRS regulations
Streamlined Excel Reporting Series Session 3: PivotTables Displays and Alternatives
-
Online
2.00 Credits
Essential techniques for displaying data in alternative ways You'll work alongside an expert instructor as you practice using PivotTables and exploring creative alternatives for insightful data presentation. You'll learn techniques for effective data presentation, including: Filtering and sorting data Cleaning and organizing data through text manipulation Using dynamic features to summarize and analyze large datasets Using slicers and filters for visual filtering Highlighting key Excel features through guided practice You'll walk through realistic scenarios that show alternative functions for greater data management, such as: GROUPBY PIVOTB PERCENTOF In addition, various text functions such as TEXTJOIN and TEXTSPLIT will be explained, highlighting how to concatenate and split text strings efficiently. *Session 3 is one of four individual sessions. Each session builds on the previous one, so consider watching [Streamlined Excel Reporting Series Session 4: External Data and PivotCharts](https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series-session-4-external-data-and-pivotcharts) to tackle real-world issues and create powerful workbooks.*
Streamlined Excel Reporting Series Session 4: External Data and PivotCharts
-
Online
2.00 Credits
Extracting data for richer insights You'll gain meaningful analysis techniques while working alongside an industry expert and knowledgeable instructor. This session begins with the GETPIVOTDATA function to enable report customization. It's a great starting point before moving on to more advanced techniques. Power Query introduction With its user-friendly interface, Power Query empowers Excel users to take the next step by enabling seamless data import and transformation. With Power Query, you will explore features, including: Getting and transforming data Loading data Managing columns Data source settings Layouts and parameters Visualizing with PivotCharts A well-designed chart can effectively illustrate data trends and comparisons. You'll learn how to create and customize PivotCharts to elevate your reports and make the data more accessible to others. *Session 4 is one of four individual sessions. Each session builds on the previous one, so consider watching all the sessions [Streamlined Excel Reporting Series](https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series) to tackle real-world issues and create powerful workbooks.*
Controller Series: Technology - Must Have Excel Competencies
-
Online
1.00 Credits
Excel has long been included in the accountant's toolbox. Even though Microsoft Power BI and other big data tools such as Qlik and Tableau are becoming more important, Excel is still a "must have" tool. We cover what the accountants of today should know about Excel to improve their efficiency, access data, and gain insights into the company, industry, and economy.
Auditing digital assets: Client acceptance and continuance, risk assessment, and laws regulations and related parties
-
Online
2.00 Credits
Auditing entities that hold or transact digital assets (bold) Would you like to better understand the environment of digital asset transactions? Have you ever wondered if you should accept or continue a client engagement? This webcast will help you identify challenges, risks and factors to consider when deciding to accept or continue with a client who holds or transacts with digital assets. During the webcast and discussion, you will learn: The Digital Assets Working Group's mission and the process through which nonauthoritative guidance is developed What private keys are and ways to safeguard them and the digital assets to which they enable access About the rapidly evolving nature of the digital asset ecosystem that may lead to challenges when performing required procedures surrounding laws and regulations You will gain: Insight into the unique aspects of the risk assessment process when involved in the digital assets space Awareness of the pseudo-anonymous nature of digital asset transactions that may lead to challenges in performing required procedures surrounding related-party relationships and transactions with related parties You will also gain access to valuable resources: Accounting for and Auditing of Digital Assets Practice Aid Blockchain Universal Glossary Webcast: Accounting for Digital Assets under U.S. GAAP Digital Asset Resources
Ethics in the World of AI: An Accountant's Guide to Managing the Risks
-
Online
2.00 Credits
Discover "Ethics in the World of AI: A CPAs Guide to Managing Risks" - a concise 2-hour training session for certified public accountants. Karl Ahlrichs and Jennifer Elder discuss the current uses of AI in business, nine risk areas, and provide practical suggestions to address these risks effectively. Equip yourself with the tools to navigate the ethical challenges of AI, upholding professional standards while embracing transformative technology. Join us now for a journey towards ethical excellence in AI.
Annual Update for Controllers and Finance Managers: Driving Business Value
-
Online
7.00 Credits
CFOs, controllers and finance managers often play a key role in driving value within an organization. Explore best practices tailored to help enhance your impact.
Performing Preparation, Compilation and Review Engagements
-
Online
2.00 Credits
Comply With All Standards As You Prepare, Compile and Review Engagements This webcast is a go-to reference for staying in compliance with all professional standards surrounding engagements performed in accordance with Statements on Standards for Accounting and Review Services (SSARSs).
Building Resiliency: The Upside of Stress
-
Online
1.00 Credits
The positive power of stress How we think about stress determines its effect on us. This webcast presents scientific studies and personal stories to help you rethink stress and make it work for you, not against you. Stress can increase our intellect, physical and emotional strength, and our empathy toward others, leading to greater success.
Preparation, Compilation, and Review Engagements: Update and Review
-
Online
4.00 Credits
By reviewing the latest developments and issues relevant to preparation, compilation and review engagements, you'll be able to adhere to professional standards while performing these types of engagements.