CPE Catalog & Events
This will generate a PDF of the current filtered catalog
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.
Surgent's Representing a Client in an IRS Audit
-
Online
3.00 Credits
Member Price: $169
Impact of the Trump Administration on IRS funding Reduction in IRS staffing Potential reduction in IRS’s ability to process and audit tax returns Status of IRS Direct File program Auditing large corporations and partnerships Audits of high income and high net worth individuals Information document requests What happens when a client agrees or disagrees with the IRS’s audit findings The Dirty Dozen for 2025: roadmap to IRS audit issues
The Successful Family Business
-
Online
4.00 Credits
Member Price: $149
Business Management Organization
Finding the Right Fit: An Exploration Financial Reporting Options for SMEs
-
Online
4.00 Credits
Member Price: $149
Unique needs of SMEs The menu of available frameworks Exploration of specific SPFs U.S. GAAP provisions for SMEs Considerations when selecting a framework Audit, review, and compilation implications Pitfalls to avoid Best practices to adopt
Understanding Internal Control Constructs
-
Online
4.00 Credits
Member Price: $149
The major topics covered in this course include:Underlying concepts of internal controlThe importance of control measure interdependency
Financial Decisions that Led Two Businessmen to Prison
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Career choicesEthical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation
Hot Topics Audit & Attest Update - 2026
-
Online
2.00 Credits
Member Price: $89
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
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
Viewing A&A Through the Eyes of a Tax Practitioner
-
Online
2.00 Credits
Member Price: $89
The role of financial reporting for a myriad of users Fundamentals concepts Special Purpose Frameworks Financial statement analysis Cross-functional collaboration
Tax Practice Standards
-
Online
2.00 Credits
Member Price: $89
Treasury Circular 230 AICPA Statements on Standards for Tax Services (SSTS) Internal Revenue Code (IRC) Common law
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.
HR Investigations - Episode 2 - Interview Techniques
-
Online
2.00 Credits
Member Price: $89
Interview terminology Types of questions Levels of listening Verbal and nonverbal communications Documenting results
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.
Cooking Up Success: CPA Clara's Recipe for a Modernized Firm
-
Online
1.00 Credits
Member Price: $39
How to structure/offer repeated services without stretching yourself thin Types of Tech Stack you should include in your firm Managing client expectations and building your workflows around them
Ethics, AI, and Music: What Every CPA Must Know
-
Online
1.00 Credits
Member Price: $55
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.
Staff Retention Keep the Best People
-
Online
3.00 Credits
Member Price: $109
Remote workforce Employee retention Staff turnover
Beyond the Basics: Financial Ratios You Might Be Overlooking
-
Online
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Understanding Cost Behavior and Its Impact on Decision-MakingContribution Margin and Break-Even AnalysisMargin of Safety and Its Role in Risk ManagementOperating Leverage and Financial SensitivityAnalyzing Asset Turnover for Operational EfficiencyCash Conversion Cycle and Working Capital InsightsFree Cash Flow Yield as a Valuation Tool
A Guide to Sampling - Part 1
-
Online
2.00 Credits
Member Price: $89
Auditing Yellowbook
Schedule C of Form 1040
-
Online
2.00 Credits
Member Price: $89
When Schedule C applies Cash v. Accrual method Typical business deductions Business vehicle expenses Section 179 and bonus depreciation
Drive Results with Metrics
-
Online
2.00 Credits
Member Price: $89
Performance Metrics Budgets