CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
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.*
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.
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
Dark Side of AI: Navigating Risk and Understanding Organizational Impact
-
Online
1.00 Credits
Artificial Intelligence (AI) is transforming industries by automating tasks, optimizing decision-making, and unlocking new efficiencies. However, alongside its benefits, AI presents significant risks, including bias, security threats, misinformation, and ethical dilemmas. This session will explore the darker side of AI, highlighting the potential dangers and their impact on organizations. This session will focus on AI failures, security vulnerabilities, regulatory concerns, and the unintended consequences that arise when AI systems operate without proper oversight. The discussion will provide insights into how organizations can mitigate these risks and ensure responsible AI deployment.
2026 Washington Tax Brief
-
Online
1.00 Credits
The AICPA Tax Advocacy Team in Washington, D.C., addresses the challenge of keeping up with tax law changes. They advocate for sound tax policy and effective administration. The Washington Tax Brief webcast series keeps members informed on major tax-related initiatives and allows them to voice concerns about potential legislation or regulations. Webcast Series Updates members on AICPA tax advocacy initiatives, proposed tax law changes and reform discussions, recent IRS regulations and guidance changes.
EPICenter Webcast Series: Bold Paths, Real Impact: Emerging Leaders in Action
-
Online
1.00 Credits
Join us as we spotlight the winners of the AICPA Emerging Leaders Award, a group of professionals already making a meaningful impact early in their careers. These honorees are driving change in their organizations and communities through leadership, innovation, and service. In this webcast, recipients share their leadership journeys, including: The challenges they have faced The opportunities they pursued The moments that shaped their growth They talk about stepping up as volunteers, mentors, and advocates while balancing career demands and personal development. Expect honest conversations, useful takeaways, and inspiration to lead.
Taxation of Property Transactions - Tax Staff Essentials
-
Online
4.00 Credits
A practical guide to business property transactions A fundamental understanding of the taxation of business property transactions is essential to any tax practice. This course prepares tax professionals to handle the tax effects of common property transactions. Topics include: Depreciation recapture Exchange transactions Dispositions of business property Updated for the effects of H.R. 1, commonly referred to as OBBBA, this learning provides a current view of these essential topics. Tips for achieving an optimal tax result on property transactions Professionals are exposed to important business property-related timing issues and planning opportunities that can lower a client's tax liability. Strategies laid out in the course empower practitioners to consider the timing of recognizing gain and loss to achieve tax savings. Part of Tax Staff Essentials Level 2 This self-study online course is part of Tax Staff Essentials Level 2, a comprehensive learning program that provides experienced tax staff with the technical training required to gain independence.
Small Firm Success Series
-
Online
1.00 Credits
Small CPA firms, defined as those with 30 or fewer professionals, face distinct challenges amid rapid technological change, evolving regulatory demands, and mounting pressure to attract and retain talent. This webcast keeps practitioners current on the developments that matter most while offering practical, immediately applicable insights to strengthen their practices. Participants will gain clarity on today's most pressing questions: How can small firms address staffing shortages and build a sustainable talent pipeline? Which emerging technologies merit investment now? How should firms prepare for new compliance requirements and regulatory updates? What practice-management strategies are most effective for staying competitive in a fast-changing landscape? What sets this webcast apart is its exclusive focus on small firms. Each session emphasizes practical, resource-efficient solutions tailored to their needs. Attendees will hear real-world examples, explore current trends, and receive actionable guidance from experts who understand the realities of small-firm leadership. Designed for partners, managers, and future leaders, this program equips small firms to operate more efficiently, respond effectively to evolving standards, and position themselves for sustainable growth.
Applying AI in A&A: Creating Effective Prompts
-
Online
1.00 Credits
When you ask someone in accounting and finance how often they use generative AI, it's no longer a "sometimes" -- it's usually daily. Effective use of the AI tools may vary, though. This webcast can help improve both efficiency and effectiveness for accounting and assurance professionals by unlocking the key to well-structured AI prompts. Examples of effectively written prompts will illustrate how to craft prompts that improve AI outputs and create even more efficiency in your work.
Business Transformation: Critical Skills for CFOs and Controllers
-
Online
4.00 Credits
Mastering business transformation with key skills and strategies relevant to modern businesses You'll learn tools that will help you manage day-to-day business operations as well as manage changes, including: Budgeting and forecasting approaches Strategic planning and risk management frameworks Technologies that can improve productivity. Optimizing your business model and identify value drivers You'll also understand how to identify and innovate your business model and how to incorporate intangible value drivers into your capital asset strategy by Using hands-on strategies to define your business model and capital structure Learning techniques and models that will guide business model innovation Understanding the role of technology in innovation Leading your team effectively and ethically Additionally, you'll evaluate how to build a successful team and maintain an ethical tone at the top by discovering how to: Attract and retain top talent Adapt leadership styles to different situations Formulate strategies that promote an ethical culture
AICPA Town Hall Series
-
Online
1.00 Credits
The AICPA Town Hall Series delivers: Timely & Critical Information Interpretation & Analysis Firm and Business Strategies Practitioner Capabilities
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.
Intermediate Individual Taxation - Tax Staff Essentials
-
Online
8.00 Credits
Modern tax strategies for individual clients H.R. 1, commonly referred to as OBBBA, has reshaped the individual tax landscape, and a cascade of guidance has made it challenging to keep track of the opportunities for individuals to save on their taxes. Materials explain the latest tax law changes and the individual and business planning opportunities they provide. You'll gather a wealth of tax-planning tips and strategies and learn about key tax return issues, so you have the latest guidance to serve your clients better. In this course, you'll explore the effects of the latest tax legislative, regulatory, and court actions, including: H.R. 1 SECURE Acts (1.0 and 2.0) Inflation Reduction Act of 2022 U.S. Tax Court rulings IRS guidance on the hottest tax topics affecting individual taxpayers Part of Tax Staff Essentials Level 2 This self-study online course is part of Tax Staff Essentials Level 2, a comprehensive learning program that provides experienced staff with the advanced technical training required to work with their most sophisticated clients.
Accounting for Digital Assets Under U.S. GAAP: Crypto lending and borrowing
-
Online
1.00 Credits
Crypto lending and borrowing As you or your clients begin exploring new ways to transact with crypto assets, one of the many possibilities is through involvement with crypto lending and borrowing. Understanding the process of lending and borrowing crypto assets is the first step. You'll learn the fundamentals related to these transactions and accounting considerations from the perspectives of both lenders and borrowers. Note: This webcast has been updated to cover 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. Part four of a series This webcast is part four 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: The process of borrowing and lending crypto assets Crypto lending accounting considerations including derecognition models Crypto borrowing accounting considerations including how to account for the obligation. Add more value Whether you're a CPA working with clients or an industry accountant responsible for corporate accounting policy, you'll gain a clear path to help your clients or entity by applying the appropriate accounting standards to digital asset crypto lending and borrowing activities. Detailed examples and use cases will demonstrate the real-world application of this guidance. You'll learn valuable information to open your world of crypto assets even more.
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.
AICPA & CIMA Faculty Hour Series (6/26/2026)
-
Online
1.50 Credits
Understand emerging trends in academia Academics will receive timely and critical information on emerging issues and the latest news affecting accounting education. Subject matter experts provide insights, analysis, and practical guidance on the key issues facing the profession and academia. Faculty Hour contributors will share their experiences, tools, and resources to ensure the success of the next generation of accountants. In addition, AICPA & CIMA staff will provide the latest news concerning changes to regulations, exams, and licensure requirements that may affect faculty and their schools.
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.*
AICPA Town Hall Series (Rebroadcast of 6/25/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
Accounting for digital assets under US GAAP: Specialized accounting, fair value, and stablecoins
-
Online
1.50 Credits
Guidance on how to account for digital assets (bold): Accounting for stablecoins may not be stable: Though the use of digital assets is rapidly expanding, accounting guidance has not kept pace. As a result, accounting for digital assets can feel shaky. The AICPA can help: The AICPA practice aid on accounting and auditing for digital assets and this webcast can help you answer the question of what to do when you or your client accounts for stablecoins. You'll be helped to understand how to account for other transactions and investments involving crypto and digital assets under U.S. GAAP. You'll also learn more about what the AICPA is doing to lend clarity and guidance to this murky but increasingly important field. Learn how you can add more value: Whether you're a CPA with attest clients or an industry accountant responsible for corporate accounting policy, this guidance will give you a clear path to help your clients or firm by applying the most up-to-date accounting policy. Detailed examples and use cases will demonstrate 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.
Excel for Accounting Professionals Session 5: Error Trapping and Improving Lookups
-
Online
2.00 Credits
Practical hands-on Excel learning exercises taught by a highly engaging expert in the field You'll develop your expertise with real-world Excel workbooks. Despite the popularity of VLOOKUP, it has its drawbacks. This session will address these drawbacks while offering alternatives. You'll walk through the VLOOKUP and IFERROR functions, and explore the following topics: Improving the use of VLOOKUP with VALUE/TEXT Improving the use of VLOOKUP with MATCH. Moving beyond VLOOKUP with INDEX Trapping errors with IFERROR Moving beyond basic Excel functions Grasping the limitations and possible enhancements for the VLOOKUP feature, along with methods to handle errors can elevate your proficiency in Excel. You'll also partake in hands-on Excel activities that showcase the integration of functions and their use in crafting spreadsheets, encompassing: Combining functions to enhance flexibility Utilizing functions for atypical data categories Perfecting sophisticated lookup functions *Session 5 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 6: List Comparisons and Indenting] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-6--list-comparisons-and-indenting) to further prepare to tackle real-world issues and build powerful workbooks.*