CPE Catalog & Events
Unlock the Power of AI with Copilot in Excel
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Copilot in ExcelAutomating Tasks and Enhancing ProductivityAdvanced Data Insights with Copilot
Surgent's Federal Tax Update
-
Virtual
4.00 Credits
Comprehensive coverage of individual provisions of the One Big Beautiful Bill Act, including but not limited to: TCJA provisions made permanent New Tip Income Deduction New Overtime Pay Deduction New Car Loan Interest Deduction New Temporary Senior Deduction Expanded SALT Cap Trump Accounts Comprehensive coverage of business provisions of the One Big Beautiful Bill Act, including but not limited to: Bonus Depreciation made permanent Increased §179 deduction Changes to §174 R&E Expenditures Changes to §163(j) Form 1099/1099-K changes Qualified Small Business Stock Exclusion The Gig Economy - examine key tax implications for gig workers, including Independent Contractor vs. Employee classification challenges and employer reporting responsibilities Timely coverage of breaking tax legislation Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas
Reviewing S Corporation Tax Returns: What Are You Missing?
-
Virtual
4.00 Credits
Common errors made involving the following tax forms: Form 1120-S Schedule K-1 Schedules K-2 and K-3 Schedule L Schedules M-1 and M-2 Form 4562 Form 4797
ACPEN: Federal Tax Update - C & S Corporations, Partnerships & LLCs (Forms 1120, 1120S & 1065)
-
Online
8.00 Credits
Discuss the most recent business income tax legislation passed to date Review numerous business income tax provisions including but not limited to the 20% qualified business income (QBI) deduction; changes to NOLs, §461(l) business loss limitations, §163(j) business interest deduction limitations, accounting method changes, depreciation, fringe benefits and entertainment expenses Brush up on issues related to compensation, distributions, liquidations, self-employment taxes and retirement plan Look at any changes to the Forms 1120, 1120S, and 1065 and other related schedules and forms
COSO's Internal Control Framework Essentials
-
Virtual
3.50 Credits
Components and principles of internal control Concepts associated with the COSO framework Management responsibilities versus auditor responsibilities Common significant accounting processes Tools and techniques used for internal control documentation
ACPEN: The Ethics Hour: Accounting Scandals: What Happened and Why? Can We Prevent Them?, featuring Tracy Cooper and Don Minges
-
Online
1.00 Credits
Why do some choose to deceive, cheat and steal Can accounting scandals be prevented A brief history of accounting scandals What to look for What should ethical professionals like you do
Beyond the Basics: Financial Ratios You Might Be Overlooking
-
Virtual
1.00 Credits
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
ACPEN: K2’s Excel’s Best New Features
-
Online
2.00 Credits
Learn how to work with Dynamic Arrays Using Excel's new XLOOKUP and XMATCH feature Improvements to Power Query and why they matter to you New collaboration and commenting options in Excel
Ethics and Technology for CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:The foundational ethical principles CPAs are required to follow and how these principles apply to audit quality, data privacy and security, and the use of emerging technologies.The profession's need to change to meet its ethics standard in a technology-centric environment.Changes being considered by the AICPA and the National Association of State Boards of Accountancy that could impact the profession.
Surgent's Mastering the Offer in Compromise: Strategies for Preparation and Negotiation
-
Virtual
2.00 Credits
Introduction to the OIC program Types of OICs Eligibility criteria Financial analysis Offer amount calculation Preparing Forms 656 and 433-A(OIC)/433-B(OIC) Supporting documentation and strategy OIC submission and IRS review process Appeals and negotiation techniques Best practices and common pitfalls Real-world scenarios and case studies
Surgent's Advising a Client Regarding the Tax Consequences Associated with Buying or Selling a Business
-
Virtual
3.00 Credits
Due diligence checklist items Asset sales and stock sales and their attendant results to buyers and sellers Section 1060 and the residual method Selling sole proprietorships, partnerships, and corporations Consequences of making a Section 754 election with adjustments under Sections 743(b) and 734(b) Section 338 and Section 338(h)(10) elections Allocating some of the purchase price of a business to personal goodwill Partnership distributions to retiring partners under Section 736(a) and 736(b) Consulting agreements and employment agreements as between buyers and sellers Advantages of a C corporation having Section 1202 stock
ACPEN: Federal Tax Update for Individuals with Doug Van Der Aa
-
Online
4.00 Credits
"Tax-mageddon" - the all-important impending expiration/extension/renewal of the TCJA Recent legislative, judicial, and IRS developments impacting individual taxpayers 2025 Tax rates and inflation-adjusted figures Cryptocurrency reporting and new Form 1099-DA Form 1099-K and previously unreported income Review of significant changes in individual tax forms Recent federal tax legislation, cases and rulings affecting income of individual taxpayers
Corporate Storytelling in Financial Reporting
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Purpose of Management Commentary (IFRS): Understanding the foundational objectivesPurpose of MD&A (AAP): SEC-mandated narrative disclosure requirementsHistorical Context: Past and present frameworks and the limitationsRecent Revisions: Key enhancements and ESG integrationPractical Examples: Real-world applications and improvementsConvergence & Guidance: Frameworks, comparisons, and implementation
ACPEN: Current Fraud Trends - Nonprofit and Government Entities
-
Online
2.00 Credits
Best practices for fraud prevention and detection Common fraud schemes in nonprofit and government entities including cash misappropriation, payroll fraud, vendor fraud, falsified billings, improper use of credit cards or purchase cards, the redirection of cash and non-cash contributions, personal use of assets, the redirection of grant benefits, other grant related fraud, travel and expense reporting fraud
ACPEN: Not Just Your Everyday FASB Update
-
Online
4.00 Credits
Analysis of relevant GAAP provisions Reminders regarding the continuing importance of ASC 606 for revenue recognition Fresh perspectives of lease accounting in the wake of ASC 842 implementation Overview of U.S. GAAP alternatives for certain entities Summary of selected, salient standards for today’s audit, review, and compilation engagements
AI 101 for CPAs: Core Concepts and Practical Applications
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:ABCs of how generative AI tools such as ChatGPT, Microsoft Copilot, and Google Gemini workWhat inherent risks are associated with this powerful technologyActionable steps you can take to mitigate the risksPractical examples of how AI can be applied in accounting, auditing, tax, and finance services
Smart Formula Selection in Excel: What to Use When
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Introduction to Strategic Formula Use:Why choosing the right formula matters: clarity, performance, and maintenanceCommon traps: overusing IF, defaulting to familiar tools, ignoring modern functionsHow Excel offers multiple ways to solve the same problem and how to pick wiselyConditional Logic and Branching Tools:IFS vs SWITCH vs nested IF: comparing readability and structureWhen to simplify logic and how to avoid nested nightmaresSummarizing Data:SUMIFS vs SUMPRODUCT: multiple conditions, weighted sums, totalsFiltering and Output Control:FILTER vs IF + INDEX: dynamic data extraction with vs without Excel 365Trade-offs in backward compatibility and ease of useCustom Output and Decision Trees:CHOOSE vs SWITCH vs LOOKUP: logic trees and category mappingEmbedded Variables and Reusability:LET vs named ranges: clarity and efficiency for long formulasUsing LAMBDA with LET to create custom functionsSimplifying and documenting complex calculationsBest Practices for Formula Selection:Criteria for deciding: readability, flexibility, future maintenanceTips for avoiding overengineering and formula bloat
ACPEN: Leading Up: The Superpower Every Ascending Leader Needs
-
Online
2.00 Credits
The consequences of upward leadership failure. Building credibility with your boss, Serving multiple bosses. Making the business case for your ideas.
ACPEN: Preparation, Compilation and Review Engagements
-
Online
2.00 Credits
Auditing Yellowbook
2026/27 AICPA Regulatory Ethics Update
-
Virtual
2.00 Credits
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
