CPE Catalog & Events
Complete Guide to Analyze Data with Excel PivotTables
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Introduction to PivotTables: Gain a solid understanding of what PivotTables are, their benefits in Excel, and how to prepare your data for creating effective PivotTables.Creating and Customizing PivotTables: Learn step-by-step how to build and format PivotTables, including filtering, sorting, and customizing layouts for optimal data analysis. Focus on Using PivotTables to Analyze Data: Explore techniques to summarize, group, and compare data with PivotTables, uncovering trends and insights for better decision-making.Advanced PivotTable Features: Discover advanced tools such as slicers, timelines, and using PowerPivot for deeper analytical capabilities. Data Visualization with PivotCharts: Learn to create PivotCharts from your PivotTables and customize them to visually present data insights effectively to stakeholders.
Internal Control - Testing for Operating Effectiveness
-
Virtual
2.00 Credits
The major topics covered in this class include:Generally accepted audit requirements related to testing controls for operating effectivenessIdentifying key controls that may prove effective and efficient to test in a control reliance strategyResponses when deviations are discovered when evaluating the design or operating effectiveness of internal controlLeveraging audit evidence available for Service Organization Control (SOC1) ReportsGeneral computer control considerations when evaluating the design and operating effectiveness of internal control over financial reporting
Surgent's Successful Communication
-
Virtual
0.00 Credits
The communication process and barriers that get in the way Techniques for overcoming barriers Understanding and self-assessment of each component of the communication process Gaining skills to listen more effectively, especially in stressful situations with heightened emotions Action plan to apply techniques in the workplace for communication success
Fraud Busters: Controls to Prevent & Detect Fraud
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Fraud motivators - the fraud triangle, typical profiles of fraud perpetratorsRevisiting the basics of controls - design vs effectiveness, preventative vs. detectiveEntity-wide controls and how they can assist in fraud deterrenceSpecific fraud types and the controls that could prevent and detect them
Surgent's Defending Firms: Email Fraud, Cloud Risks, Cyber Insurance, and Remote Work Security
-
Virtual
0.00 Credits
Email fraud Phishing attacks Cloud security risks Cyber insurance Securing remote work environments
Surgent's Improving Your Profits: Identifying Cost Cutting Opportunities
-
Virtual
2.00 Credits
What keeps companies from becoming streamlined? Behavioral biases Information processing biases Emotional biases How to deal with behavioral biases Connecting behavioral biases to cost cutting Creating a culture of cost cutting Rules of thumb for cost cutting Managing headcount Post-COVID common areas of excess cost Budgeting techniques Budget variances Benchmarking Common size financial statements Horizontal analysis Negotiation and contracting techniques Cash flow and the business cycle
Surgent's Public Speaking and Presentation Skills
-
Virtual
0.00 Credits
How experienced speakers manage presentation anxiety The elements of effective persuasion The three styles of speech Strategies to improve speech pace The importance of volume when presenting The art of the pause Methods for using visual aids Best practices for preparing for a presentation Components of an effective presentation
Surgent's Top Business Tax Planning Strategies
-
Virtual
2.00 Credits
Lower marginal tax rates made permanent New, more generous depreciation rules for bonus and Section 179 Qualified production property and bonus depreciation Full expensing of domestic research and experimental expenditures Rev. Proc. 2025-28 and options for small taxpayers Taking advantage of the QBI deduction Taking advantage of the SALT cap and the pass-through entity tax Form 1099 reporting changes Deducting business interest and business losses Taking advantage of the new Section 1202 tax regime
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: Introduction to Not-for-Profit Accounting
-
Online
2.00 Credits
Not-for-Profit Accounting Accounting & Auditing Yellowbook
ACPEN: Schedule K-1: What is it & What Do I Do with It?
-
Online
2.00 Credits
Overview of Schedule K-1 for Partnerships, S Corporations, and Estates/Trust Reporting Schedule K-1 information on Form 1040 Basis limitations, loss limitations, and material participation rules Qualified Business Income (QBI) Deduction and Schedule K-1 integration Case studies highlighting real-world application of Schedule K-1 reporting Proposed changes to Schedules K-2 and K-3 for 2021 and beyond Best practices for avoiding errors and ensuring compliance
Public Procurement Basics: Protecting the People's Money
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Guidelines and requirements that will help lead you to public procurement success.Guidance on how governments can meet complicated procurement needs.Best practices to protect public and Federal funds.
Surgent's Build an AI Agent With ChatGPT: A Hands-on Lab for Financial Professionals
-
Virtual
0.00 Credits
Agentic simulation using prompt design and structured interaction Flipped agent/user roles in ChatGPT (autonomy emulation) Use case walkthroughs: audit Q&A bot, tax helper, financial planning agent Risk scenarios: hallucinations, scope creep, prompt hacking Governance, professional skepticism, and documentation best practices
Using ChatGPT with Excel
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Introduction to ChatGPT and other AI (Artificial Intelligence) language modelsDiscussion of best practices for using ChatGPT with ExcelUse ChatGPT to create, debug and explain formulasUse ChatGPT to learn how to use Excel featuresUse ChatGPT to automate repetitive tasks in ExcelUse ChatGPT to easily create macros
ACPEN: Businesses Receiving Government Assistance
-
Online
2.00 Credits
What is Yellow Book? What is different because of Yellow Book? When might Yellow Book apply to a business? Common application of concepts to businesses Answers to common questions
Business Tax Update: OBBA and Recent Developments
-
Virtual
2.00 Credits
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
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: Mastering Communication Skills for the CPA
-
Online
2.00 Credits
Pervasive best practices for effective communication Specific strategies for written materials Unique considerations for verbal presentations The importance of recursive revision Tips for success Pitfalls to avoid
ACPEN: Introduction to Yellow Book
-
Online
2.00 Credits
AICPA Code of Professional Conduct Accounting & Auditing Yellowbook
2026/27 Yellow Book Update
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Significant changes related to quality management and updates affecting key audit roles, with an emphasis on how these revisions impact audit planning and execution.The GAO's implementation delay and its implications for 2026 audit planning.Recent leadership changes at the U.S. Government Accountability Office and what those transitions may signal for future guidance and oversight priorities.Overview of recent updates to the Green Book, helping auditors understand changes to internal control guidance that may affect governmental entities and Single Audit engagements.
