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.
AI 101 for CPAs: Core Concepts and Practical Applications
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:ABCs of how generative AI tools such as ChatGPT, Microsoft Copilot, and Google Gemini workWhat inherent risks are associated with this powerful technologyActionable steps you can take to mitigate the risksPractical examples of how AI can be applied in accounting, auditing, tax, and finance services
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
ACPEN: S Corporations: How to Calculate Shareholder Basis
-
Online
2.00 Credits
Discuss the calculation of basis when the entity is formed including the impact of contributed property Explain the importance of shareholder loans to the entity Uses a comprehensive example to illustrate the mechanics of the basis determination process Discuss how basis is impacted by distributions of corporation property and sale/or liquidation of the S corporation interest Explain how S corporation losses impact Form 1040 Schedule E reporting Show how to get from the Schedule K-1 information to the basis calculations
ACPEN: What's Going on at the AICPA (2026/27)
-
Online
2.00 Credits
AICPA audit and attestation developments Next phase of quality management Monitoring and remediation responsibilities SSAE No. 24 and SSARS No. 26 updates Exposure drafts on confirmations and fraud SAS No. 149 and group audit implications
Surgent's Capital Assets: Basis and Taxation for Financial Professionals
-
Virtual
2.00 Credits
Capital asset classification and basis determination Realization vs. recognition rules and special scenarios Disallowed losses and related limitations Types of capital gains and losses and their tax treatment Netting capital gains and losses Calculating taxes on ordinary income and capital gains Marginal vs. effective tax rates Tax planning strategies for capital assets
ACPEN: K2’s Data Analytics For Accountants And Auditors
-
Online
4.00 Credits
Understanding the importance of data analytics in modern business environments Generating and interpreting data analytics using everyday applications such as Microsoft Excel and Microsoft's Power BI platform Using regression analysis to create and validate forecasts and projections
Leveraging ChatGPT for Innovative Business Advisory Services
-
Virtual
2.00 Credits
The major topics covered in this course include:Introduction to ChatGPT and its applications in the business advisory contextIn-depth exploration of enterprise evaluation methodologies like SWOT, PESTLE, BCG Matrix, McKinsey 7S Model, Ansoff Matrix, etc.Practical case studies demonstrating application of ChatGPT in accounting business analysisKey challenges faced by accounting firms and how ChatGPT can help overcome theseBest practices for implementing AI tools in the accounting sectorFuture opportunities and trends in AI-enhanced business advisory services
ACPEN: Real Estate Professionals: Passive Activity, Sec. 199A and Investment Income Tax
-
Online
2.00 Credits
Definition, pros and cons of being a real estate professional Integration of the real estate professional rules with reporting on Form 1040, Schedule E Real estate professionals and indirectly owned (partnerships, S corporations) entity’s reporting on Form 1040 How ""real estate business"" is interpreted under the Section 199A rules and how it integrates with the passive activity rules Real estate professionals and the Form 8582 (Passive Activities) How to make the ""grouping"" election for passive activities and the flow-through deduction
Hot Topics Audit & Attest Update - 2026
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The major topics that will be covered in this course include:Recent quality improvements to the SASs and SSARsOther matters that should be on your radar
Surgent's Foundations of Cybersecurity for Financial Professionals
-
Virtual
0.00 Credits
Financial professionals’ roles in cybersecurity risk management Foundational terminology and principles (e.g., risk management, threat actors) Real-world case studies of cybersecurity strategies in financial settings Integrating cybersecurity into financial reporting and compliance Understanding the dynamic cybersecurity threat environment
ACPEN: K2’s Best Word, Outlook, And PowerPoint Features
-
Online
4.00 Credits
Creating Word and PowerPoint documents with greater ease and efficiency Enabling critical Outlook options for improved productivity Best practices for working with Word, Outlook, and PowerPoint
Become a Data Analysis Expert
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Data Analysis Process Flow: An introduction to the Data Analysis Process Flow and how it is your pathway to becoming a Data Analysis Expert.Data Modeling: A comprehensive discussion of building a data model and calculating metrics.Data Visualizations: An understanding how visualizations can present data in a more insightful and impactful manner.
ACPEN: The Value of Conflict
-
Online
1.00 Credits
Conflict resolution
ACPEN: Accounting for Construction Contractors
-
Online
2.00 Credits
Overview of FASB ASC 910 AICPA guidance for construction contractors Industry specific accounting considerations Revenue recognition methods Percentage of completion method Completed contract method Contract modifications Contract costs and allocation Complex accounting issues in construction
Accounting & Attestation for ESG
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Current ESG-related initiatives and projects underway at the Financial Accounting Standards Board, Governmental Accounting Standards Board, and the AICPA. Types of services CPAs may provide in connection with ESG reporting, including advisory and attestation engagements.
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: Corporate Ethics Cases: Discuss Real Life Conflicts
-
Online
4.00 Credits
Can you protect the public interest without violating our profession's confidentiality rules? How can a corporate world CPA get in trouble with their board of accountancy? Is a culture of fear and intimidation particularly susceptible to corporate fraud? How can using the CPA credential get a corporate accountant in trouble? Is exaggerating your CPE hours a violation of our professional codes of conduct? What are your options when your employer is clearly breaking the law? Does any legislation provide effective Whistleblower protection?
Retaining Top Talent: Strategies for CPA Firms
-
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: The true cost of turnover versus retention investment Research findings on why professionals leave or stay Whole-person retention strategies beyond compensation Work-life balance solutions that maintain productivity Career development paths for non-partner track professionals Business model transformations for sustainable staffing Technology and outsourcing strategies to reduce burnout Retention strategies specific to diverse talent and younger professionals
Surgent's Controller/CFO Update: Hot Topics Facing Today's Financial Professional
-
Virtual
4.00 Credits
Economic update Leadership and management changes because of recent developments, including AI Managing for productivity Hiring the best people for the organization New motivation techniques
