CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
AICPA Town Hall Series (Rebroadcast of 4/9/2026)
-
Online
1.00 Credits
Each event is a rebroadcast of the live Town Hall webcast from the previous week.The AICPA Town Hall Series delivers: Timely & Critical Information Interpretation & Analysis Firm and Business Strategies Practitioner Capabilities
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
Tools for Mastering Ethical Decision Making
-
Online
1.00 Credits
This webcast is designed to equip individuals with essential skills and knowledge for making ethical decisions in both personal and professional settings. This webcast can help you to: Sharpen your ability to spot ethical pressures and dilemmas in any context Boost your moral courage and confidence to address these challenges head-on Master an actionable ethical decision-making framework to make principled choices. Elevate your ethical prowess and gain the confidence to navigate any professional or personal situation with unwavering integrity.
Excel for Accounting Professionals Session 3: Workbook Design Principles and Organization
-
Online
2.00 Credits
Enhancing Excel workbook productivity This workshop covers organizing and managing worksheet information, offering hands-on participation alongside the instructor. Through the practical tasks, you will gain a comprehensive grasp of commonly utilized Excel functions such as: Hiding worksheets Inputting cells styles for users Organizing workbooks Mastering Excel capabilities Becoming proficient in Excel entails developing workbooks that are efficient and well-organized. The facilitator will guide you through mastering complex functions, selecting cells and objects, and organizing principles of workbook design. You'll enhance your basic understanding of Excel with topics including: Creating complex formulas with nested functions Applying techniques for group selection *Session 3 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 4: Conditional Summing and Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-4--conditional-summing-and-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*
Excel for Accounting Professionals Session 4: Conditional Summing and Lookups
-
Online
2.00 Credits
Boosting productivity with Excel For those unfamiliar with conditional summing, you're in for a revelation -it's an impactful technique that improves productivity in creating reports. You'll learn how to optimize Excel efficiency by managing duplicates, selecting appropriate shortcuts, and performing lookups. Practical hands-on Excel learning exercises taught by highly engaging expert in the field You'll also deepen your skills and tackle real-world Excel workbooks that address the following: Benefits of using lookup functions over direct cell referencing A comprehensive exploration of the popular VLOOKUP function Techniques for removing duplicates to create a distinct set of report labels *Session 4 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 5: Error Trapping and Improving Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-5--error-trapping-and-improving-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*
Ethics Under Stress
-
Online
2.00 Credits
In the modern professional landscape, stress is often an unwelcome constant. But how does it impact our ethical compass? "Ethics Under Stress" delves deep into the intertwined nature of stress and ethical decision-making, both on a personal and organizational level. Through real-world examples, interactive simulations, and expert insights, participants will understand the subtle yet profound ways stress can compromise ethical behavior and gain actionable strategies to strengthen ethical resilience amidst challenges.
Finance Business Partnering: The Essentials
-
Online
8.00 Credits
Critical Competencies This webcast builds on your current knowledge and experience to help you successfully navigate and drive value for your business during a time of disruptive, technology-led change. You will learn how to stay relevant and future-focused while building your competencies in critical areas including communication, influencing, and business acumen. This webcast also delivers strategies and best practices to support your ability to enable strategic decisions to drive business forward.
Risk Assessment Under SAS No. 145
-
Online
2.00 Credits
Get familiar with SAS No. 145 (bold) In October 2021, the AICPA Auditing Standards Board issued Statement on Auditing Standards (SAS) No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement. SAS No. 145 does not fundamentally change the key concepts underpinning audit risk. Rather, it clarifies and enhances certain aspects of the identification and assessment of the risks of material misstatement to drive better risk assessments and, therefore, enhance your audit quality. Hear from members of the Auditing Standards Board's risk assessment task force as they help you learn to navigate SAS No. 145 and examine new and updated concepts including: A new definition of significant risk New guidance on maintaining professional skepticism Revised requirements to evaluate the design of certain controls Separately assessing inherent risk and control risk Revised requirements regarding audit documentation New guidance on scalability
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.
Quality Management: Performing a Root Cause Analysis
-
Online
2.00 Credits
Root cause analysis is a powerful tool for understanding why quality issues arise, and for preventing them from recurring. This webcast examines the principles and objectives of a root cause analysis and how it aligns with SQMS No. 1's focus on continual improvement. Learn practical approaches for: Identifying underlying causes of findings and deficiencies Evaluating contributing factors Implementing meaningful corrective actions We'll also explore how this process can help firms of all sizes to: Enhance audit quality Strengthen remediation activities Foster a culture of proactive problem-solving
Risk Management Techniques and Tools
-
Online
2.00 Credits
Identify and eliminate risk Understand how risk affects all areas of business-from hiring and onboarding to customer fulfillment and customer support, and everything in between. Gain the knowledge to make informed decisions about risk assessment. Understand the importance of fully integrating risk assessment techniques into other elements of enterprise risk management. Tools and techniques With the assistance of 17 tools and techniques, learn how to assess and manage risks in your organization. Compare SWOT analysis and PESTLE analysis in analyzing risks. Understand how enterprise risk management (ERM) can help protect and enhance stakeholder value. Learn how ERM can be used by businesses of all sizes.
Finance Business Partnering: A Roadmap to Strategic Influence
-
Online
1.00 Credits
Become a trusted and valued business partner In the dynamic landscape of modern business, the role of finance professionals is rapidly evolving. No longer confined to traditional number-crunching, today's finance experts are expected to be strategic partners, influential in shaping the future of their organizations. Global trends and changing organizational environments drive finance to be more strategic and proactive - to move beyond reporting on results to helping business units achieve results. During this session, we will dive into essential skills for finance professionals, such as: Building effective stakeholder relationships Developing acute business acumen Enhancing strategic thinking and problem-solving abilities This webcast will provide attendees with a roadmap to becoming a trusted and valued business partner.
Taxation of Property Transactions - Tax Staff Essentials
-
Online
4.00 Credits
Professionals learn about business property-related timing issues and planning opportunities that can lead to tax savings.
Quality Management: Engagement Quality Reviews
-
Online
2.00 Credits
SQMS No. 2, Engagement Quality Reviews, sets out requirements and guidance for firms to conduct an engagement quality (EQ) review. The standard also addresses the qualifications, eligibility, responsibilities, and appointment of an EQ reviewer. The predecessor standard, SQCS No. 8, combined quality control policies with the engagement quality control review. SQMS No. 2 was issued separately to highlight the importance of the EQ review within a firm's system of quality management. SQMS No. 2 formalizes and strengthens the review process through clarified guidance and enhanced documentation requirements. It also distinguishes the responsibilities of the firm from those of the EQR reviewer, ensuring greater accountability and transparency.
Obtaining an Understanding of Internal Control
-
Online
1.00 Credits
Understand internal control Understand internal control in risk assessment as required by GAAS. Gain an overview of internal control and related key aspects so that you recognize auditor and management roles and responsibilities related to internal control and procedures involved in understanding an entity's internal control in a risk assessment.
Future-Ready Finance: Motivating the Next Workforce
-
Online
1.50 Credits
As the workforce continues to evolve, finance professionals must adapt to new expectations, diverse work styles, and shifting motivators to attract and retain top talent. Future-Ready Finance: Motivating the Next Workforce explores how organizations can create an environment that fosters engagement, innovation, and long-term success.
Performing a Single Audit Under the Uniform Guidance
-
Online
8.00 Credits
Auditors performing single audits can learn about major program determination, pass-through entity responsibilities, SEFA requirements and other topics.
Documenting Internal Control
-
Online
1.00 Credits
Documenting internal controls Familiarize yourself with commonly used documentation tools, such as narratives, flowcharts, internal control questionnaires and control matrixes. Walk through COSO's internal control template used to document an assessment of a system on internal control.
From Risk to Resilience: Disaster Planning for CPA Financial Planners
-
Online
1.00 Credits
In an era of increasingly frequent and severe natural disasters, CPA financial planners can play a critical role in helping clients prepare for, withstand, and recover from disruptive events. This webcast gives CPA financial planners a practical framework for helping clients prepare for and recover from disasters. Advisers will learn how to: Assess a client's exposure Build an actionable readiness plan Evaluate insurance adequacy across property and casualty, liability, disability, life, and cyber risks The webcast also covers: Structuring liquidity for short-term needs Applying key tax-relief rules to real-world scenarios Coordinating a post-event recovery plan that brings together insurers, advisers, and family decision-makers while safeguarding clients from fraud and identity theft
COSO's Internal Control Framework Essentials
-
Online
3.50 Credits
COSO framework overview Gain an overview of COSO's internal control framework comprising five components and their related principles. Learn how to evaluate the control environment, risk assessment, control activities, information and communication, and monitoring activities at your or your client's entity. Through real-life examples, enhance your understanding of how to apply the framework as it relates to financial reporting whether you are an auditor or entity management.