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.
This will generate a PDF of the current filtered catalog
Surgent's System and Organization Controls (SOC) Engagements (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
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 1®, SOC 2®, and SOC 3®) 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.
More Dates
Two Types of Goals You Need to Be Successful (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
Do you understand the root cause for many professional and personal goals not being achieved? The SMART acronym is valuable in setting goals but insufficient for achieving them. You need two types of goals to boost your chances of success. Outcome goals focus on the results you want to attain. Process goals identify the action steps required to accomplish those desired outcomes. This session explores the essence of both types of goals, and practical examples and tips for the execution of your goals.
More Dates
Leading Into the Future: Rethinking Work, Value & Leadership in Accounting (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
The accounting profession is at a crossroads — not because of a new generation, but because the entire architecture of work is being rewritten. Smaller firms are feeling it most: recruiting has become harder, AI is changing client expectations overnight, and leadership succession looms large. In this fast-moving and practical session, global future-of-work strategist Steve Cadigan (LinkedIn’s first CHRO and author of Workquake) unpacks how small and mid-sized firms can reimagine how they attract, develop, and lead talent in a world where certainty is gone and adaptability is gold. Through real-world examples from progressive firms like Bookminders, Prestige Accounting, LedgerWise, Nova Accounting, and Insights CPAs, Steve shows how leaders are reshaping work models, leveraging AI as a time- creator, and making accounting a magnet for modern talent again.
More Dates
Advanced IT Audit & Real-World Testing (3 hours)
-
Online
3.0 Credits
Member Price: $109
See more dates
This advanced course focuses on executing IT audits in real-world environments. Participants will learn how to perform walkthroughs, design testing procedures, evaluate control effectiveness, and prepare audit-ready documentation.
More Dates
The Art of Marketing for CPAs (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
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
Embracing Neurodiversity in the Workplace (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
This webinar will explore embracing and supporting neurodiversity in the workplace, promoting inclusivity, and creating a more diverse and dynamic environment.
More Dates
Understanding the 4 W's in Budgeting: Who, What, When, and Which? (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This session introduces a structured approach to government budgeting using the four W’s: Who, What, When, and Which. Participants will explore WHO should be involved in the budgeting process, including internal teams and external stakeholders, while learning effective communication strategies to foster collaboration. The session examines WHAT the budgeting process entails, covering essential phases, components, legal requirements, and common challenges. Attendees will also learn WHEN to engage the public through strategic planning, workshops, and outreach initiatives. Finally, the session highlights WHICH departments play key roles, from financial planning to managing capital projects. By the end of this session, participants will have a comprehensive understanding of government budgeting and how to align financial planning with community priorities. YELLOW BOOK: Qualifies for Yellow Book CPE based on your unique audited entity.
More Dates
Relationship Networking: The Art Of Conversation (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
In the fast moving world where everyone is communicating through email, text and instant messaging we have forgotten the power of face-to-face conversation. Communication and connection is the foundation for building a thriving network and business. During this talk, The Connector’s Advantage author, Michelle Tillis Lederman will inspire you to leverage the power of personal connection in the digital age while still incorporating the efficiency of virtual communication.
More Dates
Maintaining a Harmonious Working Environment (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
A harmonious working environment is one in which people feel safe, seen, heard, and respected. Critical to maintaining it are that employees have high self-esteem, are treated with respect, and work in a safe, non-violent setting. This course provides practical knowledge and scripts on how to take appropriate action and deal effectively with discriminatory comments, sexual harassment, and threats and acts of violence, such that personal and employer liability is avoided.
More Dates
Coaching Leaders to Handle Sensitive Employee Relations Situations (1.2 hours)
-
Online
1.2 Credits
Member Price: $39
See more dates
This session provides HR Professionals with scripts for and tactics for coaching leaders in handling an array of employee relations situations with sensitivity, good judgment, and high confidence. Topics include employee complaints, personality & attitude problems, performance counseling, personal hygiene problems, disability-related performance issues, misconduct due to mental conditions. You will learn how to use a unique process, “Reset the Clock,” that prevents attorneys from taking something leaders did wrong or did not do in the past and using it to support legal challenges in the future. Liability is replaced with credibility. Lawsuits are then avoided rather than won. Financial assets are protected, morale stays high, and bad publicity is averted. HR Professionals avoid hearing from senior leaders: “You should have anticipated this” after an avoidable legal claim.
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
The Power of a Good Story! (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Effective Communication Skills (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
When asked the question, "What would you like to improve about your leadership and communication style?". More than 65% of leaders say they want to be more confident and assertive in their communication. Confidence and clarity communicate leadership. If you are responsible for growing a profitable company or a productive team, you want team members who have the ability to reach goals, make sales, finish projects, and serve customers. Being a confident, compelling leader helps to inspire better relationships, promotes trust, and reduces stress in the workplace. Confident communication cultivates cooperation, goal achievement, and a more respectful work environment. Clear and compelling leaders are better equipped to move projects forward and make things happen while improving cooperation and respect from partners and subordinates.
More Dates
Excel for Accounting Professionals Session 5: Error Trapping and Improving Lookups (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Practical hands-on Excel learning exercises taught by a highly engaging expert in the field You'll develop your expertise with real-world Excel workbooks. Despite the popularity of VLOOKUP, it has its drawbacks. This session will address these drawbacks while offering alternatives. You'll walk through the VLOOKUP and IFERROR functions, and explore the following topics: Improving the use of VLOOKUP with VALUE/TEXT Improving the use of VLOOKUP with MATCH. Moving beyond VLOOKUP with INDEX Trapping errors with IFERROR Moving beyond basic Excel functions Grasping the limitations and possible enhancements for the VLOOKUP feature, along with methods to handle errors can elevate your proficiency in Excel. You'll also partake in hands-on Excel activities that showcase the integration of functions and their use in crafting spreadsheets, encompassing: Combining functions to enhance flexibility Utilizing functions for atypical data categories Perfecting sophisticated lookup functions *Session 5 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 6: List Comparisons and Indenting] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-6--list-comparisons-and-indenting) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Getting On Top of It All: How to Work Smarter, Not Harder - Part 1 (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
There is always too much to do and too little time to do it all. Fortunately, if you know the right ways to manage people, projects and your time, you can get on top of everything by working smarter. In this seminar you'll learn the best ways to get more done in less time, how to stay sane with all you have to do, and how to get other people to do some of "your" work by building great relationships.
More Dates
Exploring the 10 Types of Leadership: Styles and Strategies for Success (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
Leadership is not one-size-fits-all. Effective leaders understand that different situations, team dynamics, and organizational cultures require different approaches. This course introduces ten distinct leadership styles and examines how each can influence team performance and organizational success. Participants will explore the characteristics, strengths, and potential limitations of each leadership style. The course encourages self-reflection to help leaders recognize their own tendencies while identifying opportunities to adapt their approach when circumstances require it. Emphasis is placed on practical strategies for engaging teams, strengthening communication, and building leadership capacity across the organization. Designed for current and emerging leaders, this course provides tools to better align leadership approach with team needs and organizational objectives.
More Dates
Benefits and Best Practices for Telework (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Prior to the COVID-19 pandemic, telework in state and local government was not often embraced as a form of employment. As the pandemic continues, governments are beginning to experience the benefits of remote work and are reevaluating hiring practices to offer more telework and hybrid work options, not simply as a result of an emergency. This course will review various telework options and best practices for success.
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
Just Ask Why - Searching for Answers: Generating Solutions (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Breaking the Wall of blind acceptance; avoiding habitual complacency and Yoking the dots between cause and effect.