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.
Leveraging Marketing Automation for Accounting Firm Growth (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
This course will provide an overview of 6 key areas of automation that accounting firms can leverage to effectively increase their lead generation and client retention efforts while reducing the burden on their time and budget. These areas include: 1. Social media 2. Content development. 3. Email marketing. 4. Text (SMS) marketing. 5. Chatbots and other interactive AI tools. 6. Drip marketing campaigns. Attendees will receive a practical guide to the technologies and tactics needed to improve marketing efforts with efficiency and ease! 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 Getting Ahead: The Art of Marketing for CPAs (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
To many clients, CPA firms all look the same. While services and specialties may vary significantly from one firm to another, it is hard for the average person to see this by simply looking at the sign outside our office door. Is there any way to make us stand out more to the outside world? Through surveys, statistics, and examples, this course looks at how CPA firms can develop a marketing plan beyond just relying on referrals. We look at the pluses and minuses of various marketing channels, regulatory constraints, and how to measure success in the competitive financial services space.
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
Building Personal Leadership Skills (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $129
See more dates
People skills are the most significant skills that professionals need to develop and yet are often the last skills perfected. This course will help participants understand personality types and the successful interactions with clients, peers and family. In addition, participants will learn Neuro-linguistic programming and develop the ability to better understand nonverbal language, which is key to communication. Participants will also learn techniques to enhance memory and to improve the ability to recall key facts.
More Dates
Surgent's Key Current Financial and Economic Issues Facing the Financial Executive [NT]
-
Online
8.0 Credits
Member Price: $279
The course explores the challenges of the current economic trends and analyzes their impact on you as the financial executive in areas of human resource management; credit markets and banking; risk management and pandemic style disruptions; cash flow planning strategies; debt and equity mix impacts in uncertain markets; globalization of the market in times of uncertainty; retirement planning and social security funding; and acquiring distressed companies and assets. Specific recommendations and insights will be offered to you to deal with the challenges.
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
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
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
Staff Retention Keep the Best People (3 hours) [NT]
-
Online
3.0 Credits
Member Price: $99
See more dates
The COVID pandemic changed the way many people worked, yet others have had remote teams for decades and little changed. Many organizations trying to bring people back to the office have experienced significant turnover. Some practices have changed forever while some principles will always remain the same. Keeping your people happy equals keeping your best people. Learn the changes you should make now and the things you should do forever!
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
Mission-Critical Leadership: How Smart Managers Lead Well in All Directions (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $79
See more dates
Most leadership development focuses on a single direction within the organizational hierarchy: downstream to subordinates. While it is important to be a good boss, leadership is much more than that. The best leaders learn to lead well in all directions. They lead upward to superiors and across among peers throughout the organization. And it all starts with self-leadership. This often overlooked or misunderstood leadership principle is essential to build a thriving and productive culture. This topic is based on Jon’s book, Mission-Critical Leadership: How Smart Managers Lead Well in All Directions.
More Dates
Surgent's Leveraging AI for Data Analytics in Accounting (2 hours)
-
Online
2.0 Credits
Member Price: $99
This course explores the data analytics aspects of AI in accounting. Participants will develop skills in leveraging AI tools for enhanced data analytics.
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
Surgent's Unconscious Bias in the Workplace (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
This interactive professional development course explores the concept of unconscious bias and its impact on workplace dynamics, decision-making, and organizational culture. Through engaging exercises, real-world case studies, and reflective activities, participants will gain a deeper understanding of how implicit attitudes shape perceptions and behaviors - often without conscious awareness. The course empowers learners to recognize their own biases, understand their origins, and develop strategies to mitigate their effects in professional settings. Participants will leave with actionable tools to foster a more inclusive, equitable, and respectful workplace.
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
Surgent's Generative AI and Cybersecurity: Opportunities and Threats (2 hours)
-
Online
2.0 Credits
Member Price: $119
This course explores how generative AI is revolutionizing cybersecurity. It highlights opportunities, such as enhanced threat detection, and risks, including AI-driven phishing and malware, particularly in financial contexts.
Tech It to the Next Level: Slim Your Team for Max Efficiency (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
Ready to slim down your team and maximize efficiency without sacrificing quality? This session breaks down how to leverage tech and automation to fill workflow gaps, build a strong tech stack, and connect tools seamlessly. Learn how one proven tech stack replaced more than half a traditional team while improving client satisfaction and reducing overhead. Walk away with practical steps to streamline operations, automate repetitive tasks, and focus your resources on what really matters. Attendees will gain practical insights into streamlining operations, automating repetitive tasks, and focusing resources on high-value activities. The session also includes an exclusive look at a proven tech stack used to replace over half a traditional team, offering actionable steps to create a leaner, tech-driven, scalable firm. Perfect for firm owners ready to rethink staffing, reduce overhead, and embrace the future of accounting efficiency. 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
Money Laundering 101 for CPAs (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
CPAs spend most of their working lives reviewing bank statements and books and records of businesses. They are experts in understanding how to prepare financial statements according to GAAP. But would a CPA know a possible money laundering transaction if they saw it? Would they know about a money laundering business? Money laundering is a subject of many action and thriller movies, but rarely understood. This presentation will educate the CPA in understanding the basics of money laundering and how to identify money laundering. This presentation will help the CPA know the truth about money laundering, how to identify it, the statutes that define it, and the court cases that interpret 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
The 10 Must Know Excel Features (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. 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
Not-for-Profit Knowledge Network: Audit Preparation ( 1 hour - morning) - Webcast
-
Online
1.0 Credits
OSCPA Members: One hour FREE CPE offered at each knowledge network! The OSCPA Not-for-Profit Knowledge Networks offer a great opportunity to explore important not-for-profit topics in one-hour informal discussions with experts and peers - and to obtain valuable CPE. Developed by OSCPA Not-for-Profit Strategic Committee.
