CPE Catalog & Events
Clean, Transform & Load Data in Power BI
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Introduction to Power Query in Power BI: Understanding the interface and basic functionalities.Data Cleaning Techniques: Removing duplicates, handling null values, and data type conversions.Data Transformation: Advanced methods for manipulating data, including pivoting, merging, and appending queries.Data Loading: Efficiently loading data into the Power BI data model.Document the Process Steps: Setting up details for each step in the process so you can document what is happening and why.
SMART Goal-Setting As a Path to Flourishing
-
Virtual
1.00 Credits
What is a goal? Objectives and key results SMART goals: What they are, how to set them and how they lead to success
Entertainment, Meals & Travel Expenses: Review and Update
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Definition of what qualifies as an entertainment expenseStrategies to deduct business entertainment expensesDeductibility of mealsSituations not subject to the 50% meals and entertainment reductionHow to handle automobile issues related to employer-provided parkingProper accounting for deductible vs. non-deductible expendituresThe four steps to analyze business expensesThe latest federal legislation, cases and rulings
Surgent's Getting Ahead: The Art of Marketing for CPAs
-
Virtual
2.00 Credits
Challenges of marketing CPA firms Developing marketing strategy Elements of a marketing plan Example: CPA firm marketing plan Marketing regulatory/AICPA issues Picking the right marketing channels Marketing channel statistical analysis Developing marketing metrics
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
Yellow Book Independence and Single Audit Fundamentals
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:The conceptual framework approach to independenceIndependence threats related to preparing financial statements and accounting recordsConsideration of specific non-audit services that would and would not impair independenceDocumentation necessary to support adequate consideration of auditor considerationFundamentals of a compliance audit performed under the Uniform GuidanceSchedule of expenditure of federal awardsDetermination of major programsUsing the Compliance Supplement Uniform Guidance administrative requirements and cost principles Testing internal control over complianceTesting complianceWriting an audit findingReporting requirements of a single audit
The Ethic of Teamwork
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Virtue ethicsTeam dynamicsCharacteristics of highly effective teamsMeeting managementTeam communicationDecision making
Surgent's Yellow Book and Single Audits: How to Stay in Good Graces and Out of Bad Places with Your Peer Reviewer
-
Virtual
4.00 Credits
The key requirements and audit areas that peer reviewers hone in on when reviewing Yellow Book and single audit engagements Avoiding common pitfalls seen in Yellow Book and single audits How to improve your performance on Yellow Book and single audits while staying in good graces with your peer reviewer
The Untold LinkedIn Hyper-Growth Story
-
Online
1.00 Credits
Talent Business Growth People Strategy Culture Communication Trust Strategy
The Controller Function - Inventory Part 1
-
Online
1.80 Credits
Accounting Finance Operations
Tax Power Ethics for Tax Professionals
-
Online
2.00 Credits
AICPA Code of Professional Conduct and interpretations Statements on Standards for Tax Services Tax preparer standards in the Internal Revenue Code Rules for practice with and before the IRS, including IRS Circular 230 New developments Best practices and case studies
Navigating IRS Collections: Overview of Form 433 & OIC
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of the IRS collection process and enforcement actions.Initial notices, taxpayer rights, and IRS timelines.When to use Forms 433-A or 433-B and required documentation.Offer in Compromise (OIC): criteria, process, and practical considerations.Payment options: installment agreements, partial payment plans, and OIC.Advising clients on IRS collections and avoiding penalties.Compliance strategies for minimizing tax liabilities.Real-world scenarios and examples for tax debt resolution.
ChatGPT Bootcamp for CPAs with John Higgins
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Review the history of ChatGPTTour of the ChatGPT app and how to use itSetting up a ChatGPT account (free & premium)Variety of hands-on case study examples for accounting, finance and taxA look under the hood at how ChatGPT worksCaution - how to avoid risks in using ChatGPTA look into the future potential for AI in business
How Much Are Your Ethics Worth?
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Understanding ethicsAvailable tools to aid in ethical decision makingThe role of bias in making ethical decisionsApplication through case studies
Surgent's Data Security: Best Practices to Protect Your Business and Yourself
-
Virtual
1.00 Credits
Ethical duty to safeguard employee, client, and litigant data Common threats, including phishing, ransomware, and bad password management Security management of business and personal electronic devices Best practices for creating and securing passwords Insight into how our personal information is exploited in our daily lives
The Controller Function - Inventory Part 2 - Valuation, Inventory Methods and Inventory Fraud
-
Online
1.50 Credits
Accounting Finance Procurement Inventory
ChatGPT and Complex Financial and HR Conversations
-
Virtual
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 Incredible Leadership Transformations in Accounting - Ways to Improve Leadership and Communication
-
Virtual
2.00 Credits
Explore the tenets of exemplary leadership which are requirements for highly effective leaders who achieve results and are respected by team members, peers, and other leaders Review key practices that recognize and build on leadership strengths to create a team environment that is productive, profitable, strengthens team members’ morale, and fosters positive energy in the work climate Examine SMART goals to inspire teams to tackle tough challenges and help team members reach and exceed their potential Review conflict management techniques to minimize negative attitudes and foster win/win resolutions for team members
Common Financial Statement Disclosures
-
Virtual
2.00 Credits
The major topics covered in this class include:General disclosures about the entity and its environmentCommon critical information useful to financial statement readers for making economic decisionsExplain results of operations through information that supplements the face financial statements
The Controllership Series - Overhead, Direct and Indirect Costs and Allocation Methods
-
Online
1.00 Credits
Accounting Finance Procurement Operations
