CPE Catalog & Events
Smart Formula Selection in Excel: What to Use When
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Introduction to Strategic Formula Use:Why choosing the right formula matters: clarity, performance, and maintenanceCommon traps: overusing IF, defaulting to familiar tools, ignoring modern functionsHow Excel offers multiple ways to solve the same problem and how to pick wiselyConditional Logic and Branching Tools:IFS vs SWITCH vs nested IF: comparing readability and structureWhen to simplify logic and how to avoid nested nightmaresSummarizing Data:SUMIFS vs SUMPRODUCT: multiple conditions, weighted sums, totalsFiltering and Output Control:FILTER vs IF + INDEX: dynamic data extraction with vs without Excel 365Trade-offs in backward compatibility and ease of useCustom Output and Decision Trees:CHOOSE vs SWITCH vs LOOKUP: logic trees and category mappingEmbedded Variables and Reusability:LET vs named ranges: clarity and efficiency for long formulasUsing LAMBDA with LET to create custom functionsSimplifying and documenting complex calculationsBest Practices for Formula Selection:Criteria for deciding: readability, flexibility, future maintenanceTips for avoiding overengineering and formula bloat
Surgent's Progressive Discipline and Termination
-
Virtual
0.00 Credits
Defining progressive discipline, including typical steps in any progressive discipline process The importance of a fair disciplinary process When and how progressive discipline should be used, including using progressive discipline in the lead-up to termination Documentation best practices Limitations on at-will employment, including contracts and laws regarding discrimination and retaliation Avoiding key risks in the termination process Best practices for legally compliant termination procedures
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.
Self-Rental Real Estate: Passive Activity & Section 199A
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Definition of self-rental property - both for Sections 199A and 469Self-rental income from directly owned properties and reporting on Form 1040, Schedule E, page 1Self-rental income from indirectly owned (partnerships, S corporations) and reporting on Form 1040, Schedule E, page 2Form 8582 (passive activity)The flow-through entity grouping electionIllustrative examples and consequences of failing to comply with the reporting standardsSelf-rental property and "former passive activities" rules
ACPEN: Mental Illness & Depression: Understanding & Supporting Employees Under the ADA
-
Online
1.00 Credits
Mental illness and depression Americans with Disabilities Act (ADA)
ACPEN: Partnership Essentials: Tax Basis Capital Accounts
-
Online
2.00 Credits
Importance of tax basis capital accounts Reporting negative tax basis Tax accounting for property contributed to a partnership Effect of the Ceiling Rule Allocation of depreciation to partners Alternative and Remedial Methods Effect on financial capital accounts Form 1065, Schedule K-1
Hot Topics Accounting Update - 2026
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:New accounting standards.The impact on Financial Reporting.Hot topics in financial reporting.Current and emerging US GAAP requirements.
Integrate ChatGPT into Your Client Advisory Services-Updated
-
Virtual
2.00 Credits
The major topics covered in this course include:ChatGPT and generative AI technology primerBuilding your generative AI vocabularyDig deeper into your engagement research to develop a higher quality advisory servicePolish your client reporting with the help of ChatGPTDeveloping your ChatGPT client advisory servicesStart with client education. You don’t need to be a technical expert to be an educatorUse AI to help your clients automate their workflows / business processesBuild better spreadsheets with ChatGPT and ExcelHelp your clients identify, evaluate and select applications for their business
Surgent's Governing Agentic AI: Cybersecurity, Data, and Risk
-
Virtual
0.00 Credits
Cyber risks: prompt injection, drift, model manipulation, data leakage Red-teaming and simulation exercises (CSA, IBM frameworks) Controls mapping: COSO, SOX, and NIST AI RMF Regulatory context: GDPR, CCPA, EU AI Act, SEC guidance Platform security discussion and comparisons
Microsoft 365 for CPAs: Unlocking Hidden Productivity Tools
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Round robin review of lesser known M365 appsReduce / eliminate internal email communications with Teams and SharePointCollaborate on spreadsheet and documents with your colleagues in real timeGet control of your appointment schedule with the Bookings appTap the full potential of OneNote as your primary repository for notes, correspondence and moreReplace email attachments with secure file sharing linksDocument business processes with the Stream appLeverage the power of AI in M365 with Copilot
Surgent's The Accountant as the Expert Witness
-
Virtual
2.00 Credits
Becoming qualified as an expert witness Best practices for testifying at trial Understanding the different roles accountants can play in litigation Working with attorneys to prepare and present a case at trial The role of experts in commercial versus personal injury litigation Confidentiality orders Compensation for expert witnesses Preparing for and attending depositions Daubert challenges to experts Expert reports The role of experts in antitrust, securities litigation, and professional liability cases Credibility as a witness
ACPEN: Tax Practice Ethical Challenges and Circular 230
-
Online
2.00 Credits
Circular 230 (IRS) rules for conducting a "best" tax practice How to avoid tax return preparation penalties Recent developments impacting today's tax practice Review of tax return preparer's registration rules Explanation of the revised AICPA Code of Professional Conduct Contingent fees
ACPEN: Navigating IRS Collections: Overview of Form 433 & Offer in Compromise
-
Online
2.00 Credits
IRS collection process overview Initial notice and subsequent notices Enforced collection actions: liens, levies, and wage garnishments Payment options and alternatives to enforced actions Detailed review of Forms 433-A & 433-B Offer in Compromise (OIC) program: qualifications and process Advising clients on compliance and payment options
AI & Accounting in Retail
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:AI-powered personalization and its impact on revenue recognitionDynamic pricing models and tax compliance risksAI in demand forecasting, inventory valuation, and COGS calculationsIntegration challenges with ERP and POS systemsGovernance, ethics, and auditability of AI decisionsData quality, audit trails, and regulatory documentationAI-assisted fraud detection, financial controls, and oversight
Ethics and Technology for CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:The foundational ethical principles CPAs are required to follow and how these principles apply to audit quality, data privacy and security, and the use of emerging technologies.The profession's need to change to meet its ethics standard in a technology-centric environment.Changes being considered by the AICPA and the National Association of State Boards of Accountancy that could impact the profession.
Ethics, AI, and Music: What Every CPA Must Know
-
Virtual
1.00 Credits
The major topics that will be covered in this course include: Four key aspects of artificial intelligence that are relevant to CPAs: machine learning, generative AI, large language models, and GPT.The role that five powerful principles—the principles of ethical intelligence—play in using AI the right way. Short, focused writing exercises (30 seconds each) designed to deepen understanding of the topic. Real-world case studies about the use of AI in music as well as accountingAnswers to several crucial questions about how to use artificial intelligence with ethical intelligence.
About the TIGTA: Who Watches the IRS?
-
Virtual
2.00 Credits
Major topics covered in this course include:The role of TIGTA in the US tax systemAuditing, investigating, and inspecting and evaluating IRS programs and operationsIdentifying opportunities to improve the administration of tax lawsPromoting integrity, economy, and efficiency in the tax systemResponding to requests from Congress and other external stakeholdersUpholding ethical standards in the accounting professionBuilding trust and confidence in the tax system
Comprehensive Accounting and Financial Reporting Update
-
Virtual
4.00 Credits
The major topics covered in this class include:CECL for nonfinancial institutions.Accounting for Paycheck Protection Program loans.Accounting for web-hosting services.Revenue recognition.Leases.FASB projects in progress.
ACPEN: GASB 96 –SBITA, GASB 94 P3, and GASB 87 Leases (Year 2)
-
Online
2.00 Credits
Requirements of GASB 96, GASB 94, and GASB 87 Implementation of GASB 96, 94 and 87
How Recent Auditing Standards Improve Risk-Based Audits
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Key changes to audit report elements intended to improve the understandability of the nature and results of financial statement auditsEnhanced required by-product communications with management and those charged with governance to promote more reliable financial statementsClarifications related to obtaining sufficient and appropriate audit evidence, including significant unusual transactions, related parties, going concern uncertainty, and accounting estimatesNew definitions and requirements related to identifying and evaluating risks of material misstatementOther important matters contained in recent SASs
