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.
ACPEN: Audit Blind Spots in Modern Cloud: Risks Audits Keep Missing
-
Online
1.00 Credits
Cloud Audit Blindspots Continuous Change Gaps CSPM-Enabled Assurance Risk-Based Prioritization Audit Program Modernization
ACPEN: Ethical Leadership: Guiding Principles When Others Falter
-
Online
2.00 Credits
Understanding yourself and others in the workplace How emotion plays a vital role in ethical dilemmas and in solutions What are some of the various outlooks on ethics? Recognizing lies Managing ethics towards solutions
ACPEN: Independence Requirements for Auditors
-
Online
2.00 Credits
AICPA Code of Professional Conduct independence requirements Core independence principles for CPAs in public practice Common independence risk areas PEEC ethics interpretations affecting independence Real-world application of independence guidance Practical compliance and implementation strategies Independence considerations in attest engagements
Surgent's A Guide to Nonqualified Deferred Compensation
-
Virtual
2.00 Credits
The basics of nonqualified deferred compensation (NQDC) NQDC compliance Taxation of NQDC plans Types of NQDC plans Financing/funding NQDC plans Planning strategies
Surgent's Reducing a Business Owner Client’s Exposure to Social Security and Self-Employment Taxes
-
Virtual
2.00 Credits
Section 1402(a)(1) exclusions from the definition of self-employment income Application of the SE tax to members of limited liability companies Taking a self-employed owner's health insurance deductions against self-employment tax How using the S corporation and the MMLLC treated as a partnership can help reduce an individual's exposure to self-employment tax How hiring a spouse and/or child helps reduce self-employment tax Differentiating between income treated as self- employment income and income that is not self-employment income
ACPEN: IRAs – Contributions & Distributions for Traditional, Roth, SEP & SIMPLE IRAs
-
Online
8.00 Credits
An emphasis on newly enacted tax legislation affecting IRAs including the NEW final required minimum distribution (RMD) regulations Contribution limits to and tax treatment of distributions from Traditional, Roth, SEP and SIMPLE IRAs Deductible phase-out limits for Traditional IRA contributions for taxpayers that are active participants in qualified retirement plans Roth IRA contribution phase-out limits as well as tax-free qualified distributions Planning opportunities for conversions to ROTH IRAs Rollover rules to/from different retirement accounts and the one-rollover-per-year limitation The different options of receiving IRA distributions before age 59 ½ and avoiding the 10% early distribution penalty (including substantially equal periodic payments) The required minimum distribution (RMD) rules from IRAs needed to avoid the 50% penalty after the account owner turns age 72 or dies The tax ramifications of spouse and non-spouse beneficiaries and how this affects the RMD calculation after the account owner’s death Overview of health savings account (HSA) eligibility rules, contribution limits and distribution rules
Untying the Knot: Taxes & Divorce
-
Virtual
8.00 Credits
The major topics that will be covered in this course include:Filing Status: Determining the correct filing status during and after divorce.Qualified Domestic Relations Orders (QDROs): Tax implications of dividing retirement accounts.Back Taxes: Strategies for addressing unpaid tax liabilities during and after divorce.Offers-in-Compromise & Installment Agreements: Resolving tax debts with the IRS.Currently-Not-Collectible Status: Understanding when and how to use this option.Innocent Spouse & Injured Spouse Relief: Protecting clients from unfair tax liabilities.Lien Discharges & Subordinations: Managing IRS liens on property during divorce.Reasonable Compensation: Evaluating fair compensation in divorce-related business valuations.Case Studies: Explore unusual and complex tax issues in divorce through real-world examples.
How to Audit Cash
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Auditing CashAudit assertions, risks, and threats to the cash balanceAuditing procedures to perform
Surgent's Adapting to Today’s Changing Accounting Landscape
-
Virtual
1.00 Credits
Evolving accounting landscape Data complexity in accounting and tax Value-added billing Artificial Intelligence Shifting client expectations Navigating regulatory uncertainty The impact of accountants on society Embracing change and innovation Pipeline challenges
AI Prompt Engineering Masterclass for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Prompt Engineering: Basics of structuring effective prompts for meaningful AI responses.Understanding AI's "Lazy" Defaults: Why LLMs provide basic answers and how to push them to deliver richer insights.Multi-Layered Prompting: Techniques to encourage AI to provide responses across beginner to expert levels.Candid and Contrarian Responses: Using prompts that elicit honest and balanced insights, even on controversial topics.Ripple Effect and Cobra Effect: Probing the broader impacts and unintended consequences of financial decisions.Avoid Stupidity Checklist: A practical prompt for reducing mistakes in AI-assisted accounting tasks.Role-Based Perspective Prompts: Crafting prompts that guide AI to respond from specific professional viewpoints.Automation Ideas: Leveraging AI to optimize repetitive accounting tasks.Emotion-Driven Prompting: Exploring how emotion-focused prompts can enhance AI performance and engagement.Practical Applications in Accounting: How to apply prompt engineering in real-world financial analysis and decision-making.
CFO Series: Advanced Financial Analysis: Use the Right Tools
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Advanced financial analysis and modeling toolsProper modeling of long-term decisionsBest practices in project analysis Alternative evaluation methodsWhy should you consider multiple metrics?Capital rationing Choosing the correct discount factorYear-end convention and other less understood assumptionsSensitivity and scenario analysisMonte Carlo Simulation in practiceInterpreting results properlyNPV vs IRR vs MIRR vs ROI.Considerations when metrics contradict other metricsReal options are hard to value but are invaluableBehavioral issuesEvaluating projects with no obvious returnMultiple numeric examples and work sheets
ACPEN: Basis Calculations & Distributions for Pass-Thru Entity Owners Schedule K-1 Analysis
-
Online
8.00 Credits
Detailed coverage of any new legislation affecting basis computations and distributions and changes to the schedule K-1s (including the NEW Form 7203 – S Corporation Shareholder Stock and Debt Basis Limitations) Line-by-line analysis of the Schedule K-1s to determine how the items affect a S shareholder’s stock and debt basis and a partner/member’s outside basis and where the items get reported on Federal individual income tax return The three loss and deduction limitations on the owner’s individual income tax return (i.e. basis, at-risk and other Form 1040 limitations) How cash or non-cash distributions affect the basis calculations and whether or not they are taxable to the owners Compare the tax treatment of the sale of a shareholder’s stock in a S corporation and a partner’s interest in a partnership What constitutes debt basis for a S corporation shareholder under the final regulations The tax ramifications of repaying loans to S corporation shareholders and on open account debt How recourse and non-recourse debt effect a partner or member’s basis calculations and amount at-risk
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: Revenue Recognition - Topic 606 Overview
-
Online
1.80 Credits
Revenue Recognition on Contracts with customers
ACPEN: How to Develop Your System of Quality Management Using the AICPA Practice Aids
-
Online
3.00 Credits
Overview of Quality Management standards Scope of SQMS 1 Components of quality management Changes from prior standards AICPA practice aids Required documentation Risk assessment process Final documentation development
ACPEN: K2’s Implementing Internal Controls In QuickBooks Online Environments
-
Online
4.00 Credits
Critical risks in QBO environments Internal control options that can mitigate risk to prudently acceptable levels Enabling alternative control measures to improve internal controls in QuickBooks environments
ACPEN: Form 1040 Individual Income Tax Prep
-
Online
8.00 Credits
Overview of Form 1040 and filing requirements Filing status and dependent rules Income reporting, including wages, interest, and dividends Adjustments to income Standard vs itemized deductions Common individual tax credits Introduction to Schedule C and Schedule E Preparer responsibilities, due diligence, and Circular 230
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
CPA to CFO: Essential Competencies for Finance Leaders
-
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: Top competencies hiring executives seek in CFO candidates based on survey of 320+ CEOs and recruiters Critical thinking frameworks and strategy creation techniques for financial leadership Forward-looking financial skills including capital management, forecasting, and funding strategies Industry-specific requirements for high-growth companies and nonprofit organizations Practical career development strategies to build CFO-ready competencies
