CPE + Events Catalog
Download the 2025-26 OSCPA-Select Calendars - .pdf
SECURE Act 2.0 and Updates (2025) (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
After a false start in 2022 when it failed to pass through Congress, the Secure Act 2.0 was passed in a flurry of year-end legislation. This two hour program will cover the important changes in savings and distributions of retirement plans that impact individuals. Employers will also need to consider how Secure Act 2.0 will the administration of existing plans or the creation of new ones. This course will provide a concise look at these hot topics. 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
Ethics without Fear for Accounting and Finance Professionals (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $125
See more dates
Finance and accounting professionals are on a pedestal and are often held to a higher standard. Keeping your ethical skills sharpened is crucial to reducing your fear and raising your courage as you solve tough decisions in real-time. This fast-paced and interactive presentation will help you practice exactly that. What will you gain? The ability to choose the most effective path in daily situations, so that when a significant crisis hits you are comfortable in your actions. Be ready, be courageous, be fair, and be consistent.
More Dates
Excel for Accounting Professionals Session 1: Tables and Named References (2 hours)
-
Online
2.0 Credits
Member Price: $125
See more dates
Transforming how you use Excel with engaging and expert-led instruction Designed for you to work alongside an expert and complete the same exercises, you'll dig deeper into topics, including: Benefits of using named references for faster navigation Increased versatility and efficiency withing your Excel workbooks Excel Tables special properties and Error reduction for greater productivity. Mastering Excel functions Excel mastery involves understanding how to create functional and efficient workbooks. The instructor will guide you through Tables, named references, and more as you build on basic Excel skills and use critical functions, such as: Excel conventions Critical shortcuts Efficient navigation techniques Automatic formula updating *Session 1 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 2: Data Validation and Conditional Formatting] (https:// https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-2--data-validation-and-conditional-formatting) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Supporting Mental Wellness to Thrive in Work and Life (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
In today's fast-paced world, maintaining a healthy work-life balance is essential for mental wellness. This course is designed to provide practical tools and strategies to help you create a balanced, fulfilling life. You'll learn actionable techniques for improving sleep hygiene, incorporating proper nutrition, fostering open communication, and managing stress. Whether you're struggling with burnout, seeking better work-life harmony, or simply looking to improve your overall well-being, this course offers valuable insights and tools to help you thrive. Designed to fit into your busy schedule, it delivers the guidance you need to make practical, sustainable changes in your life, starting today. 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
Build a Data Model for Analysis in Power BI (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. 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
Tax Depreciation: Review and Update (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
A discussion of recent law changes that impact capitalization, depreciation, and disposition of assets. 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 Basics of Employment Law for Non-HR Professionals (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
Learn the basics of employment law and how they affect best practices to help control the interview and discover hidden talents of applicants.
More Dates
Surgent's Hiring New Workers and Payroll Taxes (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
When a new employee is hired, there are a lot of things the employer needs to take care of. Aside from getting employment contracts signed, training lined up, and the new hire breakfast planned, employers are tasked with making sure all of the payroll forms are filled out. For many small business owners, this can be a source of anxiety. They often wonder if they have everything they need. They also hear horror stories about potential IRS penalties for not having all of the boxes checked. In this course, we will explore the payroll compliance side of hiring new employees. From the alphabet soup of forms that need to be filled out to the initial payroll tax forms, we have you covered if you are a new practitioner or new business owner. We will even discuss the surprisingly difficult-to-navigate world of unemployment insurance.
More Dates
ChatGPT Bootcamp for CPAs with John Higgins (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
ChatGPT is the fastest growing application in the history of technology with over 100 million users adopting it in within two months. It is a revolutionary technology that boosts the quality and efficiency of business processes in every industry. As "knowledge workers", CPAs and CFOs are positioned to be prime beneficiaries of this technology. This half day hands-on course will get you well on your way to becoming a ChatGPT expert. John Higgins, a nationally recognized advisor and educator on CPA technology, will guide you through the process of accessing ChatGPT and applying it to a variety of practical accounting, finance and tax scenarios. This course will catapult you to the top of the pyramid of CPAs who are knowledgeable in ChatGPT and you will be ready to put it to use in your day-to-day tasks. 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
Enterprise-Wide Risk Management in Accounting and Finance (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Organizations are challenged with identifying, evaluating, and responding to a wide variety of risks. This course will discuss tips and best practices for enterprise-wide risk management for accounting and finance professionals. 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
The Leadership Skills of Tomorrow: Delegate and Listen (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Mastering two leadership skills will decrease your stress, and give you room to enjoy your career. Delegating and listening are key essential skills to hone to elevate your career. You were born with two ears and one mouth. And yet, good listeners aren't born. World-class listeners deliberately practice this skill, even when their audience is challenging. This is a skill which can be learned. Participants will gain awareness into their blind spots to listening, strategies to regain focus, how to stop interrupting, and demonstrate to their audience they are listening. How often have you said, "It would just be easier if I did this myself?" or "Nobody can do this task as well as I can, so I'll just do it myself." If this sounds like you, then it's time to start working on your delegation skills. Delegation is not only important as a means to save you time, but it is also about developing the next generation of leaders. 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 2: Data Validation and Conditional Formatting (2 hours)
-
Online
2.0 Credits
Member Price: $125
See more dates
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.*
More Dates
The Ethic of Teamwork (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
"No one cares how much you know until they know how much you care." To be a part of a team, a team that truly cares for its people, is to be granted an opportunity for growth and inclusion and a sense of belonging. It doesn't get better than that! This ethics-based webinar examines the essence of what constitutes teams that are high functioning and highly collaborative. One essential component is the balance between content (getting the job done!) and process (how we get things done...how we treat each other). This webinar will offer concrete practical suggestions for teams both for content and process effectiveness. It will also offer opportunities for self-reflection and actions to take to enhance team performance. 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
GPT Builder for Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of using ChatGPT's GPT Builder to create custom GPTs specifically tailored for accounting professionals. Learn how to leverage this powerful tool to streamline accounting workflows, enhance client services, automate routine tasks, and improve financial analysis capabilities through customized AI solutions designed for accounting-specific applications. custom versions of ChatGPT with added skills and knowledge for specific tasks or industries. This course is designed to guide accountants on how to leverage these enhanced ChatGPT functionalities to streamline financial workflows, analyze data, and engage in more dynamic, multi-modal interactions. 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
Taking Advantage of Array Formulas in Excel (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. 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
Accounting of the Soul: Making the World a Better Place (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
This workshop explores how each of us can play a part in helping to make the world a more fair and gentler place. This one-hour webinar includes an overview of Aristotle's virtue ethics and its application to present day life. We will focus on the virtue of compassion both individually and organizationally and its impact on individual, organizational and world wellbeing. 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
Clean, Transform & Load Data in Power BI (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. 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
2024 Revision to Government Auditing Standards Impact (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This course will provide an update of Government Auditing Standards as a result of the GAO's issuance of the 2024 Revision to Government Auditing Standards. The course will focus on the Revisions impact on financial statement audits. The course will also focus on the impact of Quality Management Standards as well as clarify as to when the concept of reporting key audit matters might apply for financial audits. 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
Tax Season Update for Individuals with Steve Dilley (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This program provides an update to the latest tax developments, rules and regulations impacting individual taxpayers, with a review and integration of the numerous 2024/25 legislation. 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 Changes in Business Methods Affects Internal Control
-
Online
8.0 Credits
Member Price: $239
See more dates
New Technology, the move toward telecommuting, the widespread adoption of electronic documentation, and a wide range of other factors have significantly and forever changed the way business is conducted. It should go without saying that changes in tools and methods lead to upheaval in any organizations internal control system. In this session, we look at all the changes that are occurring and discuss what's coming in the not too distant future. The material then looks at how internal controls have been affected and what other updates are on the horizon. Anyone trying to use controls to keep their organization efficient and secure should consider this session because the rate of change to both operational methods and control processes has been and will continue to be incredible. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.