CPE Catalog & Events
The 10 Must Know Excel Features
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.
Tax Implications of Retirement Plan Distributions
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Required minimum distributions for a deceased’s heirs2025 retirement plan contribution limitsRequired minimum distributions and contributions to charityKey provisions of Secure Act 2.0
ACPEN: Thinking Like an Auditor When Preparing Your Financial Statements
-
Online
2.00 Credits
Determining an appropriate sense of quantitative and qualitative materiality Identifying the critical components of the financial statements that matter most to financial statement users Evaluating where the financial statements are most likely to contain material fraud and error, and ensuring adequate internal control and monitoring to mitigate those risks
Tax Depreciation: Review and Update
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Recent tax legislation and developments related to capitalizationEligible property for Section 179 and Section 168(k)Discussion of the Section 179 deduction and its use to depreciate real propertyThe Section 168(k) deduction and its use to depreciate real propertyDisposition of segments of real propertyExchanges of tangible personal property after repeal of the like-kind exchange rulesOther related topics
ACPEN: Financial Statement Analysis
-
Online
4.00 Credits
Purposes of financial statement analysis Trend analysis and vertical & horizontal analysis Simple and multivariate regression; Analysis of metrics Assessment of liquidity, solvency, and profitability Using data visualizations The role of qualitative factors
ACPEN: Maximizing Fringe Benefits: Strategies for Business and Personal Needs for Today and Beyond
-
Online
8.00 Credits
Legislative and regulatory updates affecting fringe benefit planning Employer-sponsored fringe benefits and tax compliance under evolving regulations IRC §132 fringe benefit options and applications Cafeteria plans: benefits, limitations, and tax considerations Tax treatment of dependent care and educational assistance programs Flexible spending accounts and health savings accounts Group term life insurance: design features and tax treatment Financing strategies for retiree medical benefits Comparing health care benefits: insured plans vs. HMOs ERISA reporting and disclosure requirements Common control rules and nondiscrimination regulations
How to Audit Inventory
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Auditing Inventory.Related Audit assertions, risks, and threats to inventory.Substantive auditing procedures that staff should perform.
ACPEN: K2's Ten Questions To Ask Your IT Team
-
Online
1.00 Credits
Ten Strategic Question Frameworks for Technology Assessment Cybersecurity and Infrastructure Oversight Through Targeted Dialogue Cloud Governance and Remote Work Technology Evaluation
AICPA's New SSTS #4 - New Ethics Standard for Tax Resolution
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:This session will provide a comprehensive overview of the ethical guidelines outlined in Circular 230 and the newly updated Statements on Standards for Tax Services (SSTS) #4. Gain insights into how these standards apply to real-world tax resolution scenarios, ensuring compliance and integrity in your practice.
Becoming a Fractional CFO: What to Do and How?
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Do you have what it takes to be a successful fractional CFO?Should you be a solo practitioner or join a larger firm? 1099 versus W2?What skills are needed to be successful?Sales, marketing, etc.What are some of the ‘red flags’?Typical assignments and issues a fractional CFO will likely encounterThe greatest opportunity for fractional CFOs?Understanding your value
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
ACPEN: Financial Statement Presentation and Disclosure
-
Online
4.00 Credits
U.S. GAAP and Special purpose frameworks Form and content of financial statements: Balance sheets Income statements; Statements of cash flows Retained earnings and/or owners’ equity statements Comprehensive income Supplementary information Comparative vs. single-period financial statements Sufficiency of disclosures Illustrative disclosures frequently encountered in small-to-medium reporting entities Industry-specific nuances
Enterprise-Wide Risk Management in Accounting and Finance
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Enterprise-wide risk management best practices for identifying, evaluating, and determining how to respond to relevant risks.The importance of risk and uncertainty disclosures in the preparation and fair presentation of financial statements, including evolving risks with cybersecurity and ESG.Coordinating risk management efforts, including the required involvement of corporate governance.How to embed risk management into day-to-day accounting and finance activities.
Workforce Transformation and Talent Management in 2025
-
Virtual
1.00 Credits
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: Understanding why the traditional pyramid structure is failing firms The inverted pentagon framework and its talent retention advantages Impact of technology and AI on entry-level accounting roles The 6 Ps of Business Model Transformation implementation Accelerating specialized skills acquisition in your workforce Effective knowledge transfer through mentorship and job rotation Technology-driven training and development strategies Best practices from other industries for workforce transformation Building and retaining specialized middle layers of expertise Strategic pricing models to support the pentagon structure
What's Behind the Data?
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Ways in which data and information can be misleadingCommon pitfalls when encountering dataHow to re-evaluate the data to avoid those pitfalls
ACPEN: Maximizing the Tax Benefits of an Installment Sale
-
Online
1.00 Credits
Installment sale treatment eligibility When to elect out of installment sale treatment Installment sales of business assets Installment sale default and the rules for personal property vs real property Depreciation recapture
ACPEN: Performance Auditing Made Easy
-
Online
1.50 Credits
Performance audit standards Performance audit types Performance audit objectives
ACPEN: The New Quality Management Standards - What Everyone Needs to Know
-
Online
2.00 Credits
Overview of the new quality management standards Focus on the most important elements of a quality management system Implementation tips that everyone in the firm should know Audit and attest standards impacted
ACPEN: Forgotten Managerial Accounting Tools
-
Online
2.00 Credits
Cost-volume-profit analysis, including target profit and break-even calculations Variable costing Relevant costs and decision-making Standard costs and variances Activity-based costing Segment reporting and analysis Capital budgeting considerations Overview of Excel capabilities for supporting managerial analysis
Surgent's Bankruptcy Basics: Understanding the Reorganization and Liquidation Process in These Uncertain Economic Times
-
Virtual
2.00 Credits
Commencement of a bankruptcy proceeding Protections provided to debtors under the Bankruptcy Code Key procedural aspects of bankruptcy The automatic stay Differences between Chapters 7, 11, and 13 bankruptcy cases The bankruptcy discharge Proofs of claim Plans of reorganization Litigation that can arise during bankruptcy Creditor committees Bankruptcy trustees Avoidable preferences and fraudulent transfers Special rights afforded to landlords and secured creditors
