CPE Catalog & Events
K2's Next Generation Excel Reporting
-
Online
8.00 Credits
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
Mastering the Excel Lookup Functions
-
Virtual
2.00 Credits
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
Budget Mastery: Process, Problems, and Solutions
-
Online
2.00 Credits
Defining the budget process Common budgetary cultures and discussion of solutions Does your budget need an overhaul or just a tune up? How to make the budget flexible Making a better budget and maybe even a better you (or at least improving the perception of the budget work itself)
SECURE Act 2.0 and Updates (2025)
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Implications for individualsChanges to the Saver’s CreditChanging the required minimum distribution rules for Roth 401(k)sChanges to required beginning dates for required minimum distributions of retirement plans. Penalty-Free Withdrawals for Certain Emergency ExpensesSpecial provisions for firefighters and military personnel spouses Increases in catch-up contributions Impact on 529 plansOpportunities for student loan payment matchingImplications for EmployersStarter § 401(k) plans for small employersRequiring automatic 401(k) enrollmentImproving worker access to emergency savingsIncreasing part-time workers’ access to retirement accountsStatute of Limitations on excise taxes imposed on overcontributions to retirement plansMultiple employer §403(b) plansAutomatic portability provisionsOther changes in the administration of company retirement plans
K2's Technology Update
-
Online
4.00 Credits
Developments in hardware and software Options for communicating and collaborating more effectively Addressing cybersecurity issues
ChatGPT Vision for Financial Analysis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to GPT Vision - Understanding the fundamentals of GPT Vision and its capabilities.Advantages of Vision Mode Research - Exploring the unique benefits of visual data analysis over traditional methods.Accessing GPT Vision - Guidance on how to access and utilize GPT Vision capabilities.Financial Screenshot Analysis - Techniques for analyzing financial documents and reports through screenshots.Operational Insights from Visual Data - Using images to gain insights into operational processes and asset management.Integration with Google Maps - Learning how to combine ChatGPT's vision capabilities with mapping technologies for enhanced spatial analysis.DDPP Analysis - Applying descriptive, diagnostic, predictive, and prescriptive analysis to visual data.Sentiment and Facial Expression Analysis - Techniques for interpreting emotions and sentiments in images to gauge client and employee feedback.Body Language Interpretation - Analyzing body language in images to understand non-verbal cues in business contexts.Effective Photo Capturing Techniques - Best practices for taking photos that provide optimal insights for financial analysis.
Ethics at Work: Diversity, Equity and Inclusion
-
Virtual
2.00 Credits
The major topics covered in this class include:Overview of ethicsEthical values and principlesDEI working definitionsUnconscious bias, assumptions, microaggressionsStanding Up and Speaking OutDEI and Organizational Responsibility
Written Information Security Plans
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Introduction to the Gramm-Leach-Bliley Act and its impact on data security.Circular 230 compliance and due diligence for practitioners.AICPA Statements of Standards relevant to WISP requirements.Key components of a Written Information Security Plan.Training requirements for employees, staff, and contractors.Practical guidance for drafting and implementing a WISP.FTC enforcement of data security standards for PTIN holders.Best practices for maintaining and updating WISP compliance.
Budget Mastery: Walkthroughs and Real World Calculations Towards Tying Budgets To Value
-
Online
2.00 Credits
How to build a flexible budget model that works? What are the steps we can take to budget for economic and external factors beyond our control? How the right Chart of Accounts can simply your work? Budget and GAAP are not the same and why they are fine not to be Efficiently modeling payroll and benefits Identifying controllable and uncontrollable expense Using key variables to stress-test your budget
A Practitioner's Guide to IRAs and Qualified Retirement Plans
-
Online
8.00 Credits
Traditional and Roth IRAs: Understanding retirement savings options SEP and SIMPLE IRAs: Exploring retirement plans for small businesses Qualified Plans: Navigating employer-sponsored retirement plans Defined Benefit and Defined Contribution Plans: Comparing retirement plan structures 401(k) Plans: Maximizing benefits with employer-sponsored options Retirement Plan Selection: Choosing the best plan for individual client needs Minimum Distribution Rules: Ensuring compliance and understanding withdrawal regulations Tax Implications: Analyzing the tax consequences of retirement plan decisions Retirement Planning Strategies: Implementing effective strategies for client financial goals
What's Changing in Risk Assessment
-
Online
2.00 Credits
Auditing Yellowbook
Budget Mastery: The Human Side of Budgeting-Navigating People's Issues with 360 Insight
-
Online
2.00 Credits
Understanding your own leadership tendencies and applying them to your strengths? Understanding core personality types Learning what type of person you are? Managing and coping with the budget team Effectively dealing with the A, B, C and other players?
Implementing an AI-Enabled Marketing Strategy for Your Firm
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Module 1: Introduction to AI in Marketing The Basics of AI – Concepts and TerminologyModule 2: Leveraging AI Tools and Technologies Overview of AI Tools for MarketingModule 3: Practical Strategies for AI Integration Integrating AI into Your Marketing WorkflowModule 4: Measuring AI-Driven Marketing Effectiveness Key Metrics for Assessing AI-Driven CampaignsModule 5: Real-Life Case Studies and Success Stories Case Studies of Firms Successfully Using AI in MarketingModule 6: Developing Your AI-Enabled Marketing Strategy Creating a Custom AI Marketing Strategy
Business Tax Update: Recent Developments
-
Online
2.00 Credits
Update on significant business tax developments related to cases and rulings Business provisions of any recent legislation impacting business entities Depreciation changes in Sec. 179 and Sec. 168(k) bonus depreciation Recent developments impacting partnership and S corporations, including any changes to Forms 1065 and 1120S
Forensic and Fraud Interviewing Techniques and Skills
-
Online
2.20 Credits
Forensic Accounting Accounting Auditing Finance
Become a Data Analysis Expert
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Data Analysis Process Flow: An introduction to the Data Analysis Process Flow and how it is your pathway to becoming a Data Analysis Expert.Data Modeling: A comprehensive discussion of building a data model and calculating metrics.Data Visualizations: An understanding how visualizations can present data in a more insightful and impactful manner.
Surgent's Buying and Selling a Business: Tax and Structuring Overview
-
Virtual
4.00 Credits
An overview of the beginning of the process and documents for preliminary tax planning Recognizing the need for due diligence in acquisitions, including checklists of important points Deemed asset sales – §338 and §338(h)(10) The impact of the §197 amortizable intangibles regulations on the acquisition and disposition of a business Allocating purchase price for tax advantage Planning to avoid double taxation under the repeal of the General Utilities doctrine Special problems and opportunities when an S corporation is the buyer or seller Installment sale and interest issues Avoiding tax pitfalls and recognizing tax planning opportunities Unique issues in buying and selling LLC/partnership interests Impact of the net investment income tax (NIIT) and the §199A pass-through deduction on the tax due on the sale of a pass-through entity Individually owned goodwill
Construction Contractors: Auditing Considerations
-
Virtual
4.00 Credits
Auditing contractor accounting and revenue from contracts with customers Planning and risk assessment for construction contractors Key internal controls Substantive procedures for long-term contractors
Surgent's Fiduciary Income Tax Returns - Form 1041 Workshop with Filled-in Forms
-
Virtual
8.00 Credits
Classifying receipts between “income” and “corpus” under the Uniform Principal and Income Act Calculation of DNI utilizing three different methods, a “forms” method (Schedule B), a “code” method, and a “shortcut” method, utilizing a worksheet of common income and expenses Proper W-2 preparation and procedures in the year of death Taxpayer passes before taking a required minimum distribution; what must be done? Forgetful fiduciaries of simple trusts Fluctuating trusts – Simple one year, complex the next Dividing income in the year of death Overview of Subchapter J Form preparation issues – Filing requirements and line-by-line explanations of Form 1041 Taxable income of estates and trusts and expense allocation issues Specific deductions and miscellaneous itemized deductions Income in respect of a decedent The income distribution deduction calculation Relation of principal and income law to DNI Understanding how to handle capital gains and losses Allocating tax items to beneficiaries: another K-1 Other considerations: excess deductions on termination Comprehensive DNI case study, with principal (cost and FMV) and income reconciliation Comprehensive trust and estate case studies, with filled-in forms
Walter Haig's SSARS Prep, Comp and Review Update
-
Virtual
8.00 Credits
The major topics that will be covered in this class include:Analysis of the ''Preparation of Financial Statements'' standards as amended by SSARS 26 with detailed implementation guidance.Analysis of the ''Compilation'' standards as amended by SSARS 26 with implementation guidance.Analysis of the ''Review'' standards as amended by SSARS 26 with detailed implementation guidance.Common mistakes made in SSARS engagements as identified in peer reviews and in litigation.
