CPE Catalog & Events
Supporting Mental Wellness to Thrive in Work and Life
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Understanding Mental Wellness: Explore how the brain functions and the connection between mental and physical wellness. Learn how stress impacts brain health and overall well-being.Practical Strategies for Balanced Living: Discover techniques for improving sleep, nutrition, and physical activity to support mental wellness. Learn the importance of setting boundaries, fostering open communication, and building meaningful connections.Recognizing and Managing Support Needs: Identify when to seek additional support and learn how to integrate self-care practices that promote sustainable mental and emotional health.
Build a Data Model for Analysis in Power BI
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Data Modeling Essentials: Understanding the core concepts of data modeling in Power BI, including integration of various data sources.Building Relationships: Techniques to establish and manage relationships between different data sets.Calculated Columns and Basic DAX Measures: Introduction to DAX (Data Analysis Expressions) and its application in creating calculated columns and basic measures.Calculated Columns vs Measures: Insights into when to use calculated columns and when to opt for measures.Explicit vs Implicit Measures: Understanding the difference and appropriate application of explicit and implicit measures in data analysis.Hierarchies in Data: Creating and utilizing hierarchies to enhance data analysis and reporting.Using Pivot Tables to Validate Measures: Practical skills in using pivot tables within Power BI to validate and refine measures.
Tax Depreciation: Review and Update
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Recent tax legislation and developments related to capitalizationEligible property for Section 179 and Section 168(k)Discussion of the Section 179 deduction and its use to depreciate real propertyThe Section 168(k) deduction and its use to depreciate real propertyDisposition of segments of real propertyExchanges of tangible personal property after repeal of the like-kind exchange rulesOther related topics
Surgent's Basics of Employment Law for Non-HR Professionals
-
Virtual
4.00 Credits
How the application of policies and employment laws within the workplace can reduce employee complaints, and protect your company from claims of discrimination or wrongful behavior Examining wage and pay practices, FMLA examples, and other challenging workplace questions, to insure actions are consistent with laws/policies Key functions of employment including recruitment, interviewing and selection
Tax Procedure
-
Online
2.00 Credits
Filing a tax return IRS audit RS Appeals Collections and litigation at courts of original jurisdiction
Surgent's Hiring New Workers and Payroll Taxes
-
Virtual
2.00 Credits
Form W-4 Form I-9 Form W-9 End-of-year compliance Payroll tax returns Unemployment insurance
Surgent's Successfully Completing a Gift Tax Return -- Form 709
-
Virtual
2.00 Credits
Taxpayers who do not file gift tax returns but should The annual exclusion rules for gifts to trusts including required Crummey notices What should be disclosed on the return for purposes of running the statute of limitations The reporting of installment sales and split-interest Valuations and valuation discounts for gifts of closely held businesses The utilization of Generation Skipping Transfer Tax and the related automatic allocation rules Reporting the use of a deceased spouse’s unused exclusion exemption amount (DSUEA) A line-by-line explanation of Form 709
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
Enterprise-Wide Risk Management in Accounting and Finance
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Enterprise-wide risk management best practices for identifying, evaluating, and determining how to respond to relevant risks.The importance of risk and uncertainty disclosures in the preparation and fair presentation of financial statements, including evolving risks with cybersecurity and ESG.Coordinating risk management efforts, including the required involvement of corporate governance.How to embed risk management into day-to-day accounting and finance activities.
2025 Annual Update for Accountants & Auditors
-
Online
6.00 Credits
Accounting Standards Updates Auditing & Accounting Yellowbook
The Leadership Skills of Tomorrow: Delegate and Listen
-
Virtual
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
Professional Skepticism for the Public Accountant
-
Online
1.00 Credits
Self-evaluation of skepticism Requirements set forth by the AICPA Code of Professional Conduct Risk assessment Analytical procedures Advice for cultivating your professionally skeptical mindset
Getting the Most When Selling a Business: Little Details to Get Top Value
-
Online
2.00 Credits
What do buyers really want? Steps to take so your business will be attractive to buyers The process to prepare for a sale The steps and timing Pitfalls to avoid The value of a strong advisory team Key considerations
Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting
-
Virtual
2.00 Credits
Data validation Conditional formatting Subtotal function Reduce formula errors Skinny row
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
GPT Builder for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to GPT Builder platform and interface for accounting professionalsCreating accounting-specific custom instructions and knowledge basesImplementing financial data analysis capabilities through GPTsDesigning GPTs for tax preparation assistance and compliance checkingBuilding client communication tools with accounting terminologyEnhancing bookkeeping efficiency with automated GPT workflowsSecurity and confidentiality considerations for financial data
Mastering The Three Pillars of Cybersecurity: Exploring the Technology Pillar
-
Online
1.00 Credits
Technology Cybersecurity
The Hardest Ethical Dilemma! Why Revenge Will Always Backfire, featuring Bob Mims and Don Minges
-
Online
1.00 Credits
The quest for fairness Human nature Our natural reaction Selfishness Conflicts of interest Equity Justice How is the Golden Rule misused? The allure of revenge and how it destroys? Understanding rationalizations How the “Integrity and Objectivity Rule” will lead to better decisions?
Build Better Budgets: Fundamental Techniques
-
Online
2.00 Credits
Advantages of budgeting The role of budgeting Master budgeting Flexible budgeting Standards and variances Capital budgeting
Taking Advantage of Array Formulas in Excel
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Array Formulas: This segment establishes the foundation by differentiating array formulas from regular Excel formulas and explaining their significance.Using Array Formulas: This section focuses on the practical application of array formulas, teaching participants how to effectively implement and utilize these formulas in a variety of common Excel tasks and scenarios.Dynamic Arrays and Spill Functions: This part covers the utilization of dynamic arrays and spill functions, highlighting their role in modern Excel data handling.Advanced Array Functions: Participants will delve into complex functions such as SUMPRODUCT, UNIQUE, SORT, and FILTER, focusing on multi-condition summing and data management.Using Array Constants: This section teaches how simplify the use of static values called Array Constants
