CPE + Events Catalog
2026-27 OSCPA-Select™ CPE - 2 catalog options:
Browse CPE by Field of Study, and use the Format/Type filter to narrow by In-Person, Webcast, Bundles or On-Demand.
You Don't Know What You Don't Know About Microsoft Excel [NT]
-
Online
8.0 Credits
Member Price: $239
See more dates
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. 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 the Financial Executive's Leadership to the Next Level (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Financial Leaders often achieve their position primarily with left brain analytical skills. They need to develop right brain thinking to evolve to the next level either professionally or as part of their personal growth plan. This course will help the financial executive and professional focus on where they are currently and help them bridge the gap in leadership skills that will enable them to gravitate to the next level. This course will guide the financial executive and professional to position themselves as leaders that others will trust and want to follow. The financial executive and financial professional will walk away understanding a more holistic approach to people and organizations and a transformational leadership style.
More Dates
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.
More Dates
Mastering the Excel Lookup Functions (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. 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
Workforce Transformation and Talent Management in 2025 (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
The accounting profession faces unprecedented workforce challenges that demand a fundamental rethinking of traditional firm structures. This course examines why the century-old pyramid practice model is becoming obsolete and presents the inverted pentagon framework as a sustainable alternative. Based on comprehensive research showing that 52% of firms expect to shrink by 20% or more in the next five years, participants will learn how to restructure their firms to thrive with fewer entry-level staff while expanding specialized expertise. The course explores the "6 Ps of Business Model Transformation" - Precision Hiring, Proactive Retention, Practical Technology Implementation, Pricing Expertise, Practice Area Expansion/Focus, and People Acceleration. Drawing from success stories in manufacturing, healthcare, and technology industries, attendees will discover proven strategies for accelerating staff development, implementing effective knowledge transfer programs, and building sustainable talent pipelines in an era of technological disruption and demographic shifts. 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
Sleepless Nights: In AI It's All About "The Prompt", in Careers It's All About "The Relationships" (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This course focuses on the individual taking ownership for their career. It provides tools and methods to assist and guide the individual to develop the collateral necessary in navigating their career. It provides a Personal Marketing Plan that can be customized to fit the career objectives and goals of the individual. It also focuses on character self-awareness, crucial for long-tern career success.
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 Excel Budgeting Ideas (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.
More Dates
The AI Revolution in 2026: What CPAs Should Know (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
AI is reshaping accounting, tax, and finance. This update surveys the state of AI technology in 2026: core concepts, software tools, risks/controls, and practical CPA use cases. You will leave with an expanded AI vocabulary, a current view of the AI landscape, and actionable talking points for staff, clients, and service providers. 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
Executive Presence, Personal Brand: Structure Your Narrative (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
Professional credibility is communicated, not assumed. In this 1-CPE session (Professional Development), participants examine structured approaches to articulating their professional identity. Drawing directly from the course framework, the session covers development of an elevator pitch, a professional value proposition, and a concise executive biography. Participants will analyze how credibility is established through clarity, relevance, and alignment with audience needs. The course emphasizes service-centered communication rather than self-promotion and provides structured guidance for refining professional messaging in leadership and client-facing contexts. 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 Better Budgets: Fundamental Techniques (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This session provides insights for enhancing the preparation and utilization of budgets. Seasoned accountants will benefit from a refreshed awareness of popular techniques. Budding financial professionals will obtain novel insight regarding fundamental budgeting concepts. All participants will develop an appreciation for the holistic nature of budgeting as an integral tool for planning and control.
More Dates
Surgent's Governing Agentic AI: Cybersecurity, Data, and Risk (2 hours)
-
Online
2.0 Credits
Member Price: $119
See more dates
As accounting firms and financial institutions deploy agentic AI, they face significant governance challenges. This course focuses on cybersecurity, data governance, and risk management practices essential for the safe and effective use of autonomous systems. Participants will examine frameworks such as NIST AI RMF and the CSA's red-teaming guidelines, as well as case studies on AI-powered cyber incidents. The course equips professionals to assess agentic system vulnerabilities, implement controls, and integrate risk insights into enterprise compliance strategies. This course equips CPAs to fulfill their oversight responsibilities in safeguarding financial data and ensuring the reliability of autonomous systems within the enterprise's control environment.
More Dates
Leading for Well-Being: Building Resilient Teams & Thriving Workplaces (3.5 hours) [NT]
-
Online
3.5 Credits
Member Price: $129
See more dates
Leaders set the tone for workplace well-being. This program will equip leaders with the tools to build resilient teams. Creating a culture of mental wellness allows employees to feel safe, valued and heard. This will improve productivity, reduce burnout and absenteeism and ultimately, create a workplace where employees can thrive. Leaders will also learn the importance of nurturing their own self-care to prevent burnout for themselves in order to be the best leader possible.
More Dates
Advanced Excel for Staff - Build Reports and Analyze Data (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize, and structure data, apply calculations to derive key metrics, and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful, and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. 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
Getting the Most When Selling a Business: Little Details to Get Top Value (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Every business will be sold eventually. When you have built a great business and decide to move on – you want the most you can get for that terrific organization! What are the steps to take to maximize the value realized? What do buyers really want? What are the three levers to achieve maximum value? If you want top dollar, preparing to sell takes years of planning. This seminar helps CEOs, entrepreneurs, CFOs, Board members, controllers, and their advisors prepare for a successful sale of the organization to maximize shareholder value. We will outline the process to get the most bang for the buck. Proper exit planning demands planning and time.
More Dates
Business Partnerships: Managing Supplier Relationships (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
As financial leaders, CPAs are often tasked with managing organizational risk. In this respect, the supplier relationship can be a tricky one. It is often one of the more familiar and comfortable business relationships we have, yet it may also be the one that presents the most significant risk to our company. In this course, we will explore how to manage the supplier relationship from onboarding to termination. Through case studies and best practices, we will discuss how to continue being a good partner to our suppliers while also understanding where potential risks exist. 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
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
Bytes, Bias, and Balance: Data Ethics for Savvy Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course explores the transformative role of artificial intelligence (AI) in accounting and auditing, highlighting its vast potential while addressing the associated risks and ethical considerations. Participants will discover how to harness AI tools to enhance efficiency and innovation, while mitigating challenges such as overreliance, data security vulnerabilities, and ethical dilemmas. Through case studies and interactive discussions, you'll gain practical skills to navigate AI complexities, ensure trustworthy outputs, and uphold ethical standards in today's fast-paced digital 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
Empowering HR Pros' Thriving in 2025 and Beyond (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
The workplace is shifting rapidly, and HR professionals are at the center of it all. The next four years will challenge us to embrace courageous leadership, strategic vision, and continuous learning. Here's the reality: " We're stressed, overworked, and often under-resourced. " The job market for HR professionals is more competitive than ever. " Aligning with organizations that share our values is non-negotiable. " Agility and the ability to lead change are critical. We cannot solely depend on our employers to rise to the occasion. This is our moment to rise. Join our Founder & CEO Anthony P. Howard on how we can empower ourselves and each other in 2025. Together, we can lead the future of HR. How are you stepping into courageous leadership this year? Bring the discussion to the event!