Skip to main content

CPE + Events Catalog

Download the 2025-26 OSCPA-Select Calendars - .pdf

Showing 10671 All CPE & Events Results

Criminal Tax: How CPAs Bring Value to Defense Attorneys (2 hours)

-

Online

2.0 Credits

Member Price: $89

See 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

Surgent's Liquidation of Flow-Through Entities for LLCs and Partnerships (2 hours)

-

Online

2.0 Credits

Member Price: $99

See more dates

Part of the technical competence of most experienced tax practitioners is the ability to advise owners of S corporations and partnerships or multiple-member LLCs treated as partnerships regarding the tax rules that apply when these entities liquidate. Entity liquidations do not occur every day; but they do occur, and often at very critical times in the business life of the entity and its owners. All tax practitioners should be able to advise their clients about the tax issues associated with client businesses that go out of existence and liquidate. This program explains the tax consequences associated with liquidating S corporations, partnerships, and multiple-member limited liability companies treated as partnerships.

More Dates

Surgent's Taxation of the Mobile Workforce (2 hours)

-

Online

2.0 Credits

Member Price: $99

See more dates

Today's workforce looks a lot different than it used to. With more people working from home and across state lines, employers must examine withholding and unemployment laws in a new light. In this course, we will examine tried and true rules in this area, but also examine statutes that are still developing. Using real-life examples and discussion, we will examine state laws on reciprocity and residency requirements. We will also look at what to do when state laws are silent or conflict on a particular issue, so that you can keep your clients in compliance and be well-prepared for the questions that will come your way in these ever-changing times.

More Dates

Defining Where and Why Internal Controls are Needed (2 hours)

-

Online

2.0 Credits

Member Price: $89

See more dates

Most organizations have many of the basic controls required to operate in place. However, a notable percentage of these companies do not have important measures that can help enhance security, productivity, and the quality of information available for decision making. In this session, we work to identify areas where important internal control measures are needed. We spend time explaining why these controls should be created, and show in detail some specific controls that would be beneficial if utilized. Those wishing to strengthen an internal control system should strongly consider attending 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

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

Navigating IRS Collections: Overview of Form 433 & OIC (2 hours)

-

Online

2.0 Credits

Member Price: $89

See more dates

This course highlights when to use Form 433-A or 433-B, along with documents needed to effectively submit an Offer in Compromise (OIC) or Installments Agreement. Settling tax debts is an important part of the IRS collection process, this course helps guide taxpayer representatives through the process so they may efficiently complete these necessary forms. 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 Bootcamp for CPAs with John Higgins (4 hours) [NT]

-

Online

4.0 Credits

Member Price: $149

See more dates

ChatGPT is the fastest growing application in the history of technology with over 100 million users adopting it in within two months. It is a revolutionary technology that boosts the quality and efficiency of business processes in every industry. As "knowledge workers", CPAs and CFOs are positioned to be prime beneficiaries of this technology. This half day hands-on course will get you well on your way to becoming a ChatGPT expert. John Higgins, a nationally recognized advisor and educator on CPA technology, will guide you through the process of accessing ChatGPT and applying it to a variety of practical accounting, finance and tax scenarios. This course will catapult you to the top of the pyramid of CPAs who are knowledgeable in ChatGPT and you will be ready to put it to use in your day-to-day tasks. 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

Using e-Signature Software to Process Agreements-Updated (2 hours) [NT]

-

Online

2.0 Credits

Member Price: $89

See more dates

Transforming your practice or business to a digital model is a journey, not a destination. There are some digital initiatives that require a great deal of time and money to deploy. There are also many "low hanging fruit" initiatives that are relatively easy and inexpensive to deploy. E-signature software is a perfect example of the latter. John Higgins, a nationally recognized leader in accounting technology, will guide you through the process of evaluating, selecting and implementing e-signature software to streamline a solution, and secure your document signing processes. You will be surprised to discover how easy it is to take your engagement letter and contract signing workflow digital. 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

