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.
Surgent's Excel: Mastering PivotTables (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.
More Dates
Data Analytics & Journal Entry Testing for Auditors (3 hours)
-
Online
3.0 Credits
Member Price: $109
See more dates
This course provides a practical understanding of IT controls and SOC reporting within financial audits. Participants will learn how to interpret SOC reports, evaluate control effectiveness, and determine reliance strategies. Real-world examples will demonstrate how IT controls tie directly to relevant financial statement areas and alignment with Complementary User Entity Controls (CUECs).
More Dates
Calculating the Retirement Need (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
For most people, funding their own retirement is the largest expense they will ever have. Due to advances in medical technology and overall healthier lifestyles, it is not unusual for someone to live 30 years or more in retirement. In this course, we will discuss how to quantify and calculate the retirement needs of the client. We will talk about time value of money concepts, how to help clients quantify their retirement goals, and even how to address risk perceptions. By doing this, we will allow practitioners to be able to better address client questions and frame trade-offs when necessary. 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
Crypto, Blockchain and Taxes (2 hours - late morning) - Webcast
-
Online
2.0 Credits
Member Price: $105
Digital assets are no longer niche—they're now a key part of personal and business portfolios. This course breaks down the core technologies behind cryptocurrency and blockchain while giving attendees the tools they need to address evolving IRS guidance, proposed FinCEN reporting, and the treatment of crypto in estates and trusts. We'll look at wallet types, transaction tracking, taxable events, and reporting obligations under current law, including the infrastructure bill's impact on brokers and exchanges. Beyond theory, this session focuses on practical planning. You'll learn how to advise clients on basis tracking, crypto-to-crypto exchanges, charitable donations of crypto, and estate transfers involving NFTs and other digital assets. This course is designed for financial professionals who need clear guidance on how to keep their clients compliant—and prepared—for what's coming next. OSCPA has partnered with the Washington Society of CPAs for this event.
NotebookLM Use Cases for Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of how accountants can use Google NotebookLM (powered by Gemini) as a practical research, synthesis, and knowledge-management companion for high-trust work. You'll learn how to convert static financial statements, audit workpapers, client documents, and regulatory guidance into a structured, conversational knowledge base-so you can query, summarize, compare, and cross-reference sources with greater speed and clarity. This course emphasizes disciplined workflows such as source control, evidence-grounded outputs, and professional judgment so NotebookLM strengthens your analysis instead of replacing 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
K2's Excel Accounting Tools: Most Useful Formulas and Pivot Tables (4 hours - late morning) - Webcast
-
Online
4.0 Credits
Member Price: $195
Financial professionals can transform their daily workflow with this comprehensive training designed specifically for accountants and business analysts. Participants will discover how to leverage advanced Excel formulas, including VLOOKUP, XLOOKUP, dynamic arrays, and logical functions that streamline complex calculations and automate routine tasks. This practical approach focuses on real-world applications, showing professionals how to reduce hours of manual work into efficient, automated processes that minimize errors and maximize productivity. Beyond powerful formulas, participants will gain hands-on experience with pivot tables, the cornerstone of modern business reporting. The course demonstrates how to create dynamic reports, implement advanced calculations, and design intuitive data visualizations that enhance decisionmaking capabilities. Professionals will walk away with immediately applicable skills that strengthen their analytical capabilities, improve reporting efficiency, and add significant value to their organization. This course bridges the gap between basic Excel knowledge and the advanced techniques needed in today's data-driven business environment, making it an essential investment for accounting professionals seeking to enhance their technical capabilities and career growth.
Rethinking Your Customers to Maximize Profitability: Identifying the Right Clients (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Some customers are unprofitable from an economic or time perspective – but many organizations do not differentiate or know the difference. When an organization has a unique, well-differentiated service or product, understanding value from the customer’s perspective becomes a crucial factor in profitable pricing. We must take the time to fully understand what our customers value - from the customer’s point of view. What is value? Why do brand, value, and customer focus matter? Developing a deep understanding of our customers is vital. Our most important customer might be someone we have not yet recognized. Understanding both external clients and internal stakeholders - including the evolving role of the finance department, is critical to long-term success. Using humorous video clips, memes, and vetted research, your understanding of customer bases will improve.
More Dates
Surgent's Engagement Letters: Scope and Risk Management (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
Strong engagement letters protect your firm. They spell out what work you will (and won't) do, who is responsible for what, and how problems will be handled. Weak or vague letters may expose firms to potential liability. In this course, you'll learn how to draft, update, and enforce engagement letters that actually work in the real world. We pull from industry guidance, malpractice insurer data, and peer-review findings to show you the clauses that matter, how to prevent "scope creep" (work expanding beyond what was agreed), and how to not compromise your independence.
More Dates
Microsoft 365 for CPAs: Unlocking Hidden Productivity Tools (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Microsoft 365 is likely the most underutilized software investment in your firm or business. This course will show how to tap in to many of the lesser known features of the Microsoft 365 ecosystem of apps to maximize your productivity and produce better outputs. Through a series of practical case study demonstrations you will learn how to leverage the full potential of Microsoft 365 in your organization. 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
Consulting Services Secrets (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
Award winning discussion leader Mark Hugh discusses how to create and capture value with consulting services. Whether you want to consult a little or full time, this valuable course reviews identifying a specialty, growing a practice, capturing value, creating deliverables, and effective marketplace marketing strategies.
More Dates
Becoming Conflict Competent (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles, and build constructive behaviors to manage conflict. 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
Big Picture Mega-Trends, Big Data, and World We Now Face (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
It is easy for us to get caught up in our work, but it is better to examine the ‘big picture’ by studying the outside factors that impact our business beyond our internal processes and day to day responsibilities. We are sometimes so busy with our tasks that we miss new developments until the developments have a profound impact on us and the organization. This session is designed to review many of these current trends, while thinking and discussing how these trends can impact our organizations and us. This is a fun and lively session that is intended to be interactive with participants either live, virtual or both. Our ever-changing world is evolving more than many realize.
More Dates
Execute Your Strategy: Turn Planning into Results or Destroy it and Start Over…Again (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Organizations that execute a wise strategy succeed; others are executed in the market. Many organizations invest significant time in strategic planning but fall short when it comes to execution. According to McKinsey, most fail to properly execute their strategy. This session explores the critical transition from strategy to performance while challenging outdated planning models and myths. We often do not think of strategy in the same context of longer-term organizational projects like ERP transitions or risk management. Why should you consider “killing” your current plan and building a new plan centered around financial performance? We will dive into the reasons strategy fails, uncover the practical tools for bridging the planning-performance gap, and explore how strong financial integration enables strategy to succeed. We review insight into what works—and what must be stopped immediately. The author uses CocaCola as a baseline to communicate elements of strategy and incorporates funny videos to highlight key points.
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
Numbers to Narrative: Storytelling in Business Communication (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
Information becomes influential when it is structured. In this 1-CPE session (Professional Development), participants explore narrative frameworks presented in the course materials, including situation-complication-resolution and hero-based narrative arcs. Using business-oriented examples, the session demonstrates how structured storytelling enhances clarity and impact without sacrificing rigor. Participants will examine how to define context, introduce tension, present evidence, and guide audiences toward resolution. The emphasis is on logical flow and disciplined narrative construction rather than dramatization. The course concludes with application of a structured storytelling model to a professional scenario. 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
Current Cybersecurity Risk Management Trends (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
One of the top concerns of any organization's leadership is how to mitigate the risk of cybersecurity threats, along with the prevention and detection of fraud. This course will focus on the most common cybersecurity vulnerabilities and fraud trends, and best practices for managing them. 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
Smart Formula Selection in Excel: What to Use When (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Excel gives you multiple ways to solve the same problem - but which formula is the right one? This course teaches a decision-based approach to function selection, helping you confidently choose between similar and competing functions. Through real-world examples and side-by-side comparisons, you'll learn when IFS or SWITCH is cleaner than nested IFs, how SUMPRODUCT can help with complex summarizing data, how to use LET in place of defined names, and much more. Ideal for professionals who want to make smarter, faster formula choices that are easier to maintain and audit. 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
Shortcuts that Excel Users Love (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take this session! 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 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
Tactical Business Systems – Getting the Most from Information Systems and ERP (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
CFOs are increasingly accountable for the effectiveness of information systems, even if IT does not formally report to them. This session focuses on the tactical role finance leaders play in evaluating, selecting, implementing, and managing information systems. Participants will gain a practical framework for understanding IT, ERP systems, security, and emerging technologies such as AI. The session emphasizes asking the right questions, aligning systems with strategy, and avoiding common pitfalls that cause system implementations to fail.