CPE Catalog & Events
Google Gemini Deep Dive Hands-on Bootcamp for CPAs
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Getting started with GeminiTour of the Gemini app and how to use itVariety of hands-on case study examples for accounting, finance, and taxProtecting your data privacy in Google GeminiAdvanced Gemini features reviewIntegration with Google appsSubscription plan option
ACPEN: 2026/27 Not-for-Profit Accounting & Auditing Update
-
TBD
4.0 Credits
Member Price: $149
Accounting Standards Updates (ASUs) affecting not-for-profit organizations Introduction to and comparison of the International Non-Profit Accounting Standard (INPAS) U.S. GAAP considerations for NFP financial reporting AICPA auditing and attestation updates Quality management: monitoring and remediation responsibilities Updates to SSAEs, SSARSs, and group audits
ACPEN: K2’s Mastering Advanced Excel Functions
-
TBD
4.0 Credits
Member Price: $149
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
Volume to Value: A New Era of Precision Hiring in Accounting
-
TBD
1.0 Credits
Member Price: $55
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: Staff Retention Keep the Best People
-
TBD
3.0 Credits
Member Price: $109
Remote workforce Employee retention Staff turnover
Calculating the Retirement Need
-
TBD
1.0 Credits
Member Price: $55
The major topics that will be covered in this course include:Overview of retirement expenses and needsOverview of risk tolerance, time value of money and retirement planning factorsExamples of client retirement situations
ACPEN: Common Sense CFO: Dealing with Ever Changing Accounting Standards and Strategy Demands
-
TBD
2.0 Credits
Member Price: $89
Understanding the modern finance and accounting organization chart GAAP accounting changes Why so many changes? The speed of change and complexity Accepting reality Recognizing and fixing the top five accounting problems and errors Leases Revenue Management estimates Why is strategy necessary? What is strategy? The two keys to strategy? Why do some financial leaders lack strategic skills? Balancing strategy with our day-to-day roles
ACPEN: Advanced Excel: Hidden Secrets and Gems
-
TBD
2.0 Credits
Member Price: $89
Awareness of advanced functions Creative methods for data manipulation Real-life examples of innovative ways to analyze and report data with Excel Using Excel to perform e-mail merges Many other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolbox
ACPEN: K2’s Taking Another Look At Power BI
-
TBD
2.0 Credits
Member Price: $89
Getting started with Power BI Creating effective visualizations in Power BI Publishing Power BI reports to dashboards Optimizing dashboards for viewing on mobile devices
ACPEN: Five Amazing Business Books in 100 Minutes
-
TBD
2.0 Credits
Member Price: $89
Five business books, including, • “Leaders Eat Last”, by Simon Sinek, • “Zero to One” by Peter Thiel, • “American Icon” by Bryce Hoffman, • “Slide:ology” by Nancy Duarte, and • “Brain Rules” by John Molina.
ACPEN: Ethical Practices and Responsibilities Under Circular 230
-
TBD
2.0 Credits
Member Price: $89
Circular 230 (IRS) rules for conducting a tax practice Provide guidelines for registered tax return preparers and tax return preparation Contingent fees Proposed new rules addressing the evolving nature of tax practice Conflict of interest, best practices, errors and omissions, written opinion requirements Evolving rules for CPA "mobility" History and background for Circular 230
ACPEN: Drive Results with Metrics
-
TBD
2.0 Credits
Member Price: $89
Performance Metrics Budgets
Business Tax Update: OBBA and Recent Developments
-
TBD
2.0 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
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 Understanding S Corporation Taxation: Shareholder Basis, AAA, and Retained Earnings
-
TBD
2.0 Credits
Member Price: $99
S corporation earnings layers Observations on earnings layers S corporation basis calculation IRC 351 transactions Four loss tiers Appreciated property distributions
Surgent's Government and Nonprofit Frauds and Controls to Stop Them
-
TBD
4.0 Credits
Member Price: $159
Examine real-world misappropriations of cash, check frauds, vendor scams, credit card abuse, grant frauds, benefit schemes, inventory thefts, and payroll frauds Identify and develop practical controls to prevent and detect fraud Tailor controls to the size and fit of the government or nonprofit
Surgent's Required Minimum Distributions: Compliance and Planning
-
TBD
4.0 Credits
Member Price: $159
Minimum distribution requirement changes by the SECURE Act 2.0 Latest IRS guidance, including final regulations The calculation of required minimum distributions using the Uniform Life Table Required minimum distributions from multiple accounts New §401(k) rules of SECURE Act 2.0 Inherited employer retirement accounts and IRAs: Changes to spousal and non-spousal beneficiary distribution options and stretch IRAs under the SECURE Act Required minimum distributions in the year of death Roth conversions for estate planning and avoiding required minimum distributions Timing of distributions for maximum tax-free compounding Section 529 rollovers to Roth accounts under SECURE Act 2.0 Qualified charitable distributions from IRAs and the relationship between deductible IRAs and QCDs under the new anti-abuse rules. Includes SECURE Act 2.0 rollovers to CRUTs and CRATs Taxation of distributions Penalties for missed required minimum distributions and reasonable cause for abatement of penalties. Includes SECURE Act 2.0 changes
ACPEN: Federal Tax Update for Business with Doug Van Der Aa
-
TBD
4.0 Credits
Member Price: $149
"Tax-mageddon" - the all-important impending expiration/extension/renewal of the TCJA Other recent legislative, judicial, and IRS developments impacting business taxpayers Current status of Research and Experimentation costs and Interest Expense Limitation Phaseout of Bonus Depreciation and MACRS issues S corporation and partnership developments Other miscellaneous business developments
ACPEN: Partnership Essentials: Review & Update
-
TBD
4.0 Credits
Member Price: $149
Recent legislative, rules and tax developments impacting partnerships and their partners Transfer of partnership interests TCJA §461(l) Excess Business Losses and §163(j) Business Interest Expense Importance of capital accounts Form 1065, Schedules K-1 and M-2 Schedules K-2 and K-3 update Reporting partner capital accounts Effect of the Ceiling Rule Alternative and Remedial Methods Effect on financial capital accounts Tax basis capital accounts
Master the Art of CPA Communication: Boost Your Influence!
-
TBD
2.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Techniques for simplifying complex financial information for clients and stakeholdersPersuasive communication principles aligned with CPA rolesBuilding and maintaining trust and credibility with diverse stakeholdersCase studies and Interviews with Finance, Accounting and CPA professionalsDeveloping empathy and emotional intelligence in communicationsBest practices for active listening to strengthen client relationshipsApplication of Influencer principles for impactful change in communication