CPE Catalog & Events
Finding Errors in Excel Spreadsheets
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors.Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis.Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies.Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively.
Selected Ethics Topics 2025 - 2026
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Stay in compliance with recent ethics standards changes that impact your practice.Learn about key regulatory changes and initiatives impacting CPAs and the future of the profession.Discuss emerging issues and standard-setting activity that could affect your practice in the future.Explore practical applications of the standards and hear about common practice issues and challenges. Examples include private equity, technology, tax planning, audit quality, regulatory enforcement and standard-setting environment.Learn how failure to follow the standards can result in unwanted regulatory actions and publicity.
ACPEN: Estimates, Contingencies and Going Concern
-
Online
2.00 Credits
Overview of accounting estimates and uncertainties Going concern accounting and auditing considerations SAS 132 requirements SAS 143 requirements Loss and gain contingencies Guarantees Credit losses Impact on financial reporting and auditing
ACPEN: Rethinking Your Customers to Maximize Profitability: Identifying the Right Clients
-
Online
2.00 Credits
Who is your customer? What is solution-based planning for customer value? Recognizing internal customers (e.g., departments served by finance) Exploring profitability differences between customers with similar revenue Creating and sustaining a customer value pyramid
ChatGPT and Advanced Accounting Research
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The accounting research transformation: Comparing Google vs. AI methodologiesAI ecosystems and specialized models for accounting applicationsAdvanced prompt engineering techniques for financial and tax researchAI-powered search engines and deep research platforms for accounting professionals AI as an ideation and thinking partner for complex accounting problems Specialized accounting research tools and AI superstoresPersona priming and P&P stacking methodologies for optimal AI interactionsEthical considerations and limitations of AI in accounting researchThe compliance chess effect: AI's impact on tax planning and regulatory responseAI-driven automation for regulatory updates and compliance monitoring
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: Key Tax Issues Facing Business & Industry
-
Online
4.00 Credits
Update and review of recent and key tax developments impacting business and industry "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 Travel and entertainment expense rules Independent contractor vs. employee
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
ACPEN: Corporate Ethics Cases: Discuss Real Life Conflicts
-
Online
4.00 Credits
Can you protect the public interest without violating our profession's confidentiality rules? How can a corporate world CPA get in trouble with their board of accountancy? Is a culture of fear and intimidation particularly susceptible to corporate fraud? How can using the CPA credential get a corporate accountant in trouble? Is exaggerating your CPE hours a violation of our professional codes of conduct? What are your options when your employer is clearly breaking the law? Does any legislation provide effective Whistleblower protection?
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
Surgent's Management Fundamentals
-
Virtual
0.00 Credits
What it takes to be effective as a manager Exploring the challenges that get in the way Looking at the driving forces that have evolved how managers engage with employees today Motivating employees of multi-generations Twelve practices that can be adopted to influence employees to become more engaged Identifying what it takes to develop employees Delegation and accountability
Independence for Auditors - AICPA, PCAOB, GAO & DOL
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Independence requirements issued by the AICPA, Government Accountability Office (GAO), Department of Labor (DOL), and the Public Company Accounting Oversight Board / SEC. Common areas of confusion, nuanced differences among the frameworks, and considerations auditors should keep in mind when performing attest services for different types of clients.
Spring Tax Update with Steve Dilley
-
Virtual
8.00 Credits
The major topics that will be covered in this course include:Update and integration of the most recent tax legislation impacting individual and business taxpayers.Review of individual and business provisions of the Inflation Reduction Act.Update on significant individual and business tax developments related to cases and rulings.Update on earned income credit, child credit, and child and dependent care credit.Crypto reporting update.Depreciation changes in Sec. 179 and Sec. 168(k) bonus depreciation.Tax issues impacting "gig" workers, including Form 1099-K.Update on partnership and S corporations, including Schedules K-2 and K-3 of Forms 1065 and 1120S related to foreign transactions.
How to Build a Custom AI Chatbot and GPT in Plain English
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Fundamentals of GPT Builder and AI agent customization techniquesIntegration of specialized knowledge bases and domain-specific expertiseSecurity and privacy considerations in AI chatbot deploymentCustom GPT development without coding expertiseImplementation of AI agents for customer support and workflow automationMulti-bot interactions and content creation strategiesBest practices for maintaining and scaling AI assistants
ACPEN: Let's End Business Ethics
-
Online
2.00 Credits
Ethics defined Are there business ethics? How to identify ethical issues Deciphering your ethical code Why ethical behavior is good for your business How to make ethical decisions
Ethics: 10 Crucial Qualities of High Character CPAs
-
Virtual
2.00 Credits
The major topics covered in this class include:Discover why the ten crucial qualities of high-character CPAs are essential to your successLearn how to evaluate these qualities in job candidates and why you must do so
Surgent's Ethics for Tax Professionals
-
Virtual
0.00 Credits
What does practicing before the IRS mean? Who may practice before the IRS? What should a tax preparer do if he or she has knowledge of a client's omission of income from a tax return? May a tax preparer rely on the work of other tax return preparers? May a tax preparer rely on and use client-provided information? Standards associated with giving advice to clients Abolition of the disclaimer requirement When must a tax preparer examine a client’s books and records?
Surgent's Excel Tables and Conditional Summing
-
Virtual
0.00 Credits
Using the Table object to store data Using the conditional summing function to aggregate Table data Using the Table object to create mapping tables
Surgent's Tax Research - Intermediate Concepts
-
Virtual
2.00 Credits
Tax code hierarchy Organization of an Internal Revenue Code section Special rules for IRC citation Citing other primary authorities Private letter rulings Primary vs. secondary authority Secondary sources of authority Steps in the tax research process Research memoranda
ACPEN: Creating A Coaching Leadership Style
-
Online
3.00 Credits
What the Coaching Leadership Style Coaching Leadership Style Competencies Solution Focused Coaching Framework Leadership Competency Pillars Historical and Current Views of Coaching Coaching Culture Definition and Framework Coaching Results Measuring Success of Coaching
