CPE Catalog & Events
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Webinar
2.00 Credits
Member Price: $99
Using lookup functions as an alternative to direct cell references Understand the limitations of the VLOOKUP function Discover ways to move beyond these limitations
Surgent's Liquidation of Flow-Through Entities for LLCs and Partnerships
-
Webinar
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
Surgent's Taxation of the Mobile Workforce
-
Webinar
2.00 Credits
Member Price: $99
What states do not have an income tax? What is the relevance to employers? Where does an employer have an obligation to withhold state taxes for an employee? At what point does an employee become a resident? Where is unemployment paid for an out-of-state employee?
The One Big Beautiful Bill: 2025 tax legislation
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:The Congressional process in passing tax legislation. Major Tax Provisions in the House version of Big Beautiful Bill Individual General Business International Health Care Accounts Qualified Opportunity Zones Industry Specific Provisions Tax Exempt Organizations Miscellaneous Provisions
An Exhaustive Look At Fraud and Ways To Control It
-
Webinar
8.00 Credits
Member Price: $239
The major topics covered in this course include:Fraudulent acts initiated from outside organizationsWhy internal fraud occursThe importance of fighting cyber-fraudSteps that verify anti-fraud activities are working
Exploring Internal Controls That Could Have Prevented Frauds
-
Webinar
2.00 Credits
Member Price: $89
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
2026/27 Not-for-Profit GAAP Update
-
Webinar
1.00 Credits
Member Price: $55
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.
Advanced ChatGPT for Accountants
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Introduction to ChatGPT and its Applications in Accounting.Custom Instructions (CI) for Persistent Context in Financial Conversations.Analyzing Financial Statements and News Releases using ChatGPT.Exploring Business Opportunities through Hyper-Local and Sectoral Analysis.Advanced Data Analysis for Financial Comparisons and Capital Asset Audits.Image Analysis for Asset, Space, and User Interface Design.Voice Interaction with ChatGPT for Enhanced User Experience and Accessibility.
Complete Guide to Analyze Data with Excel PivotTables
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Introduction to PivotTables: Gain a solid understanding of what PivotTables are, their benefits in Excel, and how to prepare your data for creating effective PivotTables.Creating and Customizing PivotTables: Learn step-by-step how to build and format PivotTables, including filtering, sorting, and customizing layouts for optimal data analysis. Focus on Using PivotTables to Analyze Data: Explore techniques to summarize, group, and compare data with PivotTables, uncovering trends and insights for better decision-making.Advanced PivotTable Features: Discover advanced tools such as slicers, timelines, and using PowerPivot for deeper analytical capabilities. Data Visualization with PivotCharts: Learn to create PivotCharts from your PivotTables and customize them to visually present data insights effectively to stakeholders.
Introduction to Risk Assessment
-
Webinar
2.00 Credits
Member Price: $89
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.
Retaining Top Talent: Strategies for CPA Firms
-
Webinar
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: The true cost of turnover versus retention investment Research findings on why professionals leave or stay Whole-person retention strategies beyond compensation Work-life balance solutions that maintain productivity Career development paths for non-partner track professionals Business model transformations for sustainable staffing Technology and outsourcing strategies to reduce burnout Retention strategies specific to diverse talent and younger professionals
Navigating IRS Correspondence: Responding to IRS Letters
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Types of IRS letters: General notices, audits, collections, return requests, and errors.Deadlines for responding to IRS correspondence.Communication best practices for dealing with the IRS.Avoiding escalation and penalties through proactive responses.Ensuring compliance when addressing IRS correspondence.Real-world examples of successful IRS communications.Common pitfalls in handling IRS letters and how to avoid them.Strategies for advising clients on IRS correspondence.
The CPA's 2026 Guide to Cryptocurrency and Blockchain
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Blockchain technology primerCryptocurrency technology primerUpdate on the cryptocurrency marketplaceCryptocurrency exchanges - the good, the bad and the uglyOverview of cryptocurrency taxation and legislationSmart contracts - what they are and how they work
CPA to CFO: Essential Competencies for Finance Leaders
-
Webinar
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: Top competencies hiring executives seek in CFO candidates based on survey of 320+ CEOs and recruiters Critical thinking frameworks and strategy creation techniques for financial leadership Forward-looking financial skills including capital management, forecasting, and funding strategies Industry-specific requirements for high-growth companies and nonprofit organizations Practical career development strategies to build CFO-ready competencies
Corporate Transparency Act Developments
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Background of the Corporate Transparency ActBeneficial Ownership Information Reporting (BOIR) Rule Entities required to report.Reporting requirements imposed by the CTADue dates of reportsInformation needed to satisfy the BOIRImpact of failure to reportHow to submit a reportCourt rulings on CTA’s unconstitutionalityImplications to entities as a result of the ruling in NSB.Potential reporting requirements due to FinCen’s proposed rulemaking with respect to non-financed purchases of residential real estate and gratuitous transfers.
Surgent's Controllership Skills Update: Current Survival Skills
-
Webinar
2.00 Credits
Member Price: $99
Changing Role of Financial Professionals: Priorities Change in mission Valued-added actions Strategic Measurements: Common errors and guidelines for improvement Balanced scorecard Strategy development and implementation Budgeting basics and next steps Risk Management: Recent lessons, including Black Swan events Defining Enterprise Risk Management (ERM) Implementation Developing a Financial Leadership Pipeline: Changing employment environment Retaining the right employees Compensation Hiring process Capital Projects: Types of projects Factors affecting capacity Valuation techniques Cash management M&A Activity: Current environment Controller’s role Strategic questions Sample transactions Due diligence Implementation Introducing Improvements/Innovation: Getting started Establishing an environment Potential first projects Organizational structure
Surgent's Excel Tables and Conditional Summing
-
Webinar
2.00 Credits
Member Price: $99
Using the Table object to store data Using the conditional summing function to aggregate Table data Using the Table object to create mapping tables
Surgent's Governing Agentic AI: Cybersecurity, Data, and Risk
-
Webinar
2.00 Credits
Member Price: $119
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
Surgent's Top Business Tax Planning Strategies
-
Webinar
2.00 Credits
Member Price: $99
Lower marginal tax rates made permanent New, more generous depreciation rules for bonus and Section 179 Qualified production property and bonus depreciation Full expensing of domestic research and experimental expenditures Rev. Proc. 2025-28 and options for small taxpayers Taking advantage of the QBI deduction Taking advantage of the SALT cap and the pass-through entity tax Form 1099 reporting changes Deducting business interest and business losses Taking advantage of the new Section 1202 tax regime
Deep Dive Into Common Auditing Deficiencies
-
Webinar
4.00 Credits
Member Price: $149
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.