CPE Catalog & Events
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: The Role of Internal Audit in Enterprise-Wide Risk Management
-
Online
4.00 Credits
Benefits of enterprise risk management Important objectives, components and principles that underlie the COSO Framework Identifying events that could cause objectives to not be achieved Techniques for evaluating both "good" risks (opportunities) and "bad" risks (threats) The roles and responsibilities of key parties throughout an organization in managing risk
ACPEN: Retirement Planning Issues: Where We Stand Now
-
Online
4.00 Credits
Thorough Exploration of Current Retirement Planning Trends and Implications Strategies for Maximizing Retirement Savings within Existing Regulatory Structures Tax-Efficient Navigation of Various Retirement Plan Options Estate Planning Techniques Aligned with Contemporary Trends for Optimal Benefits Insight into Latest Rules for Required Minimum Distributions (RMDs)
ACPEN: IRAs – Contributions & Distributions for Traditional, Roth, SEP & SIMPLE IRAs
-
Online
8.00 Credits
An emphasis on newly enacted tax legislation affecting IRAs including the NEW final required minimum distribution (RMD) regulations Contribution limits to and tax treatment of distributions from Traditional, Roth, SEP and SIMPLE IRAs Deductible phase-out limits for Traditional IRA contributions for taxpayers that are active participants in qualified retirement plans Roth IRA contribution phase-out limits as well as tax-free qualified distributions Planning opportunities for conversions to ROTH IRAs Rollover rules to/from different retirement accounts and the one-rollover-per-year limitation The different options of receiving IRA distributions before age 59 ½ and avoiding the 10% early distribution penalty (including substantially equal periodic payments) The required minimum distribution (RMD) rules from IRAs needed to avoid the 50% penalty after the account owner turns age 72 or dies The tax ramifications of spouse and non-spouse beneficiaries and how this affects the RMD calculation after the account owner’s death Overview of health savings account (HSA) eligibility rules, contribution limits and distribution rules
ACPEN: Passive Activities & Rental Real Estate Income Tax Issues
-
Online
8.00 Credits
Detailed coverage of the passive activity rules under IRC §469 (and related regulations), how the 3.8% net investment income tax under §1411 and qualified business income (QBI) deduction under §199A applies to rentals and passive activities, and what is a trade or business rental is under §162 How the PAL rules apply to rental real estate activities and investments in S corporations and partnerships Definition of an activity and the activity grouping and disclosure rules Real estate professional exception to the PAL rules for investments in non-passive rentals Special $25,000 loss allowance for rental real estate with active participation Material participation safe harbor rules Events that trigger suspended PALs Limitations on tax credits generated by passive activities Special rules that re-characterize passive income to non-passive income What rentals are subject to self-employment tax under §1402
ACPEN: Estate Planning for Today and Beyond
-
Online
8.00 Credits
Analysis of upcoming trends and anticipated shifts in estate planning practices Review of legislative updates affecting estate planning strategies Advanced techniques for minimizing estate taxes and maximizing wealth transfer efficiency Integration of digital assets and technology into estate planning frameworks Consideration of unique challenges presented by blended families, same-sex marriages, and non-traditional relationships
Current Cybersecurity Risk Management Trends
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of current cybersecurity threats and how to mitigate data breach risk.Describe how to avoid malware and other security threats
ACPEN: Topic 842: FASB's Lease Accounting Standard Update
-
Online
2.00 Credits
What is a lease? Recognition and measurement of lease assets and liabilities Impact on lessors and lessees Disclosures and transition rules Effective dates
Surgent's Establishing State Residency and Saving Your Clients Money
-
Virtual
2.00 Credits
Typical provisions in state statutes regarding domicile and residency In depth analysis of domicile and residency definitions Issues regarding one’s permanent abode Analysis of jurisdiction where taxpayer has the greatest connections Detailed discussion of criteria used to establish domicile and residency
2026/27 Annual Update for Accountants & Auditors
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Key accounting and auditing developments affecting accountants and auditors across industries.Recently issued and upcoming Accounting Standards Updates (ASUs), including standards effective for December 31, 2026 year-ends for public companies, private entities, and not-for-profit organizations.Recent and proposed standards affecting audit, attestation, and consulting engagements, including SSAE No. 24, SSARS No. 26, exposure drafts related to confirmations and fraud, and SAS No. 149 addressing group audits.
About the TIGTA: Who Watches the IRS?
-
Virtual
2.00 Credits
Major topics covered in this course include:The role of TIGTA in the US tax systemAuditing, investigating, and inspecting and evaluating IRS programs and operationsIdentifying opportunities to improve the administration of tax lawsPromoting integrity, economy, and efficiency in the tax systemResponding to requests from Congress and other external stakeholdersUpholding ethical standards in the accounting professionBuilding trust and confidence in the tax system
ACPEN: IFRS Update
-
Online
2.00 Credits
Explore where financial statement preparers should focus the most time and attention on now when preparing interim and annual financial statements, such as: o Costs charged to PP&E in the "testing&" phase o Calculating onerous contract costs o Calculating the 10 percent test for determining substantially different cash flows Discover highlights of recently-issued IFRS pronouncements, focusing on changes with upcoming effective dates, such as: o Classification of liabilities as current o Defining accounting estimates
ACPEN: Ethical Leadership: Guiding Principles When Others Falter
-
Online
2.00 Credits
Understanding yourself and others in the workplace How emotion plays a vital role in ethical dilemmas and in solutions What are some of the various outlooks on ethics? Recognizing lies Managing ethics towards solutions
Surgent's Engagement and Client Retention Best Practices
-
Virtual
0.00 Credits
Managing client expectations How automation improves client engagement Understanding the role of feedback systems Seeking referrals Building client loyalty Customer retention marketing Expanding services offered to clients Knowing when it is appropriate to enter new markets
Surgent's Ethical Considerations for CPAs
-
Virtual
0.00 Credits
Auditor independence and its importance to the public accounting profession Common threats to auditor independence AICPA’s framework for assessing conflicts of interest Unique threats related to non-attest services to attest clients Common safeguards to help assure compliance with relevant rules and regulations
Surgent's Exploring Business Valuation Fundamentals
-
Virtual
0.00 Credits
What does value mean? Technical vs. fundamental analysis Intrinsic value Other discounted cash flow models Assumptions in the Gordon Growth Model Valuations using free cash flows Residual income model Enterprise value Value in mergers and acquisitions Small business valuations and discounts Advanced valuation models
ACPEN: The Power of a Good Story!
-
Online
4.00 Credits
The 3 elements of storytelling 3 real world examples 10 thoughts for the road
ACPEN: The Essential SSARS Update with Renee Rampulla
-
Online
4.00 Credits
Preparation Engagements Compilation Engagements Review Engagements Quality Management Components Common Accounting and Reporting Issues Frequent Peer Review Matters
ChatGPT and Advanced Financial Analysis for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Financial Modeling with ChatGPT IntegrationAdvanced Ratio Analysis TechniquesRisk Assessment and Scenario AnalysisValuation Methods and ChatGPT ApplicationsUtilizing Performance Metrics in Financial AnalysisData Analysis and Interpretation with AIInvestment Analysis Enhanced by ChatGPT
ACPEN: Upholding Independence While Holding Your Client's Hand
-
Online
2.00 Credits
Circumstances that may cause recent FASB pronouncements to introduce threats to independence AICP's Code of Professional Conduct Best practice tips and practical strategies for preserving independence when assisting clients with technical matters
