CPE Catalog & Events
The 10 Must Know Excel Features
-
TBD
0.0 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.
ACPEN: How to Develop Your System of Quality Management Using the AICPA Practice Aids
-
TBD
3.0 Credits
Member Price: $109
Overview of Quality Management standards Scope of SQMS 1 Components of quality management Changes from prior standards AICPA practice aids Required documentation Risk assessment process Final documentation development
ACPEN: Expand Your Analytical Toolbox More Tools for Success
-
TBD
4.0 Credits
Member Price: $149
5 step valuation process 2 specific valuation approaches The Gordon Model 10 thoughts on banker selection Rating your bank 10 hints for keeping your toolbox full
ACPEN: The Essential SSARS Update with Renee Rampulla
-
TBD
4.0 Credits
Member Price: $149
Preparation Engagements Compilation Engagements Review Engagements Quality Management Components Common Accounting and Reporting Issues Frequent Peer Review Matters
ACPEN: 2026 Tax Season Update for Individuals with Steve Dilley
-
TBD
4.0 Credits
Member Price: $149
Update and integration of recent tax legislation impacting 2026 individual returns Update on significant individual tax developments related to cases and rulings Individual tax changes including the earned income credit, child credit, and child and dependent care credit Section 199A changes, including use of carryforward passive activity and 199A losses and latest tax forms Crypto reporting update 2027 tax rate schedule and other inflation adjusted items Passive activity and hobby loss rules changes
ACPEN: Estates & Trusts: Executor Duties and Tax Responsibilities in Estate Administration
-
TBD
4.0 Credits
Member Price: $149
Legal and fiduciary responsibilities of the executor or personal representative Overview of the estate administration process from appointment through final distribution Filing requirements for Form 1040, Form 1041, and Form 706 Income in respect of a decedent (IRD) and basis adjustments Estate asset identification, valuation, and management Creditor claims, debt settlement, and distribution procedures Obtaining an EIN for the estate and IRS notice procedures IRS audit risks related to estate administration Executor liability considerations and risk management Estate accounting records, documentation, and communication with beneficiaries
ACPEN: K2’s Implementing Internal Controls In QuickBooks Online Environments
-
TBD
4.0 Credits
Member Price: $149
Critical risks in QBO environments Internal control options that can mitigate risk to prudently acceptable levels Enabling alternative control measures to improve internal controls in QuickBooks environments
Forensic Accounting: Finding Hidden Treasure in Tax Returns
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:The rules of IRS disclosure of tax informationUnderstanding the role of IRS transcriptsInterpreting the actions of the IRS in transcriptsFOIA requestsAnalyzing tax information and returns for financial leads
ACPEN: 2026 Tax Season Update with Steve Dilley
-
TBD
8.0 Credits
Member Price: $250
Update and integration of recent tax legislation impacting 2026 returns and significant individual and business tax developments related to cases and rulings Individual tax changes including the earned income credit, child credit, and child and dependent care credit Partnership and S corporation developments Section 199A changes and reporting, losses and forms Depreciation update: Section 179 and 168(k) 2026 and 2027 tax rate schedules and other inflation adjusted items Tax forms update: individual, S corporation, and partnerships
ACPEN: Form 1040 Individual Income Tax Prep
-
TBD
8.0 Credits
Member Price: $250
Overview of Form 1040 and filing requirements Filing status and dependent rules Income reporting, including wages, interest, and dividends Adjustments to income Standard vs itemized deductions Common individual tax credits Introduction to Schedule C and Schedule E Preparer responsibilities, due diligence, and Circular 230
Surgent's Advanced Critical Tax Issues for S Corporations
-
TBD
8.0 Credits
Member Price: $279
Inclusion of OBBBA (One Big Beautiful Bill Act) provisions that are germane to this course Final regulations on “eligible terminated S corporations” (ETSCs) Cases, rulings, and tax law changes affecting S corporations Compensation planning in S corporations, including limitations in a family-controlled business; self-employment tax issues, including IRS efforts to address underreporing of S corporation officer compensation Use of redemptions: still some advantages Planning for the liquidation of an S corporation Tax issues for family ownership of S corporation stock Impact of the tax on net investment income on sales of S corporation stock Stock basis: Loss limitations, AAA, and distribution issues in depth Debt basis: what the regulations on back-to-back loans mean to investors Estate planning for S corporation shareholders, including buy-sell agreements, QSubs, ESBTs, and uses of life insurance Built-in gains: the 5-year recognition period S corporation structuring: one class of stock Methods of accounting Legislation on mortgage interest reporting, basis, statute of limitations, and tax return due dates New cases on revocation of S election in bankruptcy court and documentation of open account indebtedness and Chief Counsel Advice on carryover of losses for ESBTs
Untying the Knot: Taxes & Divorce
-
TBD
8.0 Credits
Member Price: $239
The major topics that will be covered in this course include:Filing Status: Determining the correct filing status during and after divorce.Qualified Domestic Relations Orders (QDROs): Tax implications of dividing retirement accounts.Back Taxes: Strategies for addressing unpaid tax liabilities during and after divorce.Offers-in-Compromise & Installment Agreements: Resolving tax debts with the IRS.Currently-Not-Collectible Status: Understanding when and how to use this option.Innocent Spouse & Injured Spouse Relief: Protecting clients from unfair tax liabilities.Lien Discharges & Subordinations: Managing IRS liens on property during divorce.Reasonable Compensation: Evaluating fair compensation in divorce-related business valuations.Case Studies: Explore unusual and complex tax issues in divorce through real-world examples.
Adobe Acrobat Tips for Working with PDF Files
-
TBD
0.0 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
ACPEN: Business Etiquette & Mindfulness
-
TBD
1.2 Credits
Member Price: $39
Communication Business Etiquette
Ethics: Giving Thanks - How to Master the Art of Gratitude
-
TBD
2.0 Credits
Member Price: $89
We'll explore what gratitude is and how expressions of it can vary from culture to culture. We'll also unpack several ways you can regularly say "thank you" to valued clients and colleagues, and we'll examine methods for evaluating gratitude in prospective and current employees.
Surgent's Purchase and Sale of a Residence: Critical Tax Issues
-
TBD
2.0 Credits
Member Price: $99
General rules relating to the sale of a residence under § 121 Sale of a taxpayer’s main home Qualifying for a partial exclusion of gain on the sale of a home How a taxpayer meets the residence requirement Meeting the look-back requirement Separated, divorced, and widowed taxpayers Work-related moves and unforeseeable events Inherited homes and homes received in a divorce Impact of business or rental use of home on the gain exclusion Reporting gain or loss on the sale of a home
Accounting for Income Taxes for Private Companies 26-27
-
TBD
4.0 Credits
Member Price: $175
Sample Schedule M calculations Sample work papers for deferred tax computations Comprehensive two-year example and computations Review and analysis of recurring temporary differences Identification of the sources to compute "cumulative temporary differences" Sample workpapers for analysis of tax positions
Case Studies in Accounting Fraud 26-27
-
TBD
4.0 Credits
Member Price: $175
Major financial statement frauds, including revenue recognition, estimates, earnings management and cut-off fraud Major misappropriation of asset fraud schemes, including skimming, larceny, and additional schemes that occur in within payments processing Review of recent cases involving the same common fraud schemes that have always existed
Ethical Intelligence: Global Case Studies & Standards 26-27
-
TBD
4.0 Credits
Member Price: $175
Ethical Responsibilities for CPAs AICPA Code of Professional Conduct PCAOB Independence & Ethics Sarbanes—Oxley Act Circular 230 Foreign Corrupt Practices Act Whistleblower & Reporting Duties (incl. Dodd-Frank) California State Board Ethics & Enforcement Data Privacy & Confidentiality (CCPA/CPRA)
Know Your Cost: Double Your Profit 26-27
-
TBD
8.0 Credits
Member Price: $329
Why traditional approaches are inadequate How superior cost information can double your profit Make Activity Based Costing spreadsheet easy Recognize joint and by-products Add throughput costing to your toolbox Depreciation Interest and the cost of capital