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.
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
Implementing an AI-Enabled Marketing Strategy for Your Firm (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
Unlock the power of artificial intelligence to transform your firm's marketing strategy. This course will explore how AI can revolutionize your marketing efforts, helping you to reach your target audience more effectively and boost your firm's growth. In this session, Gaynor Meilke will guide you through the steps to implement an AI-enabled marketing strategy tailored to your firm's needs. Key Takeaways: Understand the fundamental principles of AI and its applications in marketing. Learn how to leverage AI tools and technologies to enhance your marketing campaigns. Discover practical strategies for integrating AI into your firm's marketing workflow. Gain insights into measuring the effectiveness of your AI-driven marketing efforts. Explore real-life case studies and success stories of firms that have successfully implemented AI in their marketing strategies. By the end of this course, you will be equipped with the knowledge and tools to harness the power of AI, streamline your marketing processes, and achieve remarkable results for your firm. Don't miss this opportunity to stay ahead of the competition and lead your firm to new heights with AI-enabled marketing 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
AI & Accounting in Construction (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of how artificial intelligence (AI) is revolutionizing the construction industry and reshaping financial oversight, accounting practices, and regulatory compliance. From autonomous equipment to predictive risk analytics, construction firms are increasingly adopting AI to enhance safety, efficiency, and profitability. As this transformation unfolds, accountants and financial professionals must evolve their roles-leveraging AI for smarter budgeting, automated compliance, and real-time auditing. The course highlights the top 20 macro-level AI trends in construction and explores how accounting professionals can align financial systems with operational AI, uphold audit integrity, and prepare for emerging tax and compliance challenges. 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
Guide Strategy, Attract Investments with Financial Forecasts (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Financial statement forecasting is essential for predicting a company's future financial health, guiding strategic decisions, and attracting investments. By analyzing historical data, market trends, and assumptions, businesses can anticipate risks and opportunities, enabling effective planning, resource allocation, and long-term stability and growth. - Forecasting Process: This involves projecting future income, expenses, and resources. By leveraging historical data and market insights, businesses can predict financial health, shaping strategic planning, investment decisions, and risk management. - Forecasting Profitability: Predicting future earnings informs strategic decisions, investment planning, and resource allocation. It facilitates effective budgeting, cash flow management, risk assessment, and enhances attractiveness to investors for sustainable growth. - Forecasting the Balance Sheet: Analysts forecast to predict a company's future financial position, assessing growth potential, solvency, and capital structure. This informs investment decisions, strategic planning, and risk management, ensuring financial stability and growth. Join our webinar to explore these concepts with a practical example, guiding you through the forecasting process and demonstrating its practical applications in real-world scenarios. 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 Exploring Business Valuation Fundamentals (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
What makes a business valuable? Who determines value? What are the key factors that make businesses valuable? In this course, we explore the different ways to value a business. We will apply foundational valuation and corporate finance concepts to real world examples in an effort to see what makes up an investment's price.
More Dates
Surgent's System and Organization Controls (SOC) Engagements (2 hours)
-
Online
2.0 Credits
Member Price: $99
In today's interconnected world, safeguarding information systems is crucial. This course will provide a comprehensive understanding of SOC engagements, exploring the types of reports (SOC 1r, SOC 2r, and SOC 3r) and the related management assertions. The use of the reports for internal controls over financial reporting (ICFR) and operations and compliance will be analyzed. This course equips accounting professionals with the knowledge to effectively lead in compliance reporting.
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
Annual Update on the 2024 Revised Uniform Guidance And Time & Effort Reporting (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
The Uniform Guidance (2 CFR 200) pertains to the management of Federal Financial Assistance for grants and cooperative agreements. The Biden Administration has performed a comprehensive update where the revised Uniform Guidance was released in April 2024. We will review all of the significant compliance and threshold changes. In addition, we will provide a brief presentation of the revised guidance as it pertains to Time and Effort reporting.
More Dates
Performing a Single Audit Under the Uniform Guidance
-
Online
8.0 Credits
Member Price: $349
Auditors performing single audits can learn about major program determination, pass-through entity responsibilities, SEFA requirements and other topics.
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 Elder Fraud (2 hours)
-
Online
2.0 Credits
Member Price: $119
See more dates
When we leave our jobs, we also leave the protection our employer provides us with regards to internet and Wi-Fi security. Hired people may be able to help with the newest applications, but they may not understand the security risks posed. This session will cover some basic information about cybersecurity weaknesses and some of the scams that target older, retired people. Many times, the perpetrator is someone close and someone who we think we can trust. In this course, you will learn some basic tools to protect against those who wish to perpetrate fraud.
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
Finding Errors in Excel Spreadsheets (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional 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
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
Integrate ChatGPT into Your Client Advisory Services-Updated (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Two of the hottest topics in the CPA profession today are CAS (client advisory services) and ChatGPT. This course will explain how to bring these two worlds together by integrating ChatGPT and other generative AI applications into your client advisory services. John Higgins, a leading advisor to the profession on ChatGPT and a seasoned client advisor on technology based solutions, will show you how you can position your firm and yourself as a "go to" advisor on how to embrace this technology in virtually any type of business. John will address how to use this technology as a research and writing assistant in your client services and how to advise your clients on this revolutionary technology and all benefits and "gotchas" that come with it. If you want to step up your advisory game, this course is a "must take." 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 Art of Marketing for CPAs (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $129
See more dates
To make more money in less time, all accountants need to learn to market themselves effectively to their clients or their firm. For better or worse, promotions and more money go to those who are the best marketers, rather than the most competent accountants. In this fascinating and fun workshop, participants will learn seven key ways to get more clients and/or promotions through the art of marketing.
More Dates
Coaching the Next Generation of CPAs (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Attracting and retaining staff is critical to an organization's success, especially in the age of the millennial worker who will change jobs multiple times in the course of a career. This course will focus on best practices for nurturing the human element of your organization, especially millennial workers who comprise a growing percentage or the workforce. 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
A Working Parent's Guide to Prioritizing Mental Wellness (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Balancing the demands of a career and family life is a challenge faced by many working parents. The pressure to excel at work while being fully present at home can leave little room for self-care, often leading to burnout and mental fatigue. This course is designed to address these challenges head-on by providing actionable strategies to prioritize your mental health and overall well-being. The course emphasizes practical, easy-to-implement techniques tailored for busy working parents. From setting boundaries to prioritizing sleep and physical activity, you'll learn how to create sustainable habits that enhance your well-being. You'll also explore how to recognize the signs that additional support -whether from friends, family, therapy, or other resources- is necessary, and how to seek help without guilt or hesitation. Ultimately, this course will help you regain a sense of balance and control in your life by equipping you with tools to manage stress, build resilience, and rediscover joy in both your professional and personal 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
Surgent's Use the Data Model to Build More Powerful PivotTables (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.
More Dates
Disrupt to Dominate: Mastering Change Leadership (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
In an era defined by rapid change and uncertainty, effective leadership requires more than just managing teams; it demands the courage to disrupt and innovate. This course is your blueprint for transforming potential chaos into a strategic advantage and is designed for leaders at all levels-whether you're a seasoned CEO, an ambitious small business owner, or an individual contributor aspiring to influence greater change. You'll gain the insights and tools needed to not only adapt to change but to lead it effectively and confidently. 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