Risk Assessment Under SAS No. 145: The Key to Audit Quality? (2 hours)

-

Online

2.0 Credits

Member Price: $89

See more dates

The AICPA has identified risk assessment as an area of focus for its Enhancing Audit Quality Initiative as deficiencies in auditor's risk assessment procedures continue to be a common issue identified in peer review. SAS No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was written to improve the quality of risk-based audits. While key concepts do not fundamentally change, the standard works to clarify and enhance certain aspects of the identification and assessment of the risks of material misstatement to drive better risk assessments and hopefully overall enhance audit quality. 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 Controllership Skills Update: Current Survival Skills (2 hours)

-

Online

2.0 Credits

Member Price: $99

See more dates

The role of financial professionals has and continues to change in organizations. The stereotype of collecting and reporting data has been replaced by a broader vision, which focuses on improving an organization's results today and preparing it for the future. This brief program offers specific actions that can be implemented by financial personnel to expand their role through improving their organization. The actions and techniques provided build upon and improve activities that exist in many organizations (measuring, budgeting, hiring, risk management, etc.), as well as providing insights into capital allocation, cash management, valuation techniques, variables that influence capacity levels, M&A activity and actions to increase efficiency and innovation. Updated to include the impact of regulations, additional examples of M&A, alliances and strategic spin-offs/splits, methods to improve efficiency from existing activities, the impact of COVID-19, as well as current organizational changes employed to manage and accelerate growth.

More Dates

Surgent's Excel Tables and Conditional Summing (2 hours) [NT]

-

Online

2.0 Credits

Member Price: $99

See more dates

In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.

More Dates

Surgent's Top Business Tax Planning Strategies (2 hours)

-

Online

2.0 Credits

Member Price: $99

See more dates

Tax planning for 2025 is largely based upon legislation contained within the Inflation Reduction Act and the SECURE Act 2.0, that offer new planning options and challenges for businesses in 2025. There are, however, other business tax changes in 2025 that result from different pieces of tax legislation, IRS pronouncements, and court cases that need to be taken into account from a planning perspective. This program analyzes the new opportunities and challenges that these tax changes offer to businesses and their owners that impact 2025 and sometimes later years.

More Dates

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

Forensic Accounting: When The Office Is A Crime Scene (4 hours)

-

Online

4.0 Credits

Member Price: $149

See more dates

Embezzlement happens often to many small businesses. Unfortunately, the lack of internal controls allow the embezzlement to remain undetected for years. But when it is discovered, the small business owner will most likely contact their CPA for advice. What should you do when your client contacts you about their employee embezzling money from their business? What options should you present to your client? How can your client protect themselves, while investigating the embezzlement? What steps need to be taken about preserving any documents, emails, texts, or phone calls? This course teaches how to engage the client, properly identify the evidence needed to prove the crime, how to write the report for civil and criminal trial, and best practices in preserving electronic and paper evidence. 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 Fraud In Single Audits (4 hours)

-

Online

4.0 Credits

Member Price: $159

See more dates

With all the planning, procedures, and reporting involved in a single audit, sometimes things can slip through the cracks. But what if the thing that slips through is fraud? Compiled from news releases, court records, and the thrilling annals of the Federal Audit Clearinghouse, this course tells the tale of six real-world frauds which seemingly dodged detection in the single audit process. Leveraging the incredible gift of hindsight, this course is designed to raise your awareness and sharpen your focus on the potential for fraud in single audits!

More Dates

Coping With the Growth of Online Fraud (4 hours)

-

Online

4.0 Credits

Member Price: $149

See more dates

Just about every company, no matter its size or the types of activities it undertakes, is at greater risk because of all the types of fraud that can be be carried out electronically. Potential perpetrators can be operating internally or externally and the scope of the damage that occurs is almost never limited to cyber-assets. While threat awareness is improving, there are still too many owners or top level executives that underestimate the scale of the issue. In this session, we delve into the types and the nature of many electronic defalcation schemes. The material then explores measures that organizations can implement to help stop these activities and add additional layers of security. 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