CPE Catalog & Events
Smart Formula Selection in Excel: What to Use When
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Introduction to Strategic Formula Use:Why choosing the right formula matters: clarity, performance, and maintenanceCommon traps: overusing IF, defaulting to familiar tools, ignoring modern functionsHow Excel offers multiple ways to solve the same problem and how to pick wiselyConditional Logic and Branching Tools:IFS vs SWITCH vs nested IF: comparing readability and structureWhen to simplify logic and how to avoid nested nightmaresSummarizing Data:SUMIFS vs SUMPRODUCT: multiple conditions, weighted sums, totalsFiltering and Output Control:FILTER vs IF + INDEX: dynamic data extraction with vs without Excel 365Trade-offs in backward compatibility and ease of useCustom Output and Decision Trees:CHOOSE vs SWITCH vs LOOKUP: logic trees and category mappingEmbedded Variables and Reusability:LET vs named ranges: clarity and efficiency for long formulasUsing LAMBDA with LET to create custom functionsSimplifying and documenting complex calculationsBest Practices for Formula Selection:Criteria for deciding: readability, flexibility, future maintenanceTips for avoiding overengineering and formula bloat
Accounting for and Auditing Cryptocurrency & Digital Assets
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Common applications related to initial recognition and measurement, subsequent measurement or derecognition, presentation, and disclosure of cryptocurrency and other digital assetsFeedback from the AICPA's Digital Assets Working Group intended to assist auditors with opining on these digital records
AICPA Town Hall Series (Rebroadcast of 8/6/2026)
-
Online
1.00 Credits
Timely & Critical Information Interpretation & Analysis Firm and Business Strategies Practitioner Capabilities
Resistance to Resilience: Strive for Tech Change Acceptance
-
Online
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Resistance to resilience in embracing new technologiesOvercoming barriers and ensuring successful implementationCutting-edge audit technologies, including AI, data analytics, and automationInsights into the Technology Acceptance Model (TAM)
August 2026 AI Update: Current Issues, Future Possibilities
-
Online
1.50 Credits
Member Price: $55
• Recent changes in major AI languages and their uses • New developments in chatbot and prompt query tools for CPAs • Major AI breakthroughs in the past 6 months • Recommended AI tools for CPAs
An Ethical Approach to Mental Health Issues at Work
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Virtue Ethics and Mental HealthDefinition, Myths and Bias of Mental HealthSuicide: Facts and ResourcesRecognizing signs of potential mental health challengesEmpathy and ListeningMental Health and Generational ExpectationsBecoming a Mental Health Ally
Auditing digital assets: Client acceptance and continuance, risk assessment, and laws regulations and related parties
-
Online
2.00 Credits
Member Price: $89
Client acceptance and continuance Risk assessment and processes and controls Laws and regulations and related parties
Fiduciary Taxation Part 2: Fiduciary Accounting & Simple Trusts 26-27
-
Online
2.00 Credits
Member Price: $99
• Review the Basic Concept of Fiduciary Duty • Review the Basic Concept of Fiduciary Accounting • Use of a Diagram to Distinguish Income and Principal • Calculating Fiduciary Accounting Income • Requirements of a Simple Trust • Problem Example Spreadsheets Reflecting Fiduciary Accounting and Taxation of Simple Trusts as well as how Depreciation is Handled by a Fiduciary Entity • Problem Examples Reflecting a Completed Form 1041 using Spreadsheet Calculations for Fiduciary Accounting and Taxation of Simple Trusts
Surgent's Comparing and Contrasting Retirement Plans for Small- and Medium-Sized Businesses
-
Online
2.00 Credits
Member Price: $99
Factors business owners should take into account when choosing a retirement plan SIMPLE plans Simplified employee pension plans 401(k) plans Defined benefit plans Ensuring eligible employees are covered Employees’ impact on choice of plan Ongoing compliance requirements Establishing a plan after the tax year end Changes to safe harbor 401(k) plans Pooled employer plans Defined benefit plans and cash balance plans
Surgent's Defending Firms: Email Fraud, Cloud Risks, Cyber Insurance, and Remote Work Security
-
Online
2.00 Credits
Member Price: $119
Email fraud Phishing attacks Cloud security risks Cyber insurance Securing remote work environments
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)
All About Fraud - Examples, Prevention and Auditing
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:2026 Report to the Nations issued by the Association of Certified Fraud Examiner.Practical approaches organizations use to prevent and deter fraud, highlighting controls, policies, and cultural factors that can reduce fraud risk.Recent fraud cases reported in the news to reinforce how these schemes manifest in real-world settings.Discussion of the auditor's responsibilities related to fraud under AU-C 240, including an overview of proposed changes to the fraud standards and what they may mean for future audit engagements.
Becoming Conflict Competent
-
Online
2.00 Credits
Member Price: $89
Major topics covered in this course include:Levels of conflictStrategies to de-escalate conflictDistinction between miscommunication and conflictResponses to conflictTactics to address, rather than avoid, conflict
Business Tax Update: OBBA and Recent Developments
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Recent legislation impacting business taxpayersThe One Big Beautiful Bill ActExtenders legislation updateMeals and entertainment expense reportingPartnership and S corporation updateIncome and deductions
Forensic Accounting: Investigating Divorce Cases
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:The role of a forensic accountant in divorce proceedingsThe marketing of forensic accounting services to family law attorneysHow to conduct a financial investigationCommon areas to uncover hidden assets or incomeThe basic calculations in evaluating marital assetsTestifying in depositions and divorce court
Ethics: How to Run Your Business Well
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:The five principles of ethical intelligenceHow to make the right decisions in a range of challenging situationsThe fundamental ethical principal, "Do No Harm"
Surgent's Adapting to OBBBA Changes: A Strategic Review
-
Online
2.00 Credits
Member Price: $119
Business losses The SALT cap Implementing Section 1202 changes Form 1099 reporting changes Business meals Health care–related issues Family and medical leave Other crucial OBBBA provisions
Surgent's Foundations of Cybersecurity for Financial Professionals
-
Online
2.00 Credits
Member Price: $119
Financial professionals’ roles in cybersecurity risk management Foundational terminology and principles (e.g., risk management, threat actors) Real-world case studies of cybersecurity strategies in financial settings Integrating cybersecurity into financial reporting and compliance Understanding the dynamic cybersecurity threat environment
The One Big Beautiful Bill: 2025 tax legislation
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:The Congressional process in passing tax legislation. Major Tax Provisions in the House version of Big Beautiful Bill Individual General Business International Health Care Accounts Qualified Opportunity Zones Industry Specific Provisions Tax Exempt Organizations Miscellaneous Provisions
ChatGPT Vision for Financial Analysis
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Introduction to GPT Vision - Understanding the fundamentals of GPT Vision and its capabilities.Advantages of Vision Mode Research - Exploring the unique benefits of visual data analysis over traditional methods.Accessing GPT Vision - Guidance on how to access and utilize GPT Vision capabilities.Financial Screenshot Analysis - Techniques for analyzing financial documents and reports through screenshots.Operational Insights from Visual Data - Using images to gain insights into operational processes and asset management.Integration with Google Maps - Learning how to combine ChatGPT's vision capabilities with mapping technologies for enhanced spatial analysis.DDPP Analysis - Applying descriptive, diagnostic, predictive, and prescriptive analysis to visual data.Sentiment and Facial Expression Analysis - Techniques for interpreting emotions and sentiments in images to gauge client and employee feedback.Body Language Interpretation - Analyzing body language in images to understand non-verbal cues in business contexts.Effective Photo Capturing Techniques - Best practices for taking photos that provide optimal insights for financial analysis.