CPE Catalog & Events
Mastering the Excel Lookup Functions
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions
ChatGPT Deep-Dive Hands-on Bootcamp for CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Getting started with ChatGPTTour of the ChatGPT app and how to use itVariety of hands-on case study examples for accounting, finance, and taxProtecting your data privacy in ChatGPTAdvanced ChatGPT features reviewSubscription plan options
ACPEN: Tricks and Treats to Avoid Litigation
-
Online
1.00 Credits
Key concepts of effective employee relations Balancing employee and employer rights Handling employee complaints Addressing personality & attitude problems
2026/27 Not-for-Profit GAAP Update
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline.The International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025.
Surgent's Guide to the AICPA Quality Management Standards
-
Virtual
2.00 Credits
Quality management standards SAS 146, SSARS No. 26, and SSAE 23 Risk assessment, which forms the basis of the SQM Monitoring and evaluating the SQM
Surgent's Controller/CFO Update: Hot Topics Facing Today's Financial Professional
-
Virtual
4.00 Credits
Economic update Leadership and management changes because of recent developments, including AI Managing for productivity Hiring the best people for the organization New motivation techniques
Surgent's Federal Tax Update
-
Virtual
4.00 Credits
Comprehensive coverage of individual provisions of the One Big Beautiful Bill Act, including but not limited to: TCJA provisions made permanent New Tip Income Deduction New Overtime Pay Deduction New Car Loan Interest Deduction New Temporary Senior Deduction Expanded SALT Cap Trump Accounts Comprehensive coverage of business provisions of the One Big Beautiful Bill Act, including but not limited to: Bonus Depreciation made permanent Increased §179 deduction Changes to §174 R&E Expenditures Changes to §163(j) Form 1099/1099-K changes Qualified Small Business Stock Exclusion The Gig Economy - examine key tax implications for gig workers, including Independent Contractor vs. Employee classification challenges and employer reporting responsibilities Timely coverage of breaking tax legislation Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas
Deep Dive Into Common Auditing Deficiencies
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Review common deficiencies identified by the AICPA and state boards of accountancy.Feature discussion on a variety of topics, including analytical procedures, sampling, group audits and risk assessment.Review of the areas of concern and how you can overcome them by employing best practices.
Introduction to Risk Assessment
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of the risk assessment procedures performed during engagements.Inquiries, analytical procedures, and observation and inspection techniques. Understanding how risk assessment drives engagement planning and supports the development of appropriate audit responses.
Surgent's IRS Tax Examinations and Hot Issues
-
Virtual
4.00 Credits
Criteria that the IRS uses to select returns for examination Substantiation requirements for travel, charitable contributions, vehicles, meals, virtual currency considerations, and tax-related identity theft Understanding worker classification determinations on who is an employee and who is an independent contractor Distinguishing S corporation officer’s reasonable compensation issues How the IRS holds persons other than an employer liable for unpaid payroll taxes, a.k.a., the trust fund recovery penalty Tax-related identity theft procedures
ACPEN: 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
Surgent’s Weekly Expert Hour
-
Virtual
1.00 Credits
Each week’s topics will change based on the most critical issues affecting financial professionals
ACPEN: Communicating in a Virtual and Live Environment – Numbers Matter But So Do Words
-
Online
2.00 Credits
Tackling the emotions of presenting Use of visuals in presentations Telling stories Who is your audience and why is it crucial? Defining presentations in a virtual and live world dynamic Discuss the overarching themes of effective presentations Building out a presentation with a roadmap order Discuss the types of presentations, including the good and the bad Tips on the right considerations in being effective in virtual presentations
ACPEN: Self-Rental Real Estate: Integrating the Passive Activity Rules with the Flow-Through Entity Deduction Rules
-
Online
2.00 Credits
Definition of self-rental property – both for Sections 199A and 469 Self-rental income from directly owned properties and reporting on Form 1040, Schedule E, page 1 Self-rental income from indirectly owned (partnerships, S corporations) and reporting on Form 1040, Schedule E, page 2 Self-rental property and the Form 8582 (passive activity) Self-rental property and the flow-through entity grouping election Self-rental property and ""former passive activities"" rules Real-life situations illustrate the various possibilities and discuss the consequences of failing to comply with the reporting standards
ACPEN: Internal Audit in The Future
-
Online
2.00 Credits
Internal Audit IIA Standards Emerging Risks Technology
Compilation, Preparation and Review Basics and Peer Reviews
-
Virtual
2.00 Credits
The major topics covered in this class include:Basic requirements included in AR-C Section 60, General Principles; AR-C Section 70, Preparation of Financial Statements; AR-C Section 80, Compilation Engagements; and AR-C Section 90, Review of Financial Statements.New requirements included in SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions.Common peer review findings.Practice tips for high-quality engagements.
2026/27 Annual Update for Governments and Not-for-Profits
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Key accounting and auditing developments affecting governmental and not-for-profit organizations. Accounting Standards Updates issued by the Financial Accounting Standards Board.The purpose of INPAS and how it compares conceptually to U.S. GAAP for not-for-profit entities.Recent developments affecting Single Audits, including the 2024 Uniform Guidance overhaul, updates to Appendix B of the AICPA GAS/Single Audit Guide, and recent guidance issued through the Office of Management and Budget (OMB).
AI & Accounting in Construction
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of AI adoption in constructionPredictive analytics and risk managementAI-integrated Building Information Modeling (BIM)Real-time compliance and financial reportingTaxation challenges in AI-driven constructionAI in project scheduling, supply chains, and quality controlRegulatory frameworks and ethical AI use in audits
AICPA Town Hall Series (10/29/2026)
-
Virtual
1.00 Credits
Timely & Critical Information Interpretation & Analysis Firm and Business Strategies Practitioner Capabilities
ACPEN: Making Effective Decisions When You Can’t Get Everything You Want
-
Online
2.00 Credits
Decision-making fundamentals Cost-volume-profit refresher Optimization analysis Constraint mitigation strategies Coping with incomplete information Solver and other Excel capabilities Qualitative considerations
