CPE Catalog & Events
Finding Errors in Excel Spreadsheets
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors.Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis.Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies.Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively.
Individual Tax Update: OBBA and Recent Developments
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Legislation impacting individual taxpayersThe One Big Beautiful Bill ActExtenders legislation updateChild tax and dependent care creditsSection 199A deductionCapital gains and lossesRental real estateOther passive activities losses
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: Mental Illness & Depression: Understanding & Supporting Employees Under the ADA
-
Online
1.00 Credits
Mental illness and depression Americans with Disabilities Act (ADA)
Surgent's Schedule 1-A: Implementing Important OBBBA Deductions for 2025
-
Virtual
2.00 Credits
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
Surgent's Unique Tax Attributes of Different Entity Types
-
Virtual
2.00 Credits
Considerations for a small business owner Self-employment taxes Guaranteed payments to partners QBI deductions: Section 199A Built-in gains tax: S corporations Excess passive income tax: S corporations PTE elections: S corporations and partnerships Taxation of fringe benefits: S corporations Double taxation of C corporation dividends Taxation of limited liability companies Which entity to choose?
The CPA's 2026 Guide to Cryptocurrency and Blockchain
-
Virtual
2.00 Credits
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
ACPEN: Partnership Checkup: Tax Issues & Forms Reporting
-
Online
4.00 Credits
Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis Impact of contributed property Explain the importance of shareholder loans to the entity Discuss how basis is impacted by distributions of corporation property and the sale/or liquidation of the S corporation interest Comprehensive examples illustrate the mechanics of the basis determination process Discusses how S corporation losses impact Form 1040 Schedule E reporting How to get from the Schedule K-1 information to the basis calculations
What's Changing in A&A for Governmental Entities (2026/27)
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Major pronouncements issued by the Governmental Accounting Standards Board, including GASB Statements No. 103, 104, and 105.Overview of active GASB exposure drafts and ongoing projects.Auditing developments, covering significant updates to the Yellow Book issued by the U.S. Government Accountability Office, including changes related to quality management, effective dates, and recent updates to the Green Book.
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
ACPEN: How to Make Difficult People Disappear...Without Breaking the Law
-
Online
1.00 Credits
Conflict Management Interpersonal Relationships Personality Styles
ACPEN: K2's Ten Questions To Ask Your IT Team
-
Online
1.00 Credits
Ten Strategic Question Frameworks for Technology Assessment Cybersecurity and Infrastructure Oversight Through Targeted Dialogue Cloud Governance and Remote Work Technology Evaluation
ACPEN: A Guide to Sampling - Part 1
-
Online
2.00 Credits
Auditing Yellowbook
Surgent's Unconscious Bias in the Workplace
-
Virtual
0.00 Credits
Introduction to Unconscious Bias The “5 Things To Know” Framework Schemas and Mental Shortcuts Types of Unconscious Bias Bias in Action: Workplace Impacts Microaggressions and Language The Four Stages of Competence Strategies for Change Tools and Resources
ACPEN: Maximizing the Tax Benefits of an Installment Sale
-
Online
1.00 Credits
Installment sale treatment eligibility When to elect out of installment sale treatment Installment sales of business assets Installment sale default and the rules for personal property vs real property Depreciation recapture
Workforce Transformation and Talent Management in 2025
-
Virtual
1.00 Credits
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: Understanding why the traditional pyramid structure is failing firms The inverted pentagon framework and its talent retention advantages Impact of technology and AI on entry-level accounting roles The 6 Ps of Business Model Transformation implementation Accelerating specialized skills acquisition in your workforce Effective knowledge transfer through mentorship and job rotation Technology-driven training and development strategies Best practices from other industries for workforce transformation Building and retaining specialized middle layers of expertise Strategic pricing models to support the pentagon structure
ACPEN: Cost and Pricing Models: Boost Your Bottom Line
-
Online
2.00 Credits
Cost Accounting Activity-based Costing
Tax Implications of Retirement Plan Distributions
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Required minimum distributions for a deceased’s heirs2025 retirement plan contribution limitsRequired minimum distributions and contributions to charityKey provisions of Secure Act 2.0
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.
Advanced Excel for Staff - Build Reports and Analyze Data
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Building Reports Workflow: Understand the steps for creating professional and functional reports.Gather and Organize Data: Learn best practices for compiling and cleaning data for accurate analysis.Set Calculations and Key Metrics: Apply formulas and functions to calculate meaningful insights. Format and Structure Report: Use formatting tools to create visually appealing and structured reports.Review and Validate: Verify data accuracy and troubleshoot potential errors.Share the Report: Learn methods for distributing reports effectively within your organization.
