CPE Catalog & Events
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.
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.
2026/27 Annual Update for Accountants & Auditors
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Key accounting and auditing developments affecting accountants and auditors across industries.Recently issued and upcoming Accounting Standards Updates (ASUs), including standards effective for December 31, 2026 year-ends for public companies, private entities, and not-for-profit organizations.Recent and proposed standards affecting audit, attestation, and consulting engagements, including SSAE No. 24, SSARS No. 26, exposure drafts related to confirmations and fraud, and SAS No. 149 addressing group audits.
How SAS Nos. 134-145 Improve Risk-Based Audits
-
Virtual
4.00 Credits
The major topics that will be covered in this class 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 SAS Nos. 134-145
Professional Ethical Considerations for CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Core principles of any Code of Professional Conduct applicable to all CPAs, including conflicts of interest, preparing and reporting information, competence, confidential information, and moreThe importance of maintaining independence for CPAs in public practice, especially when also performing nonattest services for the attest client Comparing and contrasting various ethical standards, including those promulgated by the AICPA, PCAOB, and international bodies
Using ChatGPT with Excel
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Introduction to ChatGPT and other AI (Artificial Intelligence) language modelsDiscussion of best practices for using ChatGPT with ExcelUse ChatGPT to create, debug and explain formulasUse ChatGPT to learn how to use Excel featuresUse ChatGPT to automate repetitive tasks in ExcelUse ChatGPT to easily create macros
ACPEN: Two Types of Goals You Need to Be Successful
-
Online
1.00 Credits
Common obstacles to goal achievement The limitations of SMART goals Characteristics of effective outcome goals Process Goals: The Roadmap to Achievement Integrating Outcome and Process Goals for Maximum Impact
Fraud Busters: Controls to Prevent & Detect Fraud
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Fraud motivators - the fraud triangle, typical profiles of fraud perpetratorsRevisiting the basics of controls - design vs effectiveness, preventative vs. detectiveEntity-wide controls and how they can assist in fraud deterrenceSpecific fraud types and the controls that could prevent and detect them
ChatGPT and Advanced Accounting Research
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The accounting research transformation: Comparing Google vs. AI methodologiesAI ecosystems and specialized models for accounting applicationsAdvanced prompt engineering techniques for financial and tax researchAI-powered search engines and deep research platforms for accounting professionals AI as an ideation and thinking partner for complex accounting problems Specialized accounting research tools and AI superstoresPersona priming and P&P stacking methodologies for optimal AI interactionsEthical considerations and limitations of AI in accounting researchThe compliance chess effect: AI's impact on tax planning and regulatory responseAI-driven automation for regulatory updates and compliance monitoring
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
ACPEN: Audit Risk Assessment in Plain English
-
Online
2.00 Credits
Overview of Audit Risk Assessment AICPA's clarified Risk Assessment Standards SAS 145 Assessing the Entity's Environment
ACPEN: Prevention & Detection of Fraud in Small Businesses
-
Online
5.00 Credits
Small Business Fraud Fraud Schemes Fraud Indicators Fraud Detection Fraud Response Fraud Prevention
Adobe Acrobat Tips for Working with PDF Files
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Review of all that Adobe Acrobat has to offerOrganizing your PDFs with bookmarks, links, file attachments and moreFormatting the presentation of PDFs with headers, footers and watermarksCreating and processing fillable formsProcessing documents for e-signatureTips for converting email messages, documents and spreadsheets into PDF formatCombining multiple PDF files into a single binder Utilizing the security features of Adobe Acrobat to protect document confidentiality
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.
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
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
ACPEN: Taxation of the Cannabis Industry
-
Online
2.00 Credits
Historical context of U.S. taxation Industrial hemp vs. marijuana Income definitions under I.R.C. §61 Tax code restrictions: §280E and §471 State-specific marijuana laws Cash management in cannabis businesses Federal court case analysis
ACPEN: K2's Productivity Life Hacks
-
Online
2.00 Credits
Using a Streamdeck for push button integration and automation Using tools such as Clockify or Rescue Time to gain insight on Easily install applications using Ninite on your Windows 10/11 device Improve data sharing between applications with Zapier, Power Automate, and others Connecting to multiple communication applications (e.g., Teams, Slack, etc.) at once with Rambox Using inbox rules and filters to automatically categorize and prioritize email
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
Critical Thinking and Skepticism in AI-Augmented CPA Work
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Professional skepticism and existing CPA standardsSix traits of the skeptical professional mindAutomation bias and other AI-related cognitive biasesEvidence and verification rules for AI outputsPractical questioning and challenge techniquesVendor claims, benchmarks, and AI due diligenceReview, documentation, accountability, and skeptical firm culture
