CPE Catalog & Events
Surgent's Data Analytics Toolkit – Tools and Applications
-
Virtual
2.00 Credits
Definition of Data Analytics Assessing your organization’s current status and establishing an environment for success Financial staff’s core activities Common uses of analytics and current examples Behavioral forces that impact decisions Examples of inaccurate forecasts Identifying strategic measurements (KPIs) Improving budgeting and forecasting and addressing Black Swan events Collecting and using data from traditional and non-traditional data sources Statistical tools, including Median, Mode, Moving average, Ratio analysis, Pareto analysis, Rolling forecast, Mission-based budgeting, Trend analysis, Regression, Z-Score (public and private organizations), and Simulation Analytical techniques, including Brainstorming, Mind mapping, and Delphi technique Software tools that are readily available and can assist in visually exploring data; expanding the scope of available data, as well as collecting, analyzing and presenting results (including Dashboards). Specific ideas for using Data Analytics, including immediate opportunities and areas for further consideration Expanded lists of readings and next level software for a participants’ future reference
ACPEN: K2’s Mastering Advanced Excel Functions
-
Online
4.00 Credits
Powerful new functions and features in Excel, such as XLOOKUP and Dynamic Arrays How to use "legacy" features and functions such as AGGREGATE Creating effective forecasts in Excel
Ethics and Technology for CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:The foundational ethical principles CPAs are required to follow and how these principles apply to audit quality, data privacy and security, and the use of emerging technologies.The profession's need to change to meet its ethics standard in a technology-centric environment.Changes being considered by the AICPA and the National Association of State Boards of Accountancy that could impact the profession.
Ethics: Giving Thanks - How to Master the Art of Gratitude
-
Virtual
2.00 Credits
We'll explore what gratitude is and how expressions of it can vary from culture to culture. We'll also unpack several ways you can regularly say "thank you" to valued clients and colleagues, and we'll examine methods for evaluating gratitude in prospective and current employees.
Mastering Partnership Basis: Inside and Outside Basis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Explain the use of both "inside" and "outside” basis determination.How to calculate tax basis capital accounts, including when the entity is formed, including the impact of contributed property.Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis.Explanation of how basis is impacted distributions and by sale and/or liquidation of the partnership interest.Comprehensive example to illustrate the mechanics of the basis determination process.
ACPEN: K2’s Collaboration – Best Platforms And Practices
-
Online
2.00 Credits
The primary drivers of collaboration Who are the leading collaboration technology providers Why collaboration sometimes fails Best practices to facilitate collaboration Today's leading collaboration providers and tools
ChatGPT and IRS Taxation Law Research
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Utilizing ChatGPT for IRS Tax Law Research: Principles and PracticesNavigating IRS Databases Using Advanced AI TechniquesUsing IRS Prompt Templates: In-depth Analysis and ApplicationChatGPT in Action: Case Studies and Real-World ScenariosExploring IRS Tax Laws: Strategies, Loopholes, and ComplianceError Prevention and Correction in Tax Law ResearchFuture Trends: AI's Evolving Role in Taxation and Accounting
ACPEN: Common Yellow Book & Single Audit Deficiencies
-
Online
4.00 Credits
Common peer review deficiencies in Yellow Book engagements Common peer review deficiencies in Single Audit engagements Yellow Book requirements (independence, CPE, reporting) Single Audit compliance requirements Internal controls over compliance Compliance testing and major program determination Root causes of audit deficiencies and prevention strategies
Beyond the Basics: Financial Ratios You Might Be Overlooking
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Understanding Cost Behavior and Its Impact on Decision-MakingContribution Margin and Break-Even AnalysisMargin of Safety and Its Role in Risk ManagementOperating Leverage and Financial SensitivityAnalyzing Asset Turnover for Operational EfficiencyCash Conversion Cycle and Working Capital InsightsFree Cash Flow Yield as a Valuation Tool
Corporate Storytelling in Financial Reporting
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Purpose of Management Commentary (IFRS): Understanding the foundational objectivesPurpose of MD&A (AAP): SEC-mandated narrative disclosure requirementsHistorical Context: Past and present frameworks and the limitationsRecent Revisions: Key enhancements and ESG integrationPractical Examples: Real-world applications and improvementsConvergence & Guidance: Frameworks, comparisons, and implementation
Common Financial Statement Disclosures
-
Virtual
2.00 Credits
The major topics covered in this class include:General disclosures about the entity and its environmentCommon critical information useful to financial statement readers for making economic decisionsExplain results of operations through information that supplements the face financial statements
Power Skills: Professionalism and Client Interactions
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Best practices when communicating with the client.Complicated scenarios for practice.
2026/27 Annual Update for Accountants & Auditors
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Key accounting and auditing developments affecting accountants and auditors across industries.Recently issued and upcoming Accounting Standards Updates (ASUs), including standards effective for December 31, 2026 year-ends for public companies, private entities, and not-for-profit organizations.Recent and proposed standards affecting audit, attestation, and consulting engagements, including SSAE No. 24, SSARS No. 26, exposure drafts related to confirmations and fraud, and SAS No. 149 addressing group audits.
Surgent's Annual Accounting and Auditing Update
-
Virtual
8.00 Credits
Recently issued FASB Accounting Standards Updates, PCC Update, and items on the FASB’s Technical Agenda Recently issued ASUs covering derivatives, credit losses under ASC 326, government grants, and expense disaggregation FASB Final PIR Report for Leases (Topic 842) Statement on Quality Management Standards: SQMS 1, SQMS 2, and SQMS 3 Proposed SAS on the auditor’s responsibility relating to fraud Recently issued SASs and other AICPA activity Recently issued PCAOB standards and SEC rulemaking activities Other important A&A practice matters
Professional Ethical Considerations for CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Core principles of any Code of Professional Conduct applicable to all CPAs, including conflicts of interest, preparing and reporting information, competence, confidential information, and moreThe importance of maintaining independence for CPAs in public practice, especially when also performing nonattest services for the attest client Comparing and contrasting various ethical standards, including those promulgated by the AICPA, PCAOB, and international bodies
Yellow Book Independence and Single Audit Fundamentals
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:The conceptual framework approach to independenceIndependence threats related to preparing financial statements and accounting recordsConsideration of specific non-audit services that would and would not impair independenceDocumentation necessary to support adequate consideration of auditor considerationFundamentals of a compliance audit performed under the Uniform GuidanceSchedule of expenditure of federal awardsDetermination of major programsUsing the Compliance Supplement Uniform Guidance administrative requirements and cost principles Testing internal control over complianceTesting complianceWriting an audit findingReporting requirements of a single audit
Agentic AI for CPAs: Automate Workflows with Intelligence
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Agentic AI concepts and terminologyCase studies for using AI agents in accounting, finance, and tax servicesStep by step demonstration of creating and deploying an AI agentIntroduction to Microsoft Copilot Studio agent builderDeveloping your AI agent deployment strategy
ChatGPT Vision for Financial Analysis
-
Virtual
2.00 Credits
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.
Smart Formula Selection in Excel: What to Use When
-
Virtual
2.00 Credits
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
Compilation, Preparation and Review Basics and Peer Reviews
-
Virtual
2.00 Credits
The major topics covered in this class include:Basic requirements included in AR-C Section 60, General Principles; AR-C Section 70, Preparation of Financial Statements; AR-C Section 80, Compilation Engagements; and AR-C Section 90, Review of Financial Statements.New requirements included in SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions.Common peer review findings.Practice tips for high-quality engagements.
