CPE Catalog & Events
5 Steps to Cultivate a Values-Based Approach to Governance
-
Online
1.20 Credits
Employee engagement Values-based governance Organizational culture Employee relations
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Virtual
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
Surgent's Time Management for Professionals
-
Virtual
2.00 Credits
Managing interruptions The role of activity logs, to-do lists and a priority matrix The psychology of time management Staying on track of your time management plan Controlling procrastination Blocking out time Creating an effective time management plan
The 10 Must Know Excel Features
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.
Surgent's Gaining a Competitive Advantage: Critical Skills for CFOs and Controllers
-
Virtual
4.00 Credits
Latest state of the economy Expense control that works Understanding our changing workforce and working environment Financial risk analysis Enterprise risk management Improving bank relationships
2025 Not-for-Profit GAAP Update
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Accounting Standard Updates issued by the FASB.Not-for-Profit Advisory Committee (NAC) and the projects they are advising the FASB on.
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Discuss the impact of the Section 199A flow-through entities deduction on partnerships and their partnersThe meaning of a "tax basis capital account"How the financial accounting and tax capital accounts differ from one anotherDetermine a partner's share of the partnership's liabilitiesDistinguish "recourse" loans from "nonrecourse" loansWhat are "qualified nonrecourse financing" loans and how they affect partnersSection 704 "built-in gain or loss" rules and how they impact Schedule K-1 reportingSection 4655 "at risk" rules and how they impact Schedule K-1 reporting
Surgent's International Tax Challenges and Opportunities for U.S. Filers
-
Virtual
3.00 Credits
Residency status for U.S. federal income tax purposes Key provisions of U.S. income tax treaties Overview of the taxation of income from foreign entities Understanding Foreign Tax Credit Identifying foreign-source and U.S.-source income Foreign earned income and housing exclusion Foreign informational form filing requirements
Master the Art of CPA Communication: Boost Your Influence!
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Techniques for simplifying complex financial information for clients and stakeholdersPersuasive communication principles aligned with CPA rolesBuilding and maintaining trust and credibility with diverse stakeholdersCase studies and Interviews with Finance, Accounting and CPA professionalsDeveloping empathy and emotional intelligence in communicationsBest practices for active listening to strengthen client relationshipsApplication of Influencer principles for impactful change in communication
An Ethical Approach to Mental Health Issues at Work
-
Virtual
2.00 Credits
The major topics covered in this class include:Virtue Ethics and Mental HealthDefinition, Myths and Bias of Mental HealthSuicide: Facts and ResourcesRecognizing signs of potential mental health challengesEmpathy and ListeningMental Health and Generational ExpectationsBecoming a Mental Health Ally
DEI in the Remote Work Era
-
Online
1.20 Credits
DEI Employee engagement Remote work Organizational culture Employee relations
Recruit. Retain. Engage. Mastering LinkedIn for HR Success
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:How to pro-actively find, identify, and connect with new candidates from various sources within LinkedIn.Best practices for organically attracting candidates to your company and team.Strategic talent networking opportunities.Essential considerations of employee advocacy and brand building using LinkedIn.Retention strategies such as promoting a positive work environment, and expanding employee recognition and engagement strategies.
Tax Practice Quarterly: Navigating Innovation in Tax
-
Virtual
2.00 Credits
Innovation in tax technology Gen AI use in tax practices
AI Prompt Engineering Masterclass for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Prompt Engineering: Basics of structuring effective prompts for meaningful AI responses.Understanding AI's "Lazy" Defaults: Why LLMs provide basic answers and how to push them to deliver richer insights.Multi-Layered Prompting: Techniques to encourage AI to provide responses across beginner to expert levels.Candid and Contrarian Responses: Using prompts that elicit honest and balanced insights, even on controversial topics.Ripple Effect and Cobra Effect: Probing the broader impacts and unintended consequences of financial decisions.Avoid Stupidity Checklist: A practical prompt for reducing mistakes in AI-assisted accounting tasks.Role-Based Perspective Prompts: Crafting prompts that guide AI to respond from specific professional viewpoints.Automation Ideas: Leveraging AI to optimize repetitive accounting tasks.Emotion-Driven Prompting: Exploring how emotion-focused prompts can enhance AI performance and engagement.Practical Applications in Accounting: How to apply prompt engineering in real-world financial analysis and decision-making.
Grading Your Auditors - Are You Getting the Most Value?
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Limitations in roles and responsibilities an auditor can accept without impairing independenceAssessing the strength of your auditor's ability to think critically, strategically, and creatively in appropriate circumstancesEvaluating your auditor's time and project management stillsGrading your auditor's communication and interpersonal skills, in exceeding your expectations on an audit
How to Start a CFO Service
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:What business owners really want from a CFO/business advisory service (it's not what you think).How to determine if you're qualified to provide CFO/business advisory services.Why now is the right time to be providing CFO/business advisory services.How to get new clients to your practice and how to approach existing clients.Why clients need you and why you need them.How much you should be charging for this type of service.How to provide a CFO/business advisory service in the most efficient way possible.
Better Forecasts: Be a Better Predictor
-
Online
2.00 Credits
Why an open mind and the ability to doubt helps make great predictions Why it is better to be a fox than a hedgehog How non-conformists change the world How to focus on what matters How to learn from the past without hindsight bias
Cryptocurrency 15 Years Later - A Market Update
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Update on the cryptocurrency marketplaceCryptocurrency exchanges - the good, the bad and the uglyOverview of cryptocurrency taxation regulationsThe technology behind cryptocurrency - Proof of stake, Layer 2, wallets and moreBlockchain technology update
Coaching Leaders to Handle Sensitive Employee Relations Situations
-
Online
1.20 Credits
Employee complaints Personality & attitude problems Performance counseling Personal hygiene problems Disability-related performance issues Misconduct due to mental conditions
Indirect Rate Recovery for Non-Profits & Pass-Through Entities
-
Online
1.00 Credits
Indirect rates Sub-recipient relationship with PTEs PPP loan forgiveness credit The District of Columbia and MD laws on settlement of indirect rates with PTEs 10% de mnimis rate vs. indirect rate negotiation
