CPE + Events Catalog
Download the 2025-26 OSCPA-Select Calendars - .pdf
Excel for Accounting Professionals Session 7: Date-Driven Workbooks and Concatenation (2 hours)
-
Online
2.0 Credits
Member Price: $125
See more dates
Realistic Excel training for skill development Shifting from manual inputs to automated formulas in Excel can help enhance data efficiency. Understanding that Excel can handle date and text values broadens the potential to improve efficiency when managing data in Excel. This webcast will focus on the following essential functions: EOMONTH MONTH and YEAR DATE CONCAT SUMIFS with CONCAT Practical hands-on Excel learning exercises taught by a highly engaging expert In this webcast, you'll develop your skills and implement Excel techniques that will boost the effectiveness of conditional summing functions using comparison operators. Additionally, you'll gain in-depth knowledge of the following: Adding helper columns Distinguishing key function differences Combining values *Session 7 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 8: Dynamic headers, mapping tables and error check] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-8--dynamic-headers-mapping-tables-and-error-check) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Self-Rental Real Estate: Passive Activity & Section 199A (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This program presents a detailed analysis of the self-rental passive activity rules, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Lease Implementation for Private Entities 25-26 (4 hours)
-
Online
4.0 Credits
Member Price: $175
See more dates
The Financial Accounting Standards Board (FASB) has issued a new accounting standard for leases. This new standard?ASC Topic 842?replaces the existing ASC Topic 840, changes the accounting for operating leases (requiring capitalization in the financial statements), and upgrades many other lease accounting and reporting aspects.
More Dates
Mergers & Acquisitions Part 2: Financial Accounting 25-26 (4 hours)
-
Online
4.0 Credits
Member Price: $175
See more dates
This course is designed to provide a deep dive into purchase accounting, also known as business combination accounting or the "acquisition method" of accounting for business combinations. You'll become familiar with ASC 805, Business Combinations and recent Codification updates impacting purchase accounting. We'll discuss the key analysis points, including the definition of a business and identify which transactions require the application of business combination accounting. The course covers common difficulties, including joint ventures and non-controlling interests, determining the acquisition date, valuation allowances and most balance sheet categories, including intangibles, inventory and deferred income taxes. Be sure to register for both courses in this series: Mergers & Acquisitions Part 1: The Accountant's Role Mergers & Acquisitions Part 2: Financial Accounting
More Dates
Ethics Case Studies: Remaining Ethical in the Age of Oversharing (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
In an era when sharing a photo of lunch can be considered an "update," the ethical standards that define the CPA profession are not always as intuitive as they once were. Our expert helps you navigate this new realm by using real-world examples to help illustrate the dos and don'ts in ethical social situations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
2025 A&A Update With Technology Implementation (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
Stay informed and prepared with this comprehensive annual update on the latest developments in accounting and auditing. We'll begin with a deep dive into the Accounting Standards Updates (ASUs) effective in 2025, followed by insights from the FAF's 2024 PCC Review and an overview of FASB's Invitation to Comment - Agenda Consultation, which will shape the future of accounting standards. On the auditing side, we'll tackle the essential changes in quality management standards that firms must implement by the end of 2025. The session will also highlight common deficiencies identified by the DOL in EBP (Employee Benefit Plan) engagements and provide a peek at upcoming projects from the Auditing Standards Board (ASB). Join us to gain practical insights and actionable takeaways to navigate these updates with confidence. Finally, we will close the course by exploring the audit technology adoption process to help transform resistance into resilience as the industry embraces new technologies. We will learn how to overcome common barriers to deliver a successful implementation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
AI FAQs for Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of artificial intelligence and its transformative impact on the accounting profession. As we move into 2025, AI technologies are reshaping traditional accounting tasks while creating new opportunities for strategic advisory services. Participants will explore how AI differs from traditional software, understand various AI applications in accounting, and develop strategies to leverage these technologies while maintaining the essential human elements that clients value most. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Compilation, Preparation and Review Basics and Peer Reviews (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Cover the basic requirements for performing preparation, compilation, and review engagements under Statements on Standards for Accounting and Review Services (SSARS), including the new SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions. Review common issues found on SSARS engagements in connection with peer reviews and the impact of various findings on the results of a peer review. Identify key issues to consider during SSARS engagements, and determine how to incorporate quality control recommendations and tips for performing high-quality SSARS engagements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event
More Dates
Forensic Accounting: Court Approved Methods of Proof (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
How does a forensic accountant calculate financial losses? Federal courts have approved various ways to calculate losses ranging from net worth method of proof to the expenditures method. Each method of proof depends on the available facts to the forensic accountant. This presentation will focus on the various court approved methods of proof, when to use them, and how to calculate the total loss. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Basic Individual Taxation Course (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Please join us for an introductory course on the fundamentals of preparing and filing an individual federal income tax return. We will cover topics such as what the federal income tax is and how it is computed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Surgent's Guide to the AICPA Quality Management Standards (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
With only a few months to go before the AICPA's Statement on Quality Management Standards 1, 2, and 3 (SQMS 1, SQMS 2, and SQMS 3, respectively), SSARS No. 26, SAS 146, and SSAE 23 are required to be implemented, this course can help you meet the deadline. It focuses not simply on theory but on HOW to perform the steps involved. The Quality Management Suite of Standards must be implemented by December 15, 2025. The standards modernize the firm's approach to quality to reflect an increased focus on risk assessment, technology use, and the presence of outside experts on many engagements. Beginning with performing a risk-based approach, the standards provide accounting firms with the ability to enhance their quality control by shifting their focus to a proactive approach (management) from a reactive approach (control). The results of the firm's risk assessment will form the basis of its new Quality Management document. This is not just a tweak of the old document but a more robust document that adds new requirements from the new standards. We will cover how to perform a risk assessment, including the key provisions of the standards, and how to effectively implement a monitoring plan. We will also review how the firm will evaluate its System of Quality Management beginning in 2026.
More Dates
Taxation of the Cannabis Industry (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course offers a comprehensive exploration of the cannabis industry, delving into essential topics such as cannabis regulations, business models, financial management, and ethical considerations. A key focus is on distinguishing between Marijuana and Industrial Hemp, including their respective tax treatments. Participants will gain a thorough understanding of the unique challenges and opportunities within the cannabis sector, covering federal and state tax implications, licensing requirements, and market trends. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Leadershift Ethics: Things Must Change! (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
With the rapid pace of change, change now happens daily in business and our personal lives. It can be difficult to navigate change when right and wrong get a bit fuzzy. New processes, new technology, new circumstances and new impacts to people must be measured and decisions made as the change evolves. Change always becomes something different than what was originally planned or imagined. In this session, learn how to measure your ethics through change. You will learn how to filter everything you do during change through a simple litmus test. Through the power of story, you will learn from the lessons of other organizations and their ethical mistakes. Lastly, you will take away what is required to manage yourself so that when ethical decisions arise, you have the mental capacity to manage through it well. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Excel for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check (3.5 hours)
-
Online
3.5 Credits
Member Price: $175
See more dates
Relevant Excel methods for accounting experts In Excel, there are several opportunities to apply features, functions and methods to build a dynamic workbook. In this hands-on demonstration of several Excel skills, you'll review the following topics through engaging expert-led instruction: Dynamic headers Horizontal reports Mapping Tables Data Validation Excel error checking skill development Designed with time for you to work along with the facilitator, this webcast examines the importance of automating reporting workbooks in Excel. You will review various topics, including: Horizontal or crosstab reports Mapping tables and how they are the key to unlocking major efficiency gains. Data validation in digital reports Error Check *Session 8 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 other parts of the bundle. [Excel for Accounting Professionals Webcast Series] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-webcast-series-bundle) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Mastering Partnership Basis: Inside and Outside Basis (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course will provide a detailed analysis of how to determine a partner's tax basis for a partnership interest, with an explanation of the use of both "inside" and "outside" basis determination. An illustrated example with filled in forms will demonstrate how the process works and the potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
How Fraud Can Affect Smaller Organizations (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
Many small to medium sized companies do not properly address the risk that arises related to fraud because these organizations do not have the resources needed to mitigate this risk or because owners or those in top level management underestimate the scope of the issue. All organizations, regardless of size, must be aware of the risks associated with intentional fraudulent acts and know that a significant and effective fraud scheme could even create going concern issues for some entities. In this session, we delve into the reasons that fraud takes place. The material discusses the types of defalcations that are often executed against smaller entities and then explores measures that organizations can implement to help stop fraud activities and add security. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Creating an Ethical Work Environment (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This session introduces theories on human nature and organizational factors affecting ethical choices. Robbie examines the role of gossip in the workplace, provides tools for ethical decision making and offers concrete actions for creating and sustaining an ethical work environment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Improve Spreadsheets by Building Controls in Excel (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
In today's data-driven world, spreadsheets serve as the backbone of business and personal productivity. However, creating complex and error-prone spreadsheets can lead to critical mistakes and inefficiencies. This course aims to equip you with the knowledge and tools to build robust spreadsheets, implementing a range of controls and safeguards to ensure data integrity, streamline processes, and maximize accuracy. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
How to Build a Custom AI Chatbot and GPT in Plain English (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Participants will learn to create customized AI chatbots that can enhance client interaction and internal operations-all without coding experience. This course provides a concise overview of specialized, task-oriented AI chatbots and GPT builders, focusing on how these technologies are revolutionizing professional workflows. Through hands-on exploration of platforms like AgentGPT, Claude Projects, Gemini Gems, and NotebookLM, participants will learn to design, deploy, and manage custom AI assistants tailored to their specific needs. The course emphasizes creating advanced AI apps that can understand context and solve complex problems autonomously. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
How to Audit Inventory (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Inventory observations are often a right of passage for audit staff. This course will cover the basics of auditing inventory, including the related audit assertions, risks, & threats to inventory. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through how to conduct a physical inventory observation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.