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
Surgent's The Road Ahead: Critical OBBBA Changes Impacting Accounting and Finance Professionals
-
Webinar
2.00 Credits
Member Price: $119
Marginal tax rates effective in 2025 and beyond The QBI deduction Qualified residential interest Child Care Credit Miscellaneous itemized deductions, including the educator deduction Rollovers from 529 plans to ABLE accounts Additional expenses treated as qualified higher education expenses for purposes of 529 accounts Termination of credits for environmentally clean autos and expenditures Other timely topics
Surgent's Unique Tax Attributes of Different Entity Types
-
Webinar
2.00 Credits
Member Price: $99
Considerations for a small business owner Self-employment taxes Guaranteed payments to partners QBI deductions: Section 199A Built-in gains tax: S corporations Excess passive income tax: S corporations PTE elections: S corporations and partnerships Taxation of fringe benefits: S corporations Double taxation of C corporation dividends Taxation of limited liability companies Which entity to choose?
ACPEN: Financial Statement Analysis
-
Webinar
4.00 Credits
Member Price: $149
Purposes of financial statement analysis Trend analysis and vertical & horizontal analysis Simple and multivariate regression; Analysis of metrics Assessment of liquidity, solvency, and profitability Using data visualizations The role of qualitative factors
ACPEN: AI-Enhanced Business Consulting for CPAs: Strategies and Tools
-
Webinar
4.00 Credits
Member Price: $149
Business Consulting Types of Management Services Identification of clientneeds Managing Client Expectations Creating Value for Clients Techniques for Effective Consulting Application of AI Professional Standards Application
Create Measures in Power BI that Define Your Metrics
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this class include:Introduction to DAX: Understanding the fundamentals of DAX and its role in Power BI.Advanced DAX Formulas: Delving into complex DAX functions and formulas for creating sophisticated measures.Time Intelligence in DAX: Exploring time-based functions to analyze data over different periods.Validating Measures with DAX: Techniques for ensuring accuracy and reliability in your DAX measures.Using PivotTables for Measure Validation: Employing PivotTables in Power BI to test and confirm the effectiveness of DAX measures.
Erase the Mark: Best Practices in Penalty Abatement
-
Webinar
2.00 Credits
Member Price: $89
The major topics covered in this course include:The authority of the IRS in assessing tax penalties.The types of penalties that can be removed.The process the IRS uses to evaluate penalty abatements.How to request penalty abatements.Best practices in asking for penalty abatement, including using appeals.
Surgent's Preparation and Compilation Engagements Under the SSARS
-
Webinar
4.00 Credits
Member Price: $159
Relevant sections of SSARS No. 21, Clarification and Recodification SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services – 2018 SSARS No. 26, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Proposed changes to the SSARS guidance Comprehensive sample engagement work programs for preparation and compilation engagements Prescribed form, specified line item, pro forma, and other engagement variations Complete illustrations of relevant engagement letters, reporting and other required communications for preparation and compilation engagements
Understanding Internal Control Constructs
-
Webinar
4.00 Credits
Member Price: $149
The major topics covered in this course include:Underlying concepts of internal controlThe importance of control measure interdependency
ACPEN: When You Hear Hoofbeats, It May Be a Zebra
-
Webinar
1.00 Credits
Member Price: $39
Internal Controls Fraud Prevention Fraud Investigation
Internal Controls Over Compliance vs Compliance
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Testing internal ControlsAlign internal controls with specific compliance requirementsThe misidentification of controls and the confusion between compliance and control processes
ACPEN: The Psychology of Fraud
-
Webinar
1.50 Credits
Member Price: $79
Fraud Fraud Triangle
ACPEN: The AB5s of Employees and Independent Contractors
-
Webinar
2.00 Credits
Member Price: $89
Four ways to classify a worker IRS 20 Factors 20% Section 199A deduction Cost of misclassifying an employee Section 530 relief Game changing impact of the Dynamex case and AB5
ACPEN: Thinking Like an Auditor When Preparing Your Financial Statements
-
Webinar
2.00 Credits
Member Price: $89
Determining an appropriate sense of quantitative and qualitative materiality Identifying the critical components of the financial statements that matter most to financial statement users Evaluating where the financial statements are most likely to contain material fraud and error, and ensuring adequate internal control and monitoring to mitigate those risks
ACPEN: New Client Ethical Challenges: The CPAs Guide
-
Webinar
2.00 Credits
Member Price: $89
How the CPA can meet the challenges presented by a new client AICPA Code of Professional Conduct AICPA Statements on Standards for Tax Services IRS Circular 230 Case study illustration of how to bring the new client into ethical, proper financial and tax compliance
Accountants and Malpractice: Can We Get Sued for This?
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:How accountant liability is a very real threat in today's litigious society.A discussion of scenarios in which accounting professionals can find themselves inadvertently involved in a lawsuit.Pitfalls in which the accountant may find him- or her- self while dealing with clients.Real-life examples from the speaker's extensive experience as a practitioner and as an expert witness in accounting malpractice cases.
Surgent's Ethical Considerations for CPAs
-
Webinar
2.00 Credits
Member Price: $99
Auditor independence and its importance to the public accounting profession Common threats to auditor independence AICPA’s framework for assessing conflicts of interest Unique threats related to non-attest services to attest clients Common safeguards to help assure compliance with relevant rules and regulations
ACPEN: Employee Theft: Understanding the Why and Preventing the Loss with Terry Shulman
-
Webinar
2.40 Credits
Member Price: $99
Employee Theft Prevention
ACPEN: Financial Statement Presentation and Disclosure
-
Webinar
4.00 Credits
Member Price: $149
U.S. GAAP and Special purpose frameworks Form and content of financial statements: Balance sheets Income statements; Statements of cash flows Retained earnings and/or owners’ equity statements Comprehensive income Supplementary information Comparative vs. single-period financial statements Sufficiency of disclosures Illustrative disclosures frequently encountered in small-to-medium reporting entities Industry-specific nuances
ACPEN: Ethics – A Line in the Sand; Implications for Daily Business
-
Webinar
4.20 Credits
Member Price: $149
Recognize the underlying drivers of individual ethical behavior Identify the relationship between ethics and integrity Highlight ethical trends in businesses throughout the world Review high profile ethics lapses in recent years