CPE Catalog & Events
Smart Formula Selection in Excel: What to Use When
-
Webinar
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
-
Webinar
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)
-
Webinar
1.00 Credits
Timely & Critical Information Interpretation & Analysis Firm and Business Strategies Practitioner Capabilities
Resistance to Resilience: Strive for Tech Change Acceptance
-
Webinar
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
-
Webinar
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
-
Webinar
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
-
Webinar
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
-
Webinar
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
K2's Advanced Topics In Power BI 26-27
-
Webinar
2.00 Credits
Member Price: $99
Creating formulas in Power BI with Data Analysis Expressions Adding Key Performance Indicators to your Power BI reports and dashboards Managing security in Power BI Publishing your reports and dashboards to Apps and Content Packs for easy sharing with other team members
Surgent's Comparing and Contrasting Retirement Plans for Small- and Medium-Sized Businesses
-
Webinar
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
-
Webinar
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
-
Webinar
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
-
Webinar
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
-
Webinar
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
-
Webinar
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
-
Webinar
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
-
Webinar
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
-
Webinar
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
-
Webinar
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
-
Webinar
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