CPE Catalog & Events
K2'S Eight Awesome PivotTable Features
-
TBD
2.0 Credits
Member Price: $79
Adding user-defined calculations to PivotTables Enhancing PivotTables with Key Performance Indicators Using PivotTables to consolidate “standard” Excel reports Creative ways to filter PivotTables Linking accounting software data into PivotTables
Leverage PowerBI.com to Create Data Analysis for Others
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this class include:Tour of the PowerBI.com Interface: An in-depth walkthrough of the PowerBI.com environment, focusing on user interface elements, navigation, and customization.PowerBI.com Concepts: Fundamental concepts of PowerBI.com, including its architecture, data handling capabilities, and integration features.Connecting to Data: Techniques for connecting various data sources to PowerBI.com, ensuring seamless data integration and synchronization.Visualizations and Dashboards: Creating impactful visualizations and assembling informative dashboards to present data compellingly.Q&A Feature: Explore the interactive Q&A feature to derive insights through natural language queries.Sharing Datasets, Reports, Dashboards: Best practices for sharing datasets, reports, and dashboards with different audiences so they can leverage your data analysis work.Creating Apps: Learn how to package reports and dashboards into apps for easy distribution and consumption.
Surgent's Employee Stock Options: What Financial Professionals Should Know When Advising Their Clients
-
TBD
2.0 Credits
Member Price: $99
What stock options are and why they are growing in popularity How stock options work, including the process of conveyance and vesting How to exercise stock options and the implications from doing so The risks associated with stock options and how to manage exposure Tax consequences and updates regarding stock options Strategies for selecting the best time to exercise stock options The difference between the two types of stock options: non-qualified and incentive The basic terminology relevant to owning and exercising options
Surgent's Features and Benefits of SEP IRAs and SIMPLE IRAs
-
TBD
2.0 Credits
Member Price: $99
The new Roth SEP IRAs and Roth SIMPLE IRAs created under SECURE Act 2.0 Key factors for choosing a retirement plan for a small business Key questions an advisor must ask a small business owner to help determine which retirement plan is suitable for their business Key questions an advisor must ask a small business owner to help ensure compliance with applicable rules and regulations How SEP and SIMPLE IRAs benefit the small business owner How SEP and SIMPLE IRAs benefit employees of small businesses The tax benefits that help to offset the cost of employer contributions How to determine which business is eligible to adopt a SIMPLE IRA or SEP IRA How to determine which employees must be covered
Surgent's Forms 7217 and 7203
-
TBD
2.0 Credits
Member Price: $99
Tax treatment of partnership distributions to partners of cash and property other than cash Basis of property received in a partnership distribution IRS’s new regulations regarding basis shifting in favor of high-marginal tax rate related partners Organization and structure of the new Form 7217 Who must file Form 7203 Determining the S corporation shareholder’s initial basis in his or her stock Basis limitations on partnership losses and deductions Organization and structure of Form 7203 — understanding the three parts of Form 7203 Filing criteria for Form 7203 Calculating an S corporation shareholder’s share of S corporation deductions and credits Understanding stock and debt basis
Surgent's Going Out on Your Own: Entity Types and Accounting Methods
-
TBD
2.0 Credits
Member Price: $99
Financial planning pyramid What to consider when picking an entity Single member LLC vs. sole proprietorship Corporations – S vs. C Double taxation
Federal Tax Update for Business with Doug Van Der Aa
-
TBD
4.0 Credits
Member Price: $129
"Tax-mageddon" - the all-important impending expiration/extension/renewal of the TCJA Other recent legislative, judicial, and IRS developments impacting business taxpayers Current status of Research and Experimentation costs and Interest Expense Limitation Phaseout of Bonus Depreciation and MACRS issues S corporation and partnership developments Other miscellaneous business developments
K2's Securing Your Data: Practical Tools For Protecting Information
-
TBD
4.0 Credits
Member Price: $129
Understanding today’s cybersecurity risks Identifying major cybersecurity risks Implementing specific steps to reduce risk
Partnership Essentials: Review & Update
-
TBD
4.0 Credits
Member Price: $129
Recent legislative, rules and tax developments impacting partnerships and their partners Transfer of partnership interests TCJA §461(l) Excess Business Losses and §163(j) Business Interest Expense Importance of capital accounts Form 1065, Schedules K-1 and M-2 Schedules K-2 and K-3 update Reporting partner capital accounts Effect of the Ceiling Rule Alternative and Remedial Methods Effect on financial capital accounts Tax basis capital accounts
K2's Next Generation Excel Reporting
-
TBD
8.0 Credits
Member Price: $225
Identifying weaknesses in traditional reporting processes Using leading-edge features in Excel to improve reporting practices How to work with Power Query to solve common reporting challenges Adding Slicers and Timelines to your Excel-based reports
Comprehensive Estate Planning: Administration & Postmortem Strategies
-
TBD
8.0 Credits
Member Price: $225
Introduction to Estate Administration How to Read a last will and testament Understanding the Entities Administration the Estate and Orderly Process The Probate process and the courts Special Issues in Estate Administration Postmortem Issues Regarding Income Taxation of Descendants and Estates Post Mortem Opportunities on the Estate Income Tax Return Available Post Mortem Estate Tax Elections Portability Election Disclaimers
Nonprofit Accounting and Financial Reporting Explained
-
TBD
8.0 Credits
Member Price: $225
Discussion of financial reporting risks increased by the current economic environment, including increased uncertainty related to critical financial statement amounts and significant disclosures Executive summary of recent Accounting Standards Updates Overview of fair value disclosure requirements and implementation issues Discussion of issues related to donor-restricted endowment funds Classification of net assets and reclassifications Endowments, including accounting, disclosures and UPMIFA Noncascontributions Contributions received and receivable Expense recognition issues Reporting expenses by function and nature Other relevant matters unique to the nonprofit environment
Tax Season Update with Steve Dilley
-
TBD
8.0 Credits
Member Price: $129
Update and integration of recent tax legislation impacting 2025 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) 2025 and 2026 tax rate schedule and other inflation adjusted items Tax forms update: individual, S corporation, and partnerships
2024 PCAOB and SEC Update
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Developments at the PCAOB.Recent trends in SEC comment letters.Enforcement actions and administrative proceedings.Conclusions and predictions for the future.
AICPA Statements on Standards for Tax Services: Ethical Considerations
-
TBD
2.0 Credits
Member Price: $79
Review of the new AICPA Statement on Standards for Tax Services Reorganization of SSTS by type of work performed Discuss new standards on data protection, reliance on tools and representation of tax clients before taxing authorities
Governmental Accounting 101
-
TBD
2.0 Credits
Member Price: $79
Fund Types Budgetary Accounting Financial Reporting Requirements Single Audit Act Audit Standards and Procedures Best Practices in Governmental Accounting
Global Internal Audit Standards (GIAS) Domain III - Part 2
-
TBD
2.0 Credits
Member Price: $79
Internal Audit Internal Controls GIAS Institute of Internal Auditors Standards Accounting
Microsoft Excel: Moving Beyond the Basics
-
TBD
2.0 Credits
Member Price: $79
Using formulas to manipulate and transform data Using formulas and reference formulas such as =VLOOKUP Using pivot tables Understanding Solver to perform multivariate analysis
Monthly Federal Tax Updates - February 2026
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Current individual tax issuesCurrent business entity tax issuesAny current tax legislation occurring during the periodOther issues affecting the profession, including IRS procedure, current cases, payroll, and other federal tax issues
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
TBD
2.0 Credits
Member Price: $99
Using lookup functions as an alternative to direct cell references Understand the limitations of the VLOOKUP function Discover ways to move beyond these limitations