CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
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.
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.
Applying the Uniform Guidance in Your Single Audits
-
Online
7.00 Credits
You can learn to understand, assess and test internal control over compliance as you apply the Uniform Guidance in your single audits.
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.
Estate & Trust Primer - Tax Staff Essentials
-
Online
4.00 Credits
A comprehensive guide to estate planning and the taxation of trusts.
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.
The Crucial Connection - Why You Should Care About Your Client's System of Internal Control
-
Online
1.50 Credits
Conduct risk assessment the right way Regardless of the size of your client or audit budget, there are specific requirements in accounting standards and generally accepted auditing principles (GAAP) related to auditing internal control for risk assessment purposes. Take a deep dive into understanding your audit client's system of internal control to perform a more effective and efficient audit.