CPE Catalog & Events
Surgent's Industry Accountant Key Performance Metrics
-
Virtual
8.00 Credits
Key tools used by businesses and financial professionals across the globe to measure performance Detailed, real-world examples of businesses utilizing these tools
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: Understanding the Tax Implications of Retirement Plan Distributions
-
Online
1.00 Credits
Required minimum distributions for a deceased's heirs 2025 retirement plan contribution limits Required minimum distributions and contributions to charity Key provisions of Secure Act 2.0
ACPEN: HR Investigations – Episode 1 – Introduction-Assessing-Planning
-
Online
1.00 Credits
Investigation terminology Assessment skills Investigative methodology
ACPEN: Businesses Receiving Government Assistance
-
Online
2.00 Credits
What is Yellow Book? What is different because of Yellow Book? When might Yellow Book apply to a business? Common application of concepts to businesses Answers to common questions
Professional Ethical Considerations for CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Core principles of any Code of Professional Conduct applicable to all CPAs, including conflicts of interest, preparing and reporting information, competence, confidential information, and moreThe importance of maintaining independence for CPAs in public practice, especially when also performing nonattest services for the attest client Comparing and contrasting various ethical standards, including those promulgated by the AICPA, PCAOB, and international bodies
Microsoft 365 Application Lightning Round Review-Updated
-
Virtual
1.00 Credits
The major topics covered in this course include:Lightning round review of the following apps, with an explanation and demonstration of what each of them offersTeams - the foundation of all that you do in Microsoft 365SharePoint / OneDrive - secure cloud storagePower BI - the new financial reporting modelStream - the YouTube for your organizationBookings - streamline your appointment scheduling OneNote - get your content organized for quick retrieval Lists - create custom list tracking reportsTo Do - consolidate all your Outlook, Planner and general "to do's" in one appPlanner - manage simple and complex engagements and projects in an intuitive appA quick look at many of the remaining apps
ACPEN: K2’s Data Security And Privacy Issues And Solutions
-
Online
2.00 Credits
Understanding the differences between data security and data privacy The major types of security and privacy breaches Key steps you can take to mitigate your risks of becoming another victim
ACPEN: The Preparation of Form 706 and 709 – Understanding the Law
-
Online
2.00 Credits
Estate and Gift Taxation Fundamentals Valuation of Estate Assets Components of the Gross Estate Deductions in Estate Taxation Charitable and Marital Deductions Tax Credits and Their Application
Surgent's Marijuana: A Generalized Business Viewpoint
-
Virtual
1.00 Credits
An overview of current state and federal laws governing marijuana A review of state boards of accountancy regarding marijuana How some financial professionals are capitalizing on the marijuana industry Providing auditing and tax services within the marijuana industry How accountants and other financial professionals can manage risk within this industry IRC Section 280E’s prohibition of deductions involving controlled substances A summary of various state taxation laws on marijuana Ethical issues for accountants who work in the marijuana industry Relevant banking regulations Growth projections
Tax Depreciation: Review and Update
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Recent tax legislation and developments related to capitalizationEligible property for Section 179 and Section 168(k)Discussion of the Section 179 deduction and its use to depreciate real propertyThe Section 168(k) deduction and its use to depreciate real propertyDisposition of segments of real propertyExchanges of tangible personal property after repeal of the like-kind exchange rulesOther related topics
CPA to CFO: Essential Competencies for Finance Leaders
-
Virtual
1.00 Credits
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: Top competencies hiring executives seek in CFO candidates based on survey of 320+ CEOs and recruiters Critical thinking frameworks and strategy creation techniques for financial leadership Forward-looking financial skills including capital management, forecasting, and funding strategies Industry-specific requirements for high-growth companies and nonprofit organizations Practical career development strategies to build CFO-ready competencies
ACPEN: Section 174: New Rules for R&E and OBBA Update
-
Online
1.00 Credits
Revised rules for tax years 2022-2024 How to change from amortizing R&E to immediately expensing R&E Analysis of the Revenue Procedure related to changes in accounting method Options available to change accounting methods Comprehensive example of how to make the accounting method change Distinction between R&E expense and R&E credit
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.
ACPEN: Individual Tax Update: Key Considerations for 2026
-
Online
8.00 Credits
Individual tax provisions compared for 2025 and 2026 reporting Recent legislative developments, cases and rulings impacting individual taxpayers ACA premium tax credit Passive activities - complete disposition 2027 inflation rates FBAR update Virtual currency and enforcement Property transactions Gross income and deductions
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
Retaining Top Talent: Strategies for CPA Firms
-
Virtual
1.00 Credits
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: The true cost of turnover versus retention investment Research findings on why professionals leave or stay Whole-person retention strategies beyond compensation Work-life balance solutions that maintain productivity Career development paths for non-partner track professionals Business model transformations for sustainable staffing Technology and outsourcing strategies to reduce burnout Retention strategies specific to diverse talent and younger professionals
ACPEN: Introduction to Not-for-Profit Accounting
-
Online
2.00 Credits
Not-for-Profit Accounting Accounting & Auditing Yellowbook
ACPEN: Schedule K-1: What is it & What Do I Do with It?
-
Online
2.00 Credits
Overview of Schedule K-1 for Partnerships, S Corporations, and Estates/Trust Reporting Schedule K-1 information on Form 1040 Basis limitations, loss limitations, and material participation rules Qualified Business Income (QBI) Deduction and Schedule K-1 integration Case studies highlighting real-world application of Schedule K-1 reporting Proposed changes to Schedules K-2 and K-3 for 2021 and beyond Best practices for avoiding errors and ensuring compliance
ACPEN: The Preparation of Form 709 – Line-by-Line
-
Online
2.00 Credits
Gift tax fundamentals and exclusions Completing Form 709 accurately Gift-splitting and its tax implications Lifetime exemption and GSTT considerations Valuation of gifted assets Common filing mistakes and IRS audits Updates on new legislation impacting gift taxation
