CPE + Events Catalog
2026-27 OSCPA-Select CPE Courses Now Available!
Browse CPE by Field of Study, and use the Format/Type filter to narrow by In-Person, Webcast, Bundles or On-Demand.
Leverage PowerBI.com to Create Data Analysis for Others (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Unlock the full potential of data analytics with our specialized course, "Leverage PowerBI.com to Create Data Analysis for Others". This two-hour, intensive training is specifically designed to empower professionals in harnessing the powerful features of Microsoft PowerBI.com. Whether you're a data analyst, business intelligence professional, or someone keen on mastering data visualization and report creation, this course is your gateway to becoming a proficient Power BI user. Dive into the dynamic world of data analytics and learn to transform raw data into visually compelling stories that drive decision-making. Our expertly crafted program offers a deep dive into the essentials of PowerBI.com, starting with a comprehensive tour of its interface and core concepts. You'll gain experience in connecting to diverse data sources, creating stunning visualizations, and building interactive dashboards that communicate insights effectively. The course also covers the innovative Q&A feature of PowerBI.com, allowing you to explore data with natural language queries. By mastering the art of sharing datasets, reports, and dashboards, and creating comprehensive apps, you'll be equipped to deliver top-tier data analysis solutions to colleagues and clients alike. Through this course, attendees will gain a deep understanding of how to leverage the PowerBI.com platform to disseminate datasets, reports, and dashboards, catering to the specific needs of their audience. Our course is tailored for those who aspire to lead in the data-driven landscape, offering not just theoretical knowledge but real-world applications. Upon completion, participants will not only have a thorough understanding of PowerBI.com but also the confidence to apply this tool in creating impactful data analysis for diverse audiences. Join us to elevate your professional skillset, make data-driven decisions with ease, and add a valuable credential to your portfolio. 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 Annual Update for Governments and Not-for-Profits (7 hours)
-
Online
7.0 Credits
Member Price: $209
See more dates
This comprehensive course provides the essential updates for professionals working with governments and not-for-profit organizations. We'll begin with an in-depth review of recent GASB standards, including compensated absences, certain asset disclosures, risk and uncertainty disclosures, and financial reporting model improvements. For each standard, we'll cover its background, potential impact, and practical strategies for implementation to ensure you're fully prepared. Next, we'll shift focus to the FASB and its implications for nonprofit organizations. While there haven't been recent nonprofit-specific standards, several Accounting Standard Updates (ASUs) significantly impact NFPs. We'll explore these ASUs, evaluate changes to programmatic investments, and discuss their interplay with the CECL standard. Additionally, we'll highlight the movement in IFR4NPO, a global initiative to develop universal financial reporting standards for nonprofits, offering insights into its potential worldwide impact. In the second half, we'll turn to governmental auditing. Key topics include the 2024 Yellow Book updates, the transition from quality control to quality management, and the implementation timelines. For Single Audits, we'll cover the 2024 Uniform Guidance changes, the 2025 Compliance Supplement, GAO reports on improper payments and fraud, the Financial Data Transparency Act (FDTA), and recent Department of Education guidance on related parties.
More Dates
Excel for Accounting Professionals Session 3: Workbook Design Principles and Organization (2 hours)
-
Online
2.0 Credits
Member Price: $125
See more dates
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.*
More Dates
Surgent's Workplace Harassment: How to Prevent Harassment and Reduce Liability Risks in Today's Changing Environment (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
Workplace harassment - especially sexual harassment - has dominated headlines in the last several years. With discussions of workplace harassment in the news, employees better understand their rights and feel more empowered to speak out, and the standard of appropriate workplace conduct is changing. With workplace harassment claims continuing to be filed at a steady pace with the United States Equal Employment Opportunity Commission, state agencies, and the courts, it is more important than ever to understand how to prevent and avoid harassment in the workplace.
More Dates
Surgent's Tax and Advisory with Agentic AI (2 hours)
-
Online
2.0 Credits
Member Price: $119
See more dates
This course examines how agentic AI is revolutionizing tax compliance, planning, and advisory services. Participants will explore real-world deployments by leading firms such as EY, which has developed agents that handle millions of global tax transactions. The course also delves into cross-border compliance issues, transfer pricing automation, and emerging advisory models powered by agent-led simulations. Risks related to bias, unauthorized practice, and data privacy will be addressed, with guidance on aligning autonomous operations with professional and regulatory standards. CPAs must understand these advancements to ensure tax compliance, manage client expectations, and mitigate professional liability risks when providing agent-assisted advisory services.
More Dates
AI Lessons Learned for Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides accountants with the leading AI insights and strategies drawn from real-world experience, empirical studies, countless CPA case studies, and social media commentary. It goes beyond theory, offering practical lessons learned from the front lines of AI implementation in the business world and accounting industry. Participants will gain actionable knowledge on bridging the theory-application gap, navigating exponential technological changes, and creating secure, adaptive AI policies. By the end of the session, accountants will be equipped to leverage AI responsibly and innovatively in their roles. 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 4: Conditional Summing and Lookups (2 hours)
-
Online
2.0 Credits
Member Price: $125
See more dates
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.*
More Dates
Take Command of your Time (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Manage distractions, decrease stress and improve productivity. This training is designed to help business professionals improve their productivity and work performance by learning how to prioritize time, decrease distractions and lower stress. 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
Surgent's Information Security and Privacy (2 hours)
-
Online
2.0 Credits
Member Price: $99
In today's interconnected world, safeguarding information systems is crucial. This course offers a deep dive into information security and privacy principles with a focus on modern cybersecurity threats tied to cloud environments, Internet of Things (IoT), and mobile technologies. The course will also cover data protection during application development. Taking this course will equip accounting professionals with the knowledge to lead in cybersecurity strategy.
Effective Coaching Strategies for High Performance (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $129
See more dates
This business coaching course is designed to enhance your coaching effectiveness by integrating innovative tools like ChatGPT (Generative AI) to support and elevate your coaching practice. You'll explore the key differences and similarities between coaching and managing, uncover the most important skill every coach should master, and learn how to get to the root cause of any problem. With hands-on coaching strategies, including neuro-linguistic programming (NLP) techniques, you'll enhance your ability to drive results. Additionally, you’ll discover how to use performance gap analysis to identify and bridge gaps, ensuring the success and growth of the individuals you coach.
More Dates
Managing Current Fraud Trends in a Shifting Environment
-
Online
8.0 Credits
Member Price: $239
See more dates
As our business environment shifts, so do trends with fraud schemes and perpetrators. This course will give you the absolutely latest information with how to identify and mitigate shifting fraud risks in any entity. 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
Cryptocurrency 15 Years Later - A Market Update (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
Bitcoin, the original cryptocurrency, was released in 2009. After 15 years the cryptocurrency market consists of over 5,000 unique coins/tokens with a market capitalization of over 1.5 trillion as of 1/1/24. This course will provide an update on the cryptocurrency market and the blockchain technology that supports it. 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
Talk This Way - Communication Skills for the CPA (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Have you ever met an accountant who exhibits solid technical prowess but possesses lackluster communication skills? It is not unusual to meet a savvy accountant who is a technical expert but could enhance the delivery of written and spoken words. This course is designed to help CPAs improve their written and verbal communication skills. Participants will learn how to tailor communication to their audience, with particular emphasis on techniques for crafting a message that effectively conveys technical information in an engaging manner. The course's author will share personal success tips gleaned from more than two decades of experience communicating myriad topics to a variety of audiences. 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
Advanced ChatGPT for Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course concisely explains the latest "see, hear, speak" multi-modal updates to ChatGPT and how they can be used in an accounting context. New features include vision processing, voice conversation, image generation, real-time Internet access, advanced data analysis, plugins and more. Discover how this technology can be used in mind-blowing ways to analyze financial data, optimize processes, and solve problems in the accounting domain. Through the lens of ChatGPT, practitioners can explore innovative solutions, automate routine tasks, and generate deeper insights and value to their clients and organizations in previously unimaginable workflows. You'll walk away with scores of advanced ChatGPT strategies and tips that can be immediately applied and deliver instant results to elevate the efficiency and effectiveness of your accounting projects and 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
ChatGPT: What Every CPA Should Know-Updated (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Don't look now, but ChatGPT is taking the business world, including the accounting profession, by storm. Every CPA, whether in public accounting or working in corporate, should have a fundamental understanding of ChatGPT and generative AI applications more broadly. This course will provide you with a foundation of knowledge about ChatGPT technology that will prepare you to have conversations with clients, customers, colleagues and service providers. More importantly, you will learn how to leverage ChatGPT to increase your personal productivity. If you feel your ChatGPT knowledge is lacking, that will not be the case after you attend this course, taught by John Higgins, one of the leading technology strategists and thought leaders for the accounting profession. 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
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
Emotional Intelligence for Professionals: Mastering the Human Side of Success (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
Technical expertise may get you in the door—but emotional intelligence (EQ) is what builds trust, earns loyalty, and sustains lasting success. For CPAs, attorneys, financial professionals, bankers, and insurance agents, your ability to navigate emotions—your own and others'—is often the difference between a good client interaction and a great one, between a team that functions and a team that thrives. This interactive course goes beyond theory and dives into real-world application. You’ll uncover what emotional intelligence really is, why it matters more than ever in today’s professional world, and how to strengthen your EQ to improve performance, strengthen relationships, and manage stress with confidence. You’ll walk away with tools you can use immediately to transform how you lead meetings, manage conflict, build client trust, and drive results—while also enriching your personal life. Whether you're looking to become a better leader, communicate with more clarity, or create meaningful client connections, this course gives you the insight and strategies to make it happen.
More Dates
Surgent's Data Security: Best Practices to Protect Your Business and Yourself (1 hour)
-
Online
1.0 Credits
Member Price: $59
See more dates
Data security is a front-of-mind topic for most businesses because the risk and cost statistics are sobering. Each of us is in the crosshairs because a typical internet-connected computer faces a cyberattack every 39 seconds. Businesses of all sizes should be cognizant of the ethical issues that must be considered when planning their approach to privacy and data security. In this webinar, we will explore both the risks we have traditionally faced in the workplace personally, as well as the novel set of data privacy threats and compliance challenge issues employers face with a remote and mobile workforce.
More Dates
