CPE + Events Catalog
Download the 2025-26 OSCPA-Select Calendars - .pdf
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
Surgent's Audit Skills Training Level 2: Preparing for Increasing Responsibilities in Public Accounting
-
Online
8.0 Credits
Member Price: $279
See more dates
As you rapidly gain experience in the auditing profession, the responsibilities of the staff accountant grow exponentially. Progressing from the base-line audit skills covered in Level 1 training that allow a new auditor to perform their roles, Level 2 training covers those skills that are required for experienced staff accountants who need to audit more complex and subjective areas, such as accounts receivable and investments, and to plan and appropriately perform sampling and analytical procedures. Redesigned to provide the relevant content to staff accountants when they need it, the Level 2 reviews the underlying accounting concepts of these often-complex areas and, through examples and exercises, discusses the relevant audit procedures required by professional standards. The course is designed to allow the staff auditor to capitalize on their prior experiences and apply them in new areas, as they continue their career advancement. IMPORTANT NOTE: This course takes place over two consecutive days. Registration for both days is required.
More Dates
Take Command of your Time (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Manage distractions, decrease stress and improve productivity. This training is designed to help business professionals improve their productivity and work performance by learning how to prioritize time, decrease distractions and lower stress. 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
Form 706 Preparation Part 3: Reporting Deductions 25-26 (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
This section of the 4-part series will cover fundamentals of Form 706 with numerous examples of how to properly report deductions on the estate tax return, including the marital and charitable deductions. Form 706 Series: Form 706 Preparation Part 1: Overview Including Portability Form 706 Preparation Part 2: Reporting Assets Form 706 Preparation Part 3: Reporting Deductions Form 706 Preparation Part 4: GST Schedule R, Form 8971, Payments & Credits
More Dates
Unlock the Power of AI with Copilot in Excel (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
In the ever-evolving world of data analytics and business intelligence, Microsoft Excel continues to be an indispensable tool for professionals across industries. With the introduction of Copilot, Microsoft has integrated the power of artificial intelligence directly into Excel, revolutionizing how users work with data. This 2-hour interactive course, Unlock the Power of AI with Copilot in Excel, provides a comprehensive overview of how Copilot transforms traditional Excel workflows into dynamic, AI-driven processes, enabling users to accomplish tasks faster, more accurately, and with less manual effort. During this course, you'll discover how Copilot leverages AI to enhance productivity and streamline operations. Whether you're a seasoned Excel user or just beginning your journey, this course will guide you through practical applications and best practices to make the most of Copilot's capabilities. Through hands-on demonstrations and real-world examples, you'll see how Copilot can save time, improve decision-making, and elevate your analytical skills to new heights. This course not only focuses on the technical aspects of Copilot but also highlights its potential to transform your day-to-day work, from automating repetitive tasks to uncovering trends and insights you might otherwise overlook. By the end of the session, you'll be equipped with the knowledge and confidence to integrate Copilot into your workflows and unlock its full potential in Microsoft 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
Deep Dive Into Common Auditing Deficiencies (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
This course will review common deficiencies identified by the AICPA and state boards of accountancy. It features discussion on a variety of topics, including analytical procedures, sampling, group audits and risk assessment. We will review the areas of concern and how you can overcome them by employing best practices. 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
Pass-Thru Entity Owners Schedule K-1 Analysis 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
This comprehensive case-driven training is designed to quickly get the accountant up to speed in basis calculations and distribution planning for the owners of pass-thru entities (i.e., S corporations, partnerships, and limited liability companies (LLCs)). The cornerstone of this course is the line-by-line analysis of the Schedule K-1s and how it affects the basis calculations. This session is taught using a Hands-On methodology. Real-world examples and cases demonstrate the complex income tax code and regulations to enhance the participant's learning experience. Each attendee will receive the most comprehensive reference manual with numerous practice aids, real-world examples, and case studies.
More Dates
Social Security Basics and Strategies for Maximizing Benefits 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
Though many clients see Social Security as a government benefit, it is a covered worker's investment asset to be managed like any other asset. Examine issues like how Social Security benefits are calculated, identifying benefit-claiming strategies, and what spouses can do now to maximize benefits at retirement. You'll learn how Social Security works and explore common planning situations?including workers with and without spouses, sandwich-generation families with dependent parents and minor children, and surviving and/or divorced spouses?and techniques to maximize your clients' benefits.
More Dates
Auditing Standards: A Comprehensive Review 25-26 (16 hours)
-
Online
16.0 Credits
Member Price: $589
See more dates
From understanding fraud requirements to improving risk assessment procedures and from testing to meeting auditing standards, discover ways to audit more effectively and efficiently. Engage in discussions that cover reducing risk and effective planning, research and documentation. Review various case studies, real-life examples and sample documentation will reinforce ideas. This course meets the specific California Board of Accountancy requirements that CPAs are required to meet for re-issuance of their license.
More Dates
AI Prompt Engineering Masterclass for Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
An advanced guide to prompting techniques that maximize AI efficiency and precision in everyday business research, operational due diligence and accounting tasks. Designed for accountants with no prior AI knowledge, the session explores how simple language and strategic prompting can unlock powerful, layered responses from large language models (LLMs). Participants will learn to overcome the "lazy" defaults of AI, using specific techniques to enhance detail, accuracy, and contextual understanding in their queries. By understanding prompt engineering's role, attendees will discover how to guide AI to provide practical, relevant, and analytical insights suited to complex financial scenarios, without needing extensive technical expertise. 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
Supervision/Management Competencies: An Ethical Approach (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Job titles for individuals can vary in different organizations even though the work is the same. This webinar is designed for the individual whose role is to oversee the work of others. This webinar includes an overview of Aristotle's virtue ethics and its application to the responsibility and privilege of developing employees to be their best and for the success of the organization. We will also address issues such as going from "buddy to boss", how to manage if you are newly assigned to an existing employee that was previously supervised by someone else, and critical skill sets necessary for supervisory/managerial positions. 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
Accounting and Disclosure Issues After a Natural Disaster (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
The repercussions from a natural disaster can be devastating. Properly accounting and reporting for the impact of those disasters can be confusing. This course will focus on some of the most FAQ related to the proper treatment of accounting for disasters in GAAP basis financial statements. 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
More Money: Strategic Ways to Improve Cash Flow (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Cash flow management is often the most important task of any CFO or financial leader. Regardless of whether one works in start-ups or established companies, non-profit or for-profit entities, cash flow makes our organizations run. Have you ever wondered whether you are optimizing your company's cash flow? In this course, we will explore how to improve your company's cash flow using analysis and financial theories in the context of real-world situations. 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 Bookkeeper Goes to Prison (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This course profiles Brenda, a financial executive from the state of Washington. Despite earning her college degree, Brenda did not find employment in her area of study. Instead, she landed a series of dead-end jobs. Business reversals frequently led to the loss of employment. When a company that she knew to be unethical offered her an executive position that included bookkeeping tasks, including overseeing all finances, she accepted. While on the job, Brenda saw owners of the company misappropriating funds. Rather than reporting the fraud, she created an elaborate scheme to benefit herself - without the owner's knowledge. Her bad decisions led to a guilty plea for wire fraud, after authorities accused her of absconding with more than $600,000 in corporate funds. A prison term of 20 months followed. Listen and learn from Brenda's experience. 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
Ethics without Fear for Accounting and Finance Professionals (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $125
See more dates
Finance and accounting professionals are on a pedestal and are often held to a higher standard. Keeping your ethical skills sharpened is crucial to reducing your fear and raising your courage as you solve tough decisions in real-time. This fast-paced and interactive presentation will help you practice exactly that. What will you gain? The ability to choose the most effective path in daily situations, so that when a significant crisis hits you are comfortable in your actions. Be ready, be courageous, be fair, and be consistent.
More Dates
Ethics: How to Give and Receive Criticism the Right Way (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
How well do you accept criticism? How might it enrich your business - and you - if you did a better job of it? This distinctive webinar will show you why it is in your best interest to accept criticism with gratitude. It's even better to welcome criticism. It's also a good idea to learn how to give criticism the right way. A related topic is the art of giving and receiving apologies, and we'll do a deep dive into this area as well. You'll leave with clear guidelines for how to criticize others, accept criticism from them, give meaningful apologies, and accept apologies with grace and ethical intelligence. The result will be a stronger CPA practice and a better you. 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
Form 706 Preparation Part 4: GST Schedule R, Form 8971, Payments & Credits 25-26 (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
This 4-part series covers the fundamentals of Form 706. In this final course, we will cover GST allocations on Schedule R, Foreign Death Tax credit, Prior Transfer credit, Qualified Conservation Easements and making the 6166 election for estate tax payment or considering a Graegin or other loan to pay the estate tax. Illustrations of attachments and/or narrative examples for Schedule R will be provided. Form 706 Series: Form 706 Preparation Part 1: Overview Including Portability Form 706 Preparation Part 2: Reporting Assets Form 706 Preparation Part 3: Reporting Deductions Form 706 Preparation Part 4: GST Schedule R, Form 8971, Payments & Credits
More Dates
Surgent's The Essential Multistate Tax Update (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
With the largest overhaul of the federal income tax code in 30 years and the repeal of the physical presence nexus standards for sales tax in the Wayfair case, the states are working fast and furious to overhaul their tax laws. As some states scramble to fund their budgets, they continue to look for additional forms of revenue. Plan to attend this fast-paced class that covers developing topics in state taxation, ranging from individuals to pass-through entities to corporate taxpayers. This class will focus on issues of small and middle-market companies and offer guidance for minimizing tax liability and negotiating the treacherous waters of compliance.
More Dates
Erase the Mark: Best Practices in Penalty Abatement (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
If there is a potential error, the IRS will assess a tax and add a hefty penalty, without even knowing the facts. As a tax professional, you will be exposed to the IRS and their methods of penalizing taxpayers for the smallest of violations. This presentation will focus on the rules and regulations that create the penalty, and the reasons that exist that the IRS will consider to remove those penalties. 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
Ethics: What a CPA in Business & Industry Needs to Know (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Accountants in business and industry face ethical conflicts almost daily. This workshop (re-)introduces the revised AICPA Code of Professional Conduct and walks through the five basic rules of conduct and the related professional ethical principles applicable to accountants in business and industry. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.