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.
Internal Controls Over Compliance vs Compliance
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Testing internal ControlsAlign internal controls with specific compliance requirementsThe misidentification of controls and the confusion between compliance and control processes
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.
Surgent's Generative AI and Cybersecurity: Opportunities and Threats
-
Virtual
0.00 Credits
Generative AI applications in cybersecurity (e.g., threat detection, automation) AI-enabled cyber threats, including phishing, deepfakes, and malware Real-world incidents involving AI-related cybersecurity challenges Proactive strategies for leveraging generative AI in cybersecurity Regulatory and ethical implications of generative AI in financial cybersecurity
Yellow Book Ethics
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The concept of public interestEthics, independence, and professional judgmentCompetence and continuing professional educationQuality control and peer reviewProper use of government information, resources, and positionProfessional behavior
ACPEN: Benefits and Best Practices for Telework
-
Online
2.00 Credits
Communication Business Management
ACPEN: Financial Accounting for Related Party Transactions
-
Online
2.00 Credits
FASB codification provisions for transactions with related parties, including business owners and special purpose entities Compares and contrasts those rules with the AICPA financial reporting framework for small and medium-sized entities Reviews the tax accounting related taxpayer standards Several real-life situations illustrate the various authoritative standards and discuss the consequences of failing to comply with those standards
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.
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.
Surgent's Ethical Considerations for CPAs
-
Virtual
0.00 Credits
Auditor independence and its importance to the public accounting profession Common threats to auditor independence AICPA’s framework for assessing conflicts of interest Unique threats related to non-attest services to attest clients Common safeguards to help assure compliance with relevant rules and regulations
Microsoft Teams for CPAs: Unlocking Its Full Potential
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Best practices for organizing your teams and channelsUnderstanding the role of Teams and SharePoint integrationUsing Teams to communicate and collaborate externally with clientsTips and tricks for managing conversations in TeamsLeveraging Microsoft Copilot AI in Teams
ChatGPT for Accountants: 50+ Use Cases
-
Virtual
2.00 Credits
Major topics covered in this course include:Introduction to ChatGPT and artificial intelligence chatbot technologiesAutomating frequently asked questions and the onboarding processVerifying and reviewing financial recordsProviding real-time support to clientsGenerating financial reportsAutomating tax return preparation and financial planningProviding guidance on financial decision making
ACPEN: The Ethics of Artificial Intelligence ("AI"): The Interaction of AI and Ethics, featuring Tracy Cooper, CPA and Don Minges, MBA
-
Online
1.00 Credits
What are the ethical issues within AI? The many biases within AI Ownership? Intellectual property rights? Who benefits economically? Changing regulations and laws Why many organizations ban AI? How AI can be used unethically? The need for strong human oversight!
Overcoming Tech Adoption Challenges in 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: Five critical technology adoption challenges facing CPA firms today Digital maturity assessment models and implementation frameworks AI integration strategies for tax, audit, and advisory services Cybersecurity considerations and risk management protocols Case studies of successful technology transformations in accounting firms
LEARNING PATH: AI-Powered Accounting
-
Virtual
10.00 Credits
This learning path helps CPAs move from "AI curious" to AI capable by building practical skills across prompt engineering, core AI concepts, and real accounting use cases. You'll learn how AI fits into the profession, where it can improve efficiency and judgment, and how to apply tools like Copilot in Excel to real workflows. It's ideal if you want to stay relevant as automation expands-without getting lost in jargon-while still grounding the learning in accounting and audit realities.
LEARNING PATH: Audit and Risk Fundamentals
-
Virtual
10.00 Credits
If you want stronger audits with fewer surprises, this path is built around the core building blocks: risk assessment, internal controls, walkthroughs, and operating effectiveness testing. It reinforces how to identify what can go wrong, where controls fail, and how fraud risk often shows up in control gaps. CPAs take this path to sharpen planning, improve documentation quality, and make testing more meaningful—especially useful for audit seniors, managers, and internal auditors responsible for higher-risk engagements.
LEARNING PATH: Auditing Key Financial Statement Areas
-
Virtual
10.00 Credits
This path is designed for CPAs who want to strengthen execution in the areas that most often drive audit risk, adjustments, and review comments. It walks through practical approaches to auditing cash, inventory, estimates, payables/expenses, and PP&E, helping you improve testing choices, evidence quality, and professional judgment. Take this path if you want a tighter, more repeatable approach to auditing the "big buckets" that can make or break engagement quality.
LEARNING PATH: CPA to CFO Leadership
-
Virtual
10.00 Credits
This path helps CPAs expand from technical expertise to executive finance leadership-the mindset shift needed for controller, finance director, and CFO tracks. It blends strategic competencies (ratios, budgeting/forecasting thinking, behavioral finance) with real-world leadership topics like supplier relationships and what it takes to operate as a fractional CFO. CPAs should take this path to strengthen advisory value, communicate like a finance leader, and make more confident decisions that go beyond compliance.
LEARNING PATH: Combatting Fraud
-
Virtual
10.00 Credits
Fraud risk is evolving, and this path gives CPAs a balanced toolkit across prevention, detection, and response-without making it purely theoretical. You'll explore control-based prevention ("Fraud Busters"), external fraud countermeasures, and higher-risk topics like money laundering, plus practical considerations tied to modern work patterns (like the gig economy). CPAs should take this path to better protect clients and organizations, improve skepticism, and recognize red flags early-before losses compound.
LEARNING PATH: Ethics and Professional Responsibility
-
Virtual
10.00 Credits
This path reinforces the ethical backbone of the profession by covering real scenarios CPAs face: technology-driven dilemmas, malpractice risk, fraud/embezzlement case studies, and professional ethical considerations. It's built to strengthen decision-making, professional skepticism, and risk awareness-especially helpful for CPAs renewing licenses and firm leaders setting the tone at the top. Take this path if you want ethics training that feels practical and job-relevant, not checkbox-only.
