CPE Catalog & Events
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Online
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 Understanding Partnership Taxation: Debt Allocations
-
Online
2.00 Credits
Member Price: $99
Recourse debt allocations Constructive liquidation scenarios Nonrecourse debt allocations Minimum gains and nonrecourse deductions Section 704(c) gains Allocations under 704(c)
Independence for Auditors - AICPA, PCAOB, GAO & DOL
-
Online
4.00 Credits
Member Price: $159
Auditing Yellowbook AICPA, GAO, DOL and PCAOB
Federal Tax Update for Business with Doug Van Der Aa
-
Online
4.00 Credits
Member Price: $159
"Tax-mageddon" - the all-important impending expiration/extension/renewal of the TCJA Other recent legislative, judicial, and IRS developments impacting business taxpayers Current status of Research and Experimentation costs and Interest Expense Limitation Phaseout of Bonus Depreciation and MACRS issues S corporation and partnership developments Other miscellaneous business developments
Creative Strategies for Buying, Selling, or Gifting a Business
-
Online
8.00 Credits
Member Price: $275
Valuation methods for business interests Stock purchase versus asset purchase Estate transfer and tax considerations Gifting strategies for business interests Trusts and partnerships in business transfers Self-canceling installment notes in transactions Transferring S corporation stock to trusts Business interest transfer with Employee Stock Ownership Plan (ESOP)
Nonprofit Accounting and Financial Reporting Explained
-
Online
8.00 Credits
Member Price: $275
Discussion of financial reporting risks increased by the current economic environment, including increased uncertainty related to critical financial statement amounts and significant disclosures Executive summary of recent Accounting Standards Updates Overview of fair value disclosure requirements and implementation issues Discussion of issues related to donor-restricted endowment funds Classification of net assets and reclassifications Endowments, including accounting, disclosures and UPMIFA Noncascontributions Contributions received and receivable Expense recognition issues Reporting expenses by function and nature Other relevant matters unique to the nonprofit environment
Microsoft Excel: Moving Beyond the Basics
-
Online
2.00 Credits
Member Price: $109
Using formulas to manipulate and transform data Using formulas and reference formulas such as =VLOOKUP Using pivot tables Understanding Solver to perform multivariate analysis
Streamlined Excel Reporting Series Session 4: External Data and PivotCharts
-
Online
2.00 Credits
Member Price: $125
GETPIVOTDATA Text Files and Power Query Data Preparation PivotCharts
Common Yellow Book & Single Audit Deficiencies
-
Online
4.00 Credits
Member Price: $159
Auditing Yellowbook COVID-related funds
How Technology Controls Should Be Developed and Implemented 25-26
-
Online
8.00 Credits
Member Price: $329
Considerations for the maintenance of an internal control system The types of policies and procedures organizations should utilize Reviewing and testing control measures Updating controls and implementing control changes
Real Estate Taxation 25-26
-
Online
8.00 Credits
Member Price: $329
California property taxation updated in light of Proposition 19 passage Qualified business income deductions [IRC Sec. 199A] Opportunity zone deferral related to real estate [IRC Sec. 1400Z-2] Passive activities loss rules [IRC Sec. 469] Real estate professional rules [IRC Sec. 469(c)(7)] Interest expense deduction rules [IRC Sec. 163] Home sale exclusion [IRC Sec. 121] 1031 exchanges Estate planning and gifting with real estate
Google Gemini AI for Accountants
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Google Gemini Quick StartGemini Standalone ChatbotMobile AppGemini integration with:WorkspaceGmailDocsSheetsSlidesUser Tips
Generation-Skipping Transfer Tax 25-26
-
Online
1.00 Credits
Member Price: $55
Taxable terminations Mismatch between available exemption and GST, and utilizing excess GST GST elections on Form 709 and automatic allocations
HR Investigations - Episode 1 - Introduction-Assessing-Planning
-
Online
1.00 Credits
Member Price: $59
Investigation terminology Assessment skills Investigative methodology
Data Extraction, Transformation, Validation the Right Data Sources for Analysis
-
Online
2.00 Credits
Member Price: $109
Understand various data types Structured vs. unstructured data Completeness and validation testing Selecting the right data sources for the job Risks and pitfalls to avoid
PPP Fraud and Financial Professionals
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Ethical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation
Determining Reasonable Compensation for Owner Employees
-
Online
1.00 Credits
Member Price: $55
The major topics covered in this class include:An analytical framework for analyzing and opining on reasonable replacement compensation for owner-employees of closely held businesses and professional practices in the context of tax planning, compliance, management consulting and business appraisal assignmentsExecutive compensation components, including the valuation of non-qualified plans and restricted stock units
AICPA Town Hall Series (Rebroadcast of 11/6/2025)
-
Online
1.00 Credits
Timely & Critical Information Interpretation & Analysis Firm and Business Strategies Practitioner Capabilities
SECURE Act 2.0: What You Need to Know
-
Online
1.00 Credits
Member Price: $59
Expanding Automatic Enrollment in Retirement Plans Increased Age for RMDs Higher Catch-up Contribution Limit Emergency Expense Penalty-Free Withdrawals “Starter” 401(k)s for Certain Employers Part-time Worker Improved Coverage
Advanced Excel for Staff - Build Reports and Analyze Data
-
Online
2.00 Credits
Member Price: $89
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.