CPE Catalog & Events
Smart Formula Selection in Excel: What to Use When
-
TBD
0.0 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 Progressive Discipline and Termination
-
TBD
2.0 Credits
Member Price: $99
Defining progressive discipline, including typical steps in any progressive discipline process The importance of a fair disciplinary process When and how progressive discipline should be used, including using progressive discipline in the lead-up to termination Documentation best practices Limitations on at-will employment, including contracts and laws regarding discrimination and retaliation Avoiding key risks in the termination process Best practices for legally compliant termination procedures
Enterprise-Wide Risk Management in Accounting and Finance
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Enterprise-wide risk management best practices for identifying, evaluating, and determining how to respond to relevant risks.The importance of risk and uncertainty disclosures in the preparation and fair presentation of financial statements, including evolving risks with cybersecurity and ESG.Coordinating risk management efforts, including the required involvement of corporate governance.How to embed risk management into day-to-day accounting and finance activities.
ACPEN: K2’s Excel Best Practices
-
TBD
8.0 Credits
Member Price: $250
Best practices associated with creating Excel workbooks, including managing workbooks How to secure Excel workbooks Collaboration options and best practices in Excel Effective reporting techniques in Excel
Self-Rental Real Estate: Passive Activity & Section 199A
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this class include:Definition of self-rental property - both for Sections 199A and 469Self-rental income from directly owned properties and reporting on Form 1040, Schedule E, page 1Self-rental income from indirectly owned (partnerships, S corporations) and reporting on Form 1040, Schedule E, page 2Form 8582 (passive activity)The flow-through entity grouping electionIllustrative examples and consequences of failing to comply with the reporting standardsSelf-rental property and "former passive activities" rules
Mastering the Art of Conflict: CPA Transformative Strategies
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Common conflicts CPAs faceThe impacts of having/not having crucial conversations Learn your conflict style and how to elevate your conflict capabilitiesIdentifying conflict triggersBest practices using an integrated approach from Crucial Conversations, Fierce Conversations, and Leading with Questions.Interviews from CPAs and real-life scenarios they faced and what crucial conversation approaches they used.
ACPEN: Mental Illness & Depression: Understanding & Supporting Employees Under the ADA
-
TBD
1.0 Credits
Member Price: $39
Mental illness and depression Americans with Disabilities Act (ADA)
ACPEN: I want the TRUTH: Preparing to be an Expert Witness
-
TBD
1.0 Credits
Member Price: $89
Rules of civil and criminal procedure Applicable standards Testifying basics Cross-examination techniques
ACPEN: Partnership Essentials: Tax Basis Capital Accounts
-
TBD
2.0 Credits
Member Price: $89
Importance of tax basis capital accounts Reporting negative tax basis Tax accounting for property contributed to a partnership Effect of the Ceiling Rule Allocation of depreciation to partners Alternative and Remedial Methods Effect on financial capital accounts Form 1065, Schedule K-1
ACPEN: Financial Acumen for Today's HR Leader
-
TBD
2.0 Credits
Member Price: $89
Financial Statement Insight Trend Analysis Financial Benchmarks
ACPEN: Navigating IRS : Responding to IRS Notices & Letters
-
TBD
2.0 Credits
Member Price: $89
Types of IRS letters: audits, collection, balance due, unreported income How to respond to CP2000, CP14, CP75, CP504, and other notices Steps to take upon receiving a letter: deadlines, records, prep Penalties and interest associated with non-response Sample response structure and real-life examples Documentation and tracking practices for correspondence Common mistakes and how to avoid them AI-supported correspondence management and ethical considerations
Hot Topics Accounting Update - 2026
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this course include:New accounting standards.The impact on Financial Reporting.Hot topics in financial reporting.Current and emerging US GAAP requirements.
Integrate ChatGPT into Your Client Advisory Services-Updated
-
TBD
0.0 Credits
Member Price: $89
The major topics covered in this course include:ChatGPT and generative AI technology primerBuilding your generative AI vocabularyDig deeper into your engagement research to develop a higher quality advisory servicePolish your client reporting with the help of ChatGPTDeveloping your ChatGPT client advisory servicesStart with client education. You don’t need to be a technical expert to be an educatorUse AI to help your clients automate their workflows / business processesBuild better spreadsheets with ChatGPT and ExcelHelp your clients identify, evaluate and select applications for their business
Surgent's Governing Agentic AI: Cybersecurity, Data, and Risk
-
TBD
2.0 Credits
Member Price: $119
Cyber risks: prompt injection, drift, model manipulation, data leakage Red-teaming and simulation exercises (CSA, IBM frameworks) Controls mapping: COSO, SOX, and NIST AI RMF Regulatory context: GDPR, CCPA, EU AI Act, SEC guidance Platform security discussion and comparisons
ACPEN: Global Internal Audit Standards (GIAS) Domain IV - Part 1
-
TBD
1.2 Credits
Member Price: $99
Internal Audit GIAS Standards Institute of Internal Auditors Accounting Auditing
ACPEN: World-Class Cost Accounting: A Practical Application Part 2
-
TBD
2.0 Credits
Member Price: $149
Classifying manufacturing overhead costs into 5 cost types Selecting the bases for tracing overhead costs to products Period Manufacturing Inefficiencies cost of sales - categories and costing Segregating inventory for costing and analysis Accounting for variances - budgeting, analyzing, timing for recording
Forensic Accounting: Investigating Divorce Cases
-
TBD
0.0 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
The Ethic of Self-Esteem For Women
-
TBD
2.0 Credits
Member Price: $89
The major topics covered in this class include:Self-Esteem: What is it?Belief systemsBenefits of High Self EsteemMinimizing traps of low Self EsteemComponents of High Self Esteem
ACPEN: Ethical Tax Practice Strategies in a Crisis World
-
TBD
2.0 Credits
Member Price: $89
"Tales from the Front" - practice issues CPAs are dealing with in these extraordinary times Review of AICPA Code of Professional Conduct Review of IRS Circular 230 Review of client tax return disclosure rules (Sec. 6103) Crisis impacts on engagement letters, contingent fees, independence, consulting services, attest and non-attest services, billing, and collections
ACPEN: Common Sense CFO: Crisis Management, Innovation, and Other Expectations Put on CFOs
-
TBD
2.0 Credits
Member Price: $89
Championing the role of innovation in the workplace Crisis management What does it mean? What is our role? The roles we take on and differences between the roles we are assigned? Current and future trends and expectations for financial leaders and CFOs Top ten crucial skills for 2035 from the Far Side’s wisdom