CPE Catalog & Events
Mastering the Excel Lookup Functions
-
Virtual
2.00 Credits
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
-
Virtual
4.00 Credits
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
-
Virtual
4.00 Credits
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
Assessing Independence Under Yellow Book
-
Online
1.00 Credits
GAO Yellowbook Ethics
The Ethics Hour: Accounting Scandals: What Happened and Why? Can We Prevent Them?, featuring Tracy Cooper and Don Minges
-
Online
1.00 Credits
Why do some choose to deceive, cheat and steal Can accounting scandals be prevented A brief history of accounting scandals What to look for What should ethical professionals like you do
Employment Law 101
-
Online
1.00 Credits
Title VII Americans With Disabilities Act Age Discrimination in Employment Act Family Medical Leave Act Fair Labor Standards Act Equal Pay Act National Labor Relations Act Fair Credit Reporting Act
Leveraging ChatGPT for Innovative Business Advisory Services
-
Virtual
2.00 Credits
The major topics covered in this course include:Introduction to ChatGPT and its applications in the business advisory contextIn-depth exploration of enterprise evaluation methodologies like SWOT, PESTLE, BCG Matrix, McKinsey 7S Model, Ansoff Matrix, etc.Practical case studies demonstrating application of ChatGPT in accounting business analysisKey challenges faced by accounting firms and how ChatGPT can help overcome theseBest practices for implementing AI tools in the accounting sectorFuture opportunities and trends in AI-enhanced business advisory services
Surgent's Engagement and Client Retention Best Practices
-
Virtual
2.00 Credits
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
-
Virtual
4.00 Credits
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.
2025 Governmental GAAP Update: Navigating GASB Standards
-
Virtual
2.00 Credits
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.
Understanding the Tax Implications of Retirement Plan Distributions
-
Online
1.00 Credits
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
Benford's Law and Other Digital Analysis Techniques
-
Online
1.80 Credits
Benford’s Law Digital Analysis Data analytics
Inventory, Expense and Payroll Fraud
-
Online
2.00 Credits
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
-
Virtual
2.00 Credits
Report type comparison Customizing PivotTable options Format and design options Calculated fields and items Multiple value fields
Surgent's Section 754 Step-Up in Basis: Understanding the Tax Issues for Partnerships and LLCs
-
Virtual
2.00 Credits
How and why a partnership makes a 754 election The effect of the 754 election when an interest in a partnership is sold or inherited How the 754 election applies when a partnership makes a distribution of property to one or more of its partners How to make the 754 basis adjustment
The Art of Engaging in Difficult Conversations
-
Virtual
2.00 Credits
The major subjects that will be covered in this course include:Awareness of your mindset entering the conversationTactics to build a pool of meaningClarity around story tellingBiggest mistakes to avoid
Securing Your Data with a Password Management App - Updated
-
Virtual
2.00 Credits
The major topics covered in this course include:Introduction to the world of password management apps and what makes them so secureReview and demonstration of top selling password management appsSoftware features that will be reviewedPassword generationEmergency user accessEntity vs. individual password managementDesktop vs. cloud basedMulti device synchronizationPII (personally identifiable information) forms fillerCredit card storageDigital data vault
Internal Control - Testing for Operating Effectiveness
-
Virtual
2.00 Credits
The major topics covered in this class include:Generally accepted audit requirements related to testing controls for operating effectivenessIdentifying key controls that may prove effective and efficient to test in a control reliance strategyResponses when deviations are discovered when evaluating the design or operating effectiveness of internal controlLeveraging audit evidence available for Service Organization Control (SOC1) ReportsGeneral computer control considerations when evaluating the design and operating effectiveness of internal control over financial reporting
Tax Implications of Retirement Plan Distributions
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Required minimum distributions for a deceased’s heirs2025 retirement plan contribution limitsRequired minimum distributions and contributions to charityKey provisions of Secure Act 2.0
Internal Control Fundamentals
-
Online
2.00 Credits
COSO Yellowbook Auditing
