CPE Catalog & Events
Surgent's Excel: Mastering PivotTables
-
Webcast
2.0 Credits
Explore PivotTable capabilities and functionality Retrieve data from a database and feed it into the PivotTable Pull web tables from web pages into Excel
Webcast: Audits Under Uniform Guidance—Single Audit & NPOs 26-27
-
Webcast
4.0 Credits
Concepts of the Single Audit under the Uniform Guidance Performing the compliance audit of federal awards, including testing auditee compliance and internal control over compliance Auditor reporting responsibilities including the compliance audit reports, the report on the schedule of expenditures of federal awards, and schedule of findings and questioned costs Requirements for the schedule of expenditures of federal awards, known as the SEFA Update on the OMB Compliance Supplement
Webcast: Preparation, Compilation & Review Services 26-27
-
Webcast
4.0 Credits
All recently issued SSARS standards Financial reporting frameworks Distinguishing special purpose frameworks from GAAP CPAs reporting on financial statements Financial statement disclosures Recently issued ethics standards Peer Review Deficiencies
Webcast: Preparation, Compilations and Reviews—A Practical Workshop 26-27
-
Webcast
8.0 Credits
Preparation Compilations Reviews
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Webcast
2.0 Credits
Creating a data model/Power Pivot Building PivotTables from multiple tables Creating Measures Using named sets
Surgent's Trump Accounts Created by OBBBA: A Comprehensive Guide for Accounting and Finance Professionals
-
Webcast
2.0 Credits
Establishing and administering a Trump Account Who can make contributions to a Trump Account Limits on contributions to a Trump Account Employer contributions to a Trump Account Participation in the pilot program What a Trump Account can invest in Basis tracking for after-tax contributions Taxation of distributions from a Trump Account Rolling a Trump Account into another account The potential advantages and disadvantages of having a Trump Account Opting out of a Trump Account Issues impacting a Trump Account, such as distribution, when the beneficiary turns 18
Surgent's The One Big Beautiful Bill Act (OBBBA): What You Need To Know
-
Webcast
4.0 Credits
The $6,000 senior deduction The QBI deduction Changes in the estate tax Wagering losses The SALT cap Tips, overtime, and car loan interest 1099 changes Trump Accounts Investments in students and education Bonus and Section 179 changes, including depreciation for qualified production property Full expensing of domestic research and experimental expenditures Changes in the deduction of business interest and business losses Renewal of Opportunity Zones Individual and corporate charitable contribution changes Expansion of Section 1202 stock Termination of credits for environmentally clean autos and expenditures Many other individual and business income tax changes contained in the OBBBA
Surgent's Reasonable Suspicion
-
Webcast
1.0 Credits
The psychosocial, physiological, and behavioral aspects of drug and alcohol abuse in the workplace The impact of drug and alcohol abuse on workplace safety The possible connection between performance issues and drug or alcohol abuse The role of documentation in reasonable suspicion testing Confidentiality concerns in the testing process
Surgent's The AI-augmented Professional: Practical Tools, Real Risks, and Immediate Use Cases
-
Webcast
2.0 Credits
Explore from the history of automation to the current landscape of large language models (LLMs) and generative tools to demystify the technology Free, accessible apps to enterprise-grade solutions and specialized accounting software tailored for tax, audit, and advisory workflows Ethical obligations and professional standards that govern AI use, including data privacy, client confidentiality, and the management of "hallucinations" or inaccuracies Through specific use cases and prompting demonstrations, understand how to use AI to draft complex communications, summarize research, optimize Excel workflows, and enhance client advisory services
Surgent's Managing Up the Ladder
-
Webcast
2.0 Credits
Influence, persuasion, and power Navigating without position power
Surgent's Management Fundamentals
-
Webcast
4.0 Credits
What it takes to be effective as a manager Exploring the challenges that get in the way Looking at the driving forces that have evolved how managers engage with employees today Motivating employees of multi-generations Twelve practices that can be adopted to influence employees to become more engaged Identifying what it takes to develop employees Delegation and accountability
Surgent's Where To Live in Retirement
-
Webcast
2.0 Credits
Does continuing to live at the current location meet retirement goals and lifestyle? Are there family concerns such as an elderly parent that prevent moving away from the current location? Is the current location affordable when income from a salary ceases? What health concerns are there that would limit the ability to move to another location? Is an assisted living facility something that should be considered now or in the future and is a suitable one available? What happens if a person is disabled while retired? Are there state and local tax considerations that would encourage staying in place or moving? Are there climate and weather concerns that would encourage a person to stay in place or move to a more desirable location? Should a retiree downsize?
Webcast: Valuing A Business: What is This Company Worth 26-27
-
Webcast
4.0 Credits
The weighted average cost of capital Discounted Cash Flow analysis Valuation methods The issues and the pros and cons of each method How do you increase the value of a business?
Surgent's The Accountant as the Expert Witness
-
Webcast
2.0 Credits
Becoming qualified as an expert witness Best practices for testifying at trial Understanding the different roles accountants can play in litigation Working with attorneys to prepare and present a case at trial The role of experts in commercial versus personal injury litigation Confidentiality orders Compensation for expert witnesses Preparing for and attending depositions Daubert challenges to experts Expert reports The role of experts in antitrust, securities litigation, and professional liability cases Credibility as a witness
Webcast: How AI Fits into the Accounting World 26-27
-
Webcast
2.0 Credits
An overview of AI constructs. How artificial intelligence is being used by accountants today. Accounting-centric AI developments on the horizon.
Surgent's Tax Research
-
Webcast
2.0 Credits
Tax code hierarchy Organization of an Internal Revenue Code section Special rules for IRC citation Citing other primary authority Private letter rulings Primary vs. secondary authority Secondary sources of authority Steps in the tax research process Research memoranda
Surgent's Tax Loss Limitations Imposed on Individuals and Pass-through Entities
-
Webcast
3.0 Credits
How to calculate a partner or S corporation shareholder’s basis Form 7203 and an S corporation shareholder’s basis The at risk basis rules and Form 6198 The passive activity loss limits The Section 461(l) loss rule The net operating loss limitation rules The Section 163(j) business interest limitation New OBBBA changes impacting business interest and Section 461(l)
Surgent's Accountability and Action
-
Webcast
4.0 Credits
Defining three critical elements: responsibility, empowerment and accountability, and how they work together to create results Designing and using clear agreements that provide clarity Skills for holding yourself and others accountable for results, no matter what Knowing where you are in the accountability game... what you do/don’t do well
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Webcast
2.0 Credits
Automation capabilities of Excel The “Get & Transform” Tool Using “Get & Transform” for flattening, splitting and combining data, unpivoting summarized data, and combining CSV exports
Surgent's Purchase and Sale of a Residence: Critical Tax Issues
-
Webcast
2.0 Credits
General rules relating to the sale of a residence under § 121 Sale of a taxpayer’s main home Qualifying for a partial exclusion of gain on the sale of a home How a taxpayer meets the residence requirement Meeting the look-back requirement Separated, divorced, and widowed taxpayers Work-related moves and unforeseeable events Inherited homes and homes received in a divorce Impact of business or rental use of home on the gain exclusion Reporting gain or loss on the sale of a home