CPE Catalog & Events
This will generate a PDF of the current filtered catalog
Mastering the Excel Lookup Functions
-
Online
2.00 Credits
Member Price: $89
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
2026 Washington Tax Brief
-
Online
1.00 Credits
Tax policy outlook IRS priorities and operational updates Recent tax regulatory developments Other emerging and high-impact tax issues
Overcoming Tech Adoption Challenges in CPA Firms
-
Online
1.00 Credits
Member Price: $55
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: Five critical technology adoption challenges facing CPA firms today Digital maturity assessment models and implementation frameworks AI integration strategies for tax, audit, and advisory services Cybersecurity considerations and risk management protocols Case studies of successful technology transformations in accounting firms
Microsoft 365 Application Lightning Round Review-Updated
-
Online
1.00 Credits
Member Price: $55
The major topics covered in this course include:Lightning round review of the following apps, with an explanation and demonstration of what each of them offersTeams - the foundation of all that you do in Microsoft 365SharePoint / OneDrive - secure cloud storagePower BI - the new financial reporting modelStream - the YouTube for your organizationBookings - streamline your appointment scheduling OneNote - get your content organized for quick retrieval Lists - create custom list tracking reportsTo Do - consolidate all your Outlook, Planner and general "to do's" in one appPlanner - manage simple and complex engagements and projects in an intuitive appA quick look at many of the remaining apps
ChatGPT Deep-Dive Hands-on Bootcamp for CPAs
-
Online
2.00 Credits
Member Price: $89
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
Surgent's Liquidation of Flow-Through Entities for LLCs and Partnerships
-
Online
2.00 Credits
Member Price: $99
Tax rules governing liquidation of a partnership or S corporation Tax treatment of the shareholder/partner/member receiving a liquidating distribution in an S corporation liquidation/partnership liquidation Tax impact on the pass-through entity when the entity is liquidated Receipt of corporate liabilities in an S corporation distribution Proportionate, liquidating partnership distributions to partners, and gains and losses to a partner on a liquidating partnership distribution Tax issues associated with a partnership distribution of noncash properties in a liquidation Compliance requirements on the occasion of a liquidation of a corporation or a partnership
Ethics: Critical Thinking, Case Studies and Fraud
-
Online
4.00 Credits
Member Price: $139
AICPA Code of Professional Conduct CPA responsibilities and AU-C 315 The new AICPA Ethics Codification Disciplinary cases and actions CPA Vision Seminal events The impact of ethical and unethical conduct on our profession
Create Measures in Power BI that Define Your Metrics
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this class include:Introduction to DAX: Understanding the fundamentals of DAX and its role in Power BI.Advanced DAX Formulas: Delving into complex DAX functions and formulas for creating sophisticated measures.Time Intelligence in DAX: Exploring time-based functions to analyze data over different periods.Validating Measures with DAX: Techniques for ensuring accuracy and reliability in your DAX measures.Using PivotTables for Measure Validation: Employing PivotTables in Power BI to test and confirm the effectiveness of DAX measures.
Accounting Industry Update 26-27
-
Online
8.00 Credits
Member Price: $329
• FASB Technical Agenda and upcoming changes • ASUs • Implementation dates and methods • Audit quality initiatives • Changes to AICPA auditing standards; and PCAOB standards
Federal Tax Update: Business Comprehensive 26-27
-
Online
8.00 Credits
Member Price: $329
• Review of recent federal legislation and administrative rulings • Review of recent modifications to tax forms • Review of small business tax law and administrative update changes • Review of retirement plan changes • Overall review of tax practice and procedures
Implementing and Maintaining an Internal Control System
-
Online
8.00 Credits
Member Price: $239
The major topics covered in this course include:Control creation and implementation basicsImplementation and update procedures for an Internal Control systemMaintaining existing internal controls
Surgent's Annual Accounting and Auditing Update
-
Online
8.00 Credits
Member Price: $299
Recently issued FASB Accounting Standards Updates, PCC Update, and items on the FASB’s Technical Agenda Recently issued ASUs covering derivatives, credit losses under ASC 326, government grants, and expense disaggregation FASB Final PIR Report for Leases (Topic 842) Statement on Quality Management Standards: SQMS 1, SQMS 2, and SQMS 3 Proposed SAS on the auditor’s responsibility relating to fraud Recently issued SASs and other AICPA activity Recently issued PCAOB standards and SEC rulemaking activities Other important A&A practice matters
Surgent's Predicting Future Financial Issues Facing the Financial Executive
-
Online
8.00 Credits
Member Price: $279
CPA becoming attuned to broad based business knowledge, professional skepticism, and subordination of judgment The future of medical care in the United States in a post COVID-19 environment Future of social security and impact on retirement planning and employee retention Impact on financial executive if the dollar is no longer the world currency “Fate of the States” – will the location of your business make you less competitive Future of workmen’s compensation and unemployment compensation Future of interest rates Impact of greater reliance on technology AICPA top 10 trends and technologies National infrastructure ESG and DEI trends in the global economy Impact of continuing uncertainty in markets
Ethical Performance Management
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Definition and Benefits of Ethical Performance ManagementSetting Standards/Goal settingPreparing and Conducting the Appraisal InterviewLegal Considerations in Performance ManagementAvoiding Rater BiasFeedback and Coaching
Forensic Accounting: Finding Hidden Treasure in Tax Returns
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:The rules of IRS disclosure of tax informationUnderstanding the role of IRS transcriptsInterpreting the actions of the IRS in transcriptsFOIA requestsAnalyzing tax information and returns for financial leads
How to Audit Accounting Estimates
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Procedures to test the process used by management to develop estimates.Common examples of accounting estimates that are included in the financial statements.Updated requirements in SAS 143.
Surgent's Controllership Skills Update: Risk Management
-
Online
2.00 Credits
Member Price: $99
Rethinking Risk Management: Historic view Challenges Rules Recent lessons Required skills Sources of Risk: Economy Competitors Operations Investments Strategy Compensation Routine practices Unethical behavior. Enterprise Risk Management (ERM): Defining ERM Areas of focus Implementation Planning for disasters Business continuity Contingencies Analytical Tools: Post-completion evaluations Simulation Z-score Hedging Brainstorming Mind mapping Delphi technique
Surgent's Incident Response and Case Studies in AI-powered Cybersecurity
-
Online
2.00 Credits
Member Price: $119
Frameworks for incident response (e.g., NIST Cybersecurity Framework) Case studies of notable AI-powered cybersecurity incidents (e.g., ransomware, data breaches) Practical tips for financial professionals to manage crises Post-incident analysis and lessons learned Building organizational resilience through continuous improvement
Surgent's Schedule 1-A: Implementing Important OBBBA Deductions for 2025
-
Online
2.00 Credits
Member Price: $119
Purpose and organization of Schedule 1-A, Form 1040 Taxpayers who can use Schedule 1-A The relationship of Form 1040 and Schedule 1-A Calculating modified adjusted gross income (MAGI) on Part I, Schedule 1-A The tip deduction, calculated on Part II, Schedule 1-A The overtime deduction, calculated on Part III, Schedule 1-A The car loan interest deduction, calculated on Part IV, Schedule 1-A The senior deduction, calculated on Part V, Schedule s1-A Phase-outs at higher levels of income
Auditing Financial Statements of ERISA Plans
-
Online
4.00 Credits
Member Price: $139
Auditing the statement of net assets available for benefits Types and classification of common plan investments Plan investment audit procedures based on type of audit and risk assessment Auditing the statement of changes in net assets available for benefits Presentation and disclosure requirements in accordance with GAAP Audit considerations related to related parties, parties in interest, prohibited transactions, a plan's tax status, and Form 5500