CPE Catalog & Events
Smart Formula Selection in Excel: What to Use When
-
TBD
0.0 Credits
Member Price: $89
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
Controls to Secure the Growing Digital Footprint
-
TBD
0.0 Credits
Member Price: $149
The major topics covered in this course include:Securing individual documentsProtecting information resident in the CloudSecuring data stored on or accessed by mobile devices
ACPEN: The Value of Conflict
-
TBD
1.0 Credits
Member Price: $39
Conflict resolution
ACPEN: Global Internal Audit Standards (GIAS) Domain II – Part 2
-
TBD
1.0 Credits
Member Price: $89
Internal Audit Standards GIAS Accounting Internal Controls
Becoming Conflict Competent
-
TBD
2.0 Credits
Member Price: $89
Major topics covered in this course include:Levels of conflictStrategies to de-escalate conflictDistinction between miscommunication and conflictResponses to conflictTactics to address, rather than avoid, conflict
Surgent's Social Security: Dispelling Common Myths with Essential Truths
-
TBD
2.0 Credits
Member Price: $119
Will Social Security be there for me? How is my benefit calculated? Can I claim my benefit and work too? When do I stop paying Social Security taxes? Why does my government pension cause my benefits to be reduced? Can I claim spousal benefits now and my own later? What is my breakeven? Can I claim benefits from my ex-spouse? What do you mean I may pay taxes on my income benefits? … and more!
The CFO Who Went to Prison
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this class include:The importance of valuesIdentifying successEthical dilemmasMitigation strategiesCreating tools to help make better decisionsPersonal accountability strategies
Surgent's Advising a Client Regarding the Tax Consequences Associated with Buying or Selling a Business
-
TBD
3.0 Credits
Member Price: $149
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: Achieving Balance in Work and Life - Part 2
-
TBD
4.0 Credits
Member Price: $149
Why we get off balance and how to overcome those tendencies Methods that turbo charge motivation, health and happiness The power of culture and friends to affect our lives The importance of clear intention in order to effect change that lasts
ACPEN: Excel Essentials for Today’s Accountant: How To Become an Expert in One Day
-
TBD
4.0 Credits
Member Price: $149
Using formulas to manipulate and transform data Using formulas and reference formulas such as =VLOOKUP Using pivot tables Understanding Solver to perform multivariate analysis Awareness of advanced functions Creative methods for data manipulation Using intellectual curiosity and professional skepticism to develop a problem-solving mentality Real-life examples of innovative ways to analyze and report data with Excel Using Excel to perform e-mail merges Enhance creativity in your approach to developing Excel models Computer software and application
ACPEN: Real Estate Tax Issues: Passive Activity, Self-Rental and Section 199A
-
TBD
4.0 Credits
Member Price: $149
Integration of the real estate professional rules with reporting on Form 1040, Schedule E Real estate professionals and indirectly owned (partnerships, S corporations) entity's reporting on Form 1040 How "real estate business" is interpreted under the Section 199A rules and how it integrates with the passive activity rules Real estate professionals and the Form 8582 (Passive Activities) How to make the "grouping" election for passive activities and the flow-through deduction Definition of self-rental property - both for Sections 199A and 469 Reporting using Form 1040, Schedule E, page 1 and 2 Self-rental property and the Form 8582 (passive activity)
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
What's Behind the Data?
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Ways in which data and information can be misleadingCommon pitfalls when encountering dataHow to re-evaluate the data to avoid those pitfalls
ACPEN: Internal Control Frameworks for Single Audit
-
TBD
1.0 Credits
Member Price: $39
COSO 2013 Update Yellowbook Accounting
ACPEN: 2026/27 Single Audit Update
-
TBD
1.0 Credits
Member Price: $39
2024 Uniform Guidance overhaul Increase in Single Audit threshold to $1 million Audit planning and execution impacts 2025 AICPA GAS/Single Audit Guide (Appendix B) updates Audit efficiency and compliance considerations
ACPEN: The Hardest Ethical Dilemma! Why Revenge Will Always Backfire, featuring Bob Mims and Don Minges
-
TBD
1.0 Credits
Member Price: $39
The quest for fairness Human nature Our natural reaction Selfishness Conflicts of interest Equity Justice How is the Golden Rule misused? The allure of revenge and how it destroys? Understanding rationalizations How the “Integrity and Objectivity Rule” will lead to better decisions?
ACPEN: Independence Requirements for CAAS Engagements
-
TBD
2.0 Credits
Member Price: $89
CAAS Auditing & Accounting Yellowbook Ethics
ACPEN: Mergers and Acquisitions: Complete Guide to Relevant Issues
-
TBD
2.0 Credits
Member Price: $89
Taxable asset acquisitions vs. non-taxable stock/equity acquisitions What happens in an asset acquisition What happens in a stock or equity acquisition 338 and 336 elections Basics of 382 Basics of 280G Earnouts and contingent payments Assumed liabilities Acquired reserves Acquired deferred revenue Treatment of transaction costs Basics of mixed entity transactions, examples such as: C-Corp buys an interest in a partnership C-Corp buys an S-Corp C-Corp buys an interest in an LLC (lots of possibilities here) S-Corp buys a partnership S-Corp buys a C-Corp S-Corp buys an interest in an LLC Partnership acquisitions of various entity types Very basic overview of tax-free re-organizations High level overview of entity formations High level overview of entity liquidations or termination
ACPEN: Section 199A Compliance: Rules and Reporting After OBBA
-
TBD
2.0 Credits
Member Price: $89
A deep-dive look at the Section 199A flow-through entities deduction Calculation of qualified business income Application to rental real estate - "safe harbor" rule and aggregation rules Self-rental rule for 199A compared to self-rental rule for passive activities Differing impact on the sole proprietorship, partnerships and S corporations Forms reporting in Form 8995 and Form 8995-A Section 199A flowchart
ACPEN: K2's Choosing Your CPA Firm Tech Stack
-
TBD
2.0 Credits
Member Price: $89
Evaluating suite vs. best-in-breed software ecosystems Understanding and applying AI-driven tools for firm efficiency Measuring ROI and integration effectiveness across the tech stack