CPE Catalog & Events
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.
Google Gemini AI for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Google Gemini Quick StartGemini Standalone ChatbotMobile AppGemini integration with:WorkspaceGmailDocsSheetsSlidesUser Tips
Partnership Tax Updates (2025)
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Court decisions covering partnership issues such as TEFRA, Statute of Limitations, Economic Substance, and Sec. 754 Elections.IRS procedural updates on passthrough entities.New developments on conservation easements.
What You Can Learn From the Statement of Cash Flows
-
Virtual
2.00 Credits
The major topics covered in this course include:Preparation of the statement of cash flowsImportance of identifying sources and uses of cash in financial reportingFinancial statement analysisCash-related financial statement disclosures
Implementing an AI-Enabled Marketing Strategy for Your Firm
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Module 1: Introduction to AI in Marketing The Basics of AI – Concepts and TerminologyModule 2: Leveraging AI Tools and Technologies Overview of AI Tools for MarketingModule 3: Practical Strategies for AI Integration Integrating AI into Your Marketing WorkflowModule 4: Measuring AI-Driven Marketing Effectiveness Key Metrics for Assessing AI-Driven CampaignsModule 5: Real-Life Case Studies and Success Stories Case Studies of Firms Successfully Using AI in MarketingModule 6: Developing Your AI-Enabled Marketing Strategy Creating a Custom AI Marketing Strategy
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
Surgent's Real Estate Taxation: Critical Considerations
-
Virtual
4.00 Credits
The impact of recent tax legislation on the real estate industry Depreciation and recapture Determining the basis when acquiring real estate Passive activity losses Calculation of gain or loss on sale of real estate Rental operations Installment sales
CFO Solutions to IRS Problems
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:The authority of IRS in assessing and collecting taxes.The common misconceptions when dealing with IRS.Common questionable actions by business owners.How to prepare for an IRS audit.The seven options in IRS collections.Possible criminal tax violations by CFOs and small business owners.
Surgent's Advanced Audits of 401(k) Plans: Best Practices and Current Developments
-
Virtual
8.00 Credits
Audit requirements for ERISA §103(a)(3)(C) audits An annual update of the changes affecting 401(k) plans Compliance issues associated with eligibility and enrollments, remittances, lack of oversight, compensation, vesting, and other topics Best practices for engagement planning, internal controls, risk assessment, and detailed testing Avoiding common mistakes while performing audit procedures Plan mergers and acquisitions Common audit reporting and disclosure issues
Walter Haig's AICPA Auditing Standards Update
-
Virtual
8.00 Credits
The major topics that will be covered in this class include:AICPA auditing standards issued during the 18-month period prior to the program that impact audits of Small- and Medium- sized entities (SMEs)The new SAS 145 risk assessment requirementsThe new SAS 134 as amended audit reportsHow to fulfill responsibility to detect fraud under AU-C Section 240How to help clients design, implement and maintain their internal controlsTroublesome areas in the audits of Small- and Medium-sized Entities (SMEs) as identified in peer reviews and litigationHow to perform profitable audits of Small- and medium-Sized Entities (SMEs)
How to Audit Cash
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Auditing CashAudit assertions, risks, and threats to the cash balanceAuditing procedures to perform
Surgent's Food, Beverage, and Entertainment Expensing
-
Virtual
2.00 Credits
The 50% deduction for meals that are ordinary and necessary in carrying on a trade or business Elimination of the temporary rules that applied for 2021 and 2022 which allowed for 100% deductibility for ordinary and necessary business-related meals When meals are still 100% deductible IRS rules relating to the nondeducibility of activities considered entertainment or amusement What constitutes entertainment/amusement for tax purposes? When employers may deduct food and beverages provided to employees 50% deductibility for occasional employee meals and for overtime meals 50% deductibility for business meals during business meetings Business meals incurred during business travel Invoice meals separately from entertainment
Surgent's Introduction to Required Minimum Distributions
-
Virtual
2.00 Credits
How SECURE Act 1.0 and SECURE Act 2.0 changed the RMD rules What is an RMD? Who is subject to RMDs? The types of accounts subject to RMDs How to calculate an RMD How to determine if a distribution can be an RMD How to determine which life expectancy table must be used when calculating an RMD The rollover and transfer rules during an RMD year IRS penalties for non-compliance with RMD regulations Applying RMD strategies to different plan types When RMDs can and cannot be aggregated How to correct an RMD shortfall How to get a waiver of the excise tax on an RMD failure The tax implication of an RMD How to donate an RMD tax-free How to determine the RMD rules that apply to a beneficiary
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Virtual
2.00 Credits
Creating a data model/Power Pivot Building PivotTables from multiple tables Creating Measures Using named sets
Yellow Book Ethics
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The concept of public interestEthics, independence, and professional judgmentCompetence and continuing professional educationQuality control and peer reviewProper use of government information, resources, and positionProfessional behavior
Fraud, Controls & Ethics: Best Practices & Case Studies
-
Virtual
4.00 Credits
The major topics covered in this course include:Examination of actual fraudsDiscussion of internal controls that could have prevented fraudsContemplation of epiphanies for your own professional scenarios.The AICPA Code of Professional ConductOther elements of professional conduct and compliance with professional standards
ChatGPT Vision for Financial Analysis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to GPT Vision - Understanding the fundamentals of GPT Vision and its capabilities.Advantages of Vision Mode Research - Exploring the unique benefits of visual data analysis over traditional methods.Accessing GPT Vision - Guidance on how to access and utilize GPT Vision capabilities.Financial Screenshot Analysis - Techniques for analyzing financial documents and reports through screenshots.Operational Insights from Visual Data - Using images to gain insights into operational processes and asset management.Integration with Google Maps - Learning how to combine ChatGPT's vision capabilities with mapping technologies for enhanced spatial analysis.DDPP Analysis - Applying descriptive, diagnostic, predictive, and prescriptive analysis to visual data.Sentiment and Facial Expression Analysis - Techniques for interpreting emotions and sentiments in images to gauge client and employee feedback.Body Language Interpretation - Analyzing body language in images to understand non-verbal cues in business contexts.Effective Photo Capturing Techniques - Best practices for taking photos that provide optimal insights for financial analysis.
Accounting Ethics 2025 (VBOA-Approved)
-
Virtual
2.00 Credits
Professional standards and guidelines. Ethical challenges and scenarios. Professional skepticism and risk management.
Exploring Internal Controls That Could Have Prevented Frauds
-
Virtual
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
Monthly Federal Tax Updates - September 2025
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Current individual tax issuesCurrent business entity tax issuesAny current tax legislation occurring during the periodOther issues affecting the profession, including IRS procedure, current cases, payroll, and other federal tax issues
