CPE Catalog & Events
The 10 Must Know Excel Features
-
Online
2.00 Credits
Member Price: $89
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.
ChatGPT and IRS Taxation Law Research
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Utilizing ChatGPT for IRS Tax Law Research: Principles and PracticesNavigating IRS Databases Using Advanced AI TechniquesUsing IRS Prompt Templates: In-depth Analysis and ApplicationChatGPT in Action: Case Studies and Real-World ScenariosExploring IRS Tax Laws: Strategies, Loopholes, and ComplianceError Prevention and Correction in Tax Law ResearchFuture Trends: AI's Evolving Role in Taxation and Accounting
How AI Fits into the Accounting World
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:An overview of AI constructs.How artificial intelligence is being used by accountants today.Accounting-centric AI developments on the horizon.
Tax Implications of Retirement Plan Distributions
-
Online
1.00 Credits
Member Price: $55
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
Written Information Security Plans
-
Online
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Introduction to the Gramm-Leach-Bliley Act and its impact on data security.Circular 230 compliance and due diligence for practitioners.AICPA Statements of Standards relevant to WISP requirements.Key components of a Written Information Security Plan.Training requirements for employees, staff, and contractors.Practical guidance for drafting and implementing a WISP.FTC enforcement of data security standards for PTIN holders.Best practices for maintaining and updating WISP compliance.
Accounting for and Auditing Cryptocurrency & Digital Assets
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Common applications related to initial recognition and measurement, subsequent measurement or derecognition, presentation, and disclosure of cryptocurrency and other digital assetsFeedback from the AICPA's Digital Assets Working Group intended to assist auditors with opining on these digital records
The One Big Beautiful Bill: 2025 tax legislation
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:The Congressional process in passing tax legislation. Major Tax Provisions in the House version of Big Beautiful Bill Individual General Business International Health Care Accounts Qualified Opportunity Zones Industry Specific Provisions Tax Exempt Organizations Miscellaneous Provisions
Mastering Partnership Basis: Inside and Outside Basis
-
Online
2.00 Credits
Member Price: $89
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.
What You Can Learn From the Statement of Cash Flows
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this course include:Preparation of the statement of cash flowsImportance of identifying sources and uses of cash in financial reportingFinancial statement analysisCash-related financial statement disclosures
How Fraud Can Affect Smaller Organizations
-
Online
4.00 Credits
Member Price: $149
The major topics included in this course include:The reasons for fraudFraudulent acts that are initiated against smaller organizationsMethods to stop fraud attempts against small businesses
Adobe Acrobat Tips for Working with PDF Files
-
Online
2.00 Credits
Member Price: $89
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
Navigating IRS Correspondence: Responding to IRS Letters
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Types of IRS letters: General notices, audits, collections, return requests, and errors.Deadlines for responding to IRS correspondence.Communication best practices for dealing with the IRS.Avoiding escalation and penalties through proactive responses.Ensuring compliance when addressing IRS correspondence.Real-world examples of successful IRS communications.Common pitfalls in handling IRS letters and how to avoid them.Strategies for advising clients on IRS correspondence.
The Ethic of Self-Esteem For Women
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Self-Esteem: What is it?Belief systemsBenefits of High Self EsteemMinimizing traps of low Self EsteemComponents of High Self Esteem
AI Prompt Engineering Masterclass for Accountants
-
Online
2.00 Credits
Member Price: $89
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.
Forgotten Managerial Accounting Tools for CPAs
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Target profit analysisBreak-even analysisRelevant costs and decision-makingStandard costs and variancesActivity-based costingSegment reporting and analysis
2026/27 AICPA Regulatory Ethics Update
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Update on ethics and independence developments from the AICPA Professional Ethics Executive Committee (PEEC)Recent developments shaping ethical requirements for the professionProposed and ongoing projects on PEEC's agenda
Corporate Transparency Act Developments
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Background of the Corporate Transparency ActBeneficial Ownership Information Reporting (BOIR) Rule Entities required to report.Reporting requirements imposed by the CTADue dates of reportsInformation needed to satisfy the BOIRImpact of failure to reportHow to submit a reportCourt rulings on CTA’s unconstitutionalityImplications to entities as a result of the ruling in NSB.Potential reporting requirements due to FinCen’s proposed rulemaking with respect to non-financed purchases of residential real estate and gratuitous transfers.
Business Partnerships: Managing Supplier Relationships
-
Online
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Overview of supplier contractsCase studies of successful and not-so-successful supplier relationshipsRisk potentials
Workforce Transformation and Talent Management in 2025
-
Online
1.00 Credits
Member Price: $55
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
Finding Errors in Excel Spreadsheets
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors.Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis.Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies.Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively.