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
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
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.
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
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
ChatGPT Vision for Financial Analysis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to GPT Vision - Understanding the fundamentals of GPT Vision and its capabilities.Advantages of Vision Mode Research - Exploring the unique benefits of visual data analysis over traditional methods.Accessing GPT Vision - Guidance on how to access and utilize GPT Vision capabilities.Financial Screenshot Analysis - Techniques for analyzing financial documents and reports through screenshots.Operational Insights from Visual Data - Using images to gain insights into operational processes and asset management.Integration with Google Maps - Learning how to combine ChatGPT's vision capabilities with mapping technologies for enhanced spatial analysis.DDPP Analysis - Applying descriptive, diagnostic, predictive, and prescriptive analysis to visual data.Sentiment and Facial Expression Analysis - Techniques for interpreting emotions and sentiments in images to gauge client and employee feedback.Body Language Interpretation - Analyzing body language in images to understand non-verbal cues in business contexts.Effective Photo Capturing Techniques - Best practices for taking photos that provide optimal insights for financial analysis.
Smarter Tax Services with Artificial Intelligence (AI) Tools
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of AI technology and how it worksIdentify where AI can be incorporated into tax research, planning, and compliance servicesDiscover new opportunities to enhance your client advisory tax services with AI toolsReview the market of emerging and AI enhanced tax software toolsLearn about the newest generation of AI enable 1040 source document collection and organizer applicationsReview specific use cases for generative AI tools (e.g. ChatGPT, Microsoft Copilot) in your tax services
The Current and Future Landscape of Audit Technology
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Explore the transformative impact of technology on the audit profession in this forward-looking courseGain practical insights into cutting-edge tools and trends, including data analytics, artificial intelligence (AI), and automationNavigate the evolving audit landscape with confidence and adaptability
Corporate Finance Technology Selection: Practical Frameworks
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:The changing finance technology landscape: continuous processing, modular ecosystems, automated controls, and real-time visibility (and the risks these shifts introduce)Technology trends and “AI” definitions: automation vs. machine learning vs. generative AI vs. agentic AI—what each means for governance and auditabilityFive common challenges in finance tech projects and how to address them:Cutting through vendor claims and AI hypeIntegration complexity and hidden costsChange management and proving ROIData quality readiness for AI and automationRisk, security, and governanceVendor Evaluation Scorecard: 20 criteria across five categories, including control “deal-breakers” (audit trails, segregation of duties, logging, SOC reporting, error handling)Five-Year Total Cost Framework: software, implementation, data migration/cleanup, integration build & maintenance, internal costs, training, and ongoing operations (plus common underestimates)Industry-specific considerations (manufacturing, distribution/wholesale, SaaS/tech, professional services)Four-phase implementation roadmap with checkpoints and red flags: Assessment & Planning; Selection & Negotiation; Implementation & Testing; Optimization & Ongoing GovernanceWorking with external advisers (CPA/auditor involvement, implementation partner expectations, and common deficiencies to avoid)
ChatGPT Deep-Dive Hands-on Bootcamp for CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Getting started with ChatGPTTour of the ChatGPT app and how to use itVariety of hands-on case study examples for accounting, finance, and taxProtecting your data privacy in ChatGPTAdvanced ChatGPT features reviewSubscription plan options
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
How Recent Auditing Standards Improve Risk-Based Audits
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Key changes to audit report elements intended to improve the understandability of the nature and results of financial statement auditsEnhanced required by-product communications with management and those charged with governance to promote more reliable financial statementsClarifications related to obtaining sufficient and appropriate audit evidence, including significant unusual transactions, related parties, going concern uncertainty, and accounting estimatesNew definitions and requirements related to identifying and evaluating risks of material misstatementOther important matters contained in recent SASs
Hot Topics Accounting Update - 2026
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:New accounting standards.The impact on Financial Reporting.Hot topics in financial reporting.Current and emerging US GAAP requirements.
Comprehensive Accounting and Financial Reporting Update
-
Virtual
4.00 Credits
The major topics covered in this class include:CECL for nonfinancial institutions.Accounting for Paycheck Protection Program loans.Accounting for web-hosting services.Revenue recognition.Leases.FASB projects in progress.
Ethics, AI, and Music: What Every CPA Must Know
-
Virtual
1.00 Credits
The major topics that will be covered in this course include: Four key aspects of artificial intelligence that are relevant to CPAs: machine learning, generative AI, large language models, and GPT.The role that five powerful principles—the principles of ethical intelligence—play in using AI the right way. Short, focused writing exercises (30 seconds each) designed to deepen understanding of the topic. Real-world case studies about the use of AI in music as well as accountingAnswers to several crucial questions about how to use artificial intelligence with ethical intelligence.
Introduction to Risk Assessment
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of the risk assessment procedures performed during engagements.Inquiries, analytical procedures, and observation and inspection techniques. Understanding how risk assessment drives engagement planning and supports the development of appropriate audit responses.