CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Auditing, Assurance, and Ethics Update for Governments and Not-for-Profits
-
Online
3.50 Credits
You'll learn about changes to the auditor's report and other new auditing standards, and understand common deficiencies in audits.
Excel for Accounting Professionals Session 1: Tables and Named References
-
Online
2.00 Credits
Transforming how you use Excel with engaging and expert-led instruction Designed for you to work alongside an expert and complete the same exercises, you'll dig deeper into topics, including: Benefits of using named references for faster navigation Increased versatility and efficiency withing your Excel workbooks Excel Tables special properties and Error reduction for greater productivity. Mastering Excel functions Excel mastery involves understanding how to create functional and efficient workbooks. The instructor will guide you through Tables, named references, and more as you build on basic Excel skills and use critical functions, such as: Excel conventions Critical shortcuts Efficient navigation techniques Automatic formula updating *Session 1 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 2: Data Validation and Conditional Formatting] (https:// https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-2--data-validation-and-conditional-formatting) to further prepare to tackle real-world issues and build powerful workbooks.*
Ethics: Critical Thinking, Case Studies and Fraud
-
Online
4.00 Credits
While ethics training is required by many states, the true value of the CPA license is in understanding how critically important ethical behavior is to one another, our customers, and to the public. This course will explore the basic tenets of ethical behavior and use case studies to explore ethical dilemmas in various companies and organizations, with special focus on the AICPA Code of Professional Conduct and AU-C Section 315.
Impact of GASB Activities on State and Local Government
-
Online
3.50 Credits
Are you ready to implement GASB's recently issued standards? Join us as we walk through each standard and provide real-world information regarding newly effective standards.
Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting
-
Online
2.00 Credits
Which Excel function is your go-to? This session invites you to actively engage and practice with the instructor, exploring exercises demonstrated. In doing so, you'll gain a firmer grasp of common Excel functionalities, including: Data validation Conditional formatting Enhanced summing options Skinny rows Achieving proficiency in Excel features Gaining proficiency in Excel means learning to design workbooks that are both functional and streamlined. The facilitator will lead you through an array of formatting skills, formula functions, and beyond as we expand upon foundational Excel knowledge with topics such as: Managing data input for individual cells Using conditional formatting to prevent errors Enhancing productivity via the Subtotal feature Ensuring total formulas refresh automatically *Session 2 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 3: Workbook Design Principles and Organization] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-3--workbook-design-principles-and-organization) to further prepare to tackle real-world issues and build 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.
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.*
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
Thanks for the Feedback - Lessons in Giving and Receiving Feedback
-
Online
1.00 Credits
Feedback is essential to development (bold) Whether we realize it or not, we are constantly giving and receiving feedback. Sometimes we dread it or dismiss it. But even if feedback is ill-timed, unfair or downright mean, we can use it for growth.
Leases: Mastering the New FASB Requirements
-
Online
8.00 Credits
FASB ASC 842, *Leases*, standards decoded By learning essential information about lease accounting requirements, you'll understand the core principles of the standards and how to apply them. You'll explore topics, such as: Identification Recognition Measurement Presentation and disclosure requirements Deliberate application of lessee accounting model You'll also learn about classifying leases, the amortization of the right-of-use asset, and the interest on a lease liability. Additional topics include: Short-term leases Purchase options Variable lease payments Sale and leaseback transactions Leveraged leases
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.
AICPA Town Hall Series (10/9/2025)
-
Online
1.00 Credits
The AICPA Town Hall Series delivers: Timely & Critical Information Interpretation & Analysis Firm and Business Strategies Practitioner Capabilities **Free for AICPA members Not an AICPA or CIMA member? Become one today.
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).
AICPA Town Hall Series (Rebroadcast of 10/9/2025)
-
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 **Free for AICPA members Not an AICPA or CIMA member? Become one today.
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.
Practical Tools and Tips to Help CPAs Manage Risk (Audit & Attest Services Focus)
-
Online
4.00 Credits
What are the risks of offering A&A services? CPAs face an ever-present threat of malpractice claims regardless of the services performed. Offering audit and attest (A&A) services exposes professionals and their firms to certain risk. Although it is impossible to eliminate all risks, you can identify and implement practical techniques to help mitigate the risk of a professional liability claim. Processes to mitigate risks in A&A You will gain insight into day-to-day risk management protocols related to firm practice management and service delivery. You'll also learn about the many ways a firm can manage risk in offering A&A services, including: Writing effective engagement letters Creating a robust onboarding process Identifying scope Managing billing and fees Deep dives into A&A loss data Examining the recent data that breaks down the causes of loss related to A&A professional liability claims can help you understand the threats to you and your firm, and focus your risk management practices. Additional benefits In addition to earning CPE credits, CNA policyholders may earn up to a 10% premium credit for three consecutive years on their AICPA Professional Liability Insurance policy. *Please consult your agent for further details regarding eligibility.*
Navigating the AI Landscape?: An Introduction to Generative AI and ChatGPT for Accounting Professionals?
-
Online
1.50 Credits
Generative AI use is growing, and ChatGPT is leading the way. But what exactly is ChatGPT, and how can it help you increase your productivity? Join us for a one-hour seminar on ChatGPT. We'll guide you through everything you need to know to get started You'll learn to use ChatGPT to: Streamline your workload Save time Boost efficiency Say goodbye to tedious data entry and hello to lightning-fast responses and analysis. As with any new technology, risks and ethical concerns must be considered. Our experts will delve into these topics and provide you with the knowledge and tools you need to use ChatGPT responsibly and effectively. Don't miss this opportunity to stay ahead of the curve and take your CPA game to the next level. Discover the amazing benefits of this groundbreaking technology.
Applying the Uniform Guidance in Your Single Audits
-
Online
8.00 Credits
You can learn to understand, assess and test internal control over compliance as you apply the Uniform Guidance in your single audits.
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.