CPE Catalog & Events
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Virtual
0.00 Credits
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 Top Individual Tax Planning Strategies
-
Virtual
2.00 Credits
Extension and enhancement of reduced rates and the standard deduction The temporary senior deduction Extension and enhancement of increased Child Tax Credit Extension and enhancement of increased estate and gift tax exemption amounts Contributions to ABLE accounts and benefitting from the Saver’s Credit Increased SALT deduction Deduction for car loan interest Using Trump Accounts Extension and enhancement of paid family and medical leave credit Enhancement of Adoption Credit, the dependent care assistance program and the child and dependent care tax credit Tax credit for contributions of individuals to scholarship granting organizations Additional expenses treated as qualified higher education expenses for purposes of 529 accounts Individual charitable contributions Health savings account related tax changes
Surgent's Virtual Currency: Keeping Up with the Tax Code
-
Virtual
2.00 Credits
Overview of virtual currency Property transactions with virtual currency Receiving virtual currency as payment Paying using virtual currency Charitable donations with virtual currency Gifting of virtual currency Form 8300 reporting
ACPEN: 2026 Spring Tax Update for Individuals with Steve Dilley
-
Online
4.00 Credits
Tips, overtime, car loan interest, and senior deduction developments Recent legislative developments, cases and rulings impacting individual taxpayers Federal Disasters—tax deduction options Individual income items, itemized deductions and credits Updated tax rate schedule and other inflation adjusted items Implications for self-employed taxpayers of various legislation
Analyzing IFRS Financial Statements
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Financial Analysis fundamentals: Overview of financial statements, their interconnections, and the foundation of advanced analysisLoblaw Companies Case Study: Introduction to our example company and its financial performanceAdvanced Analysis Techniques: Common size analysis, Dupont framework, financial leverage, and operational metricsOperational Focus: Separating core business performance from financing activitiesApplied analysis and managerial ratios: Segment analysis, cash flow analysis, and managerial ratiosManagement Commentary: Overview of the corporate narrative as presented from IFRS lens.
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.
ACPEN: Benefits and Best Practices for Telework
-
Online
2.00 Credits
Communication Business Management
ACPEN: Treasury Circular 230 for EAs and Other Tax Preparers
-
Online
2.20 Credits
Circular 230 Conflicts of interest Loving case RTRP Other Ethical Issues Fees Qualifying continuing education
Streamlined Excel Reporting Series Session 3: PivotTable Wrap-Up and Web Data
-
Virtual
2.00 Credits
Tax Depreciation: Review and Update
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Recent tax legislation and developments related to capitalizationEligible property for Section 179 and Section 168(k)Discussion of the Section 179 deduction and its use to depreciate real propertyThe Section 168(k) deduction and its use to depreciate real propertyDisposition of segments of real propertyExchanges of tangible personal property after repeal of the like-kind exchange rulesOther related topics
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: The SECURE Act 2.0 – Planning Opportunities for Employers
-
Online
1.00 Credits
Implications for Employers Starter § 401(k) plans for small employers Requiring automatic 401(k) enrollment Improving worker access to emergency savings Increasing part-time workers’ access to retirement accounts Statute of Limitations on excise taxes imposed on overcontributions to retirement plans Multiple employer §403(b) plans Automatic portability provisions Other changes in the administration of company retirement plans
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: HR Investigations – Episode 2 – Interview Techniques
-
Online
2.00 Credits
Interview terminology Types of questions Levels of listening Verbal and nonverbal communications Documenting results
How to Build a Custom AI Chatbot and GPT in Plain English
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Fundamentals of GPT Builder and AI agent customization techniquesIntegration of specialized knowledge bases and domain-specific expertiseSecurity and privacy considerations in AI chatbot deploymentCustom GPT development without coding expertiseImplementation of AI agents for customer support and workflow automationMulti-bot interactions and content creation strategiesBest practices for maintaining and scaling AI assistants
ACPEN: Building and Maintaining an Engaged Remote Team
-
Online
1.00 Credits
Designing a secure and compliant remote work environment Technology stack essentials for remote CPA firms Structuring communication and meetings for remote teams Accountability systems and performance visibility Leadership touchpoints and management hierarchy Building engagement, culture, and trust without physical proximity Retention strategies: bonding, recognition, and in-person connection
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.
ACPEN: The Ethics of Artificial Intelligence ("AI"): The Interaction of AI and Ethics, featuring Tracy Cooper, CPA and Don Minges, MBA
-
Online
1.00 Credits
What are the ethical issues within AI? The many biases within AI Ownership? Intellectual property rights? Who benefits economically? Changing regulations and laws Why many organizations ban AI? How AI can be used unethically? The need for strong human oversight!
Surgent's Establishing State Residency and Saving Your Clients Money
-
Virtual
2.00 Credits
Typical provisions in state statutes regarding domicile and residency In depth analysis of domicile and residency definitions Issues regarding one’s permanent abode Analysis of jurisdiction where taxpayer has the greatest connections Detailed discussion of criteria used to establish domicile and residency
Surgent's Excel Budgeting Ideas
-
Virtual
0.00 Credits
Set up an in-cell drop-down list of budget methods Change the calculations in the cells based on the selected budget method Use names in worksheets
