CPE Catalog & Events
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Online
2.00 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
Cybersecurity Fundamentals for CPAs
-
Online
2.00 Credits
The major topics that will be covered in this course include:Top cloud security threats and how to protect against themData security best practices and how to implement themTypes of cloud services and how to choose a good vendorEffective password management and multi-factor authentication for accountsHome network and device security practices
Individual Tax Update: Recent Developments
-
Online
2.00 Credits
The major topics that will be covered in this class include:2021/22 legislation impacting individual taxpayersExtenders legislation updateChild tax and dependent care creditsSection 199A deductionCapital gains and lossesRental real estateOther passive activities losses
Power BI - Analyze Your Data With Excel Pivot Tables
-
Online
4.00 Credits
The major topics that will be covered in this class include:The advantages of PivotTable for Data AnalysisStep-by-Step PivotTable creationCreating PivotChartsThis course is #3 in the Microsoft Power BI series of webinars. Click button below to see suggested viewing order. View Series Sequence
Audit 503: Management - Being a Balanced Leader-Manager
-
Online
2.00 Credits
The major topics covered in this course include:Differentiating between managing and leading, while highlighting the importance of eachAssessing your own natural management and leadership styleAdapting management and leadership styles to the specific circumstancesBecoming a catalyst for positive changeOvercoming barriers to successfully managing and leadingSuccessfully engaging in difficult conversations to minimize performance issues and conflict
Promote Internal Whistleblowing and Succeed in Creating a Strong Speak Up Culture
-
Online
1.00 Credits
Speak up culture Encouraging internal whistleblowing Ethical culture Internal complaint reporting processes
Defining Where and Why Internal Controls are Needed
-
Online
2.00 Credits
The major topics covered in this course include:Control design basicsAreas or segments of an enterprise to controlControls to reduce riskControls to drive operations
The Competent Accountant - Mastering the Role of the Controller/ CFO
-
Online
4.00 Credits
Business Management Organization
Exploring Internal Controls That Could Have Prevented Frauds
-
Online
2.00 Credits
The major topics covered in this class include:Examination of actual fraudsDiscussion of internal controls that could have prevented the fraudsContemplation of epiphanies for your own professional scenarios
ChatGPT and Complex Financial and HR Conversations
-
Online
2.00 Credits
The major topics that will be covered in this course include:Complex and nuanced communications related to:Budget Allocation and Negotiation TechniquesCompensation and Benefits StructuringManaging Financial Performance and LayoffsFinancial and HR Aspects of Mergers and AcquisitionsRegulatory Compliance and Ethical Financial PracticesStrategies for Financial Crisis ManagementEffective Performance Management Systems
Surgent's Client Advisory Services (CAS): A Guide to the Variety of Offerings Professionals Can Provide
-
Online
2.00 Credits
Details on CAS: new services or rebranding? Review the value of timely accurate automated accounting Review the three levels of service Discuss technology options Assess your client base for who would benefit most from CAS Staffing requirements for CAS The value of servicing a niche
Surgent's Preparation and Compilation Engagements Under the SSARS
-
Online
4.00 Credits
Relevant sections of SSARS No. 21, Clarification and Recodification Updates to SSARS No. 21 guidance due to issuance of SSARS Nos. 22, 23 and 24 Proposed changes to the SSARS guidance Comprehensive sample engagement work programs for preparation and compilation engagements Prescribed form, specified line item, pro forma, and other engagement variations Complete illustrations of relevant engagement letters, reporting and other required communications for preparation and compilation engagements SSARS No. 21 implementation issues and peer review feedback
IRS Penalties and Abatements
-
Online
2.00 Credits
The major topics covered in this class include:Various types of penalties: Accuracy related, fraud, understatement of valuation, reporting requirement, failure to pay, and pay or deposit penaltiesRules on waiver of penalties and interestsVarious forms and procedures for requesting reliefFirst Time Abatement: Requirements and proceduresHow an individual taxpayer qualifies for Reasonable Cause abatementProcedures for requesting refund of paid penaltiesAvailable administrative options
Supervision/Management Competencies: An Ethical Approach
-
Online
2.00 Credits
The major topics covered in this course include:Overview of Virtue EthicsMilgram and Zimbardo case studiesNavigating the transition from "Buddy to Boss"Self-Awareness and Regard for OthersSetting Standards and Analyzing PerformanceUnconscious BiasCommunication Skills
Audit 504: Making Rain - Success with Clients and Prospects
-
Online
2.00 Credits
The major topics covered in this course include:Continued marketing to existing clientsHow to better connect with existing and prospective clientsMotivating prospective clients to engage with your firmMethods for building value perceptions with existing and prospective clientsDifferentiating your firm from the competition, including translating features into benefitsHandling objections and closing a sale
New Mergers & Acquisitions: Tricks, Traps, & Terrors
-
Online
4.20 Credits
Business Management Organization
The Leadership Skills of Tomorrow: Delegate and Listen
-
Online
2.00 Credits
The major subjects that will be covered in this course include:Three levels of listeningStrategies to remain focusedBuilding trust through listeningTactics to practice the Titanium RuleDelegating with confidenceEstablishing an accountability system
The Head and Heart of Ethics - Featuring Bob Mims and Don Minges
-
Online
1.00 Credits
The difficult trade-offs in making choices. Functioning in the ‘gray’ areas. The value of trust. How lack of accountability can lead to ethical issues.
Surgent's Excel Budgeting Ideas
-
Online
2.00 Credits
Set up an in-cell drop-down list of budget methods Change the calculations in the cells based on the selected budget method Use names in worksheets
The Ethic of Recruitment and Selection
-
Online
2.00 Credits
The major topics covered in this course include:Discussion of ethical and effective recruiting strategiesSelection processes that foster diversity and inclusionHow to increase talent pools to ensure hiring success