CPE Catalog & Events
Mastering the Excel Lookup Functions
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions
Ethics in the Real World 26-27
-
TBD
4.0 Credits
Member Price: $175
Why model codes of ethics fail The science behind organizations "Ethical DNA" Understanding the psychology behind "Tone at the Top" The interaction between critical thinking and ethics Breaking myths about motivation related to decision-making Ethical decision-making under pressure Are ethics and morals "fixed" or can we learn to improve
K2's Data Analytics For Accountants And Auditors 26-27
-
TBD
4.0 Credits
Member Price: $175
Understanding the importance of data analytics in modern business environments Generating and interpreting data analytics using everyday applications such as Microsoft Excel and Microsoft's Power BI platform Using regression analysis to create and validate forecasts and projections
World Class Cost Accounting: A Practical Application—Part 2 26-27
-
TBD
4.0 Credits
Member Price: $175
Classification of MFG overhead into the five cost types Selecting the bases for tracing or assigning overhead to products Period Manufacturing Inefficiencies'categories and costing
Fundamentals of Form 1040 -- Business
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Self-employment and business income taxation (Schedule C, self-employment tax, business deductions)Reporting income from pass-through entities (Schedule E, Schedule K-1, Shareholder stock and debt basis on Form 7203)Application of Form 7217 for capital construction fundsBest practices for self-employed clients and small business ownersKey deductions and credits for business ownersAvoiding common IRS audit triggers related to business income reportingLegislative updates impacting business income taxation in the current year
A&A Update for Closely Held Businesses 26-27
-
TBD
6.0 Credits
Member Price: $259
Recently issued FASB Accounting Standards Updates, including those that will become effective during audit engagements conducted in 2026 Recently issued Statements on Auditing Standards and other AICPA activity Recently issued Statements on Standards for Accounting and Review Services
K2's Excel Best Practices 26-27
-
TBD
8.0 Credits
Member Price: $329
Best practices associated with creating Excel workbooks, including managing workbooks How to secure Excel workbooks Collaboration options and best practices in Excel Effective reporting techniques in Excel
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
The CPA's 2026 Guide to Cryptocurrency and Blockchain
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Blockchain technology primerCryptocurrency technology primerUpdate on the cryptocurrency marketplaceCryptocurrency exchanges - the good, the bad and the uglyOverview of cryptocurrency taxation and legislationSmart contracts - what they are and how they work
The Best S Corporation, Limited Liability, and Partnership Update Course by Surgent
-
TBD
8.0 Credits
Member Price: $299
Discussion of key individual provisions of the One Big Beautiful Bill Act, such as TCJA provisions made permanent, new tip income deduction, new overtime pay deduction, Trump accounts, and the expanded SALT cap 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 Excess Business Loss Limitation Section 1244 Small Business Stock and Section 1202 Qualified Small Business Stock treatment and applicability Principles and considerations for nonresident withholding, composite payments, and passthrough entity taxes Partnership Distributions, Form 7217, and S Corporation Redemptions Thinking beyond §163(j) -- Interest Allocation Rules, Original Issue Discount, Applicable High Yield Discount Obligations, Convertible Corporate Debt Instruments, and Debt-Financed Distributions Timely coverage of breaking tax legislation Selected Practice and Reporting Issues: What’s new? A review of recent cases and tax law changes and IRS guidance affecting S corporations, partnerships, limited liability companies, and limited liability partnerships Decentralized Autonomous Organizations (DAOs)
Corporate Storytelling in Financial Reporting
-
TBD
0.0 Credits
Member Price: $55
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: Performance Management
-
TBD
1.0 Credits
Member Price: $39
Setting and resetting performance expectations On-the-spot counseling Addressing erratic performance Drafting and presenting performance appraisals
ACPEN: Revenue Recognition - Recognize Revenue
-
TBD
1.0 Credits
Member Price: $39
Revenue Recognition Accounting
ACPEN: Sarbanes-Oxley Update - Accounting Risk Assessment considerations - 20 years later
-
TBD
1.8 Credits
Member Price: $79
Sarbanes-Oxley Accounting Risk Assessment
ACPEN: Powerful Public Speaking
-
TBD
1.5 Credits
Member Price: $39
Communications
ACPEN: Partnership Essentials: Tax Basis Capital Accounts
-
TBD
2.0 Credits
Member Price: $89
Importance of tax basis capital accounts Reporting negative tax basis Tax accounting for property contributed to a partnership Effect of the Ceiling Rule Allocation of depreciation to partners Alternative and Remedial Methods Effect on financial capital accounts Form 1065, Schedule K-1
ACPEN: What's Going on at the GASB (2026/27)
-
TBD
2.0 Credits
Member Price: $89
GASB Statement No. 103 (financial reporting model improvements) GASB Statement No. 104 (capital asset disclosure enhancements) GASB Statement No. 105 (subsequent events) Recent GASB pronouncements and updates Active GASB exposure drafts and ongoing projects
ACPEN: Where to Hide Fraud Inventory – Expenses – Payroll
-
TBD
2.0 Credits
Member Price: $89
Fraud Concealment Inventory Fraud Expense Fraud Payroll Fraud Internal Controls Risk Assessment Audit Testing
Entertainment, Meals & Travel Expenses: Review and Update
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this class include:Definition of what qualifies as an entertainment expenseStrategies to deduct business entertainment expensesDeductibility of mealsSituations not subject to the 50% meals and entertainment reductionHow to handle automobile issues related to employer-provided parkingProper accounting for deductible vs. non-deductible expendituresThe four steps to analyze business expensesThe latest federal legislation, cases and rulings
ACPEN: The Controllership Series - Financial Statement Preparation
-
TBD
1.6 Credits
Member Price: $99
Accounting Finance Financial Statement Preparation