CPE Catalog & Events
Mastering the Excel Lookup Functions
-
Webinar
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
Selected Ethics Topics 2025 - 2026
-
Webinar
0.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Stay in compliance with recent ethics standards changes that impact your practice.Learn about key regulatory changes and initiatives impacting CPAs and the future of the profession.Discuss emerging issues and standard-setting activity that could affect your practice in the future.Explore practical applications of the standards and hear about common practice issues and challenges. Examples include private equity, technology, tax planning, audit quality, regulatory enforcement and standard-setting environment.Learn how failure to follow the standards can result in unwanted regulatory actions and publicity.
Surgent's Agentic AI Foundations for Finance and Accounting
-
Webinar
2.00 Credits
Member Price: $119
Evolution from RPA to agentic AI (PRAL cycle: perceive, reason, act, and learn) Use cases in financial reporting and decision support Platform overview: simulating agents with ChatGPT; enterprise examples from IBM watsonx, Microsoft Copilot, and UiPath Global regulation: EU AI Act, U.S. Executive Order, AICPA Code of Conduct Ethical considerations and professional skepticism in autonomous systems
No Tax on Overtime: Payroll Compliance
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of the Fair Labor Standards Act (FLSA) overtime provisionsDefinition of a “workweek” and the 40-hour thresholdTime-and-a-half requirement and exclusions from overtime payExempt vs. nonexempt employee classifications (executive, administrative, professional, and industry-specific exemptions)Excluded payments (discretionary bonuses, reimbursements, retirement contributions)Step-by-step calculation examples for different compensation structuresBest practices for documentation and payroll systemsCase studies illustrating misclassification and miscalculation issues
The AI Revolution in 2026: What CPAs Should Know
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:State of AI technology in 2026: capabilities, limits, and vendor solutions landscapeEssential terminology: models, training data, prompts, agents, guardrails, and moreCPA use cases: accounting, tax, advisory, and moreRisk management and data governance: data privacy, bias, accuracy, documentationWhat’s next: near-term trends and how to evaluate new tools
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
Workforce Transformation and Talent Management in 2025
-
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: 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
S Corporations: Calculating Shareholder Basis
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Discuss the calculation of basis when the entity is formed including the impact of contributed propertyExplain the importance of shareholder loans to the entityUses a comprehensive example to illustrate the mechanics of the basis determination processSchedule K-1 Basis and Form 7203Discuss how basis is impacted by distributions of corporation propertyExplain how basis is impacted by sale/or liquidation of the S corporation interestDiscuss how S corporation losses impact Form 1040 Schedule E reportingShow how to get from the Schedule K-1 information to the basis calculations
Using ChatGPT with Excel
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Introduction to ChatGPT and other AI (Artificial Intelligence) language modelsDiscussion of best practices for using ChatGPT with ExcelUse ChatGPT to create, debug and explain formulasUse ChatGPT to learn how to use Excel featuresUse ChatGPT to automate repetitive tasks in ExcelUse ChatGPT to easily create macros
Surgent's U.S. Taxation of Foreign Corporations: A Case Study Approach
-
Webinar
3.00 Credits
Member Price: $149
Understand how to approach and analyze the U.S. taxation of foreign corporations Using an example, calculate tested income, Subpart F, and PFIC income inclusions for an individual and C corporation Determine how much foreign tax credit can be claimed against such income inclusions Determine how subsequent dividend distributions from the foreign corporation are taxed Calculate capital gain on the disposition of the foreign corporation Compare different outcomes and discuss the impact of Section 962 election Identify basic strategies for managing tax liabilities related to foreign corporations
How Recent Auditing Standards Improve Risk-Based Audits
-
Webinar
4.00 Credits
Member Price: $149
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
Comprehensive Partnership Taxation Form 1065 26-27
-
Webinar
8.00 Credits
Member Price: $329
Special and Targeted allocations Proper calculation of outside and inside tax basis Tax consequences of distributions including the impact of "hot assets" Transfer of partnership interests Issuance of partnership interests to service partners
Financial Reporting Fundamentals 26-27
-
Webinar
8.00 Credits
Member Price: $329
Financial statements, disclosures and presentations Review of two Annual Financial Reports (IFRS and U.S. GAAP)
Multi Year Failure to File: Getting into Compliance
-
Webinar
8.00 Credits
Member Price: $239
The major topics that will be covered in this course include:Process-from client onboarding and transcript analysis.Risk assessment, ethical considerations, and resolution strategies.Manage cases involving individuals, married couples, businesses, payroll taxes, and S corporations.Real-world examples, IRS references, and best practices are integrated throughout to ensure confidence and compliance.
The Best S Corporation, Limited Liability, and Partnership Update Course by Surgent
-
Webinar
8.00 Credits
Member Price: $299
Discussion of key individual provisions of the One Big Beautiful Bill Act, such as TCJA provisions made permanent, new tip income deduction, new overtime pay deduction, Trump accounts, and the expanded SALT cap Comprehensive coverage of business provisions of the One Big Beautiful Bill Act, including but not limited to: Bonus Depreciation made permanent Increased §179 deduction Changes to §174 R&E Expenditures Changes to §163(j) Form 1099/1099-K changes Qualified Small Business Stock Exclusion Excess Business Loss Limitation Section 1244 Small Business Stock and Section 1202 Qualified Small Business Stock treatment and applicability Principles and considerations for nonresident withholding, composite payments, and passthrough entity taxes Partnership Distributions, Form 7217, and S Corporation Redemptions Thinking beyond §163(j) -- Interest Allocation Rules, Original Issue Discount, Applicable High Yield Discount Obligations, Convertible Corporate Debt Instruments, and Debt-Financed Distributions Timely coverage of breaking tax legislation Selected Practice and Reporting Issues: What’s new? A review of recent cases and tax law changes and IRS guidance affecting S corporations, partnerships, limited liability companies, and limited liability partnerships Decentralized Autonomous Organizations (DAOs)
Noble Leadership: An Ethical Approach
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Leadership DefinitionVirtue EthicsRelationship of Virtue Ethics to LeadershipCharacteristics of the Noble LeaderActions to create a culture of respect and dignity
Controls to Secure the Growing Digital Footprint
-
Webinar
4.00 Credits
Member Price: $149
The major topics covered in this course include:Securing individual documentsProtecting information resident in the CloudSecuring data stored on or accessed by mobile devices
Bytes, Bias, and Balance: Data Ethics for Savvy Accountants
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:The transformative role of artificial intelligence (AI) in accounting and auditingEnhancing efficiency and innovation with AI toolsMitigating challenges such as overreliance, data security vulnerabilities, and ethical dilemmas
Surgent's Getting Ahead: The Art of Marketing for CPAs
-
Webinar
2.00 Credits
Member Price: $99
Challenges of marketing CPA firms Developing marketing strategy Elements of a marketing plan Example: CPA firm marketing plan Marketing regulatory/AICPA issues Picking the right marketing channels Marketing channel statistical analysis Developing marketing metrics
A Culture of Regulatory Ethics: A Competitive Advantage
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this class include:Does it pay for a company to have strong ethics?Can you measure the financial impact of ethics?Does ethics make a difference in financial performance?Can ethics be used as a competitive advantage?What sets the CPA designation apart?AICPA Code of Professional Conduct & the Conceptual Framework ApproachEthics as a marketing toolPersonalizing your Code of EthicsFour building blocks of ethical cultureWhat influences employee behavior?Ethical researchBuilding trust in organizationsMaintaining objectivity in difficult situations