CPE Catalog & Events
ACPEN: Inventory Observation - Cretaceous Conservatory Simulation
-
Online
3.00 Credits
Obsservation Auditing
Surgent's Accountability and Action
-
Virtual
0.00 Credits
Defining three critical elements: responsibility, empowerment and accountability, and how they work together to create results Designing and using clear agreements that provide clarity Skills for holding yourself and others accountable for results, no matter what Knowing where you are in the accountability game... what you do/don’t do well
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.
Leverage PowerBI.com to Create Data Analysis for Others
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Tour of the PowerBI.com Interface: An in-depth walkthrough of the PowerBI.com environment, focusing on user interface elements, navigation, and customization.PowerBI.com Concepts: Fundamental concepts of PowerBI.com, including its architecture, data handling capabilities, and integration features.Connecting to Data: Techniques for connecting various data sources to PowerBI.com, ensuring seamless data integration and synchronization.Visualizations and Dashboards: Creating impactful visualizations and assembling informative dashboards to present data compellingly.Q&A Feature: Explore the interactive Q&A feature to derive insights through natural language queries.Sharing Datasets, Reports, Dashboards: Best practices for sharing datasets, reports, and dashboards with different audiences so they can leverage your data analysis work.Creating Apps: Learn how to package reports and dashboards into apps for easy distribution and consumption.
ACPEN: SECURE Act 2.0: What You Need to Know
-
Online
1.00 Credits
Expanding Automatic Enrollment in Retirement Plans Increased Age for RMDs Higher Catch-up Contribution Limit Emergency Expense Penalty-Free Withdrawals “Starter” 401(k)s for Certain Employers Part-time Worker Improved Coverage
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 Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Virtual
0.00 Credits
Automation capabilities of Excel The “Get & Transform” Tool Using “Get & Transform” for flattening, splitting and combining data, unpivoting summarized data, and combining CSV exports
AI & Accounting in Manufacturing
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Intelligent automation and dark factoriesPredictive maintenance and real-time cost trackingAI-enabled financial reporting and dashboardsContinuous auditing and anomaly detectionTax compliance automation and transfer pricing AIData governance and cybersecurity in financial systemsWorkforce reskilling and AI-augmented financial roles
Surgent's Purchase and Sale of a Residence: Critical Tax Issues
-
Virtual
2.00 Credits
General rules relating to the sale of a residence under § 121 Sale of a taxpayer’s main home Qualifying for a partial exclusion of gain on the sale of a home How a taxpayer meets the residence requirement Meeting the look-back requirement Separated, divorced, and widowed taxpayers Work-related moves and unforeseeable events Inherited homes and homes received in a divorce Impact of business or rental use of home on the gain exclusion Reporting gain or loss on the sale of a home
ACPEN: The Preparation of Form 706 - Line-by-Line
-
Online
3.00 Credits
Overview of Form 706 and estate tax fundamentals Gross estate valuation and inclusion rules Deductions, credits, and tax computation Portability election and its implications Filing deadlines and procedural requirements Common issues and IRS audit triggers Legislative changes affecting estate taxation
Surgent's Ethical Considerations for the CPA
-
Virtual
0.00 Credits
Examine the CPA's role in today's economy Compare similarities and differences between individual and business ethics Explore the link between ethics, integrity and scruples Discuss the basic attributes of ethics and professional conduct Review the history of the CPA profession and the CPA's requirement to adhere to ethics policies and codes of conduct Review the AICPA's Code of Professional Conduct and a CPA's responsibilities to the public, clients and colleagues Discuss the common rules and statutes faced daily in the CPA profession. Case studies may also be utilized to present potential ethical dilemmas CPAs may face during their careers Review CPA Independence violations by current legal case examples
Mastering Partnership Basis: Inside and Outside Basis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Explain the use of both "inside" and "outside” basis determination.How to calculate tax basis capital accounts, including when the entity is formed, including the impact of contributed property.Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis.Explanation of how basis is impacted distributions and by sale and/or liquidation of the partnership interest.Comprehensive example to illustrate the mechanics of the basis determination process.
ACPEN: The Controllership Series - The Controllers Role in Financial Forecasting
-
Online
1.50 Credits
Accounting Finance
ACPEN: Develop Your Emotional Intelligence to Be More Successful in Life and Leadership
-
Online
2.00 Credits
Emotional Intelligence (EQ) in Leadership Building Stronger Workplace Relationships Creating and Leading High-Performing Teams Navigating Change with Emotional Intelligence
Common Financial Statement Disclosures
-
Virtual
2.00 Credits
The major topics covered in this class include:General disclosures about the entity and its environmentCommon critical information useful to financial statement readers for making economic decisionsExplain results of operations through information that supplements the face financial statements
Excel for Accounting Professionals Session 4: Conditional Summing and Lookups
-
Virtual
2.00 Credits
Excel shortcuts Conditional summing Removing duplicate values VLOOKUP function
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: Assessing the Real Ethics of an Organization?, featuring Joe Oringel, MBA, CPA, CIA and Don Minges, MBA
-
Online
1.00 Credits
What are the signs of an ethical versus unethical organization? The need for clear policies Policies should be detailed, clear and unambiguous The importance of ‘doing the right thing when no one else is looking’ How exceptions offer opportunities to the unethical Should exceptions be allowed?
ACPEN: Listening to the Statement of Cash Flows
-
Online
2.00 Credits
Preparation of the statement of cash flows Importance of identifying sources and uses of cash in financial reporting Financial statement analysis Cash-related financial statement disclosures
Analyzing Financial Statements
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Balance sheet analysisIncome statement analysisCash flow statement analysisClues in the notes and MD&AIndustry nuances
