CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
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.*
Advanced Tax Planning S Corporations - Tax Staff Essentials
-
Online
7.50 Credits
Intricacies of the S corporation form S corporations represent a special tax structure with unique rules and limitations. For those who've mastered the basics of the S corporation form, this course delves into advanced matters related to the ever-popular form: Basis in S corporation stock Compensation planning Use of qualified subchapter S subsidiaries S corporations in estate planning Updated for recent developments, including H.R. 1 It's important to stay current on legislation and IRS publications that affect S corporations, including H.R. 1, commonly referred to as OBBBA. Learners also gain insight into instances in which the IRS has permitted cures of a defective S corporation election or an involuntary S termination. The course also includes: Recently released revenue procedures New private letter rulings Other key pronouncements that are crucial to providing quality services to S corporation clients Part of Tax Staff Essentials Level 4 This self-study online course is part of Tax Staff Essentials Level 4, a comprehensive learning program that provides tax managers, directors, and partners with the advanced technical training required to work with their most sophisticated clients.
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.
Current and Upcoming FASB Issues
-
Online
2.00 Credits
Keeping up with FASB changes You'll explore changes in accounting, including: Relevant pronouncements Exposure drafts Projects Additionally, you'll be able to identify recently issued FASB standards and guidance that cover broad and narrow issues, as well as understanding how to apply them. You'll also learn about upcoming standards that will be effective in the near future.
AI-Powered Excel: Leveraging AI and ChatGPT for Supercharged Productivity
-
Online
1.00 Credits
Learn how to enhance your Excel workflows with AI in this course, "AI-Powered Excel: Leveraging AI and ChatGPT for Supercharged Productivity." Discover the various AI features built into Excel and how to use ChatGPT to create, understand and troubleshoot Excel functions and formulas. Imagine turning two-hour Excel tasks into two minutes of effort! This course will help you streamline your Excel work, research and documentation, saving you time and effort in your day-to-day tasks.
S Corporations: Key Issues, Compliance, and Tax Strategies - Tax Staff Essentials
-
Online
8.00 Credits
Explaining the misunderstood The S corporation form is unique and often misunderstood. You'll learn how to assist your clients with the most misconstrued areas of S corporation taxation and how they can use S status to their advantage. Updated for recent legislation, including H.R. 1 The world of taxation is never static. H.R. 1, commonly referred to as OBBBA and passed in 2025, affected virtually every type of taxpayer, including S corporations. Refreshed materials discuss the H.R. 1 provisions that affect S corporations and their shareholders, including the qualified business income deduction and Section 179 expensing. The course has also been updated for legislative and regulatory developments related to: Inflation Reduction Act SECURE 2.0 SECURE 1.0 Weighing the pros and cons S corporation status doesn't suit every business. Throughout the course, you'll learn when it is advantageous or disadvantageous to be taxed as an S corporation. Making the model work You'll be exposed to methods of effectively communicating with potential business clients and existing shareholders about how you can make the S corporation business model work for them. Part of Tax Staff Essentials Level 1 This self-study online course is part of Tax Staff Essentials Level 1, a comprehensive learning program that provides tax staff with the technical training required to support their teams.
Reviewing Individual Tax Returns: What Are You Missing?
-
Online
4.00 Credits
Catch errors on individual returns The sheer volume of individual tax returns requiring preparation can create a work environment that invariably leads to errors or omissions. A trained eye can spot mistakes. A case-based approach to learning return review Four case studies focus on issues that individual return preparers and reviewers will frequently encounter in their practice: Section 199A (qualified business income deduction) Home office deduction Rental properties Hobby losses Hiring of spouses Depreciation, including bonus depreciation Section 179 issues Organization and startup costs Temporary senior deduction State and local tax deduction In-course application Learners get access to four 2025 individual returns and try their hand at reviewing them for: Errors Areas for improvement Opportunities to educate or advise the client Developed with H.R. 1, commonly referred to as OBBBA, in mind, these returns are designed to provoke planning ideas for the modern client.
Excel for Accounting Professionals Session 6: List Comparisons and Indenting
-
Online
2.00 Credits
Major benefits of detailed Excel workbooks Understanding list comparisons in Excel is vital for improved workbook efficiency. In this webcast, the facilitator will walk you through comprehensive learning exercises that provide an overview of the following topics: Performing list comparisons Building multicolumn list comparisons Using lookups Indenting commands In-depth training for Excel upskilling This webcast is crafted to enable active participation as you follow the demonstrations. It will navigate you through the intricacies associated with working Excel columns, helping you to apply key functions effectively for significant improvements through the following: ISERROR COUNTIFS SUMIFS *Session 6 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 7: Data- Driven Workbooks and Concatenation] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-7--date-driven-workbooks-and-concatenation) to further prepare to tackle real-world issues and build powerful workbooks.*
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
Tax Fundamentals of LLCs and Partnerships - Tax Staff Essentials
-
Online
8.00 Credits
Building a solid foundation of partnership and LLC taxation A foundational understanding of partnership taxation is essential to a tax preparer's career. Given that most U.S. businesses are formed as pass-through entities, you'll likely encounter partnership tax matters that require your attention. This course covers the taxation of partnerships, including limited liability companies (LLCs) treated as partnerships for U.S. federal income tax purposes. Matters discussed include: Common transactions Check-the-box election rules Consequential court cases involving partnership formation Skills to explain partnership taxation matters to your clients Talking about tax can sometimes sound like speaking a foreign language to your clients. Learn how to explain complex issues with accuracy and confidence. Part of Tax Staff Essentials Level 1 This self-study online course is part of Tax Staff Essentials Level 1, a comprehensive learning program that provides tax staff with the technical training required to support their teams.
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 (Rebroadcast of 7/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
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.
Form 990: Best Practices for Accurate Preparation
-
Online
8.00 Credits
Take an in-depth look at Form 990. Dive into the 12-parts of Form 990 and its 16 schedules with a line-by-line analysis that offers explanations and tips for accurate completion. Updated for changes in 1099-MISC and 1099-NEC reporting, the webcast shows participants the ins and outs of reporting on Form 990.
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
Conducting a Remote Audit
-
Online
4.00 Credits
Auditing for today's world Remoting auditing is happening everywhere you turn. Understanding the considerations for a remote audit and the specific techniques for performing the engagement will help you integrate remote auditing into your practice. You will learn how to: Leverage the benefits of remote auditing Manage the team, client, and audit process remotely Identify engagement-wide procedures from client acceptance through report issuance when remote auditing Identify and obtain audit evidence for generally material accounts
Construction Contractors: Non-Revenue and Non-Lease Accounting Considerations
-
Online
4.00 Credits
Construction accounting fundamentals The construction industry stands out in its need to adhere to diverse accounting standards. Essential knowledge and key issues influencing the field are explored as you learn about the overall construction process through the following topics: Industry players Preparing cost estimates and bids Project management Contracts and modifications Unique accounting issues for contractors Various contractor expenses that affect job profitability need to be identified and examined to ensure accurate accounting of a company's total spending and performance. You'll review this concept and other characteristics unique to contractors as you gather critical information and learn the implications for CPAs. Relevant topics include: Contractor financial statements Common disclosures Supplementary information Working with a surety Surety is an integral part of the construction process. You'll take a detailed look at the benchmarks a surety might analyze in a contractor's financial statements as well as the following topics: Types of surety bonds The surety process Surety underwriting considerations Warning signs for the surety
The Bottom Line on the New Lease Accounting Requirements
-
Online
4.00 Credits
FASB ASC 842, *Leases* explained Understanding lease fundamentals is essential to applying FASB lease requirements appropriately. As such, you'll delve into key concepts that define what a lease is, as well as basic lease accounting topics, such as: Contracts containing leases Lease classification Amortization of the right-of-use asset Impairment considerations Lease presentation and disclosure requirements Comprehensive examples and case studies will guide you through approaches to help you adopt accounting guidance for FASB ASU 2023-01. You'll also review the presentation and disclosure requirements, and other topics, including: Lease versus non-lease components Sales-type lease Direct financing lease Operating lease Lease terminations
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.
Reviewing Partnership Tax Returns: What Are You Missing?
-
Online
4.00 Credits
Ways to avoid common errors A thorough review can spot errors that are commonly missed during the preparation of a partnership or LLC return. Course materials are designed to sharpen your reviewer skills by examining case studies and discussing complex LLC and partnership issues often missed by staff tax return preparers. Four case studies, four opportunities to apply your reviewing skills The course's case study-based approach is designed to increase comprehension and retention. Each case includes a narrative and a full 2025 tax return, developed to include the effects of H.R. 1, commonly referred to as OBBBA. Learners are encouraged to spot errors made in the returns and potential areas for improvement. Partnership tax filing requirements Course materials discuss the filing requirements for Schedules K-2 and K-3, including the availability of the domestic filing exception.