CPE Catalog & Events
Advanced Excel for Staff - Build Reports and Analyze Data
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Building Reports Workflow: Understand the steps for creating professional and functional reports.Gather and Organize Data: Learn best practices for compiling and cleaning data for accurate analysis.Set Calculations and Key Metrics: Apply formulas and functions to calculate meaningful insights. Format and Structure Report: Use formatting tools to create visually appealing and structured reports.Review and Validate: Verify data accuracy and troubleshoot potential errors.Share the Report: Learn methods for distributing reports effectively within your organization.
2026/27 Not-for-Profit GAAP Update
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline.The International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025.
ACPEN: K2’s Data Security And Privacy Issues And Solutions
-
Online
2.00 Credits
Understanding the differences between data security and data privacy The major types of security and privacy breaches Key steps you can take to mitigate your risks of becoming another victim
ACPEN: The Preparation of Form 709 – Line-by-Line
-
Online
2.00 Credits
Gift tax fundamentals and exclusions Completing Form 709 accurately Gift-splitting and its tax implications Lifetime exemption and GSTT considerations Valuation of gifted assets Common filing mistakes and IRS audits Updates on new legislation impacting gift taxation
Surgent's Ensure Your Accounting Team Is Operating at Peak Performance Through Engagement and Motivation
-
Virtual
1.00 Credits
Increase productivity and profitability Communicate better and resolve conflict Learn teamwork principles in today's changing accounting workplace Motivate yourself and your team
Business Transformation: Critical Skills for CFOs and Controllers
-
Virtual
4.00 Credits
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
