CPE Catalog & Events
Surgent's Excel: Mastering PivotTables
-
Virtual
0.00 Credits
Explore PivotTable capabilities and functionality Retrieve data from a database and feed it into the PivotTable Pull web tables from web pages into Excel
ACPEN: Cash Flow Clarity: Effectively Communicate Cash Flows for your Board and C-Suite
-
Online
2.00 Credits
The importance and structure of the cash flow statement Understanding operating, investing, and financing activities Presenting the statement using the "Sources and Uses" approach How to tell the business story through cash flows and alternative reporting methods Identifying key drivers of cash and liquidity Bridging the gap between accrual accounting and understanding cash Communicating effectively with CEOs, boards, and non-financial stakeholders
S Corporations: Calculating Shareholder Basis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Discuss the calculation of basis when the entity is formed including the impact of contributed propertyExplain the importance of shareholder loans to the entityUses a comprehensive example to illustrate the mechanics of the basis determination processSchedule K-1 Basis and Form 7203Discuss how basis is impacted by distributions of corporation propertyExplain how basis is impacted by sale/or liquidation of the S corporation interestDiscuss how S corporation losses impact Form 1040 Schedule E reportingShow how to get from the Schedule K-1 information to the basis calculations
ACPEN: How to Develop Your System of Quality Management Using the AICPA Practice Aids
-
Online
3.00 Credits
Overview of Quality Management standards Scope of SQMS 1 Components of quality management Changes from prior standards AICPA practice aids Required documentation Risk assessment process Final documentation development
ACPEN: Estates & Trusts: Executor Duties and Tax Responsibilities in Estate Administration
-
Online
4.00 Credits
Legal and fiduciary responsibilities of the executor or personal representative Overview of the estate administration process from appointment through final distribution Filing requirements for Form 1040, Form 1041, and Form 706 Income in respect of a decedent (IRD) and basis adjustments Estate asset identification, valuation, and management Creditor claims, debt settlement, and distribution procedures Obtaining an EIN for the estate and IRS notice procedures IRS audit risks related to estate administration Executor liability considerations and risk management Estate accounting records, documentation, and communication with beneficiaries
ACPEN: K2’s Implementing Internal Controls In QuickBooks Online Environments
-
Online
4.00 Credits
Critical risks in QBO environments Internal control options that can mitigate risk to prudently acceptable levels Enabling alternative control measures to improve internal controls in QuickBooks environments
Create Measures in Power BI that Define Your Metrics
-
Virtual
4.00 Credits
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.
How to Audit Inventory
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Auditing Inventory.Related Audit assertions, risks, and threats to inventory.Substantive auditing procedures that staff should perform.
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
ACPEN: Fraud Assessment for Small and Medium Sized Businesses
-
Online
4.00 Credits
The fraud triangle The fraud savvy model Symptoms of fraud Benford's Law The net worth method The vulnerability chart 10 steps for action today
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.
ACPEN: Professional Skepticism for the Public Accountant
-
Online
1.00 Credits
Self-evaluation of skepticism Requirements set forth by the AICPA Code of Professional Conduct Risk assessment Analytical procedures Advice for cultivating your professionally skeptical mindset
ACPEN: Federal Disasters - How to Deduct Personal Casualty Losses
-
Online
1.00 Credits
Federal Disaster Relief Act provisions enacted in December, 2024 and July, 2025 Comparison of personal use casualties with business/investment casualties When to claim casualty losses How to postpone casualty gains Filled-in forms examples Time limits for amended returns
ACPEN: Managing Generational and Cultural Variances
-
Online
1.60 Credits
Management Leadership Cultural Variances Generational Variances
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.
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
Executive Presence, Personal Brand: Structure Your Narrative
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Components of executive presenceAudience-centered elevator pitch structureProfessional value proposition frameworkStructuring a concise executive biographyAligning personal narrative with organizational valueCommon pitfalls in professional self-presentationApplication and refinement exercise
Volume to Value: A New Era of Precision Hiring in Accounting
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:The shift from volume to precision hiringWhy firms are moving to targeted, competency-based hiringTalent market impacts and competitive hiring realitiesAI in recruiting: practical use cases and implicationsWhere AI tools commonly support hiring workflowsBenefits and limitations of AI-enabled screening and assessmentThe skills mismatch in accounting hiringWhy critical thinking and professional communication gaps persistWhy traditional hiring methods miss these competenciesThe new competency hierarchy for high performersDefining and prioritizing the competencies that drive resultsAI ethics awareness and professional judgment in an AI-enabled workplaceAssessment methods for precision hiringStructured behavioral interviewing and scoring rubricsWork simulations, case presentations, and client scenariosUsing AI-enabled assessments responsibly and consistentlyMetrics and ROI: evaluating successQuality-of-hire measures (performance, ramp time, manager satisfaction)Retention and turnover measuresEfficiency measures (time-to-fill, cost-to-fill) and how to balance themImplementation roadmapA phased approach to adopting precision hiring (foundation → expansion → optimization)– Building governance, documentation, and consistency for scalability
ACPEN: Federal Tax Update – Individuals (Form 1040)
-
Online
8.00 Credits
Discuss the most recent individual income tax legislation passed to date Review numerous individual income tax provisions related to business (i.e., sole proprietors and owners in pass through entities) including but not limited to the 20% qualified business income (QBI) deduction, §461(l) business loss limitations, §163(j) interest deduction limitations and depreciation. Cover issues related and any changes to the various taxes (i.e., income tax rates, capital gain tax rates, self-employment tax and alternative minimum tax (AMT), 3.8% net investment income tax) Brush up on other topics such as income filing status, personal exemptions, itemized deductions, exclusions from income, adjustments to income, rentals, passive activity rules and individual income tax credits (e.g., child tax credit and dependent care credit) Walk through the NEW final required minimum distribution (RMD) regulations Look at any changes to the Form 1040 and other related schedules and forms
Surgent's Advanced Audits of 401(k) Plans: Best Practices and Current Developments
-
Virtual
8.00 Credits
Audit requirements for ERISA §103(a)(3)(C) audits An annual update of the changes affecting 401(k) plans Compliance issues associated with eligibility and enrollments, remittances, lack of oversight, compensation, vesting, and other topics Best practices for engagement planning, internal controls, risk assessment, and detailed testing Avoiding common mistakes while performing audit procedures Plan mergers and acquisitions Common audit reporting and disclosure issues
