CPE Catalog & Events
Advanced Excel: Hidden Secrets and Gems
-
Virtual
2.00 Credits
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
-
Virtual
2.00 Credits
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
-
Virtual
2.00 Credits
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
-
Virtual
4.00 Credits
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
-
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
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.
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
Integrity, Objectivity and Judgment: Values in Action
-
Virtual
1.00 Credits
The major topics covered in this class include:AICPA Code of Conduct: Integrity and ObjectivityCase Study: Mortgage crisis of 2007-2010Case Study: World Com
Create Visuals in Power BI to Successfully Analyze Data
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Tour of the Power BI Desktop Interface: Understand the layout, tools, and features of Power BI Desktop.Tour of PowerBI.com Interface: Familiarize with the online environment of Power BI for report creation.Importing Power Pivot Data Model: Understand how to integrate Power Pivot models into Power BI for more complex data analysis.Building Visuals: Learn the step-by-step process to create compelling visuals and understand the importance of visual context in data storytelling.Review of Available Visuals: Explore the variety of visuals available in Power BI and their appropriate applications.Power BI Desktop Features: Delve into the advanced features of Power BI Desktop, enhancing data manipulation and visualization capabilities.Building Interactivity into Visuals: Learn to create dynamic and interactive reports that engage and inform.Publishing Reports to PowerBI.com: Gain skills in uploading and managing reports on PowerBI.com for wider access and collaboration.
Surgent's Compilations, Reviews, and Preparations: Engagement Performance and Annual Update
-
Virtual
8.00 Credits
SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services -- 2018 SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions SSARS No. 26, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Sample comprehensive engagement work programs for preparation, compilation and review engagements Reporting and disclosure illustrations for each level of service, including attesting on personal financial statements, prescribed form, special purpose framework and other engagement variations Other communication requirements, such as sample engagement letters and management representation letters
