CPE Catalog & Events
Advanced Excel: Hidden Secrets and Gems
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Awareness of advanced functionsCreative methods for data manipulationUsing intellectual curiosity and professional skepticism to develop a problem-solving mentalityReal-life examples of innovative ways to analyze and report data with ExcelUsing Excel to perform e-mail mergesMany other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolboxEnhance creativity in your approach to developing Excel models
Streamlined Excel Reporting Series Session 1: PivotTable Fundamentals
-
Online
2.00 Credits
Member Price: $125
PivotTable basics Row fields Value fields Column fields Filters Updating data automatically in PivotTables Groups and subtotals Value formats
Surgent's A Complete Guide to Form 1099-K
-
Online
2.00 Credits
Member Price: $99
What Form 1099-K is designed to do Filing thresholds for the Form 1099-K Who sends and who receives Form 1099-K Form 1099-K reporting thresholds Personal payments from family and friends Personal items sold at a gain or a loss Reporting provisions for gig workers, partnerships, and corporations Mistaken receipt of a Form 1099-K What to do when the Form 1099-K has a mistake Situations when the gross amount on a Form 1099-K must be shared How to handle the receipt of multiple Forms 1099-K
Surgent's Critical Issues Involving Taxation of Construction Contractors
-
Online
4.00 Credits
Member Price: $159
The impact of recent legislation on the construction industry How to qualify for the “small contractor exemption” and its advantages to the taxpayer Options available to the “small” contractor regarding taxation of long-term contracts How the choice of entity impacts taxation of contractors How AMT impacts the construction industry IRC §460 and “large” contractors How “uninstalled materials” impact taxation of contractors How the “look-back” rules impact contractors How the “10 percent method” can allow certain contractors to defer recognizing taxable income Critical tax planning strategies for contractors
Mastering the Excel Lookup Functions
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions
Surgent's Buying and Selling a Business: Tax and Structuring Overview
-
Online
4.00 Credits
Member Price: $159
An overview of the beginning of the process and documents for preliminary tax planning Recognizing the need for due diligence in acquisitions, including checklists of important points Deemed asset sales – §338 and §338(h)(10) The impact of the §197 amortizable intangibles regulations on the acquisition and disposition of a business Allocating purchase price for tax advantage Planning to avoid double taxation under the repeal of the General Utilities doctrine Special problems and opportunities when an S corporation is the buyer or seller Installment sale and interest issues Avoiding tax pitfalls and recognizing tax planning opportunities Unique issues in buying and selling LLC/partnership interests Impact of the net investment income tax (NIIT) and the §199A pass-through deduction on the tax due on the sale of a pass-through entity Individually owned goodwill
How Recent Auditing Standards Improve Risk-Based Audits
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Key changes to audit report elements intended to improve the understandability of the nature and results of financial statement auditsEnhanced required by-product communications with management and those charged with governance to promote more reliable financial statementsClarifications related to obtaining sufficient and appropriate audit evidence, including significant unusual transactions, related parties, going concern uncertainty, and accounting estimatesNew definitions and requirements related to identifying and evaluating risks of material misstatementOther important matters contained in recent SASs
Addressing Misconduct
-
Online
1.00 Credits
Member Price: $59
Insubordination Personality and attitude problems Generalized disparaging comments Previously unaddressed conduct Misconduct due to mental condition Corrective action meetings and documentation Attendance control
Surgent's Engagement and Client Retention Best Practices
-
Online
2.00 Credits
Member Price: $119
Managing client expectations How automation improves client engagement Understanding the role of feedback systems Seeking referrals Building client loyalty Customer retention marketing Expanding services offered to clients Knowing when it is appropriate to enter new markets
How AI Is Automating Internal Control
-
Online
4.00 Credits
Member Price: $149
The major topics covered in this class include:An explanation of Artificial Intelligence (AI).Specific ways AI is replacing human cognition. What is on the internal control horizon related to AI and other technologies.
Tax Season Update with Steve Dilley
-
Online
8.00 Credits
Member Price: $159
Update and integration of recent tax legislation impacting 2025 returns and significant individual and business tax developments related to cases and rulings Individual tax changes including the earned income credit, child credit, and child and dependent care credit; Partnership and S corporation developments Section 199A changes and reporting, losses and forms Depreciation update: Section 179 and 168(k) 2025 and 2026 tax rate schedule and other inflation adjusted items Tax forms update: individual, S corporation, and partnerships
Was It Fraud or Just Poor Audit Quality?
-
Online
1.60 Credits
Member Price: $79
Financial statement manipulation Ethics enforcement process Auditor conflicts of interest
2025 Governmental GAAP Update: Navigating GASB Standards
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:New GASB standards:GASB 100, Accounting Changes and Error Corrections.GASB 101, Compensated Absences.Practical case studies.
Just Ask Why - Searching for Answers: Generating Solutions
-
Online
4.00 Credits
Member Price: $159
The basic benefits of why The 5-15 report Curiosity and creativity
Understanding the Tax Implications of Retirement Plan Distributions
-
Online
1.00 Credits
Member Price: $59
Required minimum distributions for a deceased's heirs 2025 retirement plan contribution limits Required minimum distributions and contributions to charity Key provisions of Secure Act 2.0
The Controllership Series - The Future Role of the Controller Part 1
-
Online
1.50 Credits
Member Price: $79
Accounting and Finance
Benford's Law and Other Digital Analysis Techniques
-
Online
1.80 Credits
Member Price: $109
Benford’s Law Digital Analysis Data analytics
Internal Control Best Practices
-
Online
2.00 Credits
Member Price: $109
Auditing Yellowbook
Inventory, Expense and Payroll Fraud
-
Online
2.00 Credits
Member Price: $109
Methods of committing inventory, expense and payroll fraud What to look for when observing inventory Detection of inventory fraud How to recognize fictitious expenses How to recognize altered expenses Indicators of fake documentation The three main reason we ask for documentation Detection and prevention of ghost employees
Streamlined Excel Reporting Series Session 2: Working with PivotTables
-
Online
2.00 Credits
Member Price: $125
Report type comparison Customizing PivotTable options Format and design options Calculated fields and items Multiple value fields