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
Comprehensive Update: FASB, AICPA (SAS, SQMS, SSARS & Ethics) 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
This 8-hour program covers recent promulgations of the FASB and AICPA. In addition to the latest ASU, SAS and Ethics interpretations, the course includes the 2-hour SSARS Highlight Reel and 2-hour SQMS programs available as stand-alone courses.
More Dates
Living Trust Administration Workshop 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
Gain hands-on knowledge while focusing on the trust administration process on the death of the single settlor and the first spouse in a joint settlor trust. In today's estate tax environment, with a change of the exemption in 2026, the answers to core questions concerning whether to file an estate tax return, make a portability election or make a QTIP election may surprise you. Learn what clauses to look for in the trust; when and how to make portability and QTIP elections; when to use the "Delaware Tax Trap" in place of QTIP election; how to educate the client concerning trust administration; and how to deal with assets outside the trust. Using checklists and forms, understand how to create a practical system for administering the living trust after death.
More Dates
Top 10 Things to Know About Estate Taxation & Planning 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
Clients believe that estate planning is only for the wealthy who will owe Federal estate tax. This isn't the case. Perhaps as a result of the 2020 pandemic, estate planning has a renewed focus. All practitioners should be familiar with the vernacular, acronyms and techniques. Estate planning involves personal issues that affect everyone, whether or not the estate tax will apply. Learn strategies to pass assets to future generations; provide education benefits; distribute retirement benefits, and provide a charitable legacy.
More Dates
Staff Tax Training: Partnerships and LLCs – Form 1065 25-26 (16 hours)
-
Online
16.0 Credits
Member Price: $589
This two-day training course provides a comprehensive understanding of the Federal income tax laws applicable to partnerships, limited liability companies (LLCs) and limited liability partnerships (LLPs) and their owners. The cornerstone of this course is the integration of the most recent tax laws and theories into real-world case scenarios that teach the preparation and review of IRS tax forms and schedules. Attendees will receive a comprehensive partnership/LLC income tax reference manual that includes practice aids, real-world examples, new Federal income tax forms and schedules, and Pat Garverick's Quick Reference Chart.
Risk Assessment Under SAS No. 145: The Key to Audit Quality? (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
The AICPA has identified risk assessment as an area of focus for its Enhancing Audit Quality Initiative as deficiencies in auditor's risk assessment procedures continue to be a common issue identified in peer review. SAS No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was written to improve the quality of risk-based audits. While key concepts do not fundamentally change, the standard works to clarify and enhance certain aspects of the identification and assessment of the risks of material misstatement to drive better risk assessments and hopefully overall enhance audit quality. 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
Reviewing Individual Tax Returns (2 hours)
-
Online
2.0 Credits
Member Price: $125
See more dates
The volume of individual tax returns requiring preparation can create an environment that leads to errors or omissions. Identify common errors practitioners make on individual tax returns for single filers.
More Dates
The Ethic of Recruitment and Selection (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Today, more than ever, it is essential that employers have an ethical and effective recruiting strategy and selection process that fosters an environment of diversity and inclusion. This webinar focuses on identifying recruiting strategies that help to increase talent pools and employment interviewing that maximizes hiring success. 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
Comprehensive Accounting and Financial Reporting Update (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This course covers recently issued accounting and financial statement reporting standards from the Financial Accounting Standards Board. Key implementation challenges and experiences from public company filings will be identified. 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
Navigating IRS Collections: The Collection Process (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course is designed for tax professionals seeking to understand and navigate the IRS collection process effectively. Participants will gain indepth knowledge of the various collection methods employed by the IRS, including liens, levies and wage garnishments. Additionall, participants will leand strategies to avoid or halt collection actions and the implications of the statute of limitations on tax collection. 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
Determining Reasonable Compensation for Owner Employees (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
This session will expand on methodologies to employ when owner-employee compensation is at issue. The session will focus on determinations of reasonable replacement compensation for individuals who both provide services to a closely held business or professional practice and also have an ownership stake in the enterprise. Executive Compensation in the form of options and restricted stock will also be covered in the context of marital dissolution proceedings. 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
Strategic Foresight (1 hour)
-
Online
1.0 Credits
Member Price: $75
See more dates
In this FutureReady course, Tom Hood explains how Strategic Foresight is crucial to preparing your organization for a future of exponential change. First, he defines Strategic Foresight and shares different ways of applying it. Then, he demonstrates how to prepare for a future that you can't yet see. And finally, Tom covers different types of innovation and how to apply them to your career and organization.
More Dates
How AI Fits into the Accounting World (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This session is designed as a primer to introduce artificial intelligence (AI) and to discuss how it will impact accountants as they work. The material will briefly explain what AI is and then focus on ways that it is already serving those in the accounting realm. It will close with a look at future AI-centric developments that will have great potential to positively impact the accounting profession. Those wishing to gain an understanding of what artificial intelligence is and how it will be used by accountants should consider attending this session. 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
Create Measures in Power BI that Define Your Metrics (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. 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
Exploring the New Lease Accounting Standard (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
It's a whole new world for lessees under ASC topic 842. This program will dive into the new standard on leases and its impact on every size entity, review effective dates, and address what you need to know now. 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
ChatGPT and Advanced Accounting Research (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of how artificial intelligence, particularly ChatGPT and other AI tools, is transforming accounting research methodologies and practices. Students will explore the shift from traditional search engine-based research to AI-driven insights, learning how to leverage various AI platforms for enhanced financial analysis, regulatory compliance, and strategic decision-making. The course emphasizes practical applications of AI in accounting contexts while addressing critical considerations such as data verification, ethical usage, and professional judgment. 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 Working Remotely: Best Practices, Challenges, and Opportunities (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
Working from home presents both benefits and challenges for professionals. For employees, working from home provides opportunities to be more productive and gain time that would otherwise be spent commuting to and from the office. Employers who utilize remote work enjoy fewer fixed costs, more efficiency, and greater employee satisfaction. Without proper planning, professionals who work remotely may experience increased anxiety and disorganization. They may also jeopardize data privacy. However, when executed properly, working remotely can help organizations become more efficient and profitable, while at the same time improving employee morale. This course looks at how firms and companies have successfully implemented work from home programs and discusses mistakes that can be avoided through proper planning.
More Dates
Lessons on Fraud Prevention from Sam Bankman-Fried's Crypto (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This course chronicles the decisions that led to the arrest of Sam Bankman-Fried (SBF), and helps participants understand the consequences that will follow for people charged with business-related crimes. Authorities arrested SBF pursuant to a grand jury indictment that charged him with wire fraud, securities fraud, money laundering, and related conspiracy charges. This lesson chronicles how the former billionaire's business decisions exposed him to criminal charges that include potential penalties of more than 100 years in federal prison for his alleged role in defrauding investors who trusted in his ability to make ethical decisions. Participants will learn about the criminal justice process, including indictments, arrest, extradition, judicial proceedings, mitigation, sentencing, prison, and collateral consequences. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.