CPE Catalog & Events
Finding Errors in Excel Spreadsheets
-
Online
2.00 Credits
Member Price: $89
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.
Clarifying Risk Assessment - SAS 145 and Beyond 26-27
-
Online
4.00 Credits
Member Price: $175
• Assessing the risk of material misstatement • Mandatory risk assessment procedures • Evaluating internal controls • Responding to risk assessment with appropriate audit procedures • Complying with revised and expanded documentation requirements
Form 5500 Annual Update 2026
-
Online
4.00 Credits
Member Price: $175
• Forms 5500, 5500SF and 5500EZ • Form 5500: nuances and schedules • Reporting and disclosing compliance issues • Reporting delinquent contributions • Failure to file
Revenue Recognition for Private Entities 26-27
-
Online
4.00 Credits
Member Price: $175
• Analysis of requirements for revenue recognition under ASC 606 • Discussion of the requirements for auditing revenue transactions • Analysis of internal control and fraud risk aspects • Identification of high-risk areas of revenue recognition • Suggested procedures for identified risks
Vows Made Visible: Ethics and the Call of the Profession 26-27
-
Online
4.00 Credits
Member Price: $175
• AICPA Code of Professional Conduct, Institute of Management Accountants Standards of Ethical Conduct and T.D. Circular 230 • Implications of the Sarbanes-Oxley Act of 2002 • Recent, relevant cases on accounting profession ethics and professional responsibility • Areas the partner should pay particular attention to • What it means to be a profession and a professional • Ethical frameworks
Accounting Industry Update 26-27
-
Online
8.00 Credits
Member Price: $329
• FASB Technical Agenda and upcoming changes • ASUs • Implementation dates and methods • Audit quality initiatives • Changes to AICPA auditing standards; and PCAOB standards
Preparation, Compilations and Reviews—A Practical Workshop 26-27
-
Online
8.00 Credits
Member Price: $329
• Preparation • Compilations • Reviews
Securing Your Data with a Password Management App - Updated
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this course include:Introduction to the world of password management apps and what makes them so secureReview and demonstration of top selling password management appsSoftware features that will be reviewedPassword generationEmergency user accessEntity vs. individual password managementDesktop vs. cloud basedMulti device synchronizationPII (personally identifiable information) forms fillerCredit card storageDigital data vault
Tax Implications of Retirement Plan Distributions
-
Online
1.00 Credits
Member Price: $55
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
Tax Update: "One Big Beautiful Bill"
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Individual Taxation: Child Tax Credit expansion and additional senior deduction SALT cap extensionIncome & Adjustments: Tip income exclusion, overtime relief, educator expensesEducation Incentives: Student loan discharge, 529 plan expansion, new “TRUMP Accounts”Business Taxation: Bonus depreciation, 199A expansion, interest deduction limitsEstate & Gift Tax: Increased exemption threshold, charitable deduction changesCompliance & Reporting: 1099-K, 1099-NEC and 1099-MISC threshold changes
Fraud & Embezzlement: Case Studies from the Trenches
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:How organizations can find themselves defrauded due to lax oversight and weak internal controls.How the existence of the "trusted advisor" creates situations where CPAs can drop their professional skepticism.Illustrations of the issues companies should look for in preventing fraud and embezzlement.
Behavioral Finance Biases
-
Online
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Overview of biases and standard of living riskOverview of difference between emotional and processing biasesExamples of various real life examples and case studies
Exploring Internal Controls That Could Have Prevented Frauds
-
Online
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
Surgent's Excel: Mastering PivotTables
-
Online
2.00 Credits
Member Price: $99
Explore PivotTable capabilities and functionality Retrieve data from a database and feed it into the PivotTable Pull web tables from web pages into Excel
Operations Level Internal Control
-
Online
4.00 Credits
Member Price: $149
The major topics covered in this course include:An overview of controls that drive proceduresConsiderations for procedural control developmentUnderstanding and controlling risk that arises when organizations change
Schedule K-1: What is it & What do I do with it?
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of Schedule K-1 for Partnerships, S Corporations, and Estates/TrustsReporting Schedule K-1 information on Form 1040Basis limitations, loss limitations, and material participation rulesQualified Business Income (QBI) Deduction and Schedule K-1 integrationSchedules K-2 and K-3 requirements
Surgent's Yellow Book and Single Audits: How to Stay in Good Graces and Out of Bad Places with Your Peer Reviewer
-
Online
4.00 Credits
Member Price: $159
The key requirements and audit areas that peer reviewers focus on when reviewing Yellow Book and single audit engagements Avoiding common pitfalls seen in Yellow Book and single audits How to improve your performance on Yellow Book and single audits while staying in good graces with your peer reviewer
Surgent’s Weekly Expert Hour
-
Online
1.00 Credits
Member Price: $59
Each week’s topics will change based on the most critical issues affecting financial professionals
Noble Leadership: An Ethical Approach
-
Online
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
Selected Ethics Topics 2025 - 2026
-
Online
2.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.